I faced this problem in Oracle 8i. Only solution is Connection pool manager (CPM) should release all the DB connections after certain time-out interval defined in Connection pool manager if they are not used.
You have have to manage connections using Connection pool manager.
Lets say, your CPM creates a connection pool of maximum 10 connections. CPM should keep track of Total DB connections, Total exhausted connections.
Lets...
User Profile
Collapse
Profile Sidebar
Collapse
pragatiswain
Last Activity: Jan 7 '09, 09:33 AM
Joined: Nov 16 '06
Location: India
-
TO_DATE(DATE_FI ELD || TIME_FIELD, <DATE_FORMAT> )
DATE_FORMAT based on stored value in fields DATE_FIELD and TIME_FIELD
example : 'MM/DD/YYYYHH24MISS'
Hope this helps....Leave a comment:
-
Write a oracle function with the following logic
RoundUp(INPUT_V AL, INPUT_DEC)
IF (INPUT_DEC >= 0) THEN
BEGIN
FOR 1..INPUT_DEC
INPUT_VAL := INPUT_VAL * 10;
LOOP;
INPUT_VAL:= TRUNC(INPUT_VAL + 1);
FOR 1..INPUT_DEC
INPUT_VAL := INPUT_VAL / 10;
LOOP;
END;
ELSE
BEGIN
INPUT_DEC = INPUT_DEC * (-1);
FOR 1..INPUT_DEC...Leave a comment:
-
Select
Insert
Update
Delete
Can be done in parallel for performance improvement provided the m/c on which oracle server is running has more than one processors....Leave a comment:
-
Can try this one too.
declare
ibaseAmt number(10,2);
iTotalAmt number(10,2);
iMonth Number(2);
Begin
ibaseAmt := 1024;
iMonth := 1;
iTotalAmt:=ibas eAmt;
dbms_output.put line('Month:'|| iMonth ||',Deposit Amt For This
month: $'|| ibaseAmt ||', Total Amount Deposited: $' || iTotalAmt);
While (iTotalAmt < 2047.50 )
ibaseAmt := ibaseAmt/2;...Leave a comment:
-
To convert to Character you need to use To_Char(integer ) function which basically gives you the ascii character corresponding to that integer value.
For your example, I guess, you really don't need that....Leave a comment:
-
Subquery keeps the sql more clear.
May be you have to see the plan, cost and execution time of both the queries and choose the better one....Leave a comment:
-
Try this:
declare
iBaseSal number(10,2);
iYr number(2);
begin
iBaseSal:=35500 ;
iYr:= 1;
For iYr= 1..6
loop
if (iYr > 1 and iYr <= 4) then
iBaseSal:= iBaseSal * 1.04;
if (iYr > 4) then
iBaseSal:= iBaseSal * 1.055;
dbms_output.put line('For Year:' || iYr || '-->' ||'Salary' || iBaseSal);
end loop
end
Hope...Leave a comment:
-
Please provide the "host string" and corresponding entry from tnsnames.ora
for my reference to analyze the problem....Leave a comment:
-
Howz this:
Select * from (Select * from employee order by sal desc) where rownum < n+1
Minus
Select * from (Select * from employee order by sal desc) where rownum < n...Leave a comment:
-
If child table data is committed or inserting in the childtable happens in the same transaction, then there is no problem. Do as Suvam has suggested you.
But if insertion in Child table happens in another session and not commited, you can not see the data. So, you have to design the application accordingly....Leave a comment:
-
-
TR1 will execute only for that user having access on the trigger....Leave a comment:
-
I also stress more on security in a real production environment.
Unix Environmental variables are user/session specific, which other users/sessions can't see.
Set environmental variables for oracle User ID / PWD. which you can put in Unix user's .profile or ask the user at the time of login to unix environment.
Hope this helps...Leave a comment:
-
-
Check this out.
SQL> grant unlimited tablespace to <MY_USER>;
--- Then Check Priviledges, should show "UNLIMITED TABLESPACE"
SQL> select * from session_privs;
Then try doing what you wanted to do....Leave a comment:
-
For Better understanding, go to
http://www.adp-gmbh.ch/ora/concepts/materialized_vi ew.html...Leave a comment:
-
I am not much experienced in this as I am just a user, not a DBA.
May be the object user_data_files is not there as that user didn't create any tablespace/ doesn't have priviledge to create table space....Leave a comment:
-
See the answer @ http://www.thescripts. com/forum/showthread.php? p=2241625#post2 241625...Leave a comment:
-
Object status is not recoded in Data dictionary. Status can be "Vadid" or "Invalid".
Tables, sequences, and synonyms are always valid. But view, procedure, function, or package may get invalid, if the dependent objects are altered or deleted/ doesn't exist.
Lets say a Stored Procedure SP1 is dependent on Table1. If Table1 is altered or deleted/ doesn't exist, SP1 becomes invalid. That info. is stored in USER_OBJECTS....Leave a comment:
No activity results to display
Show More
Leave a comment: