| CPU_PER_SESSION [message #62894] |
Sun, 22 August 2004 22:09  |
Ayham Wafai
Messages: 5
Registered: August 2004
|
Junior Member |
|
|
How does CPU_PER_SESSION work? Does it look at CPU time the session used executing a SQL and adds up every execution and when the value of CPU_per_session is reached the session errors out? That is what it sounds like. How does it work when there is more than one processor server?
Thank you.
|
|
|
|
| Re: CPU_PER_SESSION [message #62898 is a reply to message #62894] |
Mon, 23 August 2004 04:28  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
CPU_PER_SESSION keeps track of the accumulated CPU time (processing time in hundredth of seconds) whatever the CPU the session is executing on.
Here is an example:
SQL> ALTER SYSTEM SET RESOURCE_LIMIT = true SCOPE=MEMORY;
System altered.
SQL> CREATE PROFILE save_cpu_time LIMIT cpu_per_session 1;
Profile created.
SQL> ALTER USER SCOTT PROFILE save_cpu_time;
User altered.
SQL> CONNECT scott/tiger
Connected.
SQL> CREATE TABLE bigemp AS SELECT * FROM emp;
Table created.
SQL> INSERT INTO bigemp SELECT * FROM bigemp;
INSERT INTO bigemp SELECT * FROM bigemp
*
ERROR at line 1:
ORA-02392: exceeded session limit on CPU usage, you are being logged off
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
