1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
| SQL> SELECT a.name , value FROM v$statname a , v$mystat b
2 WHERE a.STATISTIC#=b.STATISTIC#
3 AND a.name LIKE '%parse count%' ;
NAME VALUE
---------------------------------------------------------------- ----------
parse count (total) 14
parse count (hard) 1
SQL> DECLARE
2 jobno number;
3 begin
4 dbms_job.submit(jobno, 'statspack.snap;',trunc(sysdate) + 1 + 9/24, ' trunc(sysdate) + 1 + 9/2
4');
5 commit ;
6 end ;
7 /
Procédure PL/SQL terminée avec succès.
SQL> SELECT a.name , value FROM v$statname a , v$mystat b
2 WHERE a.STATISTIC#=b.STATISTIC#
3 AND a.name LIKE '%parse count%' ;
NAME VALUE
---------------------------------------------------------------- ----------
parse count (total) 114
parse count (hard) 12
SQL> SELECT a.name , value FROM v$statname a , v$mystat b
2 WHERE a.STATISTIC#=b.STATISTIC#
3 AND a.name LIKE '%parse count%' ;
NAME VALUE
---------------------------------------------------------------- ----------
parse count (total) 115
parse count (hard) 12
SQL> SELECT a.name , value FROM v$statname a , v$mystat b
2 WHERE a.STATISTIC#=b.STATISTIC#
3 AND a.name LIKE '%parse count%' ;
NAME VALUE
---------------------------------------------------------------- ----------
parse count (total) 116
parse count (hard) 12
SQL> r
1 SELECT a.name , value FROM v$statname a , v$mystat b
2 WHERE a.STATISTIC#=b.STATISTIC#
3* AND a.name LIKE '%parse count%'
NAME VALUE
---------------------------------------------------------------- ----------
parse count (total) 117
parse count (hard) 12
SQL>
SQL> exec DBMS_JOB.REMOVE('92') ;
Procédure PL/SQL terminée avec succès.
SQL> SELECT a.name , value FROM v$statname a , v$mystat b
2 WHERE a.STATISTIC#=b.STATISTIC#
3 AND a.name LIKE '%parse count%' ;
NAME VALUE
---------------------------------------------------------------- ----------
parse count (total) 124
parse count (hard) 17 |
Partager