I got a questions from one user of Exadata:
1.Do we need to gather system statistics on Exadata ?
2. How to gather system statistics on Exadata ?
3. If I run the command exec dbms_stats.gather_system_stats ('EXADATA') - how to point the start time and end time?
1.Do we need to gather system statistics on Exadata ?
cost = (#srds * sreadtm + #mrds * mreadtm + #cpucycles / cpuspeed) / sreadtm
#srds number of single block reads
sreadtm single block read time
#mrds number of multi block reads
mreadtm multi block read time
#cpucycles number of cpu cycles
cpuspeed cpu cycles per second
-
System resources, which includes estimated I/O, CPU, and memory .... "
So, in order to generate an optimal plan, the optimizer must know the characteristics of the equipment.
10.2.4
System Statistic: " The system statistics describe hardware characteristics such as I/O and CPU performance and utilization.
System statistics enable the query optimizer to
more accurately estimate I/O and CPU costs when choosing execution
plans. The database does not invalidate previously parsed SQL statements
when updating system statistics. The database parses all new SQL
statements using new statistics. "
Table 15-2 Optimizer System Statistics in the DBMS_STAT Package
Unlike table, index, or column statistics, Oracle does not
invalidate already parsed SQL statements when system statistics get
updated. All new SQL statements are parsed using new statistics.
https://docs.oracle.com/cd/B14117_01/server.101/b10752/stats.htm#40899
But there is another view on this question: https://blogs.oracle.com/optimizer/should-you-gather-system-statistics
2. How to gather system statistics on Exadata ?
13.4 Gathering System Statistics Manually
166.7.53 GATHER_SYSTEM_STATS Procedure
Rules:
- Capture system statistics when the database has the most typical workload
- Capture system statistics during not less than 1-2 hours
Also you can set YOUR OWN VALUES:
1. begin
dbms_stats.set_system_stats('sreadtim',2);
-- define single blocks reads to 2 ms
dbms_stats.set_system_stats('mreadtim',5);
-- define multiblock reads to 5 ms
end;
3. About dbms_stats.gather_system_stats ('EXADATA')
The dbms_stats.gather_system_stats('EXADATA') - does not gather statistics, it simply SET SOME CONSTANTS:
For example, on my notebook i have defaul values before dbms_stats.gather_system_stats('EXADATA'):
SQL> select * from aux_stats$;
SNAME
PNAME
PVAL1 PVAL2
-------------
----------------------- ---------- ---------------------
SYSSTATS_INFO
STATUS
COMPLETED
SYSSTATS_INFO
DSTART
07-29-2020 07:53
SYSSTATS_INFO
DSTOP
07-29-2020 07:53
SYSSTATS_INFO
FLAGS
1
SYSSTATS_MAIN
CPUSPEEDNW
897.990726
SYSSTATS_MAIN
IOSEEKTIM
10
SYSSTATS_MAIN
IOTFRSPEED
4096
SYSSTATS_MAIN
SREADTIM
SYSSTATS_MAIN
MREADTIM
SYSSTATS_MAIN
CPUSPEED
SYSSTATS_MAIN
MBRC
SYSSTATS_MAIN
MAXTHR
SYSSTATS_MAIN
SLAVETHR
SQL>
delete * from aux_stats$;
SQL>
commit;
Commit
complete.
SQL> exec
dbms_stats.gather_system_stats('EXADATA');
PL/SQL
procedure successfully completed.
SQL> select * from aux_stats$;
SNAME
PNAME PVAL1 PVAL2
-------------
------------------------ ---------- ---------------------
SYSSTATS_INFO
STATUS
COMPLETED
SYSSTATS_INFO
DSTART
12-16-2020 11:34
SYSSTATS_INFO
DSTOP
12-16-2020 11:34
SYSSTATS_INFO
FLAGS
1
SYSSTATS_MAIN
CPUSPEEDNW 2928
SYSSTATS_MAIN
IOSEEKTIM 10
SYSSTATS_MAIN
IOTFRSPEED
204800
SYSSTATS_MAIN
SREADTIM
SYSSTATS_MAIN
MREADTIM
SYSSTATS_MAIN
CPUSPEED
SYSSTATS_MAIN
MBRC 83
SYSSTATS_MAIN
MAXTHR
SYSSTATS_MAIN
SLAVETHR
13 rows selected.
As you can see dbms_stats.gather_system_stats('EXADATA')simply set
CPUSPEEDNW 2987
IOSEEKTIM
10
IOTFRSPEED
204800
MBRC
83
Or dbms_stats.gather_system_stats('EXADATA') calculated these values ?
Let trace dbms_stats.gather_system_stats('EXADATA') :
SQL> alter session set events '10046 trace name context forever, level 4';
SQL> exec dbms_stats.gather_system_stats('EXADATA');
SQL> alter session set events '10046 trace name context forever, level 0';
What we see in the trace:
=====================
PARSING IN
CURSOR #140565938845448 len=77 dep=1 uid=0 oct=2 lid=0 tim=1832183071
hv=928404322 ad='6a0f3e88' sqlid='67ncvpsvpcnv2'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'CPUSPEEDNW', :B1 , NULL)
END OF STMT
BINDS
#140565938845448:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1460 bln=22 avl=03 flg=09
value=2928
EXEC
#140565938845448:c=45,e=45,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183111
CLOSE
#140565938845448:c=1,e=1,dep=1,type=3,tim=1832183122
=====================
PARSING IN
CURSOR #140565938842944 len=76 dep=1 uid=0 oct=2 lid=0 tim=1832183132
hv=543581576 ad='6a0f3b58' sqlid='auvf07wh6ctc8'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'IOSEEKTIM', :B1 , NULL)
END OF STMT
BINDS
#140565938842944:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1478 bln=22 avl=02 flg=09
value=10
EXEC
#140565938842944:c=37,e=37,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183165
CLOSE
#140565938842944:c=0,e=0,dep=1,type=3,tim=1832183174
=====================
PARSING IN
CURSOR #140565938837432 len=77 dep=1 uid=0 oct=2 lid=0 tim=1832183184
hv=3127723828 ad='6a0f3828' sqlid='38gjx7kx6ujtn'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'IOTFRSPEED', :B1 , NULL)
END OF STMT
BINDS
#140565938837432:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1490 bln=22 avl=03 flg=09
value=204800
EXEC
#140565938837432:c=36,e=36,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183216
CLOSE
#140565938837432:c=0,e=0,dep=1,type=3,tim=1832183226
=====================
The full listing of trace file:
===========================================================
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_10584.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0
Build label: RDBMS_19.9.0.0.0DBRU_LINUX.X64_200930
ORACLE_HOME: /u01/app/oracle/dbhome_1
System name: Linux
Node name: oem.test.edu
Release: 5.4.17-2011.4.4.el8uek.x86_64
Version: #2 SMP Sat Jun 27 11:14:55 PDT 2020
Machine: x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 7
Unix process pid: 10584, image: oracle@oem.test.edu
*** 2020-12-16T11:41:38.329894+03:00 (PDB1(3))
*** SESSION ID:(240.2244) 2020-12-16T11:41:38.329923+03:00
*** CLIENT ID:() 2020-12-16T11:41:38.329926+03:00
*** SERVICE NAME:(pdb1) 2020-12-16T11:41:38.329929+03:00
*** MODULE NAME:(sqlplus@oem.test.edu (TNS V1-V3)) 2020-12-16T11:41:38.329932+03:00
*** ACTION NAME:() 2020-12-16T11:41:38.329934+03:00
*** CLIENT DRIVER:(SQL*PLUS) 2020-12-16T11:41:38.329936+03:00
*** CONTAINER ID:(3) 2020-12-16T11:41:38.329939+03:00
CLOSE #140565941051688:c=23,e=23,dep=0,type=1,tim=1832062095
=====================
PARSING IN CURSOR #140565942129688 len=54 dep=0 uid=0 oct=47 lid=0 tim=1832062521 hv=1060689565 ad='6bccd980' sqlid='95vr6z4zmjpnx'
BEGIN dbms_stats.gather_system_stats('EXADATA'); END;
END OF STMT
PARSE #140565942129688:c=44,e=44,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1832062520
=====================
PARSING IN CURSOR #140565941838896 len=73 dep=1 uid=0 oct=3 lid=0 tim=1832062775 hv=2059840778 ad='67bf7358' sqlid='2f002z1xcdb8a'
SELECT VALUE FROM SYS.NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_SORT'
END OF STMT
EXEC #140565941838896:c=21,e=21,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=1805486652,tim=1832062774
FETCH #140565941838896:c=20,e=20,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=1805486652,tim=1832062842
CLOSE #140565941838896:c=0,e=0,dep=1,type=3,tim=1832062855
=====================
PARSING IN CURSOR #140565940524088 len=73 dep=1 uid=0 oct=3 lid=0 tim=1832062872 hv=1472012665 ad='67bf7028' sqlid='5w5npw9bvu8bt'
SELECT VALUE FROM SYS.NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_COMP'
END OF STMT
EXEC #140565940524088:c=8,e=8,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=1805486652,tim=1832062872
FETCH #140565940524088:c=12,e=12,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=1805486652,tim=1832062901
CLOSE #140565940524088:c=0,e=0,dep=1,type=3,tim=1832062909
=====================
PARSING IN CURSOR #140565942378136 len=94 dep=1 uid=0 oct=3 lid=0 tim=1832062929 hv=3821161089 ad='67964348' sqlid='5mgx3qrjw4kn1'
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ ST_OPR_ID_SEQ.NEXTVAL FROM DUAL
END OF STMT
EXEC #140565942378136:c=4,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=2973543806,tim=1832062929
FETCH #140565942378136:c=6,e=6,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=2973543806,tim=1832062952
CLOSE #140565942378136:c=1,e=1,dep=1,type=3,tim=1832062960
=====================
PARSING IN CURSOR #140565941832296 len=183 dep=1 uid=0 oct=3 lid=0 tim=1832062980 hv=3205126760 ad='67963188' sqlid='b4fqsa2zhnqm8'
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ O.NAME FROM OBJ$ O, USER$ U WHERE O.OWNER# = U.USER# AND O.OBJ# = (SELECT SYS_CONTEXT('USERENV', 'BG_JOB_ID') FROM DUAL)
END OF STMT
EXEC #140565941832296:c=14,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=750105498,tim=1832062980
FETCH #140565941832296:c=1,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=750105498,tim=1832063001
CLOSE #140565941832296:c=1,e=0,dep=1,type=3,tim=1832063023
=====================
PARSING IN CURSOR #140565938848144 len=172 dep=1 uid=0 oct=2 lid=0 tim=1832063387 hv=872460390 ad='6952de30' sqlid='ddsukg4u01c36'
insert /* QOSH:REC_STS */ into sys.wri$_optstat_opr (id, operation, target, start_time, end_time, status, job_name, session_id, notes) values (:1,:2,:3,:4,:5,:6,:7,:8,:9)
END OF STMT
PARSE #140565938848144:c=169,e=293,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=0,tim=1832063387
BINDS #140565938848144:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd814c25f30 bln=22 avl=03 flg=05
value=583
Bind#1
oacdty=01 mxl=32(19) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=7fd814c32a7c bln=32 avl=19 flg=09
value="gather_system_stats"
Bind#2
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#3
oacdty=181 mxl=13(13) mxlc=00 mal=00 scl=09 pre=00
oacflg=00 fl2=9000001 frm=00 csi=00 siz=56 off=0
kxsbbbfp=7fd814c25ee0 bln=13 avl=13 flg=05
value=16-DEC-20 11.41.38.330251000 AM +03:00
Bind#4
oacdty=181 mxl=13(13) mxlc=00 mal=00 scl=09 pre=00
oacflg=00 fl2=9000001 frm=00 csi=00 siz=0 off=16
kxsbbbfp=7fd814c25ef0 bln=13 avl=13 flg=01
value=16-DEC-20 11.41.38.330251000 AM +03:00
Bind#5
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=32
kxsbbbfp=7fd814c25f00 bln=22 avl=02 flg=01
value=1
Bind#6
oacdty=01 mxl=32(00) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=00000000 bln=32 avl=00 flg=09
Bind#7
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd814c25eb0 bln=22 avl=03 flg=05
value=240
Bind#8
oacdty=01 mxl=2000(183) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=873 siz=2000 off=0
kxsbbbfp=7fd814c3293c bln=2000 avl=183 flg=09
value="<params><param name="gathering_mode" val="EXADATA"/><param name="interval" val="60"/><param name="statid" val=""/><param name="statown" val=""/><param name="stattab" val=""/></params>"
EXEC #140565938848144:c=615,e=615,p=0,cr=1,cu=9,mis=1,r=1,dep=1,og=1,plh=0,tim=1832064028
STAT #140565938848144 id=1 cnt=0 pid=0 pos=1 obj=0 op='LOAD TABLE CONVENTIONAL WRI$_OPTSTAT_OPR (cr=1 pr=0 pw=0 str=1 time=98 us)'
CLOSE #140565938848144:c=2,e=2,dep=1,type=0,tim=1832064069
=====================
PARSING IN CURSOR #140565940797768 len=129 dep=1 uid=0 oct=3 lid=0 tim=1832064274 hv=1326288355 ad='67a6e7f0' sqlid='0dcdtrt7hv3g3'
SELECT /*+ rule OPT_PARAM('_parallel_syspls_obey_force' 'false') */ VALUE FROM V$PARAMETER WHERE UPPER(NAME) = 'STATISTICS_LEVEL'
END OF STMT
EXEC #140565940797768:c=28,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=3,plh=1023639799,tim=1832064274
FETCH #140565940797768:c=6953,e=7546,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=3,plh=1023639799,tim=1832071850
CLOSE #140565940797768:c=23,e=23,dep=1,type=3,tim=1832071910
=====================
PARSING IN CURSOR #140565942739648 len=97 dep=2 uid=0 oct=3 lid=0 tim=1832074081 hv=791757000 ad='70d11f58' sqlid='87gaftwrm2h68'
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1
END OF STMT
PARSE #140565942739648:c=180,e=181,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,plh=0,tim=1832074081
BINDS #140565942739648:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80f145880 bln=22 avl=06 flg=05
value=4294953262
EXEC #140565942739648:c=574,e=614,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,plh=1072382624,tim=1832074734
FETCH #140565942739648:c=6,e=7,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832074747
STAT #140565942739648 id=1 cnt=0 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=2 pr=0 pw=0 str=1 time=8 us cost=3 size=113 card=1)'
STAT #140565942739648 id=2 cnt=0 pid=1 pos=1 obj=36 op='INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 str=1 time=7 us cost=2 size=0 card=1)'
CLOSE #140565942739648:c=0,e=0,dep=2,type=3,tim=1832074789
BINDS #140565942739648:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80f145880 bln=22 avl=06 flg=05
value=4294951319
EXEC #140565942739648:c=22,e=22,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832074825
FETCH #140565942739648:c=2,e=2,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832074832
CLOSE #140565942739648:c=0,e=0,dep=2,type=3,tim=1832074840
BINDS #140565942739648:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80f145880 bln=22 avl=06 flg=05
value=4294951050
EXEC #140565942739648:c=26,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832074876
FETCH #140565942739648:c=2,e=2,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832074883
CLOSE #140565942739648:c=0,e=0,dep=2,type=3,tim=1832074890
=====================
PARSING IN CURSOR #140565938848144 len=72 dep=1 uid=0 oct=3 lid=0 tim=1832074935 hv=3235042752 ad='695b2f58' sqlid='0kuzyw30d5pf0'
select count(*) cnt from v$datafile where status in ('SYSTEM', 'ONLINE')
END OF STMT
PARSE #140565938848144:c=2344,e=2974,p=0,cr=7,cu=0,mis=1,r=0,dep=1,og=1,plh=1332938801,tim=1832074935
EXEC #140565938848144:c=20,e=20,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=1332938801,tim=1832074983
FETCH #140565938848144:c=151,e=151,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=1332938801,tim=1832075142
STAT #140565938848144 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=0 pr=0 pw=0 str=1 time=164 us)'
STAT #140565938848144 id=2 cnt=4 pid=1 pos=1 obj=0 op='FIXED TABLE FULL X$KCVDF (cr=0 pr=0 pw=0 str=1 time=146 us cost=0 size=65 card=1)'
CLOSE #140565938848144:c=30,e=31,dep=1,type=0,tim=1832075206
BINDS #140565942739648:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80f145880 bln=22 avl=06 flg=05
value=4294953262
EXEC #140565942739648:c=34,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832076828
FETCH #140565942739648:c=3,e=3,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832076838
CLOSE #140565942739648:c=1,e=1,dep=2,type=3,tim=1832076849
BINDS #140565942739648:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80f145880 bln=22 avl=06 flg=05
value=4294951319
EXEC #140565942739648:c=21,e=21,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832076881
FETCH #140565942739648:c=2,e=2,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832076888
CLOSE #140565942739648:c=0,e=0,dep=2,type=3,tim=1832076895
BINDS #140565942739648:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80f145880 bln=22 avl=06 flg=05
value=4294951050
EXEC #140565942739648:c=20,e=20,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832076924
FETCH #140565942739648:c=2,e=2,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=1072382624,tim=1832076930
CLOSE #140565942739648:c=0,e=0,dep=2,type=3,tim=1832076937
=====================
PARSING IN CURSOR #140565938848144 len=86 dep=1 uid=0 oct=3 lid=0 tim=1832076967 hv=2806229348 ad='69563690' sqlid='5tpvatamn7ab4'
select file#, blocks, block_size from v$datafile where status in ('SYSTEM', 'ONLINE')
END OF STMT
PARSE #140565938848144:c=2267,e=1718,p=0,cr=7,cu=0,mis=1,r=0,dep=1,og=1,plh=3398306107,tim=1832076967
EXEC #140565938848144:c=10,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=3398306107,tim=1832077007
FETCH #140565938848144:c=61,e=61,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=3398306107,tim=1832077077
FETCH #140565938848144:c=10,e=10,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=3398306107,tim=1832077095
FETCH #140565938848144:c=8,e=8,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=3398306107,tim=1832077109
FETCH #140565938848144:c=7,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=3398306107,tim=1832077123
FETCH #140565938848144:c=18,e=18,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=3398306107,tim=1832077147
STAT #140565938848144 id=1 cnt=4 pid=0 pos=1 obj=0 op='FIXED TABLE FULL X$KCVDF (cr=0 pr=0 pw=0 str=1 time=66 us cost=0 size=104 card=1)'
CLOSE #140565938848144:c=2,e=2,dep=1,type=0,tim=1832077172
=====================
PARSING IN CURSOR #140565942165984 len=170 dep=1 uid=0 oct=3 lid=0 tim=1832179784 hv=1931359042 ad='67965a68' sqlid='5rurx5xtjwcu2'
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ KSPPCV.KSPPSTVL FROM X$KSPPCV KSPPCV, X$KSPPI KSPPI WHERE KSPPI.INDX = KSPPCV.INDX AND KSPPI.KSPPINM = :B1
END OF STMT
BINDS #140565942165984:
Bind#0
oacdty=01 mxl=2000(116) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=873 siz=2000 off=0
kxsbbbfp=7fd80edac850 bln=2000 avl=29 flg=05
value="db_file_multiblock_read_count"
EXEC #140565942165984:c=110,e=110,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=185276389,tim=1832179874
FETCH #140565942165984:c=106,e=106,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=185276389,tim=1832179996
CLOSE #140565942165984:c=1,e=1,dep=1,type=3,tim=1832180023
EXEC #140565941838896:c=11,e=11,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=1805486652,tim=1832180060
FETCH #140565941838896:c=20,e=20,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=1805486652,tim=1832180095
CLOSE #140565941838896:c=1,e=1,dep=1,type=3,tim=1832180107
EXEC #140565940524088:c=7,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=1805486652,tim=1832180122
FETCH #140565940524088:c=12,e=12,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=1805486652,tim=1832180142
CLOSE #140565940524088:c=0,e=0,dep=1,type=3,tim=1832180151
=====================
PARSING IN CURSOR #140565942168488 len=119 dep=1 uid=0 oct=3 lid=0 tim=1832180190 hv=4203535333 ad='679925e8' sqlid='b9nbhsbx8tqz5'
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1
END OF STMT
BINDS #140565942168488:
Bind#0
oacdty=01 mxl=128(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=873 siz=128 off=0
kxsbbbfp=7fd80edacfa0 bln=128 avl=07 flg=05
value="PUBLISH"
EXEC #140565942168488:c=38,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=1097271556,tim=1832180223
FETCH #140565942168488:c=34,e=34,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=1097271556,tim=1832180264
CLOSE #140565942168488:c=1,e=1,dep=1,type=3,tim=1832180275
=====================
PARSING IN CURSOR #140565940787984 len=163 dep=1 uid=0 oct=3 lid=0 tim=1832180308 hv=3937375941 ad='67a734f0' sqlid='8ndfc0zpaz5q5'
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ S.SNAME, S.PNAME, S.PVAL1, S.PVAL2 FROM AUX_STATS$ S WHERE S.SNAME LIKE 'SYSSTATS%' ORDER BY S.SNAME
END OF STMT
EXEC #140565940787984:c=10,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=302179760,tim=1832180308
FETCH #140565940787984:c=10,e=10,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180344
FETCH #140565940787984:c=3,e=3,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180358
FETCH #140565940787984:c=2,e=2,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180368
FETCH #140565940787984:c=1,e=1,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180376
FETCH #140565940787984:c=1,e=1,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180385
FETCH #140565940787984:c=1,e=1,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180394
FETCH #140565940787984:c=2,e=2,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180403
FETCH #140565940787984:c=1,e=1,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180411
FETCH #140565940787984:c=1,e=1,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180419
FETCH #140565940787984:c=1,e=2,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180428
FETCH #140565940787984:c=1,e=1,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180436
FETCH #140565940787984:c=2,e=2,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180445
FETCH #140565940787984:c=2,e=2,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=1,plh=302179760,tim=1832180454
FETCH #140565940787984:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=302179760,tim=1832180461
CLOSE #140565940787984:c=1,e=1,dep=1,type=3,tim=1832180541
=====================
PARSING IN CURSOR #140565941320288 len=61 dep=1 uid=0 oct=6 lid=0 tim=1832180573 hv=2318223170 ad='67bf7ce8' sqlid='8fmhq7a52uju2'
UPDATE SYS.WRI$_OPTSTAT_AUX_HISTORY SET PVAL1 = 0 WHERE 1 = 0
END OF STMT
EXEC #140565941320288:c=20,e=20,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=2156868965,tim=1832180573
CLOSE #140565941320288:c=0,e=0,dep=1,type=3,tim=1832180595
=====================
PARSING IN CURSOR #140565941317784 len=47 dep=1 uid=0 oct=6 lid=0 tim=1832180608 hv=108181487 ad='67bf79b8' sqlid='cvszzn4375dzg'
UPDATE SYS.AUX_STATS$ SET PVAL1 = 0 WHERE 1 = 0
END OF STMT
EXEC #140565941317784:c=6,e=6,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=4206089498,tim=1832180608
CLOSE #140565941317784:c=0,e=0,dep=1,type=3,tim=1832180633
=====================
PARSING IN CURSOR #140565938870544 len=56 dep=1 uid=0 oct=7 lid=0 tim=1832180745 hv=311428414 ad='6a0f51a8' sqlid='f4zw6vs99019y'
DELETE FROM SYS.AUX_STATS$ WHERE SNAME = 'SYSSTATS_INFO'
END OF STMT
EXEC #140565938870544:c=102,e=102,p=0,cr=1,cu=8,mis=0,r=4,dep=1,og=1,plh=1692104539,tim=1832180745
CLOSE #140565938870544:c=0,e=0,dep=1,type=3,tim=1832180772
=====================
PARSING IN CURSOR #140565938867696 len=73 dep=1 uid=0 oct=2 lid=0 tim=1832180791 hv=454001916 ad='6a0f4e78' sqlid='d93t6tndhz17w'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_INFO', 'STATUS', NULL, :B1 )
END OF STMT
BINDS #140565938867696:
Bind#0
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=7fd80eec1300 bln=32 avl=09 flg=09
value="COMPLETED"
EXEC #140565938867696:c=0,e=51,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832180837
CLOSE #140565938867696:c=0,e=1,dep=1,type=3,tim=1832180848
=====================
PARSING IN CURSOR #140565938863400 len=73 dep=1 uid=0 oct=2 lid=0 tim=1832180858 hv=3821777836 ad='6a0f4b48' sqlid='2rtww83jwrcxc'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_INFO', 'DSTART', NULL, :B1 )
END OF STMT
BINDS #140565938863400:
Bind#0
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=7fd80eec1320 bln=32 avl=16 flg=09
value="12-16-2020 11:41"
EXEC #140565938863400:c=0,e=38,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832180892
CLOSE #140565938863400:c=0,e=1,dep=1,type=3,tim=1832180902
=====================
PARSING IN CURSOR #140565938858232 len=72 dep=1 uid=0 oct=2 lid=0 tim=1832180912 hv=912777027 ad='6a0f4818' sqlid='b1z10j0v6gru3'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_INFO', 'DSTOP', NULL, :B1 )
END OF STMT
BINDS #140565938858232:
Bind#0
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=7fd80eec1340 bln=32 avl=16 flg=09
value="12-16-2020 11:41"
EXEC #140565938858232:c=0,e=58,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832180966
CLOSE #140565938858232:c=0,e=0,dep=1,type=3,tim=1832180977
=====================
PARSING IN CURSOR #140565938855384 len=72 dep=1 uid=0 oct=2 lid=0 tim=1832180987 hv=994138424 ad='6a0f44e8' sqlid='2tj5x5hxn2q9s'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_INFO', 'FLAGS', :B1 , NULL)
END OF STMT
BINDS #140565938855384:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1360 bln=22 avl=02 flg=09
value=1
EXEC #140565938855384:c=0,e=37,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832181020
CLOSE #140565938855384:c=0,e=0,dep=1,type=3,tim=1832181029
=====================
PARSING IN CURSOR #140565938848144 len=289 dep=1 uid=0 oct=2 lid=0 tim=1832181239 hv=383811924 ad='695e1c28' sqlid='33xdmccbf10an'
insert /* QOSH:SAV_SYS_STS */ into sys.wri$_optstat_aux_history (savtime, sname, pname, pval1, pval2) select :1, sname, pname, pval1, pval2 from sys.aux_stats$ where sname = 'SYSSTATS_MAIN' and not exists (select /*+index(h) */ 1 from sys.wri$_optstat_aux_history h where savtime = :2)
END OF STMT
PARSE #140565938848144:c=0,e=182,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=0,tim=1832181239
BINDS #140565938848144:
Bind#0
oacdty=181 mxl=13(13) mxlc=00 mal=00 scl=09 pre=00
oacflg=00 fl2=9000001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=7fd80f18fa78 bln=13 avl=13 flg=05
value=16-DEC-20 11.41.38.448560000 AM +03:00
Bind#1
oacdty=181 mxl=13(13) mxlc=00 mal=00 scl=09 pre=00
oacflg=00 fl2=9000001 frm=00 csi=00 siz=0 off=16
kxsbbbfp=7fd80f18fa88 bln=13 avl=13 flg=01
value=16-DEC-20 11.41.38.448560000 AM +03:00
EXEC #140565938848144:c=1737,e=1557,p=0,cr=5,cu=6,mis=1,r=9,dep=1,og=1,plh=333016110,tim=1832182819
STAT #140565938848144 id=1 cnt=0 pid=0 pos=1 obj=0 op='LOAD TABLE CONVENTIONAL WRI$_OPTSTAT_AUX_HISTORY (cr=5 pr=0 pw=0 str=1 time=152 us)'
STAT #140565938848144 id=2 cnt=9 pid=1 pos=1 obj=0 op='FILTER (cr=4 pr=0 pw=0 str=1 time=69 us)'
STAT #140565938848144 id=3 cnt=9 pid=2 pos=1 obj=644 op='TABLE ACCESS FULL AUX_STATS$ (cr=3 pr=0 pw=0 str=1 time=60 us cost=2 size=252 card=9)'
STAT #140565938848144 id=4 cnt=0 pid=2 pos=2 obj=684 op='INDEX RANGE SCAN I_WRI$_OPTSTAT_AUX_ST (cr=1 pr=0 pw=0 str=1 time=6 us cost=1 size=11 card=1)'
CLOSE #140565938848144:c=2,e=2,dep=1,type=0,tim=1832182915
=====================
PARSING IN CURSOR #140565938850216 len=56 dep=1 uid=0 oct=7 lid=0 tim=1832183028 hv=2821397124 ad='6a0f41b8' sqlid='a535pb2n2q6n4'
DELETE FROM SYS.AUX_STATS$ WHERE SNAME = 'SYSSTATS_MAIN'
END OF STMT
EXEC #140565938850216:c=74,e=74,p=0,cr=1,cu=13,mis=0,r=9,dep=1,og=1,plh=1692104539,tim=1832183028
CLOSE #140565938850216:c=1,e=1,dep=1,type=3,tim=1832183057
=====================
PARSING IN CURSOR #140565938845448 len=77 dep=1 uid=0 oct=2 lid=0 tim=1832183071 hv=928404322 ad='6a0f3e88' sqlid='67ncvpsvpcnv2'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'CPUSPEEDNW', :B1 , NULL)
END OF STMT
BINDS #140565938845448:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1460 bln=22 avl=03 flg=09
value=2928
EXEC #140565938845448:c=45,e=45,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183111
CLOSE #140565938845448:c=1,e=1,dep=1,type=3,tim=1832183122
=====================
PARSING IN CURSOR #140565938842944 len=76 dep=1 uid=0 oct=2 lid=0 tim=1832183132 hv=543581576 ad='6a0f3b58' sqlid='auvf07wh6ctc8'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'IOSEEKTIM', :B1 , NULL)
END OF STMT
BINDS #140565938842944:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1478 bln=22 avl=02 flg=09
value=10
EXEC #140565938842944:c=37,e=37,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183165
CLOSE #140565938842944:c=0,e=0,dep=1,type=3,tim=1832183174
=====================
PARSING IN CURSOR #140565938837432 len=77 dep=1 uid=0 oct=2 lid=0 tim=1832183184 hv=3127723828 ad='6a0f3828' sqlid='38gjx7kx6ujtn'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'IOTFRSPEED', :B1 , NULL)
END OF STMT
BINDS #140565938837432:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1490 bln=22 avl=03 flg=09
value=204800
EXEC #140565938837432:c=36,e=36,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183216
CLOSE #140565938837432:c=0,e=0,dep=1,type=3,tim=1832183226
=====================
PARSING IN CURSOR #140565938834928 len=75 dep=1 uid=0 oct=2 lid=0 tim=1832183238 hv=1547970203 ad='6a0f34f8' sqlid='5ca6vx5f489nv'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'SREADTIM', :B1 , NULL)
END OF STMT
BINDS #140565938834928:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec14c0 bln=22 avl=00 flg=09
EXEC #140565938834928:c=33,e=33,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183268
CLOSE #140565938834928:c=1,e=1,dep=1,type=3,tim=1832183277
=====================
PARSING IN CURSOR #140565942665592 len=75 dep=1 uid=0 oct=2 lid=0 tim=1832183285 hv=2108722292 ad='6a0f21c8' sqlid='fm39amjyv133n'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'MREADTIM', :B1 , NULL)
END OF STMT
BINDS #140565942665592:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec14d8 bln=22 avl=00 flg=09
EXEC #140565942665592:c=44,e=44,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183326
CLOSE #140565942665592:c=0,e=0,dep=1,type=3,tim=1832183353
=====================
PARSING IN CURSOR #140565942663352 len=75 dep=1 uid=0 oct=2 lid=0 tim=1832183362 hv=4129833197 ad='6a0f1e98' sqlid='1rh50c7v2hh7d'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'CPUSPEED', :B1 , NULL)
END OF STMT
BINDS #140565942663352:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec14a8 bln=22 avl=00 flg=09
EXEC #140565942663352:c=37,e=37,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183396
CLOSE #140565942663352:c=0,e=0,dep=1,type=3,tim=1832183404
=====================
PARSING IN CURSOR #140565941835392 len=71 dep=1 uid=0 oct=2 lid=0 tim=1832183415 hv=4016519028 ad='6a0f1b68' sqlid='32kbjpmrqfdvn'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'MBRC', :B1 , NULL)
END OF STMT
BINDS #140565941835392:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec14f0 bln=22 avl=02 flg=09
value=83
EXEC #140565941835392:c=72,e=73,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183483
CLOSE #140565941835392:c=0,e=0,dep=1,type=3,tim=1832183494
=====================
PARSING IN CURSOR #140565942331992 len=73 dep=1 uid=0 oct=2 lid=0 tim=1832183505 hv=941172397 ad='6a0f1838' sqlid='5nv8b5cw1k9pd'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'MAXTHR', :B1 , NULL)
END OF STMT
BINDS #140565942331992:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1508 bln=22 avl=00 flg=09
EXEC #140565942331992:c=34,e=35,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183536
CLOSE #140565942331992:c=0,e=0,dep=1,type=3,tim=1832183544
=====================
PARSING IN CURSOR #140565942329488 len=75 dep=1 uid=0 oct=2 lid=0 tim=1832183554 hv=3800693767 ad='6a0f1508' sqlid='b11g5kvj8mz07'
INSERT INTO SYS.AUX_STATS$ VALUES ('SYSSTATS_MAIN', 'SLAVETHR', :B1 , NULL)
END OF STMT
BINDS #140565942329488:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1520 bln=22 avl=00 flg=09
EXEC #140565942329488:c=39,e=39,p=0,cr=0,cu=3,mis=0,r=1,dep=1,og=1,plh=0,tim=1832183590
CLOSE #140565942329488:c=0,e=0,dep=1,type=3,tim=1832183598
=====================
PARSING IN CURSOR #140565938847952 len=6 dep=1 uid=0 oct=44 lid=0 tim=1832183612 hv=255718823 ad='0' sqlid='8ggw94h7mvxd7'
COMMIT
END OF STMT
PARSE #140565938847952:c=4,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1832183612
XCTEND rlbk=0, rd_only=0, tim=1832183632
EXEC #140565938847952:c=68,e=68,p=0,cr=0,cu=1,mis=0,r=0,dep=1,og=0,plh=0,tim=1832183697
CLOSE #140565938847952:c=1,e=1,dep=1,type=3,tim=1832183708
=====================
PARSING IN CURSOR #140565942376648 len=56 dep=1 uid=0 oct=7 lid=0 tim=1832184015 hv=885923863 ad='6a0f11d8' sqlid='0v4vphwucw80r'
DELETE FROM SYS.AUX_STATS$ WHERE SNAME = 'SYSSTATS_TEMP'
END OF STMT
EXEC #140565942376648:c=26,e=26,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=1,plh=1692104539,tim=1832184015
CLOSE #140565942376648:c=0,e=0,dep=1,type=3,tim=1832184057
PARSE #140565938847952:c=1,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1832184067
XCTEND rlbk=0, rd_only=1, tim=1832184075
EXEC #140565938847952:c=10,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1832184082
CLOSE #140565938847952:c=0,e=0,dep=1,type=3,tim=1832184088
PARSE #140565938847952:c=0,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1832184095
XCTEND rlbk=0, rd_only=1, tim=1832184101
EXEC #140565938847952:c=5,e=5,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1832184105
CLOSE #140565938847952:c=0,e=0,dep=1,type=3,tim=1832184109
PARSE #140565938847952:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1832184114
XCTEND rlbk=0, rd_only=1, tim=1832184119
EXEC #140565938847952:c=4,e=5,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1832184123
CLOSE #140565938847952:c=0,e=0,dep=1,type=3,tim=1832184127
=====================
PARSING IN CURSOR #140565941082320 len=138 dep=1 uid=0 oct=6 lid=0 tim=1832184143 hv=113741489 ad='67962b28' sqlid='0kygk503cg3pj'
UPDATE /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ WRI$_OPTSTAT_OPR SET STATUS = :B2 , END_TIME = SYSTIMESTAMP WHERE ID = :B1
END OF STMT
BINDS #140565941082320:
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=646f5560 bln=22 avl=02 flg=09
value=2
Bind#1
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd80eec1fa8 bln=22 avl=03 flg=09
value=583
EXEC #140565941082320:c=146,e=146,p=0,cr=1,cu=3,mis=0,r=1,dep=1,og=1,plh=2375226716,tim=1832184282
CLOSE #140565941082320:c=1,e=1,dep=1,type=3,tim=1832184303
PARSE #140565938847952:c=1,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1832184311
XCTEND rlbk=0, rd_only=0, tim=1832184334
EXEC #140565938847952:c=116,e=116,p=0,cr=0,cu=1,mis=0,r=0,dep=1,og=0,plh=0,tim=1832184448
CLOSE #140565938847952:c=0,e=0,dep=1,type=3,tim=1832184458
EXEC #140565942129688:c=45819,e=121939,p=0,cr=52,cu=82,mis=0,r=1,dep=0,og=1,plh=0,tim=1832184484
*** 2020-12-16T11:42:17.944697+03:00 (PDB1(3))
CLOSE #140565942129688:c=15,e=15,dep=0,type=1,tim=1871677173
=====================
PARSING IN CURSOR #140565941051688 len=68 dep=0 uid=0 oct=42 lid=0 tim=1871677421 hv=222310797 ad='0' sqlid='bb055g46n0ccd'
alter session set events '10046 trace name context forever, level 0'
END OF STMT
PARSE #140565941051688:c=186,e=186,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1871677420
EXEC #140565941051688:c=199,e=199,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1871677646
*** 2020-12-16T11:42:54.340753+03:00 (PDB1(3))
CLOSE #140565941051688:c=15,e=15,dep=0,type=1,tim=1908073209
*** 2020-12-16T11:42:54.341135+03:00 (PDB1(3))
Processing Oradebug command 'help'
*** 2020-12-16T11:42:54.341299+03:00 (PDB1(3))
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.