|
-
use profile to control it
use profile as mentioned below and set parameters to control the I/O like :-
LOGICAL_READS_PER_SESSION unlimited LOGICAL_READS_PER_CALL 100
example statement to create profile
read more in doc on profile
CREATE PROFILE clerk LIMIT
SESSIONS_PER_USER 2
CPU_PER_SESSION unlimited
CPU_PER_CALL 6000
LOGICAL_READS_PER_SESSION unlimited
LOGICAL_READS_PER_CALL 100
IDLE_TIME 30
CONNECT_TIME 480;
[Edited by anujpathak on 04-11-2002 at 07:04 AM]
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
|
Reply With Quote