-
to LND
you are good, I never thought I should check alert file
here are tons of error in alert and 2 trace file:
ORA-12012: error on auto execute of job 9
ORA-02394: exceeded session limit on IO usage, you are being logged off
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2883
ORA-06512: at line 1
*** SESSION ID:(9.37413) 2001.02.02.14.42.50.000
*** 2001.02.02.14.42.50.000
ORA-12012: error on auto execute of job 10
ORA-02394: exceeded session limit on IO usage, you are being logged off
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2883
looks like I have problem for IO usage, how to solve it?
I am on SCO unixware 7.1, oracle 8.0.5
Jim
-
maybe look into profiles (in SQL manual, create profile).
view is DBA_PROFILE
then what user has whar profile too.
-
SQL> select * from user_resource_limits;
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
I just find out, this is known bug ora-02394 for 8.0.4 and fixed on 8.0.6 and 8.0.5.2 (this is our version)
I guess there is no solution!
-
does it make sense to limit to some high value?
-
LND,
believe or not, it works. what I did is bounce DB once.
I tried few times, after setting up snapshot site, before
shutdown instance, I can see the job is doing nothing
(from dba_jobs). after bounce back, it refresh every
6 seconds!!! any idea?
Derek
-
I will try to remember this idea: reboot, reboot even if not asked.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|