Oracle Database Commands and Practical Examples

Sunday, 25 December 2022

Examples sessions commands

Check session level details :

set lines 200 pages 1000

col USERNAME for a20

col MACHINE for a20

col PROGRAM for a30

col MODULE for a30

col ACTION for a25

select SID,SERIAL#,USERNAME,MACHINE,PROGRAM,SQL_ID,MODULE,ACTION from v$session;

SQL> select sql_text from v$sql where sql_id='cbdw3jv9azwbu';

SQL_TEXT

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select SID,SERIAL#,USERNAME,MACHINE,PROGRAM,SQL_ID,MODULE,ACTION from v$session

SQL> select sql_text from v$sql where sql_id='g0aywfbqsj573';

SQL_TEXT

select * from dba_source

SQL>

col SQL_TEXT for a30

select a.SID,a.SERIAL#,b.SQL_TEXT from v$session a,v$sql b where a.SQL_ID=b.SQL_ID and a.SQL_ID='g0aywfbqsj573';

SQL Text of particular sql_id

SQL> select a.SID,a.SERIAL#,b.SQL_TEXT from v$session a,v$sql b where a.SQL_ID=b.SQL_ID and a.SQL_ID='g0aywfbqsj573';

SID SERIAL# SQL_TEXT

---------- ---------- ------------------------------

60 36460 select * from dba_source

122 34561 select * from dba_source

125 58351 select * from dba_source

SQL>

Long Ops details sessions

1)Rman Backup and Restore

2)Parallel Query(Large chunks)

3)Recovery ( Crash and Media )

4)Large Full Table scans

5)Sorting

6)Stats job

7)If the table scan exceeds 10,000 formatted blocks

8)operation is greater than 6 seconds

Exception where view does not record

1)Index long operations(long time)

col SERIAL# for a20

col OPNAME for a20

col START_TIME for a30

col LAST_UPDATE_TIME for a30

col TIME_REMAINING for a30

col ELAPSED_SECONDS for a30

col MESSAGE for a30

col SQL_ID for a30

col USERNAME for a30

select SID,SERIAL#,OPNAME,START_TIME,LAST_UPDATE_TIME,ELAPSED_SECONDS,MESSAGE,SQL_ID,USERNAME,100 * (SOFAR/TOTALWORK) PCT from v$session_longops where SOFAR >0 and TOTALWORK >0;

76 1601 SYS srv6.example.com sqlplus@srv6.example.com (TNS g0aywfbqsj573 sqlplus@srv6.example.com (TNS

V1-V3) V1-V3)

77 47626 SYS DESKTOP-FIGDCKD SQL Developer SQL Developer

78 4270 SYS srv6.example.com sqlplus@srv6.example.com (TNS cbdw3jv9azwbu sqlplus@srv6.example.com (TNS

V1-V3) V1-V3)

79 52224 SOE1 DESKTOP-FIGDCKD SQL Developer 1d030zjx7k2kd SQL Developer

84 9473 srv6.example.com oracle@srv6.example.com (W005) KTSJ KTSJ Slave

85 20361 SYS srv6.example.com oracle@srv6.example.com (P001) g0aywfbqsj573 sqlplus@srv6.example.com (TNS

V1-V3)

86 15017 srv6.example.com oracle@srv6.example.com (TT04)

90 16629 SYS srv6.example.com oracle@srv6.example.com (P000) g0aywfbqsj573 sqlplus@srv6.example.com (TNS

V1-V3)

59 rows selected.

SQL> col sid for a20

SQL> col SERIAL# for a20

col OPNAME for a20

col START_TIME for a30

col LAST_UPDATE_TIME for a30

col TIME_REMAINING for a30

col ELAPSED_SECONDS for a30

col MESSAGE for a30

col SQL_ID for a30

col USERNAME for a30

select SID,SERIAL#,OPNAME,START_TIME,LAST_UPDATE_TIME,ELAPSED_SECONDS,MESSAGE,SQL_ID,USERNAME,100 * (SOFAR/TOTALWORK) PCT from v$session_longops where SOFAR >0 and TOTALWORK >0;SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>

no rows selected

Explain plan of SQL _ID

SQL> select * from table(dbms_xplan.display_cursor('1d030zjx7k2kd',null));

PLAN_TABLE_OUTPUT

SQL_ID 1d030zjx7k2kd, child number 0

-------------------------------------

select * from CUSTOMERS

Plan hash value: 2008213504

-------------------------------------------------------------------------------

-------------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | | | 823 (100)| |

| 1 | TABLE ACCESS FULL| CUSTOMERS | 161K| 17M| 823 (1)| 00:00:01 |

-------------------------------------------------------------------------------

13 rows selected.

SQL> select * from table(dbms_xplan.display_cursor('g0aywfbqsj573',null));

PLAN_TABLE_OUTPUT

SQL_ID g0aywfbqsj573, child number 0

-------------------------------------

select * from dba_source

Plan hash value: 3543585337

------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | | | 1 (100)| | | | | | |

| 1 | PX COORDINATOR | | | | | | | | | | |

| 2 | PX SEND QC (RANDOM) | :TQ10000 | 20000 | 41M| 1 (100)| 00:00:01 | | | Q1,00 | P->S | QC (RAND) |

| 3 | PX PARTITION LIST ALL | | 20000 | 41M| 1 (100)| 00:00:01 | 1 | 2 | Q1,00 | PCWC | |

| 4 | EXTENDED DATA LINK FULL| INT$DBA_SOURCE | 20000 | 41M| 1 (100)| 00:00:01 | | | Q1,00 | PCWP | |

------------------------------------------------------------------------------------------------------------------------------------------

16 rows selected.

Gather stats of schema table

SQL> exec DBMS_STATS.GATHER_TABLE_STATS('SOE1','CUSTOMERS');

PL/SQL procedure successfully completed.

SQL>

select SID,SERIAL#,USERNAME,MACHINE,PROGRAM,SQL_ID,MODULE,ACTION from v$session where username='SOE1';

select SID,SERIAL#,OPNAME,START_TIME,LAST_UPDATE_TIME,ELAPSED_SECONDS,MESSAGE,SQL_ID,USERNAME from v$session_longops where username='SOE1';

SQL> select SID,SERIAL#,SQL_ID,PROGRAM,TERMINAL,ACTION,MODULE from v$session where audsid=sys_context('USERENV','SESSIONID');

----------------------------------------------------------------------------------------------------------------------

Session SID details

SQL> select sid from v$mystat where rownum <2;

SID

----------

SID SERIAL# SQL_ID

---------- ---------- -------------

PROGRAM TERMINAL

------------------------------------------------ ------------------------------

ACTION

----------------------------------------------------------------

MODULE

----------------------------------------------------------------

76 28355 1w1p87znsbt7c

sqlplus@srv6.example.com (TNS V1-V3) pts/2

SQL*Plus

SQL>

SQL> select sql_text from v$sql where sql_id='1w1p87znsbt7c';

SQL_TEXT

--------------------------------------------------------------------------------

select SID,SERIAL#,SQL_ID,PROGRAM,TERMINAL,ACTION,MODULE from v$session where au

dsid=sys_context('USERENV','SESSIONID')

SQL>

----------------------------------------------------------------------------------------------------------

Top >> PID >> SPID

SQL> select se.sid,se.SERIAL#,se.SQL_ID,se.MACHINE,se.TERMINAL,se.MODULE,se.ACTION from v$session se inner join v$process pr on (pr.ADDR=se.PADDR) where pr.spid='13281';

SID SERIAL# SQL_ID

---------- ---------- -------------

MACHINE

----------------------------------------------------------------

TERMINAL

------------------------------

MODULE

----------------------------------------------------------------

ACTION

----------------------------------------------------------------

32 24650

srv6.example.com

UNKNOWN

SID SERIAL# SQL_ID

---------- ---------- -------------

MACHINE

----------------------------------------------------------------

TERMINAL

------------------------------

MODULE

----------------------------------------------------------------

ACTION

----------------------------------------------------------------

Blocking SID

SQL> select sid,serial#,MACHINE,program,sql_id,command,blocking_session from v$session where blocking_session is not null;

SQL> lock table soe1.customers in exclusive mode;

Table(s) Locked.

SQL> update soe1.customers set CUST_FIRST_NAME='VARUN' WHERE CUSTOMER_ID=39652358;

SQL> col MACHINE for a40

SQL> SET LINES 200

SQL> select sid,serial#,MACHINE,program,sql_id,command,blocking_session from v$session where blocking_session is not null;

SID SERIAL# MACHINE PROGRAM SQL_ID COMMAND BLOCKING_SESSION

---------- ---------- ---------------------------------------- ------------------------------------------------ ------------- ---------- ----------------

76 28355 srv6.example.com sqlplus@srv6.example.com (TNS V1-V3) bwgxdy0n3dtq9 6 78

SQL> select sid as blocked,serial#,MACHINE,program,sql_id,command,blocking_session as blocker from v$session where blocking_session is not null;

BLOCKED SERIAL# MACHINE PROGRAM SQL_ID COMMAND BLOCKER

---------- ---------- ---------------------------------------- ------------------------------------------------ ------------- ---------- ----------

76 28355 srv6.example.com sqlplus@srv6.example.com (TNS V1-V3) bwgxdy0n3dtq9 6 78

SQL>

Db Troubleshooting : Tips to Check alert log file error using command

locate <file name>

[oracle@srv6 trace]$ locate alert_primary19c.log

/u01/app/oracle/diag/rdbms/primary19c/primary19c/trace/alert_primary19c.log

[oracle@srv6 trace]$

check ORA- error in alert log using vi editor

/ORA-

grep 'ORA-' <alert file >|tail

[oracle@srv6 trace]$ grep 'ORA-' alert_primary19c.log|tail

ORA-12541: TNS:no listener

ORA-16055: FAL request rejected

ORA-12543: TNS:destination host unreachable

ORA-16055: FAL request rejected

ORA-12543: TNS:destination host unreachable

[oracle@srv6 trace]$

grep -A5 'ORA-' <alert file >|tail

[oracle@srv6 trace]$ grep -A5 'ORA-' alert_primary19c.log|tail

2022-12-25T13:49:18.741705+05:30

PDB(3):Endian type of dictionary set to little

2022-12-25T13:49:19.125446+05:30

ORA-12543: TNS:destination host unreachable

TT00 (PID:2918): krsg_check_connection: Error 12543 connecting to standby 'standby19c'

2022-12-25T13:49:33.300551+05:30

PDB3(4):Opening pdb with no Resource Manager plan active

2022-12-25T13:49:33.753469+05:30

PDB4(5):Opening pdb with no Resource Manager plan active

[oracle@srv6 trace]$

Thursday, 15 December 2022

PT : Load plan hash value from particular sql_id

Check plan hash value of SQL ID cptjnrc8v4v78

Query :

set lines 155

col execs for 999,999,999

col avg_etime for 999,999.999

col avg_lio for 999,999,999.9

col begin_interval_time for a30

col node for 99999

set lines 400 pages 400

set lines 500 pages 400

break on plan_hash_value on startup_time skip 1

select ss.snap_id, ss.instance_number node, begin_interval_time, sql_id, SQL_PROFILE, IOWAIT_TOTAL ,CPU_TIME_TOTAL,plan_hash_value,

nvl(executions_delta,0) execs,

(elapsed_time_delta/decode(nvl(executions_delta,0),0,1,executions_delta))/1000000 avg_etime,

(buffer_gets_delta/decode(nvl(buffer_gets_delta,0),0,1,executions_delta)) avg_lio

from DBA_HIST_SQLSTAT S, DBA_HIST_SNAPSHOT SS

where sql_id = nvl('&sql_id','b0a0vf29z9416')

and ss.snap_id = S.snap_id

and ss.instance_number = S.instance_number

and executions_delta > 0

order by 1, 2, 3

Query Output

SQL> set lines 155

col execs for 999,999,999

SQL> SQL> col avg_etime for 999,999.999

SQL> col avg_lio for 999,999,999.9

SQL> col begin_interval_time for a30

SQL> col node for 99999

SQL> set lines 400 pages 400

SQL> set lines 500 pages 400

break on plan_hash_value on startup_time skip 1

SQL> SQL> select ss.snap_id, ss.instance_number node, begin_interval_time, sql_id, SQL_PROFILE, IOWAIT_TOTAL ,CPU_TIME_TOTAL,plan_hash_value,

2 nvl(executions_delta,0) execs,

3 (elapsed_time_delta/decode(nvl(executions_delta,0),0,1,executions_delta))/1000000 avg_etime,

4 (buffer_gets_delta/decode(nvl(buffer_gets_delta,0),0,1,executions_delta)) avg_lio

5 from DBA_HIST_SQLSTAT S, DBA_HIST_SNAPSHOT SS

6 where sql_id = nvl('&sql_id','cptjnrc8v4v78')

7 and ss.snap_id = S.snap_id

8 and ss.instance_number = S.instance_number

and executions_delta > 0

9 10 order by 1, 2, 3

11 /

Enter value for sql_id: cptjnrc8v4v78

SNAP_ID NODE BEGIN_INTERVAL_TIME SQL_ID SQL_PROFILE IOWAIT_TOTAL CPU_TIME_TOTAL PLAN_HASH_VALUE EXECS AVG_ETIME AVG_LIO

---------- ------ ------------------------------ ------------- ---------------------------------------------------------------- ------------ -------------- --------------- ------------ ------------ --------------

7871 1 06-NOV-22 06.00.22.389 PM cptjnrc8v4v78 29842891 28973945 1915411015 4 14.634 1,429,152.8

7877 1 07-NOV-22 12.00.20.731 AM cptjnrc8v4v78 57103266 46418546 3 14.859 1,429,254.3

7879 1 07-NOV-22 02.00.02.007 AM cptjnrc8v4v78 64178609 52344279 1 12.892 1,429,208.0

7880 1 07-NOV-22 03.00.22.774 AM cptjnrc8v4v78 68791828 60612340 1 12.826 1,429,209.0

7884 1 07-NOV-22 07.00.41.593 AM cptjnrc8v4v78 1.2403E+10 3554681592 564 28.034 1,424,053.1

7884 1 07-NOV-22 07.00.41.593 AM cptjnrc8v4v78 256311009 56823300 3178084654 12 26.120 1,183,976.4

7886 1 07-NOV-22 09.00.24.366 AM cptjnrc8v4v78 1.2568E+10 3669106806 1915411015 18 15.526 1,064,575.6

7887 1 07-NOV-22 10.00.45.622 AM cptjnrc8v4v78 1.2574E+10 3677318620 1 14.012 1,429,206.0

7888 1 07-NOV-22 11.00.05.948 AM cptjnrc8v4v78 1.2628E+10 3712515559 7 12.629 1,186,152.0

7889 1 07-NOV-22 12.00.26.040 PM cptjnrc8v4v78 1.2628E+10 3715027689 1 2.520 491,571.0

7890 1 07-NOV-22 01.00.46.520 PM cptjnrc8v4v78 1.2715E+10 3780949516 11 13.832 1,429,222.5

7891 1 07-NOV-22 02.00.06.328 PM cptjnrc8v4v78 1.2715E+10 3799313535 7 2.633 491,571.1

7892 1 07-NOV-22 03.00.26.424 PM cptjnrc8v4v78 1.7049E+10 5174461021 213 26.744 1,419,635.3

7893 1 07-NOV-22 04.00.47.294 PM cptjnrc8v4v78 1.8402E+10 5926073988 95 22.212 1,292,852.3

7893 1 07-NOV-22 04.00.47.294 PM cptjnrc8v4v78 314929992 91454111 3178084654 2 47.525 1,183,927.5

7894 1 07-NOV-22 05.00.07.671 PM cptjnrc8v4v78 1.9926E+10 6593616330 1915411015 82 26.905 1,403,375.8

7895 1 07-NOV-22 06.00.27.767 PM cptjnrc8v4v78 2.6871E+10 9895272347 375 27.375 1,417,445.0

7897 1 07-NOV-22 08.00.07.993 PM cptjnrc8v4v78 2.7060E+10 1.0000E+10 12 24.568 1,429,238.7

7898 1 07-NOV-22 09.00.28.664 PM cptjnrc8v4v78 2.7131E+10 1.0073E+10 9 16.115 1,410,250.6

7899 1 07-NOV-22 10.00.49.592 PM cptjnrc8v4v78 2.9306E+10 1.1057E+10 118 26.792 1,349,716.7

7901 1 08-NOV-22 12.00.30.582 AM cptjnrc8v4v78 2.9391E+10 1.1100E+10 8 15.900 1,250,566.5

7903 1 08-NOV-22 02.00.11.833 AM cptjnrc8v4v78 2.9398E+10 1.1106E+10 1 13.354 1,429,218.0

7904 1 08-NOV-22 03.00.32.247 AM cptjnrc8v4v78 2.9419E+10 1.1131E+10 3 15.277 1,429,214.7

7908 1 08-NOV-22 07.00.53.367 AM cptjnrc8v4v78 485840166 128855977 3178084654 8 26.014 1,183,889.1

7908 1 08-NOV-22 07.00.53.367 AM cptjnrc8v4v78 3.3756E+10 1.2368E+10 1915411015 206 26.973 1,425,503.6

7910 1 08-NOV-22 09.00.34.691 AM cptjnrc8v4v78 3.3756E+10 1.2389E+10 8 2.631 491,595.0

7911 1 08-NOV-22 10.00.56.057 AM cptjnrc8v4v78 3.3761E+10 1.2397E+10 1 12.795 1,429,222.0

7912 1 08-NOV-22 11.00.16.438 AM cptjnrc8v4v78 3.3836E+10 1.2448E+10 9 14.107 1,270,409.7

7913 1 08-NOV-22 12.00.36.598 PM cptjnrc8v4v78 3.4404E+10 1.2737E+10 61 13.998 931,092.2

7915 1 08-NOV-22 02.00.18.105 PM cptjnrc8v4v78 3.4407E+10 1.2750E+10 3 5.611 804,171.0

7916 1 08-NOV-22 03.00.38.712 PM cptjnrc8v4v78 3.6538E+10 1.3413E+10 105 26.587 1,426,755.9

7917 1 08-NOV-22 04.00.59.832 PM cptjnrc8v4v78 3.6613E+10 1.3501E+10 13 12.550 1,212,832.8

7918 1 08-NOV-22 05.00.20.280 PM cptjnrc8v4v78 3.7912E+10 1.4110E+10 79 24.021 1,390,440.9

7919 1 08-NOV-22 06.00.40.822 PM cptjnrc8v4v78 4.0641E+10 1.5377E+10 148 27.060 1,408,292.5

7921 1 08-NOV-22 08.00.20.410 PM cptjnrc8v4v78 4.0728E+10 1.5461E+10 10 17.031 1,403,985.9

7922 1 08-NOV-22 09.00.41.337 PM cptjnrc8v4v78 4.0804E+10 1.5521E+10 8 16.957 1,429,223.4

7923 1 08-NOV-22 10.00.01.690 PM cptjnrc8v4v78 4.2135E+10 1.6088E+10 73 25.962 1,340,218.4

7925 1 09-NOV-22 12.00.42.934 AM cptjnrc8v4v78 4.2281E+10 1.6164E+10 10 22.129 1,429,198.0

7927 1 09-NOV-22 02.00.24.185 AM cptjnrc8v4v78 4.2309E+10 1.6186E+10 4 12.498 1,306,538.3

7932 1 09-NOV-22 07.00.06.453 AM cptjnrc8v4v78 5.3712E+10 1.9357E+10 523 27.844 1,421,470.6

7932 1 09-NOV-22 07.00.06.453 AM cptjnrc8v4v78 618439735 157004304 3178084654 6 26.803 1,183,885.5

7934 1 09-NOV-22 09.00.48.443 AM cptjnrc8v4v78 5.4067E+10 1.9468E+10 1915411015 19 24.504 935,725.7

7935 1 09-NOV-22 10.00.08.439 AM cptjnrc8v4v78 5.4073E+10 1.9476E+10 1 14.435 1,429,197.0

7936 1 09-NOV-22 11.00.27.959 AM cptjnrc8v4v78 5.4098E+10 1.9518E+10 5 13.086 1,429,208.8

7937 1 09-NOV-22 12.00.48.118 PM cptjnrc8v4v78 5.4798E+10 1.9889E+10 94 11.368 833,764.8

7938 1 09-NOV-22 01.00.08.631 PM cptjnrc8v4v78 5.4971E+10 1.9973E+10 13 19.668 1,350,828.2

7939 1 09-NOV-22 02.00.28.855 PM cptjnrc8v4v78 5.5129E+10 2.0148E+10 37 8.969 795,681.8

7940 1 09-NOV-22 03.00.49.336 PM cptjnrc8v4v78 5.9872E+10 2.1655E+10 234 26.633 .0

7940 1 09-NOV-22 03.00.49.336 PM cptjnrc8v4v78 722013296 174531319 3178084654 5 24.098 937,608.6

7941 1 09-NOV-22 04.00.09.720 PM cptjnrc8v4v78 6.0925E+10 2.2371E+10 1915411015 114 15.532 1,063,093.5

7942 1 09-NOV-22 05.00.30.006 PM cptjnrc8v4v78 6.3263E+10 2.3464E+10 159 21.594 1,148,011.3

7943 1 09-NOV-22 06.00.50.420 PM cptjnrc8v4v78 6.7764E+10 2.5553E+10 238 27.755 1,423,190.2

7945 1 09-NOV-22 08.00.30.904 PM cptjnrc8v4v78 6.8065E+10 2.5728E+10 21 22.714 1,412,346.2

7945 1 09-NOV-22 08.00.30.904 PM cptjnrc8v4v78 729815853 181136794 3178084654 1 14.566 1,183,869.0

7947 1 09-NOV-22 10.00.11.766 PM cptjnrc8v4v78 6.8947E+10 2.6131E+10 1915411015 52 24.632 1,334,900.4

7949 1 10-NOV-22 12.00.54.072 AM cptjnrc8v4v78 6.8992E+10 2.6168E+10 6 13.558 1,429,198.0

7956 1 10-NOV-22 07.00.17.973 AM cptjnrc8v4v78 7.7629E+10 2.8609E+10 399 27.691 1,422,049.2

7956 1 10-NOV-22 07.00.17.973 AM cptjnrc8v4v78 836259716 205141705 3178084654 5 26.076 1,183,888.4

7958 1 10-NOV-22 09.01.00.280 AM cptjnrc8v4v78 7.7635E+10 2.8633E+10 1915411015 7 4.355 625,539.4

7959 1 10-NOV-22 10.00.21.176 AM cptjnrc8v4v78 7.7645E+10 2.8649E+10 6 4.307 476,521.3

7960 1 10-NOV-22 11.00.41.590 AM cptjnrc8v4v78 7.7744E+10 2.8728E+10 15 11.824 1,238,649.9

7961 1 10-NOV-22 12.00.01.682 PM cptjnrc8v4v78 7.8297E+10 2.9200E+10 105 9.744 848,969.2

7962 1 10-NOV-22 01.00.22.262 PM cptjnrc8v4v78 7.8368E+10 2.9258E+10 9 14.117 1,429,210.3

7963 1 10-NOV-22 02.00.42.487 PM cptjnrc8v4v78 7.8368E+10 2.9292E+10 13 2.649 475,355.8

7964 1 10-NOV-22 03.00.03.156 PM cptjnrc8v4v78 7.9387E+10 2.9646E+10 57 24.022 1,373,084.8

7964 1 10-NOV-22 03.00.03.156 PM cptjnrc8v4v78 852967523 208627873 3178084654 1 20.061 937,615.0

7965 1 10-NOV-22 04.00.23.350 PM cptjnrc8v4v78 8.0221E+10 3.0189E+10 1915411015 86 16.059 1,074,313.6

7966 1 10-NOV-22 05.00.44.408 PM cptjnrc8v4v78 8.1025E+10 3.0651E+10 74 17.052 1,185,367.8

7967 1 10-NOV-22 06.00.04.854 PM cptjnrc8v4v78 8.5391E+10 3.2781E+10 248 26.232 1,404,572.2

7968 1 10-NOV-22 07.00.25.269 PM cptjnrc8v4v78 8.5391E+10 3.2789E+10 4 1.979 368,725.0

7969 1 10-NOV-22 08.00.45.626 PM cptjnrc8v4v78 8.5499E+10 3.2844E+10 8 20.128 1,429,199.4

7971 1 10-NOV-22 10.00.26.999 PM cptjnrc8v4v78 8.9415E+10 3.4431E+10 206 26.687 1,335,261.6

7976 1 11-NOV-22 03.00.11.256 AM cptjnrc8v4v78 8.9482E+10 3.4480E+10 7 16.403 1,429,191.0

7980 1 11-NOV-22 07.00.33.400 AM cptjnrc8v4v78 1.0110E+11 3.7766E+10 542 27.420 1,423,957.4

7980 1 11-NOV-22 07.00.33.400 AM cptjnrc8v4v78 983842757 237242421 3178084654 6 26.591 1,183,873.5

7981 1 11-NOV-22 08.00.54.328 AM cptjnrc8v4v78 1.0111E+11 3.7772E+10 1915411015 1 13.491 1,429,192.0

7982 1 11-NOV-22 09.00.15.289 AM cptjnrc8v4v78 1.0111E+11 3.7793E+10 8 2.628 491,809.0

7983 1 11-NOV-22 10.00.35.829 AM cptjnrc8v4v78 1.0169E+11 3.7953E+10 26 28.616 1,415,558.2

7984 1 11-NOV-22 11.00.56.637 AM cptjnrc8v4v78 1.0170E+11 3.7959E+10 2 7.252 714,915.0

7985 1 11-NOV-22 12.00.17.208 PM cptjnrc8v4v78 1.0381E+11 3.8655E+10 125 22.357 1,227,481.6

7986 1 11-NOV-22 01.00.37.944 PM cptjnrc8v4v78 1.0390E+11 3.8708E+10 8 18.159 1,430,054.3

7987 1 11-NOV-22 02.00.59.064 PM cptjnrc8v4v78 1.0391E+11 3.8752E+10 14 3.726 528,203.1

7988 1 11-NOV-22 03.00.19.895 PM cptjnrc8v4v78 1.0909E+11 4.0287E+10 239 28.047 1,426,671.4

7988 1 11-NOV-22 03.00.19.895 PM cptjnrc8v4v78 1005341578 241058761 3178084654 1 25.165 937,613.0

7989 1 11-NOV-22 04.00.40.760 PM cptjnrc8v4v78 1.0957E+11 4.0677E+10 1915411015 60 14.498 1,095,983.8

7990 1 11-NOV-22 05.00.00.695 PM cptjnrc8v4v78 1.1157E+11 4.1655E+10 127 23.455 1,290,068.1

7991 1 11-NOV-22 06.00.21.558 PM cptjnrc8v4v78 1.1188E+11 4.1871E+10 111 4.738 372,438.7

7992 1 11-NOV-22 07.00.42.167 PM cptjnrc8v4v78 1.1480E+11 4.2789E+10 161 23.872 1,156,535.2

7993 1 11-NOV-22 08.00.02.836 PM cptjnrc8v4v78 1.1502E+11 4.2921E+10 15 23.897 1,401,315.1

7994 1 11-NOV-22 09.00.23.801 PM cptjnrc8v4v78 1.1517E+11 4.2982E+10 9 23.461 1,422,000.8

8039 1 13-NOV-22 06.00.02.604 PM cptjnrc8v4v78 14282415 20432744 236126445 3 11.537 962,970.0

8040 1 13-NOV-22 07.00.14.413 PM cptjnrc8v4v78 35826096 37924162 3 12.980 962,957.3

8045 1 14-NOV-22 12.00.13.644 AM cptjnrc8v4v78 989357236 223128000 38 30.017 869,193.4

8046 1 14-NOV-22 01.00.25.739 AM cptjnrc8v4v78 1036958063 289162758 16 7.078 844,441.1

8047 1 14-NOV-22 02.00.38.667 AM cptjnrc8v4v78 1101566930 339757487 13 8.830 849,291.4

8048 1 14-NOV-22 03.00.52.683 AM cptjnrc8v4v78 1108459663 344026876 1 11.128 963,543.0

8049 1 14-NOV-22 04.00.07.629 AM cptjnrc8v4v78 1119374794 352340133 3 6.392 642,389.3

8052 1 14-NOV-22 07.00.59.018 AM cptjnrc8v4v78 6265739169 2735845456 529 14.211 957,142.0

8052 1 14-NOV-22 07.00.59.018 AM cptjnrc8v4v78 24046956 23407965 3178084654 5 9.492 1,184,586.2

8054 1 14-NOV-22 09.00.34.701 AM cptjnrc8v4v78 6399457957 2813589289 236126445 18 11.748 743,639.3

8055 1 14-NOV-22 10.00.52.492 AM cptjnrc8v4v78 6459480388 2860023242 11 9.639 963,549.9

8056 1 14-NOV-22 11.00.09.291 AM cptjnrc8v4v78 6467312413 2865670534 1 13.439 963,687.0

8057 1 14-NOV-22 12.00.26.124 PM cptjnrc8v4v78 7486129184 3306499675 116 12.548 767,083.4

8058 1 14-NOV-22 01.00.43.660 PM cptjnrc8v4v78 7502245194 3327255119 5 7.344 963,658.0

8059 1 14-NOV-22 02.00.00.139 PM cptjnrc8v4v78 7537346965 3346078532 7 7.667 496,354.4

8060 1 14-NOV-22 03.00.16.780 PM cptjnrc8v4v78 1.0190E+10 4614358295 269 14.546 957,860.8

8061 1 14-NOV-22 04.00.35.276 PM cptjnrc8v4v78 1.0661E+10 4937138476 70 11.335 763,820.6

8062 1 14-NOV-22 05.00.54.284 PM cptjnrc8v4v78 1.3405E+10 6504467076 277 15.553 934,389.1

8063 1 14-NOV-22 06.00.13.322 PM cptjnrc8v4v78 1.6137E+10 8332014628 320 14.250 942,977.3

8066 1 14-NOV-22 09.00.09.614 PM cptjnrc8v4v78 1.6160E+10 8345651136 3 12.069 969,643.7

8067 1 14-NOV-22 10.00.28.363 PM cptjnrc8v4v78 1.6718E+10 8767606130 89 11.025 828,942.4

8069 1 15-NOV-22 12.00.08.013 AM cptjnrc8v4v78 1.6808E+10 8786671352 3 36.163 968,699.3

8070 1 15-NOV-22 01.00.28.877 AM cptjnrc8v4v78 1.6828E+10 8808942728 4 10.531 967,902.0

8071 1 15-NOV-22 02.00.49.614 AM cptjnrc8v4v78 1.6834E+10 8814577080 1 12.428 967,641.0

8072 1 15-NOV-22 03.00.09.294 AM cptjnrc8v4v78 1.6853E+10 8831458063 4 8.738 968,331.0

8076 1 15-NOV-22 07.00.27.403 AM cptjnrc8v4v78 1.9955E+10 1.0257E+10 318 14.209 959,460.4

8076 1 15-NOV-22 07.00.27.403 AM cptjnrc8v4v78 44568946 42456110 3178084654 4 9.827 1,186,699.0

8078 1 15-NOV-22 09.00.06.797 AM cptjnrc8v4v78 2.0018E+10 1.0283E+10 236126445 9 9.896 499,777.0

8079 1 15-NOV-22 10.00.26.891 AM cptjnrc8v4v78 2.0025E+10 1.0291E+10 2 7.179 967,973.0

8081 1 15-NOV-22 12.00.05.643 PM cptjnrc8v4v78 2.0599E+10 1.0587E+10 67 12.996 850,685.2

8082 1 15-NOV-22 01.00.24.718 PM cptjnrc8v4v78 2.0610E+10 1.0608E+10 4 7.877 967,704.8

8083 1 15-NOV-22 02.00.44.171 PM cptjnrc8v4v78 2.0623E+10 1.0618E+10 4 5.780 499,897.3

8084 1 15-NOV-22 03.00.03.241 PM cptjnrc8v4v78 2.2578E+10 1.1674E+10 228 13.181 954,133.2

8085 1 15-NOV-22 04.00.22.796 PM cptjnrc8v4v78 2.2745E+10 1.1838E+10 41 8.080 694,479.2

8086 1 15-NOV-22 05.00.41.740 PM cptjnrc8v4v78 2.3192E+10 1.2133E+10 56 13.216 933,471.9

8087 1 15-NOV-22 06.01.00.683 PM cptjnrc8v4v78 2.7574E+10 1.4888E+10 463 15.392 958,038.1

8089 1 15-NOV-22 08.00.38.603 PM cptjnrc8v4v78 2.7636E+10 1.4928E+10 7 14.505 968,681.0

8090 1 15-NOV-22 09.00.57.740 PM cptjnrc8v4v78 2.7676E+10 1.4953E+10 5 13.168 968,319.6

8091 1 15-NOV-22 10.00.16.525 PM cptjnrc8v4v78 2.8525E+10 1.5616E+10 137 11.041 831,008.0

8095 1 16-NOV-22 02.00.36.559 AM cptjnrc8v4v78 2.8541E+10 1.5625E+10 2 12.358 968,074.5

8096 1 16-NOV-22 03.00.56.780 AM cptjnrc8v4v78 2.8554E+10 1.5636E+10 2 12.206 968,106.0

8100 1 16-NOV-22 07.00.14.923 AM cptjnrc8v4v78 3.3559E+10 1.7905E+10 502 14.478 956,758.3

8100 1 16-NOV-22 07.00.14.923 AM cptjnrc8v4v78 64861290 61724553 3178084654 4 9.840 1,186,878.8

8102 1 16-NOV-22 09.00.54.476 AM cptjnrc8v4v78 3.3584E+10 1.7934E+10 236126445 9 6.018 604,179.4

8103 1 16-NOV-22 10.00.14.605 AM cptjnrc8v4v78 3.3603E+10 1.7961E+10 7 6.716 913,289.6

8105 1 16-NOV-22 12.00.53.964 PM cptjnrc8v4v78 3.4490E+10 1.8342E+10 97 13.049 745,584.6

8107 1 16-NOV-22 02.00.32.267 PM cptjnrc8v4v78 3.4505E+10 1.8355E+10 4 5.695 500,303.0

8108 1 16-NOV-22 03.00.51.468 PM cptjnrc8v4v78 64861290 68725836 3178084654 2 3.508 936,349.0

8108 1 16-NOV-22 03.00.51.468 PM cptjnrc8v4v78 3.5801E+10 1.8902E+10 236126445 115 16.010 967,884.3

8109 1 16-NOV-22 04.00.10.763 PM cptjnrc8v4v78 3.6075E+10 1.9059E+10 36 11.938 760,431.2

8110 1 16-NOV-22 05.00.29.517 PM cptjnrc8v4v78 3.7116E+10 1.9665E+10 131 12.549 818,120.5

8111 1 16-NOV-22 06.00.48.266 PM cptjnrc8v4v78 3.7735E+10 2.0228E+10 102 11.588 928,373.0

8113 1 16-NOV-22 08.00.26.635 PM cptjnrc8v4v78 3.7789E+10 2.0282E+10 10 10.764 969,834.7

8113 1 16-NOV-22 08.00.26.635 PM cptjnrc8v4v78 76237944 84598272 3178084654 1 38.459 1,187,616.0

8115 1 16-NOV-22 10.00.06.734 PM cptjnrc8v4v78 3.8496E+10 2.0782E+10 236126445 99 12.167 876,292.2

8117 1 17-NOV-22 12.00.48.396 AM cptjnrc8v4v78 3.8513E+10 2.0803E+10 4 9.658 969,655.5

8118 1 17-NOV-22 01.00.08.717 AM cptjnrc8v4v78 3.8713E+10 2.0890E+10 17 16.809 960,338.9

8119 1 17-NOV-22 02.00.29.325 AM cptjnrc8v4v78 3.8776E+10 2.0974E+10 20 7.328 869,336.9

8120 1 17-NOV-22 03.00.49.421 AM cptjnrc8v4v78 3.8779E+10 2.0978E+10 1 7.076 969,326.0

8121 1 17-NOV-22 04.00.09.101 AM cptjnrc8v4v78 3.8782E+10 2.0982E+10 2 3.447 484,675.5

8124 1 17-NOV-22 07.00.09.036 AM cptjnrc8v4v78 4.2351E+10 2.2630E+10 364 14.331 964,216.7

8124 1 17-NOV-22 07.00.09.036 AM cptjnrc8v4v78 117902183 127524705 3178084654 9 9.389 1,187,483.8

8126 1 17-NOV-22 09.00.49.038 AM cptjnrc8v4v78 4.2437E+10 2.2656E+10 236126445 6 18.471 .0

8127 1 17-NOV-22 10.00.09.932 AM cptjnrc8v4v78 4.2451E+10 2.2667E+10 2 12.803 969,555.0

8129 1 17-NOV-22 12.00.48.526 PM cptjnrc8v4v78 4.2840E+10 2.2897E+10 61 10.110 797,565.1

8131 1 17-NOV-22 02.00.27.597 PM cptjnrc8v4v78 4.2954E+10 2.2976E+10 16 12.056 823,335.1

8132 1 17-NOV-22 03.00.47.693 PM cptjnrc8v4v78 4.3946E+10 2.3433E+10 97 14.888 961,306.0

8132 1 17-NOV-22 03.00.47.693 PM cptjnrc8v4v78 117902183 138155732 3178084654 3 3.557 936,349.0

8133 1 17-NOV-22 04.00.06.796 PM cptjnrc8v4v78 4.4454E+10 2.3821E+10 236126445 97 9.226 703,895.6

8134 1 17-NOV-22 05.00.25.876 PM cptjnrc8v4v78 4.5294E+10 2.4351E+10 128 10.681 749,137.7

8135 1 17-NOV-22 06.00.45.325 PM cptjnrc8v4v78 4.7545E+10 2.5882E+10 262 14.425 966,529.3

8138 1 17-NOV-22 09.00.43.469 PM cptjnrc8v4v78 4.7562E+10 2.5902E+10 4 9.303 972,237.5

8138 1 17-NOV-22 09.00.43.469 PM cptjnrc8v4v78 126878866 152654596 3178084654 1 30.358 1,188,885.0

8139 1 17-NOV-22 10.00.02.858 PM cptjnrc8v4v78 4.8337E+10 2.6455E+10 236126445 101 13.128 914,074.1

8140 1 17-NOV-22 11.00.23.438 PM cptjnrc8v4v78 4.8343E+10 2.6466E+10 2 8.707 972,297.5

8141 1 18-NOV-22 12.00.43.468 AM cptjnrc8v4v78 4.8484E+10 2.6554E+10 17 13.463 942,699.2

8142 1 18-NOV-22 01.00.04.558 AM cptjnrc8v4v78 4.8513E+10 2.6584E+10 6 9.706 888,358.0

8148 1 18-NOV-22 07.00.05.260 AM cptjnrc8v4v78 5.4623E+10 2.9305E+10 593 14.868 961,017.0

8148 1 18-NOV-22 07.00.05.260 AM cptjnrc8v4v78 157684659 181573305 3178084654 6 9.938 1,189,024.8

8149 1 18-NOV-22 08.00.25.227 AM cptjnrc8v4v78 5.4628E+10 2.9314E+10 236126445 2 6.793 972,586.0

8150 1 18-NOV-22 09.00.45.835 AM cptjnrc8v4v78 5.4695E+10 2.9348E+10 9 11.125 660,810.9

8151 1 18-NOV-22 10.00.05.452 AM cptjnrc8v4v78 5.5082E+10 2.9530E+10 41 13.897 951,680.1

8152 1 18-NOV-22 11.00.25.356 AM cptjnrc8v4v78 5.5085E+10 2.9535E+10 2 4.191 486,632.0

8153 1 18-NOV-22 12.00.45.391 PM cptjnrc8v4v78 5.6220E+10 2.9996E+10 119 13.385 748,239.6

8154 1 18-NOV-22 01.00.04.137 PM cptjnrc8v4v78 5.6230E+10 3.0006E+10 2 9.726 973,351.0

8155 1 18-NOV-22 02.00.23.656 PM cptjnrc8v4v78 5.6659E+10 3.0121E+10 40 13.627 503,678.8

8156 1 18-NOV-22 03.00.43.468 PM cptjnrc8v4v78 0 3506736 12621651 1 3.524 936,701.0

8156 1 18-NOV-22 03.00.43.468 PM cptjnrc8v4v78 1048052375 807029113 1915411015 122 15.234 1,420,116.4

8157 1 18-NOV-22 04.00.02.793 PM cptjnrc8v4v78 1823022022 1209374372 86 13.617 810,362.8

8158 1 18-NOV-22 05.00.22.220 PM cptjnrc8v4v78 2926335192 2293139107 137 16.068 1,328,532.5

8159 1 18-NOV-22 06.00.42.060 PM cptjnrc8v4v78 3914136938 3796207975 167 14.947 1,425,291.6

8160 1 18-NOV-22 07.00.01.193 PM cptjnrc8v4v78 5025321055 4968338821 202 11.329 1,111,185.1

8161 1 18-NOV-22 08.00.20.365 PM cptjnrc8v4v78 5035387963 4984829427 2 13.284 1,442,288.0

8162 1 18-NOV-22 09.00.40.269 PM cptjnrc8v4v78 5058315103 5018447128 5 11.300 1,442,174.0

8192 1 20-NOV-22 04.00.39.355 AM cptjnrc8v4v78 2202132 4622375 3178084654 1 6.784 1,190,431.0

8206 1 20-NOV-22 06.00.48.823 PM cptjnrc8v4v78 17164002 32088319 236126445 5 9.834 974,137.4

8212 1 21-NOV-22 12.00.08.311 AM cptjnrc8v4v78 124622236 92884719 11 15.254 927,568.7

8213 1 21-NOV-22 01.00.22.326 AM cptjnrc8v4v78 128016232 96851809 1 7.323 973,781.0

8214 1 21-NOV-22 02.00.37.815 AM cptjnrc8v4v78 131663890 101101421 2 3.930 487,426.0

8215 1 21-NOV-22 03.00.55.607 AM cptjnrc8v4v78 135382139 106876472 1 9.429 974,960.0

8219 1 21-NOV-22 07.00.04.152 AM cptjnrc8v4v78 6234750835 2856105265 602 14.660 967,749.4

8219 1 21-NOV-22 07.00.04.152 AM cptjnrc8v4v78 56371146 54322361 3178084654 11 10.054 1,190,289.2

8221 1 21-NOV-22 09.00.39.096 AM cptjnrc8v4v78 6349636664 2922025333 236126445 15 12.114 711,741.1

8222 1 21-NOV-22 10.00.55.929 AM cptjnrc8v4v78 6403523111 2984484428 15 7.814 850,621.5

8224 1 21-NOV-22 12.00.30.649 PM cptjnrc8v4v78 7912323157 3719392866 165 13.581 897,416.3

8225 1 21-NOV-22 01.00.48.567 PM cptjnrc8v4v78 7928782938 3742249670 5 7.823 938,812.2

8226 1 21-NOV-22 02.00.07.541 PM cptjnrc8v4v78 7954218304 3756528359 5 7.885 506,931.0

8227 1 21-NOV-22 03.00.24.694 PM cptjnrc8v4v78 1.0377E+10 4901398440 246 14.473 959,423.1

8227 1 21-NOV-22 03.00.24.694 PM cptjnrc8v4v78 56371146 57945750 3178084654 1 3.618 936,349.0

8228 1 21-NOV-22 04.00.39.414 PM cptjnrc8v4v78 1.2110E+10 5736842023 236126445 150 17.146 894,868.8

8229 1 21-NOV-22 05.00.56.565 PM cptjnrc8v4v78 1.4113E+10 6735563149 263 11.388 655,826.0

8229 1 21-NOV-22 05.00.56.565 PM cptjnrc8v4v78 162052347 153583352 3178084654 6 51.735 1,190,338.7

8230 1 21-NOV-22 06.00.13.750 PM cptjnrc8v4v78 1.6988E+10 8841684852 236126445 358 13.931 966,261.0

8233 1 21-NOV-22 09.00.10.806 PM cptjnrc8v4v78 1.7000E+10 8853871774 3 8.231 975,314.3

8234 1 21-NOV-22 10.00.28.921 PM cptjnrc8v4v78 1.7061E+10 8921326856 15 8.480 909,044.3

8236 1 22-NOV-22 12.00.08.567 AM cptjnrc8v4v78 1.7079E+10 8944736019 5 8.277 976,678.8

8237 1 22-NOV-22 01.00.28.726 AM cptjnrc8v4v78 1.7083E+10 8950567183 1 9.490 976,358.0

8238 1 22-NOV-22 02.00.48.950 AM cptjnrc8v4v78 1.7086E+10 8955053154 1 8.261 976,386.0

8240 1 22-NOV-22 04.00.27.320 AM cptjnrc8v4v78 1.7090E+10 8959078244 1 7.149 977,596.0

8243 1 22-NOV-22 07.00.27.829 AM cptjnrc8v4v78 219972919 215582378 3178084654 13 9.214 1,191,238.2

8243 1 22-NOV-22 07.00.27.829 AM cptjnrc8v4v78 2.1234E+10 1.0914E+10 236126445 422 14.438 970,193.0

8245 1 22-NOV-22 09.00.08.891 AM cptjnrc8v4v78 2.1248E+10 1.0926E+10 4 6.346 508,789.0

8246 1 22-NOV-22 10.00.29.949 AM cptjnrc8v4v78 2.1260E+10 1.0939E+10 3 8.385 976,977.0

8247 1 22-NOV-22 11.00.50.359 AM cptjnrc8v4v78 2.1270E+10 1.0955E+10 4 6.583 732,743.3

8248 1 22-NOV-22 12.00.10.615 PM cptjnrc8v4v78 2.1871E+10 1.1195E+10 63 13.303 694,497.8

8249 1 22-NOV-22 01.00.30.902 PM cptjnrc8v4v78 2.1881E+10 1.1208E+10 3 7.643 820,802.0

8250 1 22-NOV-22 02.00.51.127 PM cptjnrc8v4v78 2.2002E+10 1.1270E+10 21 8.675 531,048.6

8251 1 22-NOV-22 03.00.10.805 PM cptjnrc8v4v78 2.2488E+10 1.1506E+10 50 14.398 961,117.7

8251 1 22-NOV-22 03.00.10.805 PM cptjnrc8v4v78 219972919 233402427 3178084654 5 3.578 936,349.0

8252 1 22-NOV-22 04.00.30.904 PM cptjnrc8v4v78 2.2585E+10 1.1611E+10 236126445 25 7.996 755,891.1

8253 1 22-NOV-22 05.00.50.998 PM cptjnrc8v4v78 2.3088E+10 1.1897E+10 57 13.910 861,087.6

8254 1 22-NOV-22 06.00.10.807 PM cptjnrc8v4v78 2.4345E+10 1.2764E+10 144 14.763 968,529.8

8258 1 22-NOV-22 10.00.29.559 PM cptjnrc8v4v78 2.5288E+10 1.3393E+10 116 13.547 893,656.0

8260 1 23-NOV-22 12.00.11.576 AM cptjnrc8v4v78 2.5304E+10 1.3415E+10 4 9.266 873,033.8

8262 1 23-NOV-22 02.00.53.942 AM cptjnrc8v4v78 2.5322E+10 1.3432E+10 4 8.878 887,359.3

8264 1 23-NOV-22 04.00.34.296 AM cptjnrc8v4v78 2.5325E+10 1.3436E+10 3 2.367 325,676.0

8267 1 23-NOV-22 07.00.35.897 AM cptjnrc8v4v78 3.0061E+10 1.5941E+10 558 12.973 965,090.4

8267 1 23-NOV-22 07.00.35.897 AM cptjnrc8v4v78 268840119 281060629 3178084654 10 9.640 1,191,263.9

8268 1 23-NOV-22 08.00.56.696 AM cptjnrc8v4v78 3.0064E+10 1.5946E+10 236126445 1 7.618 976,999.0

8269 1 23-NOV-22 09.00.17.143 AM cptjnrc8v4v78 3.0098E+10 1.5966E+10 7 7.583 508,831.0

8270 1 23-NOV-22 10.00.38.137 AM cptjnrc8v4v78 3.0407E+10 1.6133E+10 37 12.988 959,471.5

8272 1 23-NOV-22 12.00.19.383 PM cptjnrc8v4v78 3.0911E+10 1.6387E+10 63 11.993 821,962.7

8273 1 23-NOV-22 01.00.40.440 PM cptjnrc8v4v78 3.0918E+10 1.6395E+10 2 7.289 977,174.5

8274 1 23-NOV-22 02.01.00.856 PM cptjnrc8v4v78 3.1036E+10 1.6475E+10 14 14.106 923,645.5

8275 1 23-NOV-22 03.00.20.469 PM cptjnrc8v4v78 3.3401E+10 1.7693E+10 247 14.460 957,847.7

8275 1 23-NOV-22 03.00.20.469 PM cptjnrc8v4v78 268840119 284825953 3178084654 1 3.770 936,349.0

8276 1 23-NOV-22 04.00.40.696 PM cptjnrc8v4v78 3.4818E+10 1.8124E+10 236126445 116 15.989 614,503.9

8277 1 23-NOV-22 05.00.00.850 PM cptjnrc8v4v78 3.5609E+10 1.8572E+10 79 15.676 952,148.4

8278 1 23-NOV-22 06.00.20.920 PM cptjnrc8v4v78 3.8008E+10 2.0087E+10 244 16.048 971,878.2

8280 1 23-NOV-22 08.00.01.014 PM cptjnrc8v4v78 3.8012E+10 2.0093E+10 1 9.517 977,691.0

8282 1 23-NOV-22 10.00.42.359 PM cptjnrc8v4v78 3.8548E+10 2.0444E+10 61 14.510 943,579.9

8282 1 23-NOV-22 10.00.42.359 PM cptjnrc8v4v78 280495355 300545430 3178084654 1 36.236 1,195,435.0

8287 1 24-NOV-22 03.00.26.550 AM cptjnrc8v4v78 3.8591E+10 2.0487E+10 236126445 9 9.615 927,572.9

8287 1 24-NOV-22 03.00.26.550 AM cptjnrc8v4v78 289442133 314765808 3178084654 2 11.620 1,191,655.0

8291 1 24-NOV-22 07.00.50.040 AM cptjnrc8v4v78 369539283 398081471 18 9.072 1,191,685.0

8291 1 24-NOV-22 07.00.50.040 AM cptjnrc8v4v78 4.2227E+10 2.2283E+10 236126445 401 13.536 973,809.8

8296 1 24-NOV-22 12.00.32.759 PM cptjnrc8v4v78 4.2339E+10 2.2349E+10 16 11.043 914,319.9

8299 1 24-NOV-22 03.00.34.230 PM cptjnrc8v4v78 4.3143E+10 2.2760E+10 90 13.486 .0

8299 1 24-NOV-22 03.00.34.230 PM cptjnrc8v4v78 369539283 401299975 3178084654 1 3.235 936,349.0

8301 1 24-NOV-22 05.00.15.095 PM cptjnrc8v4v78 4.3386E+10 2.2861E+10 236126445 27 12.733 777,948.3

8302 1 24-NOV-22 06.00.35.960 PM cptjnrc8v4v78 4.3534E+10 2.2944E+10 18 12.773 978,098.2

8304 1 24-NOV-22 08.00.16.119 PM cptjnrc8v4v78 4.3543E+10 2.2952E+10 2 8.793 977,786.0

8306 1 24-NOV-22 10.00.57.526 PM cptjnrc8v4v78 4.3547E+10 2.2956E+10 1 7.499 978,229.0

8308 1 25-NOV-22 12.00.39.161 AM cptjnrc8v4v78 4.3567E+10 2.2978E+10 5 8.412 978,082.2

8315 1 25-NOV-22 07.00.03.221 AM cptjnrc8v4v78 4.9518E+10 2.5877E+10 652 13.548 969,160.3

8315 1 25-NOV-22 07.00.03.221 AM cptjnrc8v4v78 454580681 488736792 3178084654 19 9.069 1,191,874.5

8317 1 25-NOV-22 09.00.44.469 AM cptjnrc8v4v78 4.9649E+10 2.5947E+10 236126445 17 11.873 694,158.6

8319 1 25-NOV-22 11.00.25.080 AM cptjnrc8v4v78 5.0071E+10 2.6119E+10 41 14.527 882,603.2

8320 1 25-NOV-22 12.00.44.984 PM cptjnrc8v4v78 5.0961E+10 2.6514E+10 100 12.850 799,579.4

8321 1 25-NOV-22 01.00.05.881 PM cptjnrc8v4v78 5.1018E+10 2.6567E+10 10 10.891 978,216.5

8322 1 25-NOV-22 02.00.26.935 PM cptjnrc8v4v78 5.1063E+10 2.6603E+10 10 7.995 825,171.2

8323 1 25-NOV-22 03.00.47.606 PM cptjnrc8v4v78 454580681 492296954 3178084654 1 3.563 936,349.0

8323 1 25-NOV-22 03.00.47.606 PM cptjnrc8v4v78 5.4029E+10 2.8418E+10 236126445 341 14.013 968,447.8

8324 1 25-NOV-22 04.00.07.158 PM cptjnrc8v4v78 5.4057E+10 2.8456E+10 7 9.451 978,254.7

8325 1 25-NOV-22 05.00.27.126 PM cptjnrc8v4v78 5.4630E+10 2.8850E+10 73 13.260 902,201.7

8326 1 25-NOV-22 06.00.47.096 PM cptjnrc8v4v78 5.5251E+10 2.9262E+10 70 14.742 974,066.0

8327 1 25-NOV-22 07.00.06.516 PM cptjnrc8v4v78 5.7307E+10 3.0455E+10 309 10.508 760,428.9

8330 1 25-NOV-22 10.00.05.367 PM cptjnrc8v4v78 5.7462E+10 3.0571E+10 21 13.022 942,166.7

8374 1 27-NOV-22 06.00.21.046 PM cptjnrc8v4v78 5.7494E+10 3.0605E+10 6 10.820 976,329.5

8380 1 28-NOV-22 12.00.25.847 AM cptjnrc8v4v78 5.7515E+10 3.0629E+10 5 9.044 978,889.4

8381 1 28-NOV-22 01.00.46.582 AM cptjnrc8v4v78 5.7523E+10 3.0641E+10 2 9.966 978,026.0

8383 1 28-NOV-22 03.00.28.471 AM cptjnrc8v4v78 5.7527E+10 3.0646E+10 1 8.222 978,084.0

8384 1 28-NOV-22 04.00.49.272 AM cptjnrc8v4v78 5.7530E+10 3.0650E+10 3 2.666 326,044.0

8387 1 28-NOV-22 07.00.50.938 AM cptjnrc8v4v78 6.3103E+10 3.3398E+10 603 13.776 968,013.8

8387 1 28-NOV-22 07.00.50.938 AM cptjnrc8v4v78 527578725 563434271 3178084654 15 9.596 1,191,696.7

8389 1 28-NOV-22 09.00.31.671 AM cptjnrc8v4v78 6.3311E+10 3.3480E+10 236126445 21 13.763 643,444.3

8390 1 28-NOV-22 10.00.52.792 AM cptjnrc8v4v78 6.3364E+10 3.3513E+10 8 10.489 977,873.0

8391 1 28-NOV-22 11.00.13.302 AM cptjnrc8v4v78 6.3367E+10 3.3517E+10 2 3.625 488,945.0

8392 1 28-NOV-22 12.00.33.911 PM cptjnrc8v4v78 6.4215E+10 3.3877E+10 95 12.698 731,010.5

8393 1 28-NOV-22 01.00.54.647 PM cptjnrc8v4v78 6.4226E+10 3.3890E+10 3 7.606 977,779.3

8394 1 28-NOV-22 02.00.15.863 PM cptjnrc8v4v78 6.4377E+10 3.3957E+10 20 10.927 579,845.2

8395 1 28-NOV-22 03.00.36.667 PM cptjnrc8v4v78 527578725 567002811 3178084654 1 3.568 936,349.0

8395 1 28-NOV-22 03.00.36.667 PM cptjnrc8v4v78 6.6233E+10 3.4994E+10 236126445 211 13.709 963,386.8

8396 1 28-NOV-22 04.00.57.333 PM cptjnrc8v4v78 6.7779E+10 3.5771E+10 164 14.153 783,043.1

8397 1 28-NOV-22 05.00.16.954 PM cptjnrc8v4v78 6.9009E+10 3.6629E+10 171 12.199 863,105.9

8398 1 28-NOV-22 06.00.36.470 PM cptjnrc8v4v78 7.0434E+10 3.7654E+10 173 14.193 969,482.6

8400 1 28-NOV-22 08.00.17.529 PM cptjnrc8v4v78 7.0455E+10 3.7682E+10 5 9.794 979,266.8

8402 1 28-NOV-22 10.00.57.975 PM cptjnrc8v4v78 7.1292E+10 3.8368E+10 126 12.077 906,282.7

8404 1 29-NOV-22 12.00.38.646 AM cptjnrc8v4v78 7.1304E+10 3.8386E+10 3 10.205 941,702.7

8406 1 29-NOV-22 02.00.20.537 AM cptjnrc8v4v78 7.1309E+10 3.8391E+10 1 9.926 984,180.0

8411 1 29-NOV-22 07.00.01.681 AM cptjnrc8v4v78 7.4978E+10 4.0270E+10 412 13.450 972,394.7

8411 1 29-NOV-22 07.00.01.681 AM cptjnrc8v4v78 580400891 624266956 3178084654 12 9.159 1,195,134.4

8413 1 29-NOV-22 09.00.42.102 AM cptjnrc8v4v78 7.5109E+10 4.0347E+10 236126445 18 11.533 725,484.1

8414 1 29-NOV-22 10.00.01.272 AM cptjnrc8v4v78 7.5169E+10 4.0387E+10 9 11.019 985,459.8

8415 1 29-NOV-22 11.00.21.048 AM cptjnrc8v4v78 7.5176E+10 4.0396E+10 2 8.378 987,283.5

8416 1 29-NOV-22 12.00.41.590 PM cptjnrc8v4v78 7.6098E+10 4.0787E+10 106 12.372 702,720.4

8418 1 29-NOV-22 02.00.21.558 PM cptjnrc8v4v78 7.6263E+10 4.0852E+10 20 11.117 523,274.1

8419 1 29-NOV-22 03.00.41.847 PM cptjnrc8v4v78 7.6741E+10 4.1110E+10 55 13.331 992,233.5

8420 1 29-NOV-22 04.00.01.812 PM cptjnrc8v4v78 7.6943E+10 4.1281E+10 39 9.596 757,467.1

8421 1 29-NOV-22 05.00.22.456 PM cptjnrc8v4v78 7.7195E+10 4.1475E+10 45 9.871 806,034.4

8422 1 29-NOV-22 06.00.43.510 PM cptjnrc8v4v78 7.9428E+10 4.3202E+10 284 13.969 990,628.6

8424 1 29-NOV-22 08.00.23.672 PM cptjnrc8v4v78 7.9661E+10 4.3361E+10 27 14.619 992,265.7

8425 1 29-NOV-22 09.00.44.217 PM cptjnrc8v4v78 7.9669E+10 4.3372E+10 2 8.685 997,890.5

8426 1 29-NOV-22 10.00.04.536 PM cptjnrc8v4v78 8.0276E+10 4.3922E+10 105 11.011 878,740.0

8428 1 30-NOV-22 12.00.46.389 AM cptjnrc8v4v78 8.0280E+10 4.3927E+10 1 8.015 997,577.0

8430 1 30-NOV-22 02.00.27.510 AM cptjnrc8v4v78 0 3084835 12621651 1 3.095 938,145.0

8431 1 30-NOV-22 03.00.47.736 AM cptjnrc8v4v78 3050688 7351025 236126445 1 10.380 998,232.0

8435 1 30-NOV-22 07.00.10.551 AM cptjnrc8v4v78 2801127394 3119565111 3178084654 486 9.794 1,179,727.2

8436 1 30-NOV-22 08.00.31.542 AM cptjnrc8v4v78 3049412233 3524568314 70 9.347 1,174,319.9

8437 1 30-NOV-22 09.00.52.472 AM cptjnrc8v4v78 3448153401 3774471573 15 58.984 1,195,198.2

8438 1 30-NOV-22 10.00.13.176 AM cptjnrc8v4v78 3484327143 3822337809 9 9.352 1,078,001.0

8439 1 30-NOV-22 11.00.34.101 AM cptjnrc8v4v78 3500555530 3853670904 4 13.323 1,477,899.3

8440 1 30-NOV-22 12.00.54.070 PM cptjnrc8v4v78 4390745472 4359243822 43 40.730 1,180,153.7

8441 1 30-NOV-22 01.00.13.815 PM cptjnrc8v4v78 4394965329 4369491861 2 7.239 1,200,957.0

8442 1 30-NOV-22 02.00.34.167 PM cptjnrc8v4v78 4672498274 4500025299 19 30.577 861,059.4

8443 1 30-NOV-22 03.00.55.357 PM cptjnrc8v4v78 5196098251 5433261380 155 9.412 1,223,391.0

8444 1 30-NOV-22 04.00.15.927 PM cptjnrc8v4v78 2.6668E+10 1.1058E+10 345 101.059 1,185,227.2

8445 1 30-NOV-22 05.00.36.280 PM cptjnrc8v4v78 4.8470E+10 2.2270E+10 592 68.869 1,206,761.2

8446 1 30-NOV-22 06.00.56.373 PM cptjnrc8v4v78 5.5203E+10 2.7640E+10 334 45.937 1,189,851.9

8448 1 30-NOV-22 08.00.36.920 PM cptjnrc8v4v78 5.5981E+10 2.8108E+10 27 64.363 1,198,094.3

8449 1 30-NOV-22 09.00.57.592 PM cptjnrc8v4v78 5.6057E+10 2.8173E+10 6 23.856 1,200,985.5

8450 1 30-NOV-22 10.00.17.785 PM cptjnrc8v4v78 6.4205E+10 3.1187E+10 215 67.628 1,141,736.8

8451 1 30-NOV-22 11.00.41.080 PM cptjnrc8v4v78 6.4210E+10 3.1196E+10 2 7.270 1,201,055.0

8451 1 30-NOV-22 11.00.41.080 PM cptjnrc8v4v78 1775858 4363460 996902736 1 6.126 1,201,731.0

8452 1 01-DEC-22 12.00.01.556 AM cptjnrc8v4v78 6.4212E+10 3.1201E+10 3178084654 1 6.528 1,201,058.0

8454 1 01-DEC-22 02.00.43.253 AM cptjnrc8v4v78 6.4228E+10 3.1220E+10 2 22.889 1,201,019.5

8459 1 01-DEC-22 07.00.26.039 AM cptjnrc8v4v78 6.5610E+10 3.3030E+10 370 8.640 1,172,290.7

8459 1 01-DEC-22 07.00.26.039 AM cptjnrc8v4v78 59364288 79019034 996902736 15 8.809 1,201,081.4

8461 1 01-DEC-22 09.00.05.941 AM cptjnrc8v4v78 6.6074E+10 3.3499E+10 3178084654 48 23.923 1,189,047.1

8462 1 01-DEC-22 10.00.27.319 AM cptjnrc8v4v78 6.6326E+10 3.3609E+10 8 51.517 1,201,375.8

8463 1 01-DEC-22 11.00.48.824 AM cptjnrc8v4v78 6.8162E+10 3.5333E+10 235 17.519 1,075,293.9

8464 1 01-DEC-22 12.00.09.143 PM cptjnrc8v4v78 6.9408E+10 3.6625E+10 131 24.167 1,189,477.9

8465 1 01-DEC-22 01.00.29.174 PM cptjnrc8v4v78 6.9419E+10 3.6651E+10 4 10.591 1,201,351.8

8466 1 01-DEC-22 02.00.49.526 PM cptjnrc8v4v78 7.1655E+10 3.8468E+10 105 49.199 1,198,185.7

8467 1 01-DEC-22 03.00.09.015 PM cptjnrc8v4v78 7.2047E+10 3.9148E+10 117 9.186 1,181,923.2

8468 1 01-DEC-22 04.00.28.927 PM cptjnrc8v4v78 7.4765E+10 4.0401E+10 72 73.762 1,191,047.9

8469 1 01-DEC-22 05.00.49.975 PM cptjnrc8v4v78 60981987 84580493 996902736 1 7.069 1,201,310.0

8469 1 01-DEC-22 05.00.49.975 PM cptjnrc8v4v78 7.5053E+10 4.0948E+10 3178084654 46 20.307 1,149,543.5

8470 1 01-DEC-22 06.00.09.590 PM cptjnrc8v4v78 8.4397E+10 4.5271E+10 243 73.000 .0

8472 1 01-DEC-22 08.00.52.282 PM cptjnrc8v4v78 8.4405E+10 4.5291E+10 2 14.225 1,063,165.5

8473 1 01-DEC-22 09.00.11.959 PM cptjnrc8v4v78 8.4456E+10 4.5362E+10 5 27.354 1,146,580.4

8474 1 01-DEC-22 10.00.32.568 PM cptjnrc8v4v78 8.9978E+10 4.6725E+10 96 90.783 1,132,457.4

8476 1 02-DEC-22 12.00.15.419 AM cptjnrc8v4v78 8.9978E+10 4.6729E+10 1 4.721 1,189,943.0

8478 1 02-DEC-22 02.00.56.437 AM cptjnrc8v4v78 9.0063E+10 4.6816E+10 6 40.281 1,189,943.0

8481 1 02-DEC-22 05.00.56.694 AM cptjnrc8v4v78 9.0063E+10 4.6858E+10 9 4.750 936,355.0

8483 1 02-DEC-22 07.00.36.983 AM cptjnrc8v4v78 1.0396E+11 5.6662E+10 899 33.417 1,175,507.5

8483 1 02-DEC-22 07.00.36.983 AM cptjnrc8v4v78 2847 424238 186594522 19 .024 1,022.6

8484 1 02-DEC-22 08.00.57.142 AM cptjnrc8v4v78 1.0396E+11 5.6676E+10 3178084654 4 3.499 936,617.0

8485 1 02-DEC-22 09.00.17.270 AM cptjnrc8v4v78 1.0403E+11 5.6806E+10 8 27.168 1,190,589.1

8486 1 02-DEC-22 10.00.37.110 AM cptjnrc8v4v78 1.0403E+11 5.6849E+10 10 4.328 1,190,859.1

350 rows selected.

----------------------------------

Load plan for particular plan hash value

SQL> vari rc number

SQL> exec :rc:=dbms_spm.load_plans_from_cursor_cache(sql_id=>'cptjnrc8v4v78',plan_hash_value=>186594522)

PL/SQL procedure successfully completed.

Baseline plan details for SQL ID

SELECT sql_handle, plan_name,ENABLED,ACCEPTED,FIXED,REPRODUCED,OPTIMIZER_COST,to_char(Created,'DD-MON-YY') Created FROM dba_sql_plan_baselines WHERE signature IN ( SELECT exact_matching_signature FROM v$sql WHERE sql_id='&SQL_ID');SQL>

Enter value for sql_id: cptjnrc8v4v78

SQL_HANDLE PLAN_NAME ENA ACC FIX REP OPTIMIZER_COST CREATED

------------------------------ -------------------------------------------------------------------------------------------------------------------------------- --- --- --- --- -------------- ---------------------------------------------------------------------------

SQL_37c41eb20989b214 SQL_PLAN_3gj0yq84smchnebd682d8 YES YES NO YES 464 02-DEC-22

SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID='cptjnrc8v4v78';

ADDRESS HASH_VALUE

---------------- ----------

00000000974D7470 296905960

Query to Purge Plan hash values except particular plan 186594522

SELECT inst_id,

'exec dbms_shared_pool.purge('''

|| address

|| ','

|| hash_value

|| ''',''C'',65);'

FROM gv$sqlarea

WHERE sql_id = 'cptjnrc8v4v78'

and plan_hash_value not in (186594522);

SQL> exec dbms_shared_pool.purge('00000000974D7470,296905960','C',65);

PL/SQL procedure successfully completed.

---

------------------------------------------- Miscellaneous ------------------------------

select ADDRESS, HASH_VALUE,OLD_HASH_VALUE,PLAN_HASH_VALUE from V$SQLAREA

where SQL_ID like ‘9kt723m2uSvna';

ADDRESS HASH_VALUE OLD_HASH_VALUE PLAN_HASH_VALUE

000000025D79C260 3315789450 2641519603 2172072736

EXEC sys.DBMS_SHARED_POOL.purge('000000010182AE70,1862304678', 'C');

show parameter OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES

alter system set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=TRUE

QL> select * from sqllog$;

SIGNATURE BATCH#

---------------------------------- ----------

3812309255651905568 1

SQL> select signature, sql_text from dba_sql_plan_baselines;

select sql_id, sql_text , exact_matching_signature from v$sql where exact_matching_signature=3812309255651905568;

SELECT sql_id, sql_fulltext FROM v$sql WHERE sql_text LIKE 'SELECT * FROM t WHERE %';

DECLARE

cnt NUMBER;

BEGIN

cnt := sys.dbms_spm.load_plans_from_cursor_cache(sql_id=>'fgumtf1strwxa');

END;

-- Quickly check in dba_sql_plan_baseline to confirm the baseline exists

SELECT b.sql_handle, b.sql_text, b.plan_name, b.enabled FROM dba_sql_plan_baselines b, v$sql s WHERE s.sql_id='fgumtf1strwxa' AND s.exact_matching_signature = b.signature;

-- The full table scan plan is not the plan we want, so let's disable this plan

DECLARE

cnt NUMBER;

BEGIN

cnt := sys.dbms_spm.alter_sql_plan_baseline(sql_handle=>'SQL_79c1d14a660634eb', plan_name=>'SQL_PLAN_7mhfj99m0cd7b94ecae5c', attribute_name=>'enabled', attribute_value=>'NO');

END;

-- The full table scan plan is not the plan we want, so let's disable this plan

DECLARE

cnt NUMBER;

BEGIN

cnt := sys.dbms_spm.alter_sql_plan_baseline(sql_handle=>'SQL_79c1d14a660634eb', plan_name=>'SQL_PLAN_7mhfj99m0cd7b94ecae5c',attribute_name=>'enabled', attribute_value=>'NO');

END;

SELECT * FROM TABLE(dbms_xplan.display_cursor());

SELECT sql_id, plan_hash_value, sql_fulltext

FROM v$sql

WHERE sql_text LIKE 'SELECT /*+ INDEX(t) */ * FROM t WHERE %';

------------------------------------------------------------------

LOAD THE SQL PLAN BASELINE MANUALLY

------------------------------------------------------------------

DECLARE

l_plans_loaded PLS_INTEGER;

BEGIN

l_plans_loaded := DBMS_SPM.load_plans_from_cursor_cache(sql_id =>'025dz4fcojj19', plan_hash_value=>6164147879,fixed=>'YES');

END;

Check the SQL plan baseline usage

SELECT * FROM dba_sql_plan_baselines where sql_text like "%SELECT /*+ ALL_ROWS */ T36.CONFLICT_ID,%';

SELECT * FROM dba_sql_plan_baselines where plan_name='SQL_PLAN_783fdfshdu98980';

Display SQL plan baselines

SELECT * FROM TABLE (DBMS_XPLAN.display_sql_plan_baseline (plan_name => 'SQL_PLAN_38327euwhcvjfug9tr8g'));

Drop the SQL plan baseline

SELECT * FROM dba_sql_plan_baselines where sql_text like "%SELECT /*+ ALL_ROWS */ T36.CONFLICT_ID,%';

select sql_handle, plan_name, enabled, accepted, fixed from dba_sql_plan_baselines;

SQL_HANDLE PLAN_NAME ENA ACC FIX

SYS_SQL_162hcjcded167 SYS_SQL_PLAN_tr463r7834kdgdn09

YES NO NO

SYS_SQL_162hcjcded167 SYS_SQL_PLAN_xcr35373bctcy21 YES

YES NO

set serveroutput on

declare

my_int pls_integer;

begin

my_int := DBMS_SPM.DROP_SQL_PLAN_BASELINE (

sql_handle => 'SQL_gdhwqe7326832',

plan_name =>'SQL_PLAN_89hwdj ew632e8932');

DBMS_OUTPUT.PUT_line(my_int);

end

1. RUN SQL TUNING ADVISOR

set long 1000000000

Col recommendations for a20@

DECLARE

1_sql_tune_task_id VARCHAR2(1@@) ;

BEGIN

1_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (sql_id => '6dkrnbx1zdwy38' ,scope => DBMS_SQLTUNE.scope_comprehensive,time_limit => 50e,task_name => ‘6dkrnbx1zdwy38_tuning_task_1',description => 'Tuning task for statement 6dkrnbx1zdwy38' ) ;

DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' ||1_sql_tune_task_id);

END;

EXEC DBMS_SQLTUNE.execute_tuning task(task_name => '6dkrnbx1zdwy38_tuning_task_1');

SET LONG 10000000;

SET PAGESIZE 100@00000

SET LINESIZE 200

SELECT DBMS_SQLTUNE.report_tuning_task('6dkrnbx1zdwy38_tuning_task_1') AS recommendations FROM dual;

2. ACCEPT THE SQL_PROFILE

execute dbms_sqltune.accept_sql_profile(task_name => ‘6dkrnbx1zdwy38_tuning_task_1', task_owner => 'SYS', replace =>TRUE);

3. CHECK THE NAME OF THE SQL_PROFILE

select name,status,force_matching from dba_sql_profiles where task_id in ( select task_id from DBA_ADVISOR_TASKS where task_name =" 6dkrnbx1zdwy38_tuning_task_1')

set pagesize 299

set lines 299

col name for a45

NAME STATUS FOR

SYS_SQLPROF_632746374839279 ENABLED NO

4. DISABLE THE SQL_PROFILE

BEGIN

DBMS_SQLTUNE.ALTER_SQL_PROFILE(name => 'SYS_SQLPROF_632746374839279',attribute_name => ‘STATUS’,value => ‘DISABLED');

END;

To enable to change the value from DISABLED to

ENABLED.

5. DROP THE SQL_PROFILE

begin

DBMS_SQLTUNE.DROP_SQL_PROFILE(name => ‘SYS SQLPROF_632746374839279');

end;

HOME

Sunday, 25 December 2022

Examples sessions commands

Db Troubleshooting : Tips to Check alert log file error using command

Thursday, 15 December 2022

PT : Load plan hash value from particular sql_id