|
-
SQL> select name,value from v$parameter
2 where upper(name) like '%TIMED%';
NAME
----------------------------------------------------------------
VALUE
------------------------------------------------------------------------------
timed_statistics
TRUE
timed_os_statistics
0
SQL> spool off
AND THEN I ISSUE THE BELOW COMMAND TO TAKE A SNAP OF THE DATABASE, THIS SCRIPT WAS RUN COUPLE TIMES BEFORE I RUN THE SPREPORT.SQL, BUT I STILL HAVE PROBLEM
exec statspack.snap(i_snap_level=>10,i_modify_parameter=>'true');
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
|