oracle中如何生成awr报告

1、进入数据库 sqlplus / as sysdba

2、查看用户 show parameter db_name

3、开始压测后执行 exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();   

4、 结束压测后执行 exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();

5、输入命令 @?/rdbms/admin/awrrpt

 备注:4和5步骤中不执行,后面默认产生系统规定的时间节点(默认人一小时生成一次报告)

6、      

      输入回车  默认是html格式

 

 7、  

 

     输入1,查询最近一天的 

 

8、

       输入开始节点和结束节点

 

9、输入想要生成的报告名称,以html格式结尾 

 

10、生成的awr默认在登陆数据库的路径(试验机:C:\Users\wangxh.PANACRO)

 

WORKLOAD REPOSITORY report for

 

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
WXH142723844wxh131-8月 -18 09:0811.2.0.1.0NO

 

 

Host NamePlatformCPUsCoresSocketsMemory (GB)
PANACEABJ-003Microsoft Windows x86 64-bit4217.48

 

 Snap IdSnap TimeSessionsCursors/Session
Begin Snap:11201-9月 -18 10:00:55311.5
End Snap:11701-9月 -18 15:00:49291.8
Elapsed: 299.90 (mins)  
DB Time: 24.16 (mins)  

 

Report Summary

Cache Sizes

 

 BeginEnd  
Buffer Cache:1,376M1,376MStd Block Size:8K
Shared Pool Size:400M400MLog Buffer:16,584K

Load Profile

 

 Per SecondPer TransactionPer ExecPer Call
DB Time(s):0.10.60.000.00
DB CPU(s):0.10.60.000.00
Redo size:8,634.268,897.4  
Logical reads:168.11,341.7  
Block changes:56.7452.5  
Physical reads:0.43.1  
Physical writes:1.18.8  
User calls:199.71,593.4  
Parses:182.51,456.0  
Hard parses:0.10.9  
W/A MB processed:0.00.3  
Logons:0.10.5  
Executes:187.21,494.1  
Rollbacks:0.00.0  
Transactions:0.1   

Instance Efficiency Percentages (Target 100%)

 

Buffer Nowait %:100.00Redo NoWait %:100.00
Buffer Hit %:99.77In-memory Sort %:100.00
Library Hit %:99.98Soft Parse %:99.94
Execute to Parse %:2.55Latch Hit %:100.00
Parse CPU to Parse Elapsd %:97.62% Non-Parse CPU:94.43

Shared Pool Statistics

 

 BeginEnd
Memory Usage %:73.3681.67
% SQL with executions>1:77.1192.73
% Memory for SQL w/exec>1:70.9486.50

 

Top 5 Timed Foreground Events

 

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 1,355 93.47 
SQL*Net message to client1,797,405300.20Network
Disk file operations I/O631120.08User I/O
log file sync578120.06Commit
db file scattered read222010.02User I/O

Host CPU (CPUs: 4 Cores: 2 Sockets: 1)

 

Load Average BeginLoad Average End%User%System%WIO%Idle
  9.617.9 72.5

Instance CPU

 

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
1.96.90.0

Memory Statistics

 

 BeginEnd
Host Mem (MB):7,659.27,659.2
SGA use (MB):1,840.01,840.0
PGA use (MB):71.474.3
% Host Mem used for SGA+PGA:24.9624.99

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 1449.4s
  • Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
  • Ordered by % or DB time desc, Statistic name
Statistic NameTime (s)% of DB Time
DB CPU1,354.7693.47
sql execute elapsed time942.3965.02
PL/SQL execution elapsed time529.2336.51
parse time elapsed95.336.58
hard parse elapsed time17.821.23
PL/SQL compilation elapsed time2.250.16
hard parse (sharing criteria) elapsed time2.210.15
connection management call elapsed time0.560.04
failed parse elapsed time0.390.03
repeated bind elapsed time0.130.01
sequence load elapsed time0.000.00
hard parse (bind mismatch) elapsed time0.000.00
DB time1,449.39 
background elapsed time97.40 
background cpu time13.38 

Back to Wait Events Statistics 
Back to Top

Operating System Statistics

  • *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
  • ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name
StatisticValueEnd Value
AVG_BUSY_TIME494,705 
AVG_IDLE_TIME1,303,789 
AVG_SYS_TIME322,199 
AVG_USER_TIME172,047 
BUSY_TIME1,980,616 
IDLE_TIME5,217,027 
SYS_TIME1,290,643 
USER_TIME689,973 
VM_IN_BYTES-7,363,472,657,615,470,592 
VM_OUT_BYTES50,841,417,351,663,616 
PHYSICAL_MEMORY_BYTES8,031,227,904 
NUM_CPUS4 
NUM_CPU_CORES2 
NUM_CPU_SOCKETS1 

Back to Wait Events Statistics 
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
01-9月 10:00:550.00     
01-9月 11:00:060.0023.367.0116.3576.640.00
01-9月 12:00:170.0020.515.6114.8979.490.00
01-9月 13:00:270.0028.499.8618.6271.510.00
01-9月 14:00:390.0043.0118.1724.8556.990.00
01-9月 15:00:490.0022.157.2314.9277.850.00

Back to Wait Events Statistics 
Back to Top

Foreground Wait Class

  • s - second, ms - millisecond - 1000th of a second
  • ordered by wait time desc, waits desc
  • %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
  • Captured Time accounts for 93.8% of Total DB time 1,449.39 (s)
  • Total FG Wait Time: 5.44 (s) DB CPU time: 1,354.76 (s)
Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  1,355 93.47
Network1,797,5470300.20
User I/O1,0810110.10
Commit5780120.06
Application1210010.01
Concurrency1,4190000.01
Other53,517100000.00
System I/O770000.00
Configuration30030.00

Back to Wait Events Statistics 
Back to Top

Foreground Wait Events

  • s - second, ms - millisecond - 1000th of a second
  • Only events with Total Wait Time (s) >= .001 are shown
  • ordered by wait time desc, waits desc (idle events last)
  • %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
SQL*Net message to client1,797,405030797.080.20
Disk file operations I/O6310120.280.08
log file sync5780120.260.06
db file scattered read2220010.100.02
db file sequential read2000000.090.01
SQL*Net break/reset to client1100010.050.01
library cache: mutex X4170000.180.00
asynch descriptor resize53,5051000023.730.00
control file sequential read770000.030.00
library cache pin9950000.440.00
enq: RO - fast object reuse110020.000.00
SQL*Net more data to client1380000.060.00
local write wait120010.010.00
log file switch (private strand flush incomplete)20030.000.00
latch: shared pool60010.000.00
direct path write temp110000.000.00
log file switch completion10030.000.00
latch: row cache objects10030.000.00
reliable message110000.000.00
SQL*Net message from client1,797,405053,25030797.08 
jobq slave wait37,69310018,81849916.72 
pipe get4,377,38006,96221,941.19 
PL/SQL lock timer1100110000.00 

Back to Wait Events Statistics 
Back to Top

Background Wait Events

  • ordered by wait time desc, waits desc (idle events last)
  • Only events with Total Wait Time (s) >= .001 are shown
  • %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
os thread startup681027400.3027.92
control file sequential read19,87501618.8116.63
control file parallel write6,53701622.9016.19
log file parallel write5,8470612.596.37
db file parallel write5,7640512.564.68
Disk file operations I/O3230120.140.61
db file sequential read3920000.170.13
db file scattered read910010.040.07
rdbms ipc reply40070.000.03
ADR block file read620000.030.03
ADR file lock300000.010.01
direct path write220000.010.01
ADR block file write250000.010.01
LGWR wait for redo copy1050000.050.01
asynch descriptor resize1,037100000.460.01
log file sync100000.000.00
log file sequential read100000.000.00
latch free1960000.090.00
direct path read170000.010.00
log file single write100000.000.00
rdbms ipc message128,50796215,839168056.99 
Streams AQ: waiting for time management or cleanup tasks25098,205491026030.00 
DIAG idle wait35,98210035,984100015.96 
smon timer827318,0442200530.04 
shared server idle wait60010018,004300060.27 
dispatcher timer30010018,002600050.13 
pmon timer6,6369017,99327112.94 
Space Manager: slave idle wait3,6469817,98549331.62 
Streams AQ: qmn slave idle wait652017,980275770.29 
Streams AQ: qmn coordinator idle wait1,1155817,980161260.49 
SQL*Net message from client4730110.21 
class slave wait830000.04 

Back to Wait Events Statistics 
Back to Top

Wait Event Histogram

  • Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
  • % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
  • % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
  • Ordered by Event (idle events last)
  % of Waits
EventTotal Waits<1ms<2ms<4ms<8ms<16ms<32ms<=1s>1s
ADR block file read6295.2  4.8    
ADR block file write2588.012.0      
ADR file lock3086.713.3      
Data file init write3100.0       
Disk file operations I/O954.282.016.41.3.1.1  
LGWR wait for redo copy10598.11.01.0     
SQL*Net break/reset to client11068.225.56.4     
SQL*Net message to client1797.8K100.0.0      
SQL*Net more data from client4100.0       
SQL*Net more data to client138100.0       
asynch descriptor resize54.5K100.0       
control file parallel write653755.5.7.542.7.2.1.4 
control file sequential read20K90.51.2.47.7.1.0.1 
db file parallel write576485.84.01.58.4.1.1.0 
db file scattered read31377.312.18.91.0.6   
db file sequential read59297.6.7.21.5    
db file single write3100.0       
direct path read17100.0       
direct path write2290.94.54.5     
direct path write temp1593.36.7      
enq: JS - queue lock1100.0       
enq: RO - fast object reuse1163.69.19.19.19.1   
latch free197100.0       
latch: row cache objects1  100.0     
latch: shared pool683.3 16.7     
library cache pin995100.0       
library cache: mutex X41798.6.7.7     
local write wait1283.38.38.3     
log file parallel write584780.02.31.615.6.2.1.2 
log file sequential read10100.0       
log file single write10100.0       
log file switch (private strand flush incomplete)2  100.0     
log file switch completion1  100.0     
log file sync58874.86.12.715.6 .2.5 
os thread startup681     26.673.4 
rdbms ipc reply425.025.025.0  25.0  
reliable message14100.0       
utl_file I/O5100.0       
DIAG idle wait36K      100.0.0
PL/SQL lock timer1      100.0 
SQL*Net message from client1797.9K26.770.32.3.4.1.0.2.0
Space Manager: slave idle wait3646.4   .0 .499.1
Streams AQ: qmn coordinator idle wait111542.4      57.6
Streams AQ: qmn slave idle wait6521.5      98.5
Streams AQ: waiting for time management or cleanup tasks2      50.050.0
class slave wait8396.42.41.2     
dispatcher timer300       100.0
jobq slave wait37.7K.0.0 .0.1.099.9 
pipe get4377.3K66.331.42.0.2.0.0.0.0
pmon timer66361.43.52.91.3.2.2.190.4
rdbms ipc message128.5K1.7.2.3.337.2.315.044.9
shared server idle wait600       100.0
smon timer82       100.0

Back to Wait Events Statistics 
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  • Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
  • Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
  • % of Total Waits: total waits for all wait classes, including Idle
  • % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
  • Ordered by Event (only non-idle events are displayed)
  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s<1s<2s>=2s
control file parallel write2399.6.2.1.1    
control file sequential read2199.9.1.0.0    
db file parallel write2100.0  .0.0   
log file parallel write999.8.1.1.0    
log file sync399.5 .5     
os thread startup50026.672.11.2.1    

Back to Wait Events Statistics 
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics 
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics 
Back to Top

Service Statistics

  • ordered by DB Time
Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
WXH1,3261,25001,800
SYS$USERS1241055901
SYS$BACKGROUND002324
WXHXDB0000

Back to Wait Events Statistics 
Back to Top

Service Wait Class Stats

  • Wait Class info for services in the Service Statistics section.
  • Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
  • Time Waited (Wt Time) in seconds
Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
WXH2950141600017975313
SYS$USERS78613000160
SYS$BACKGROUND8561681270000

Back to Wait Events Statistics 
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
  • %Total - Elapsed Time as a percentage of Total DB time
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Captured SQL account for 37.6% of Total DB Time (s): 1,449
  • Captured PL/SQL account for 82.4% of Total DB Time (s): 1,449
Elapsed Time (s)ExecutionsElapsed Time per Exec (s)%Total%CPU%IOSQL IdSQL ModuleSQL Text
469.56767.0832.40105.420.000mf6d1n1zzm0zPL/SQL Developerbegin -- Call the procedure oc...
355.261355.2624.51104.950.00977mq4aw9jc36PL/SQL DeveloperINSERT INTO 理化检查 SELECT SUBJID...
347.511,431,0720.0023.9899.660.00du7nyv586fquhPL/SQL Developerdeclare runtime_info sys.dbms_...
326.431,431,2180.0022.52104.150.00g0unxwd406yu0PL/SQL Developerdeclare ret binary_integer; be...
95.84195.846.61107.260.0025986tpfa5wc3PL/SQL DeveloperINSERT INTO 理化检查 SELECT SUBJID...
34.46134.462.3893.540.82b6usrg82hwsa3DBMS_SCHEDULERcall dbms_stats.gather_databas...
15.73115.731.09107.120.0104p6yvxfsv7cyPL/SQL DeveloperINSERT INTO 体格检查 SELECT SUBJID...
15.711310.121.0893.770.00c0j6cx9kzjf7gDBMS_SCHEDULERSELECT EXTRACTVALUE(VALUE(T), ...
14.75176,6080.001.02100.450.05dr4mnnwqwm3rqPL/SQL Developerinsert into shuju1 (SUBJID, V...
13.65153,7480.000.94106.620.04845hn917wsu63PL/SQL Developerinsert into shuju1 (SUBJID, V...

Back to SQL Statistics 
Back to Top

SQL ordered by CPU Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • %Total - CPU Time as a percentage of Total DB CPU
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Captured SQL account for 42.0% of Total CPU Time (s): 1,355
  • Captured PL/SQL account for 90.7% of Total CPU Time (s): 1,355
CPU Time (s)ExecutionsCPU per Exec (s)%TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
494.99770.7136.54469.56105.420.000mf6d1n1zzm0zPL/SQL Developerbegin -- Call the procedure oc...
372.861372.8627.52355.26104.950.00977mq4aw9jc36PL/SQL DeveloperINSERT INTO 理化检查 SELECT SUBJID...
346.321,431,0720.0025.56347.5199.660.00du7nyv586fquhPL/SQL Developerdeclare runtime_info sys.dbms_...
339.971,431,2180.0025.09326.43104.150.00g0unxwd406yu0PL/SQL Developerdeclare ret binary_integer; be...
102.801102.807.5995.84107.260.0025986tpfa5wc3PL/SQL DeveloperINSERT INTO 理化检查 SELECT SUBJID...
32.23132.232.3834.4693.540.82b6usrg82hwsa3DBMS_SCHEDULERcall dbms_stats.gather_databas...
16.85116.851.2415.73107.120.0104p6yvxfsv7cyPL/SQL DeveloperINSERT INTO 体格检查 SELECT SUBJID...
14.82176,6080.001.0914.75100.450.05dr4mnnwqwm3rqPL/SQL Developerinsert into shuju1 (SUBJID, V...
14.731310.111.0915.7193.770.00c0j6cx9kzjf7gDBMS_SCHEDULERSELECT EXTRACTVALUE(VALUE(T), ...
14.55153,7480.001.0713.65106.620.04845hn917wsu63PL/SQL Developerinsert into shuju1 (SUBJID, V...

Back to SQL Statistics 
Back to Top

SQL ordered by User I/O Wait Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • %Total - User I/O Time as a percentage of Total User I/O Wait time
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Captured SQL account for 46.8% of Total User I/O Wait Time (s): 2
  • Captured PL/SQL account for 58.8% of Total User I/O Wait Time (s): 2
User I/O Time (s)ExecutionsUIO per Exec (s)%TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
0.662990.0029.796.2990.0110.576gvch1xu9ca3g DECLARE job BINARY_INTEGER := ...
0.482990.0021.680.5197.1794.187mdacxfm37utkEM_PINGSELECT COUNT(*) FROM MGMT_FAIL...
0.2810.2812.6834.4693.540.82b6usrg82hwsa3DBMS_SCHEDULERcall dbms_stats.gather_databas...
0.1810.187.894.0591.254.3505s9358mm6vrr begin dbms_feature_usage_inter...
0.1710.177.480.2129.7979.702gjv8dam6m03gDBMS_SCHEDULER/* SQL Analyze(1) */ select /*...
0.122680.005.510.7087.3317.663am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_...
0.07500.003.310.08178.4393.75459f3z9u4fb3u select value$ from props$ wher...
0.06120.012.850.1155.1556.127mgr3uwydqq8j select decode(open_mode, 'MOU...
0.06340.002.641.2199.554.8832bph60y97zdcPL/SQL DeveloperSELECT DISTINCT DESCRIPTION, F...
0.0350.011.200.2165.8412.56gjm43un5cy843 SELECT SUM(USED), SUM(TOTAL) F...
0.021290.001.040.0355.0182.19cvn54b7yz0s8u select /*+ index(idl_ub1$ i_id...

Back to SQL Statistics 
Back to Top

SQL ordered by Gets

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • %Total - Buffer Gets as a percentage of Total Buffer Gets
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Total Buffer Gets: 3,025,488
  • Captured SQL account for 79.0% of Total
Buffer GetsExecutionsGets per Exec%TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
723,020176,6084.0923.9014.75100.450.05dr4mnnwqwm3rqPL/SQL Developerinsert into shuju1 (SUBJID, V...
629,883153,7484.1020.8213.65106.620.04845hn917wsu63PL/SQL Developerinsert into shuju1 (SUBJID, V...
623,3901623,390.0020.6034.4693.540.82b6usrg82hwsa3DBMS_SCHEDULERcall dbms_stats.gather_databas...
167,6251167,625.005.544.0591.254.3505s9358mm6vrr begin dbms_feature_usage_inter...
161,400299539.805.336.2990.0110.576gvch1xu9ca3g DECLARE job BINARY_INTEGER := ...
149,4742,05472.774.940.29101.890.32cvhk2j2gymzhdDBMS_SCHEDULERSELECT SU.NAME, SO.NAME, A.STA...
98,063249,031.503.243.8795.130.11fqmpmkfr6pqykPlSqlDev.exeselect s.synonym_name object_n...
78,847178,847.002.615.2093.670.122tr12b1b8uj71DBMS_SCHEDULERMERGE /*+ dynamic_sampling(ST ...
71,3452,66326.792.361.0399.980.0043ruajmwv9fus insert into histgrm$(obj#, int...
59,11516,2403.641.950.4397.390.00cm5vu20fhtnq1 select /*+ connect_by_filterin...
55,539268207.241.840.7087.3317.663am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_...
50,1154,09812.231.660.1695.550.006qg99cfg26kwbDBMS_SCHEDULERSELECT COUNT(UNQ) UNQ, COUNT(P...
48,16076,880.001.59469.56105.420.000mf6d1n1zzm0zPL/SQL Developerbegin -- Call the procedure oc...
47,262341,390.061.561.2199.554.8832bph60y97zdcPL/SQL DeveloperSELECT DISTINCT DESCRIPTION, F...
46,80315,6013.001.550.23106.950.677sx5p1ug5ag12DBMS_SCHEDULERSELECT SPARE4 FROM SYS.OPTSTAT...
41,43858,287.601.370.2165.8412.56gjm43un5cy843 SELECT SUM(USED), SUM(TOTAL) F...
35,50280144.321.170.76119.420.004y1y43113gv8f delete from histgrm$ where obj...

Back to SQL Statistics 
Back to Top

SQL ordered by Reads

  • %Total - Physical Reads as a percentage of Total Disk Reads
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Total Disk Reads: 6,899
  • Captured SQL account for 53.0% of Total
Physical ReadsExecutionsReads per Exec%TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
4,99514,995.0072.4034.4693.540.82b6usrg82hwsa3DBMS_SCHEDULERcall dbms_stats.gather_databas...
3,38313,383.0049.040.2129.7979.702gjv8dam6m03gDBMS_SCHEDULER/* SQL Analyze(1) */ select /*...
1,71811,718.0024.904.0591.254.3505s9358mm6vrr begin dbms_feature_usage_inter...
691290.531.000.0355.0182.19cvn54b7yz0s8u select /*+ index(idl_ub1$ i_id...
411400.290.590.020.0072.1739m4sx9k63ba2 select /*+ index(idl_ub2$ i_id...
34134.000.490.1096.2912.70ff5spha9pjuyuSQL*Plusselect * from table(dbms_xplan...
31131.000.450.4096.721.81f4r4y82fnaqgy BEGIN ctxsys.drifeat.dr$featur...
293110.090.420.02169.4151.328swypbbr0m372 select order#, columns, types ...
19119.000.280.5494.991.133h1rjtcff3wy1 BEGIN ordsys.CARTRIDGE.dbms_fe...
163160.050.230.0357.8122.363ktacv9r56b51 select owner#, name, namespace...

Back to SQL Statistics 
Back to Top

SQL ordered by Physical Reads (UnOptimized)

  • UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
  • %Opt - Optimized Reads as percentage of SQL Read Requests
  • %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
  • Total Physical Read Requests: 909
  • Captured SQL account for 46.9% of Total
  • Total UnOptimized Read Requests: 909
  • Captured SQL account for 46.9% of Total
  • Total Optimized Read Requests: 1
  • Captured SQL account for 0.0% of Total
UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%TotalSQL IdSQL ModuleSQL Text
7287281728.000.0080.0905s9358mm6vrr begin dbms_feature_usage_inter...
3323321332.000.0036.52b6usrg82hwsa3DBMS_SCHEDULERcall dbms_stats.gather_databas...
1201202640.450.0013.2049s332uhbnsma declare vsn varchar2(20); beg...
1061061106.000.0011.662gjv8dam6m03gDBMS_SCHEDULER/* SQL Analyze(1) */ select /*...
8484127.000.009.247mgr3uwydqq8j select decode(open_mode, 'MOU...
70702990.230.007.706gvch1xu9ca3g DECLARE job BINARY_INTEGER := ...
69691290.530.007.59cvn54b7yz0s8u select /*+ index(idl_ub1$ i_id...
67672680.250.007.373am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_...
41411400.290.004.5139m4sx9k63ba2 select /*+ index(idl_ub2$ i_id...
3434134.000.003.74ff5spha9pjuyuSQL*Plusselect * from table(dbms_xplan...
303056.000.003.30gjm43un5cy843 SELECT SUM(USED), SUM(TOTAL) F...
242483.000.002.64aukf94xzh2p3g declare policy varchar2(512);...
2424124.000.002.64f4r4y82fnaqgy BEGIN ctxsys.drifeat.dr$featur...
1515115.000.001.653h1rjtcff3wy1 BEGIN ordsys.CARTRIDGE.dbms_fe...
1515115.000.001.65fa16465c7pqmdPL/SQL Developerselect table_name, constraint_...
14141420.100.001.54c6awqs517jpj0 select /*+ index(idl_char$ i_i...
13131290.100.001.43ga9j9xk5cy9s0 select /*+ index(idl_sb4$ i_id...

Back to SQL Statistics 
Back to Top

SQL ordered by Executions

  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Total Executions: 3,369,093
  • Captured SQL account for 12.4% of Total
ExecutionsRows ProcessedRows per ExecElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
1,431,2181,431,2181.00326.43104.150.00g0unxwd406yu0PL/SQL Developerdeclare ret binary_integer; be...
1,431,0721,431,0721.00347.5199.660.00du7nyv586fquhPL/SQL Developerdeclare runtime_info sys.dbms_...
176,608176,6081.0014.75100.450.05dr4mnnwqwm3rqPL/SQL Developerinsert into shuju1 (SUBJID, V...
153,748153,7481.0013.65106.620.04845hn917wsu63PL/SQL Developerinsert into shuju1 (SUBJID, V...
16,24028,5671.760.4397.390.00cm5vu20fhtnq1 select /*+ connect_by_filterin...
15,60115,6011.000.23106.950.677sx5p1ug5ag12DBMS_SCHEDULERSELECT SPARE4 FROM SYS.OPTSTAT...
14,30600.000.12134.660.00cn39cg7kr98v6DBMS_SCHEDULERSELECT P.VALCHAR FROM SYS.OPTS...
4,0984,0981.000.1695.550.006qg99cfg26kwbDBMS_SCHEDULERSELECT COUNT(UNQ) UNQ, COUNT(P...
2,6992,6991.000.71116.810.002q7x9yavq27zyPL/SQL Developerdeclare i integer; fr integer;...
2,66313,5665.091.0399.980.0043ruajmwv9fus insert into histgrm$(obj#, int...

Back to SQL Statistics 
Back to Top

SQL ordered by Parse Calls

  • Total Parse Calls: 3,283,212
  • Captured SQL account for 11.1% of Total
Parse CallsExecutions% Total ParsesSQL IdSQL ModuleSQL Text
1,431,2171,431,21843.59g0unxwd406yu0PL/SQL Developerdeclare ret binary_integer; be...
1,431,0721,431,07243.59du7nyv586fquhPL/SQL Developerdeclare runtime_info sys.dbms_...
176,608176,6085.38dr4mnnwqwm3rqPL/SQL Developerinsert into shuju1 (SUBJID, V...
153,748153,7484.68845hn917wsu63PL/SQL Developerinsert into shuju1 (SUBJID, V...
16,24016,2400.49cm5vu20fhtnq1 select /*+ connect_by_filterin...
2,6992,6990.082q7x9yavq27zyPL/SQL Developerdeclare i integer; fr integer;...
9709700.03350f5yrnnmshs lock table sys.mon_mods$ in ex...
9709700.03g00cj285jmgsw update sys.mon_mods$ set inser...
9429420.038wg0nmja0pfacPL/SQL Developerdeclare -- Probe 2.1 backtrace...
9389380.039gkq7rruycsjp select parttype, partcnt, part...

Back to SQL Statistics 
Back to Top

SQL ordered by Sharable Memory

  • Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b)Executions% TotalSQL IdSQL ModuleSQL Text
1,253,89950.30gjm43un5cy843 SELECT SUM(USED), SUM(TOTAL) F...
1,244,533190.3020kv8785mj5shPL/SQL Developerselect * from sys.all_tab_part...
1,128,018130.27ab3swhv5g138y select OBJOID, CLSOID, RUNTIME...

Back to SQL Statistics 
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics 
Back to Top

 

Complete List of SQL Text

 

SQL IdSQL Text
04p6yvxfsv7cyINSERT INTO 体格检查 SELECT SUBJID, VISIT, FORM, GOURPNAME , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '肌肉骨骼系统', ITEM_VALUE, ''))) 肌肉骨骼系统 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '肌肉骨骼系统异常情况描述', ITEM_VALUE, ''))) 肌肉骨骼系统异常情况描述 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '神经系统异常情况描述', ITEM_VALUE, ''))) 神经系统异常情况描述 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '其他', ITEM_VALUE, ''))) 其他 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '泌尿生殖系统', ITEM_VALUE, ''))) 泌尿生殖系统 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '泌尿生殖系统异常情况描述', ITEM_VALUE, ''))) 泌尿生殖系统异常情况描述 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '循环系统', ITEM_VALUE, ''))) 循环系统 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '皮肤异常情况描述', ITEM_VALUE, ''))) 皮肤异常情况描述 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '其他异常情况描述', ITEM_VALUE, ''))) 其他异常情况描述 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '呼吸系统异常情况描述', ITEM_VALUE, ''))) 呼吸系统异常情况描述 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '内分泌和代谢系统异常情况描述', ITEM_VALUE, ''))) 内分泌和代谢系统异常情况描述 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '皮肤', ITEM_VALUE, ''))) 皮肤 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '内分泌和代谢系统', ITEM_VALUE, ''))) 内分泌和代谢系统 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '五官', ITEM_VALUE, ''))) 五官 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '五官异常情 况描述', ITEM_VALUE, ''))) 五官异常情况描述 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '呼吸系统', ITEM_VALUE, ''))) 呼吸系统 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '消化系统', ITEM_VALUE, ''))) 消化系统 , wmsys.wm_concat(to_char(DECOD E(DESCRIPTION, '神经系统', ITEM_VALUE, ''))) 神经系统 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '循环系统异常情况描述', ITEM_VALUE, ''))) 循环系统异常情况描述 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '消化系统异常情况描述', ITEM_VALUE, ''))) 消化系统异常情况描述 from shuju1 group by SUBJID, VISIT, FORM, GOURPNAME
05s9358mm6vrrbegin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end;
0mf6d1n1zzm0zbegin -- Call the procedure oc; end;
20kv8785mj5shselect * from sys.all_tab_partitions where table_name = :object_name and table_owner = :object_owner and trim(composite) = 'NO' order by partition_position
25986tpfa5wc3INSERT INTO 理化检查 SELECT SUBJID, VISIT, FORM , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血清总胆红素临床判断', ITEM_VALUE, ''))) 血清总胆红素临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血清总胆红素异常注释', ITEM_VALUE, ''))) 血清总胆红素异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞数检测值', ITEM_VALUE, ''))) 红细胞数检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血红蛋白检测值', ITEM_VALUE, ''))) 血红蛋白检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '葡萄糖异常注释', ITEM_VALUE, ''))) 葡萄糖异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞检测值', ITEM_VALUE, ''))) 红细胞检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞临床判断', ITEM_VALUE, ''))) 白细胞临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞异常注释', ITEM_VALUE, ''))) 白细胞异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '天门冬氨酸氨基转移酶异常注释', ITEM_VALUE, ''))) 天门冬氨酸氨基转移酶异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '碱性磷酸酶异常注释', ITEM_VALUE, ''))) 碱性磷酸酶异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '肌酐临床判断', ITEM_VALUE, ''))) 肌酐临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '检查日期', ITEM_VALUE, ''))) 检查日期 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞数临床判断', ITEM_VALUE, ''))) 红细胞数临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '葡萄糖检测值', ITEM_VALUE, ''))) 葡萄糖检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '蛋白质 临床判断', ITEM_VALUE, ''))) 蛋白质临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞临床判断', ITEM_VALUE, ''))) 红细胞临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞异常注释', ITEM_VALUE, ''))) 红细胞异常注释 , wmsys.wm_concat(to_cha r(DECODE(DESCRIPTION, '碱性磷酸酶临床判断', ITEM_VALUE, ''))) 碱性磷酸酶临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞数检测值', ITEM_VALUE, ''))) 白细胞数检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血小板检测值', ITEM_VALUE, ''))) 血小板检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血小板异常注释', ITEM_VALUE, ''))) 血小板异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '葡萄糖临床判断', ITEM_VALUE, ''))) 葡萄糖临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '天门冬氨酸氨基转移酶临床判断', ITEM_VALUE, ''))) 天门冬氨酸氨基转移酶临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '心电图结果', ITEM_VALUE, ''))) 心电图结果 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '心电图结论', ITEM_VALUE, ''))) 心电图结论 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '蛋白质异常注释', ITEM_VALUE, ''))) 蛋白质异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞检测值', ITEM_VALUE, ''))) 白细胞检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '谷氨酰转肽酶临床判断', ITEM_VALUE, ''))) 谷氨酰转肽酶临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '肌酐异常注释', ITEM_VALUE, ''))) 肌酐异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '心电图异常注释', ITEM_VALUE, ''))) 心电图异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血小板临床判断', ITEM_VALUE, ''))) 血小板临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '蛋白质检测值', ITEM_VALUE, ''))) 蛋白质检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '丙氨酸 氨基转移酶检测值', ITEM_VALUE, ''))) 丙氨酸氨基转移酶检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞数异常注释', ITEM_VALUE, ''))) 红细胞数异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞数异常注释', ITEM_VALUE, ''))) 白细胞数异常注释 , wmsys.wm _concat(to_char(DECODE(DESCRIPTION, '血红蛋白异常注释', ITEM_VALUE, ''))) 血红蛋白异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '丙氨酸氨基转移酶异常注释', ITEM_VALUE, ''))) 丙氨酸氨基转移酶异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '天门冬氨酸氨基转移酶检测值', ITEM_VALUE, ''))) 天门冬氨酸氨基转移酶检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '碱性磷酸酶检测值', ITEM_VALUE, ''))) 碱性磷酸酶检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血清总胆红素检测值', ITEM_VALUE, ''))) 血清总胆红素检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '谷氨酰转肽酶检测值', ITEM_VALUE, ''))) 谷氨酰转肽酶检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '尿素氮检测值', ITEM_VALUE, ''))) 尿素氮检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '尿素氮临床判断', ITEM_VALUE, ''))) 尿素氮临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '尿素氮异常注释', ITEM_VALUE, ''))) 尿素氮异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '心电图临床判断', ITEM_VALUE, ''))) 心电图临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血红蛋白临床判断', ITEM_VALUE, ''))) 血红蛋白临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '单位', ITEM_VALUE, ''))) 单位 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '谷氨酰转肽酶异常注释', ITEM_VALUE, ''))) 谷氨酰转肽酶异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '肌酐检测值', ITEM_VALUE, ''))) 肌酐检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞数临床判断', ITEM_VALUE, ''))) 白细胞数临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '丙氨酸氨基转移酶临床判断', ITEM_VALUE, ''))) 丙氨酸氨基转移酶临床判断 from shuju1 group by SUBJID, VISIT, FORM
2gjv8dam6m03g/* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("OBJ#")), to_char(substrb(dump(min("OBJ#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OBJ#"), 16, 0, 32), 1, 120)), to_char(count("PART")), to_char(substrb(dump(min("PART"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PART"), 16, 0, 32), 1, 120)), to_char(count("VERSION")), to_char(substrb(dump(min("VERSION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("VERSION"), 16, 0, 32), 1, 120)), to_char(count("PIECE#")), to_char(substrb(dump(min("PIECE#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PIECE#"), 16, 0, 32), 1, 120)), to_char(count("LENGTH")), to_char(substrb(dump(min("LENGTH"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LENGTH"), 16, 0, 32), 1, 120)) from "SYS"."IDL_UB2$" t /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
2q7x9yavq27zydeclare i integer; fr integer; begin i := 0; loop :result := sys.dbms_debug.get_value(variable_name => :variable_name, frame# => :frame#, scalar_value => :scalar_value, format => :format); if i = 0 then fr := :result; end if; exit when (:result in (0, 1, 32)) or (i = 9); i := i + 1; :frame# := :frame# + 1; end loop; if :result <> 0 then :result := fr; end if; end;
2tr12b1b8uj71MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > LOG(0.01, NVL(LOC_STALE_PCT, :B1 )/100) THEN 128 ELSE 0 END + AFLAGS AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 5 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#( +) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND BITAND(T.PROPERTY, 2147483648) = 0 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME IN ('SUMDELTA$', 'SNAP_XCMT$')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100 .0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M .DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL, 'TRUE') * :B6 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_ est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, SYS.OPTSTAT_USER_PREFS$ P, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(CM.BOBJ#, :B10 ) IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND O.OBJ# = P.OBJ# (+) AND P.PNAME(+) = 'STALE_PERCENT' AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 6 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND I.TYPE# = 4 AND I.BO# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLO CK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S , SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OPTSTAT_USER_PREFS$ P WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B2 ) <> 0) AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.PART# PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B7 ) <> 0) AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.SUBPART# PART#, I.POBJ# BO#, NULL LOC_STALE_PCT FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(IND.BO#, :B10 ) IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLAGS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B5 , :B4 , NEW.PART#, NEW.BO#)
32bph60y97zdcSELECT DISTINCT DESCRIPTION, FORM FROM SHUJU1
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
39m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3am9cfkvx7gq1CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3h1rjtcff3wy1BEGIN ordsys.CARTRIDGE.dbms_feature_multimedia(:feature_boolean, :aux_cnt, :feature_info); END;
3ktacv9r56b51select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
43ruajmwv9fusinsert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7)
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
49s332uhbnsmadeclare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;
4y1y43113gv8fdelete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6qg99cfg26kwbSELECT COUNT(UNQ) UNQ, COUNT(PFX) PFX FROM (SELECT /*+ first_rows(1) leading(cc) */ CD.TYPE# UNQ, NULL PFX FROM SYS.CCOL$ CC, SYS.CDEF$ CD WHERE CC.OBJ# = :B2 AND CC.INTCOL# = :B1 AND CD.CON# = CC.CON# AND CD.OBJ# = CC.OBJ# AND CD.ENABLED IS NOT NULL AND CD.INTCOLS = 1 AND CD.TYPE# IN (2, 3) AND BITAND(CD.DEFER, 2+4) = 4 AND ROWNUM < 2 UNION ALL SELECT /*+ first_rows(1) leading(i) */ CASE WHEN I.INTCOLS = 1 AND BITAND(I.PROPERTY, 1) = 1 THEN 3 ELSE NULL END UNQ, CASE WHEN IC.POS# = 1 THEN 1 ELSE NULL END PFX FROM SYS.IND$ I, SYS.ICOL$ IC WHERE I.BO# = :B2 AND I.BO# = IC.BO# AND IC.INTCOL# = :B1 AND I.OBJ# = IC.OBJ# AND BITAND(I.FLAGS, 1025) = 0 AND ROWNUM < 2 )
7mdacxfm37utkSELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYS_EXTRACT_UTC(SYSTIMESTAMP)-LAST_TIME_STAMP_UTC > NUMTODSINTERVAL(HEARTBEAT_INTERVAL*:B1 , 'SECOND')
7mgr3uwydqq8jselect decode(open_mode, 'MOUNTED', 0, 'READ WRITE', 1, 'READ ONLY', 1, 'READ ONLY WITH APPLY', 1, 2) dbstate into :dbstate from v$database
7sx5p1ug5ag12SELECT SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1
845hn917wsu63insert into shuju1 (SUBJID, VISIT, FORM, GOURPNAME, DESCRIPTION, ITEM_VALUE) values (:v0, :v1, :v2, :v3, :v4, :v5)
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
8wg0nmja0pfacdeclare -- Probe 2.1 backtrace sys.dbms_debug.backtrace_table; program_info sys.dbms_debug.program_info; i integer; j integer; begin sys.dbms_debug.print_backtrace(listing => :listing); begin sys.dbms_debug.print_backtrace(backtrace => backtrace); exception when others then backtrace.delete; end; :names := ''; :namespaces := ''; :owners := ''; :lines := ''; i := backtrace.first; j := 0; while (i is not null) and (j < 100) loop program_info := backtrace(i); :names := :names || program_info.name || chr(10); :namespaces := :namespaces || to_char(program_info.namespace) || chr(10); :owners := :owners || program_info.owner || chr(10); :lines := :lines || to_char(program_info.line#) || chr(10); i := backtrace.next(i); j := j + 1; end loop; end;
977mq4aw9jc36INSERT INTO 理化检查 SELECT SUBJID, VISIT, FORM, GOURPNAME , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞数检测值', ITEM_VALUE, ''))) 红细胞数检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血红蛋白检测值', ITEM_VALUE, ''))) 血红蛋白检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '葡萄糖异常注释', ITEM_VALUE, ''))) 葡萄糖异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞检测值', ITEM_VALUE, ''))) 红细胞检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞临床判断', ITEM_VALUE, ''))) 白细胞临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '天门冬氨酸氨基转移酶异常注释', ITEM_VALUE, ''))) 天门冬氨酸氨基转移酶异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '碱性磷酸酶临床判断', ITEM_VALUE, ''))) 碱性磷酸酶临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞数检测值', ITEM_VALUE, ''))) 白细胞数检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血小板检测值', ITEM_VALUE, ''))) 血小板检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '心电图结果', ITEM_VALUE, ''))) 心电图结果 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞检测值', ITEM_VALUE, ''))) 白细胞检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '丙氨酸氨基转移酶检测值', ITEM_VALUE, ''))) 丙氨酸氨基转移酶检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '谷氨酰转肽酶临床判断', ITEM_VALUE, ''))) 谷氨酰转肽酶临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '心电图异常注释', ITEM_VALUE, ''))) 心电图异常注释 , wmsys.wm_concat(to_char(DECODE(DESCR IPTION, '血小板临床判断', ITEM_VALUE, ''))) 血小板临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '丙氨酸氨基转移酶异常注释', ITEM_VALUE, ''))) 丙氨酸氨基转移酶异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞数异常注释', ITEM_VALUE, ''))) 红细胞数异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血红蛋白临床判断', ITEM_VALUE, ''))) 血红蛋白临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '单位', ITEM_VALUE, ''))) 单位 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞数临床判断', ITEM_VALUE, ''))) 白细胞数临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血清总胆红素临床判断', ITEM_VALUE, ''))) 血清总胆红素临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血清总胆红素异常注释', ITEM_VALUE, ''))) 血清总胆红素异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞异常注释', ITEM_VALUE, ''))) 白细胞异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '碱性磷酸酶异常注释', ITEM_VALUE, ''))) 碱性磷酸酶异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '肌酐临床判断', ITEM_VALUE, ''))) 肌酐临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '检查日期', ITEM_VALUE, ''))) 检查日期 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞数临床判断', ITEM_VALUE, ''))) 红细胞数临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '葡萄糖检测值', ITEM_VALUE, ''))) 葡萄糖检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '蛋白质临床判断', ITEM_VALUE, ''))) 蛋白质临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞临床判断', ITEM_VALUE, ''))) 红细胞临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '红细胞异常注释', ITEM_VALUE, ''))) 红细胞异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '天门冬氨酸氨基转移酶临床判断', ITEM_VALUE, ''))) 天门冬氨酸氨基转移酶临床判断 , wmsys.wm_c oncat(to_char(DECODE(DESCRIPTION, '血小板异常注释', ITEM_VALUE, ''))) 血小板异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '葡萄糖临床判断', ITEM_VALUE, ''))) 葡萄糖临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '心电图结论', ITEM_VALUE, ''))) 心电图结论 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '蛋白质异常注释', ITEM_VALUE, ''))) 蛋白质异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '肌酐异常注释', ITEM_VALUE, ''))) 肌酐异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '蛋白质检测值', ITEM_VALUE, ''))) 蛋白质检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '天门冬氨酸氨基转移酶检测值', ITEM_VALUE, ''))) 天门冬氨酸氨基转移酶检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '白细胞数异常注释', ITEM_VALUE, ''))) 白细胞数异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血红蛋白异常注释', ITEM_VALUE, ''))) 血红蛋白异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '碱性磷酸酶检测值', ITEM_VALUE, ''))) 碱性磷酸酶检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '血清总胆红素检测值', ITEM_VALUE, ''))) 血清总胆红素检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '谷氨酰转肽酶检测值', ITEM_VALUE, ''))) 谷氨酰转肽酶检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '尿素氮检测值', ITEM_VALUE, ''))) 尿素氮检测值 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '尿素氮临床判断', ITEM_VALUE, ''))) 尿素氮临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '尿素氮异常注释', ITEM_VALUE, ''))) 尿素氮异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '心电图临床判断', ITEM_VALUE, ''))) 心电图临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '丙氨酸氨基转移酶临床判断', ITEM_VALUE, ''))) 丙氨酸氨基转移酶临床判断 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '谷氨酰转肽酶异常注释', ITEM_VALUE, ''))) 谷氨酰转肽酶异常注释 , wmsys.wm_concat(to_char(DECODE(DESCRIPTION, '肌酐检测值', ITEM_VALUE, ''))) 肌酐检测值 from shuju1 group by SUBJID, VISIT, FORM, GOURPNAME
9gkq7rruycsjpselect parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1
ab3swhv5g138yselect OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
aukf94xzh2p3gdeclare policy varchar2(512); alldest number := dbms_rcvman.FALSE#; rlgscn number; begin if (:alldest > 0) then alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.getRedoLogDeletionPolicy(policy => policy); dbms_rcvman.setRedoLogDeletionPolicy(policy => policy, alldest => alldest); if ((policy like '%APPLIED%' OR policy like '%SHIPPED%') AND policy not like '%BACKED UP%') then dbms_rcvman.getSCNForAppliedPolicy( minscn => :applied_scn , rlgscn => rlgscn); else :applied_scn := 0; end if; end;
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
c0j6cx9kzjf7gSELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T
c6awqs517jpj0select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cn39cg7kr98v6SELECT P.VALCHAR FROM SYS.OPTSTAT_USER_PREFS$ P WHERE P.OBJ#=:B2 AND P.PNAME=:B1
cvhk2j2gymzhdSELECT SU.NAME, SO.NAME, A.STATSTYPE#, C.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, OBJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OID$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND O.NAME=:B3 AND U.NAME=:B2 AND C.NAME=:B1
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
dr4mnnwqwm3rqinsert into shuju1 (SUBJID, VISIT, FORM, DESCRIPTION, ITEM_VALUE) values (:v0, :v1, :v2, :v3, :v4)
du7nyv586fquhdeclare runtime_info sys.dbms_debug.runtime_info; sync_result integer; begin sys.dbms_debug.default_timeout := :default_timeout; runtime_info.program.namespace := :program_namespace; runtime_info.program.name := :program_name; runtime_info.program.owner := :program_owner; runtime_info.program.dblink := :program_dblink; runtime_info.line# := :line#; runtime_info.terminated := :terminated; runtime_info.breakpoint := :breakpoint; runtime_info.stackdepth := :stackdepth; runtime_info.interpreterdepth := :interpreterdepth; runtime_info.reason := :reason; if :do_sync = 1 then sync_result := sys.dbms_debug.synchronize(run_info => runtime_info, info_requested => sys.dbms_debug.info_getStackDepth + sys.dbms_debug.info_getLineInfo + sys.dbms_debug.info_getBreakpoint); end if; :cont_result := sys.dbms_debug.continue(run_info => runtime_info, breakflags => :breakflags, info_requested => sys.dbms_debug.info_getStackDepth + sys.dbms_debug.info_getLineInfo + sys.dbms_debug.info_getBreakpoint); :program_namespace := runtime_info.program.namespace; :program_name := runtime_info.program.name; :program_owner := runtime_info.program.owner; :program_dblink := runtime_info.program.dblink; :line# := runtime_info.line#; :terminated := runtime_info.terminated; :breakpoint := runtime_info.breakpoint; :stackdepth := runtime_info.stackdepth; :interpreterdepth := runtime_info.interpreterdepth; :reason := runtime_info.reason; sys.dbms_debug.default_timeout := 3600; end;
f4r4y82fnaqgyBEGIN ctxsys.drifeat.dr$feature_track(:feature_boolean, :aux_cnt, :feature_info); END;
fa16465c7pqmdselect table_name, constraint_name, status, owner from sys.all_constraints where r_owner = :r_owner and constraint_type = 'R' and r_constraint_name in ( select constraint_name from sys.all_constraints where constraint_type in ('P', 'U') and table_name = :r_table_name and owner = :r_owner ) order by table_name, constraint_name
ff5spha9pjuyuselect * from table(dbms_xplan.display)
fqmpmkfr6pqykselect s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g0unxwd406yu0declare ret binary_integer; begin ret := PBSDE.DEBUG_LOOP; end;
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gjm43un5cy843SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)

Back to SQL Statistics 
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

  • Ordered by statistic name
StatisticTotalper Secondper Trans
Batched IO (bound) vector count120.000.01
Batched IO (full) vector count00.000.00
Batched IO block miss count380.000.02
Batched IO double miss count00.000.00
Batched IO same unit count250.000.01
Batched IO single block count110.000.00
Batched IO vector block count20.000.00
Batched IO vector read count10.000.00
Block Cleanout Optim referenced210.000.01
CCursor + sql area evicted250.000.01
CPU used by this session107,5875.9847.71
CPU used when call started103,4545.7545.88
CR blocks created5060.030.22
Cached Commit SCN referenced2580.010.11
Commit SCN cached30.000.00
DB time2,682,801149.091,189.71
DBWR checkpoint buffers written19,2341.078.53
DBWR checkpoints160.000.01
DBWR object drop buffers written3930.020.17
DBWR transaction table writes4490.020.20
DBWR undo block writes6,9880.393.10
HSC Heap Segment Block Changes412,89622.95183.10
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts1,4120.080.63
Heap Segment Array Updates6610.040.29
IMU CR rollbacks5860.030.26
IMU Flushes4040.020.18
IMU Redo allocation size638,24835.47283.04
IMU commits1,9870.110.88
IMU contention10.000.00
IMU ktichg flush50.000.00
IMU pool not allocated20.000.00
IMU recursive-transaction flush20.000.00
IMU undo allocation size9,168,872509.554,066.02
IMU- failed to get a private strand20.000.00
LOB table id lookup cache misses10.000.00
Number of read IOs issued00.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
RowCR attempts2070.010.09
RowCR hits2070.010.09
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client1,797,40499.89797.07
TBS Extension: bytes extended3,932,160218.531,743.75
TBS Extension: files extended30.000.00
TBS Extension: tasks created220.000.01
TBS Extension: tasks executed220.000.01
active txn count during cleanout4,0770.231.81
application wait time100.000.00
background checkpoints completed70.000.00
background checkpoints started50.000.00
background timeouts75,3984.1933.44
buffer is not pinned count606,51233.71268.96
buffer is pinned count803,20644.64356.19
bytes received via SQL*Net from client3,718,946,383206,676.351,649,200.17
bytes sent via SQL*Net to client309,034,39617,174.25137,044.08
calls to get snapshot scn: kcmgss196,26810.9187.04
calls to kcmgas15,4790.866.86
calls to kcmgcs431,26123.97191.25
cell physical IO interconnect bytes927,578,62451,549.16411,343.07
change write time5750.030.25
cleanout - number of ktugct calls4,1870.231.86
cleanouts and rollbacks - consistent read gets1340.010.06
cleanouts only - consistent read gets720.000.03
cluster key scan block gets133,6197.4359.25
cluster key scans113,5076.3150.34
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed10.000.00
commit batch/immediate requested10.000.00
commit cleanout failures: block lost270.000.01
commit cleanout failures: callback failure740.000.03
commit cleanouts23,7451.3210.53
commit cleanouts successfully completed23,6441.3110.49
commit immediate performed10.000.00
commit immediate requested10.000.00
commit txn count during cleanout3370.020.15
concurrency wait time2,7270.151.21
consistent changes11,1850.624.96
consistent gets1,678,33493.27744.27
consistent gets - examination445,58924.76197.60
consistent gets direct140.000.01
consistent gets from cache1,678,32093.27744.27
consistent gets from cache (fastpath)1,187,96466.02526.81
cursor authentications9420.050.42
data blocks consistent reads - undo records applied9480.050.42
db block changes1,020,32056.70452.47
db block gets1,347,15474.87597.41
db block gets direct1400.010.06
db block gets from cache1,347,01474.86597.35
db block gets from cache (fastpath)777,35243.20344.72
deferred (CURRENT) block cleanout applications11,5340.645.11
enqueue conversions3,7020.211.64
enqueue releases172,7879.6076.62
enqueue requests172,7899.6076.62
enqueue timeouts10.000.00
enqueue waits120.000.01
execute count3,369,093187.231,494.05
failed probes on index block reclamation10.000.00
file io wait time3,481,194193.461,543.77
free buffer requested20,1881.128.95
heap block compress5370.030.24
immediate (CR) block cleanout applications2060.010.09
immediate (CURRENT) block cleanout applications6,0310.342.67
index crx upgrade (positioned)510.000.02
index crx upgrade (prefetch)00.000.00
index fast full scans (full)4550.030.20
index fetch by key583,50532.43258.76
index scans kdiixs1374,08420.79165.89
leaf node 90-10 splits1120.010.05
leaf node splits2200.010.10
lob reads4,2950.241.90
lob writes3,4710.191.54
lob writes unaligned3,4710.191.54
logons cumulative1,1450.060.51
max cf enq hold time160.000.01
messages received11,4710.645.09
messages sent11,4710.645.09
min active SCN optimization applied on CR30.000.00
no work - consistent read gets781,19743.41346.43
non-idle wait count1,898,896105.53842.08
non-idle wait time7,6280.423.38
opened cursors cumulative3,356,781186.551,488.59
parse count (describe)360.000.02
parse count (failures)1520.010.07
parse count (hard)2,0580.110.91
parse count (total)3,283,212182.461,455.97
parse time cpu7,5450.423.35
parse time elapsed7,7290.433.43
physical read IO requests9090.050.40
physical read bytes56,516,6083,140.8525,062.80
physical read total IO requests20,9021.169.27
physical read total bytes384,717,82421,380.27170,606.57
physical read total multi block requests930.010.04
physical reads6,8990.383.06
physical reads cache6,8500.383.04
physical reads cache prefetch5,9900.332.66
physical reads direct490.000.02
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup30.000.00
physical write IO requests5,8750.332.61
physical write bytes162,316,2889,020.5571,980.62
physical write total IO requests24,8331.3811.01
physical write total bytes542,860,80030,168.89240,736.50
physical write total multi block requests9110.050.40
physical writes19,8141.108.79
physical writes direct1750.010.08
physical writes direct (lob)390.000.02
physical writes direct temporary tablespace1010.010.04
physical writes from cache19,6391.098.71
physical writes non checkpoint11,7600.655.22
process last non-idle time14,8560.836.59
recovery blocks read00.000.00
recursive calls6,735,351374.312,986.85
recursive cpu usage56,9543.1725.26
redo blocks checksummed by FG (exclusive)26,3151.4611.67
redo blocks read for recovery00.000.00
redo blocks written317,14517.62140.64
redo buffer allocation retries30.000.00
redo entries507,50828.20225.06
redo k-bytes read for recovery00.000.00
redo k-bytes read total00.000.00
redo log space requests30.000.00
redo log space wait time20.000.00
redo ordering marks5,6430.312.50
redo size155,363,5248,634.1668,897.35
redo size for direct writes1,7680.100.78
redo subscn max counts11,4920.645.10
redo synch time820.000.04
redo synch writes6900.040.31
redo wastage1,526,60484.84676.99
redo write time6670.040.30
redo writes5,8470.322.59
rollback changes - undo records applied10.000.00
rollbacks only - consistent read gets3720.020.16
rows fetched via callback90,5085.0340.14
session connect time5,4680.302.42
session cursor cache hits635,78935.33281.95
session logical reads3,025,488168.141,341.68
shared hash latch upgrades - no wait21,9821.229.75
sorts (memory)60,7363.3826.93
sorts (rows)3,766,001209.291,670.07
sql area evicted6450.040.29
sql area purged2030.010.09
switch current to new buffer2,5340.141.12
table fetch by rowid213,23011.8594.56
table fetch continued row5930.030.26
table scan blocks gotten284,16915.79126.02
table scan rows gotten20,711,7421,151.039,184.81
table scans (long tables)10.000.00
table scans (short tables)30,2491.6813.41
temp space allocated (bytes)8,388,608466.193,720.00
total cf enq hold time4070.020.18
total number of cf enq holders1830.010.08
total number of times SMON posted220.000.01
transaction rollbacks10.000.00
undo change vector size39,553,2602,198.1317,540.25
user I/O wait time2230.010.10
user calls3,592,993199.681,593.35
user commits2,1920.120.97
user rollbacks630.000.03
workarea executions - onepass00.000.00
workarea executions - optimal27,3501.5212.13
write clones created in background120.000.01

Back to Instance Activity Statistics 
Back to Top

Instance Activity Stats - Absolute Values

  • Statistics with absolute values (should not be diffed)
StatisticBegin ValueEnd Value
session uga memory max6,629,559,02412,083,207,472
session pga memory1,932,356,0962,677,229,464
session pga memory max2,227,261,3603,104,013,288
session cursor cache count51,74873,149
session uga memory3,749,663,380,1845,231,482,835,472
opened cursors current4852
logons current3129

Back to Instance Activity Statistics 
Back to Top

Instance Activity Stats - Thread Activity

  • Statistics identified by '(derived)' come from sources other than SYSSTAT
StatisticTotalper Hour
log switches (derived)51.00

Back to Instance Activity Statistics 
Back to Top

 

IO Stats

Back to Top

IOStat by Function summary

  • 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
  • ordered by (Data Read + Write) desc
Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others311M1.11.017283208M0.72.01155926.4K0.61
LGWR2M0.01.000111157M0.33.0087251660.00
DBWR0M0.000M154M0.32.008558151.07
Buffer Cache Reads54M0.05.0030000M0.000M8600.67
Direct Reads1M0.00.0000550M0.000M0 
Direct Writes0M0.000M1M0.00.0000550 
TOTAL:368M1.16.020451520M1.38.02889827.4K0.61

Back to IO Stats 
Back to Top

IOStat by Filetype summary

  • 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
  • Small Read and Large Read are average service times, in milliseconds
  • Ordered by (Data Read + Write) desc
Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Control File312M1.11.017339205M0.73.0113920.45 
Data File53M0.05.002945152M0.33.0084470.392.60
Log File0M0.000M155M0.33.0086130.00 
Temp File1M0.00.0000552M0.00.0001111.250.00
TOTAL:366M1.16.020340514M1.38.0285640.452.52

Back to IO Stats 
Back to Top

IOStat by Function/Filetype summary

  • 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
  • Ordered by (Data Read + Write) desc for each function
Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others311M1.11.017283208M0.72.01155919.9K0.45
Others (Control File)311M1.10.017283203M0.72.01128119.8K0.45
Others (Data File)0M0.000M5M0.00.000277480.00
LGWR2M0.01.000111157M0.33.0087251160.00
LGWR (Log File)0M0.000M155M0.33.008613200.00
LGWR (Control File)2M0.01.0001112M0.01.000111960.00
DBWR0M0.000M154M0.32.008558151.07
DBWR (Data File)0M0.000M154M0.32.0085580 
DBWR (Control File)0M0.000M0M0.000M151.07
Buffer Cache Reads54M0.05.0030000M0.000M8600.67
Buffer Cache Reads (Data File)54M0.05.0030000M0.000M8600.67
Direct Reads1M0.00.0000550M0.000M0 
Direct Reads (Data File)1M0.00.0000550M0.000M0 
Direct Writes0M0.000M1M0.00.0000550 
Direct Writes (Data File)0M0.000M1M0.00.0000550 
TOTAL:368M1.16.020451520M1.38.02889820.9K0.46

Back to IO Stats 
Back to Top

Tablespace IO Stats

  • ordered by IOs (Reads + Writes) desc
TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX11500.527.302,745000.00
SYSTEM72900.588.111,328000.00
UNDOTBS1700.001.001,327000.00
USERS3700.271.00452000.00
TEMP1500.676.7316000.00
EXAMPLE700.001.007000.00

Back to IO Stats 
Back to Top

File IO Stats

  • ordered by Tablespace, File
TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EXAMPLEC:\APP\ADMINISTRATOR\ORADATA\WXH\EXAMPLE01.DBF700.001.007000.00
SYSAUXC:\APP\ADMINISTRATOR\ORADATA\WXH\SYSAUX01.DBF11500.527.302,745000.00
SYSTEMC:\APP\ADMINISTRATOR\ORADATA\WXH\SYSTEM01.DBF72900.588.111,328000.00
TEMPC:\APP\ADMINISTRATOR\ORADATA\WXH\TEMP01.DBF1500.676.731600 
UNDOTBS1C:\APP\ADMINISTRATOR\ORADATA\WXH\UNDOTBS01.DBF700.001.001,327000.00
USERSC:\APP\ADMINISTRATOR\ORADATA\WXH\USERS01.DBF3700.271.00452000.00

Back to IO Stats 
Back to Top

 

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

  • Standard block size Pools D: default, K: keep, R: recycle
  • Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D169,4201003,025,1406,85019,639000

Back to Buffer Pool Statistics 
Back to Top

Checkpoint Activity

  • Total Physical Writes: 19,814
MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000019,2340

Back to Buffer Pool Statistics 
Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  • B: Begin Snapshot, E: End Snapshot
 Targt MTTR (s)Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B0123005951189531516588895315   
E06275134715461658881546   

Back to Advisory Statistics 
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics 
Back to Top

Buffer Pool Advisory

  • Only rows with estimated physical reads >0 are displayed
  • ordered by Block Size, Buffers For Estimate
PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D1280.09161.3758110.00
D2560.19321.024315.00
D3840.28471.004215.00
D5120.37631.004215.00
D6400.47791.004215.00
D7680.56951.004215.00
D8960.651101.004215.00
D1,0240.741261.004215.00
D1,1520.841421.004215.00
D1,2800.931581.004215.00
D1,3761.001691.004215.00
D1,4081.021731.004215.00
D1,5361.121891.004215.00
D1,6641.212051.004215.00
D1,7921.302211.004215.00
D1,9201.402361.004215.00
D2,0481.492521.004215.00
D2,1761.582681.004215.00
D2,3041.672841.004215.00
D2,4321.772991.004215.00
D2,5601.863151.004215.00

Back to Advisory Statistics 
Back to Top

PGA Aggr Summary

  • PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.007540

Back to Advisory Statistics 
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics 
Back to Top

PGA Aggr Target Histogram

  • Optimal Executions are purely in-memory operations
Low OptimalHigh OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K26,03326,03300
64K128K70270200
128K256K222200
256K512K505000
512K1024K43643600
1M2M737300
2M4M161600
4M8M111100
8M16M7700

Back to Advisory Statistics 
Back to Top

PGA Memory Advisory

  • When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0
PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to DiskEstd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
1540.133,005.820.00100.000529,663
3080.253,005.820.00100.000529,663
6160.503,005.820.00100.000529,663
9240.753,005.820.00100.000529,663
1,2321.003,005.820.00100.000529,663
1,4781.203,005.820.00100.000529,663
1,7251.403,005.820.00100.000529,663
1,9711.603,005.820.00100.000529,663
2,2181.803,005.820.00100.000529,663
2,4642.003,005.820.00100.000529,663
3,6963.003,005.820.00100.000529,663
4,9284.003,005.820.00100.000529,663
7,3926.003,005.820.00100.000529,663
9,8568.003,005.820.00100.000529,663

Back to Advisory Statistics 
Back to Top

Shared Pool Advisory

  • SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
  • Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.
Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
1600.40151,06152,2181.002191.246,600
2080.52643,84052,2281.002091.1820,528
2560.641115,43452,2511.001861.0520,534
3040.761587,10852,2581.001791.0120,536
3520.882069,30352,2591.001781.0120,536
4001.0024310,94252,2601.001771.0020,536
4481.1225111,43652,2601.001771.0020,536
4961.2425111,43652,2601.001771.0020,536
5441.3625111,43652,2601.001771.0020,536
5921.4825111,43652,2601.001771.0020,536
6401.6025111,43652,2601.001771.0020,536
6881.7225111,43652,2601.001771.0020,536
7361.8425111,43652,2601.001771.0020,536
7841.9625111,43652,2601.001771.0020,536
8322.0825111,43652,2601.001771.0020,536

Back to Advisory Statistics 
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
4600.251,99958,026
9200.501,98542,361
1,3800.751,98542,361
1,8401.001,98542,361
2,3001.251,98542,361
2,7601.501,98542,361
3,2201.751,98542,361
3,6802.001,98542,361

Back to Advisory Statistics 
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics 
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics 
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics 
Back to Top

Enqueue Activity

  • only enqueues with waits are shown
  • Enqueue stats gathered prior to 10g should not be compared with 10g data
  • ordered by Wait Time desc, Waits desc
Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse)999901101.45
JS-Job Scheduler (queue lock)65,36465,3640100.00

Back to Wait Statistics 
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

  • Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
  • STO - Snapshot Too Old count, OOS - Out of Space count
  • Undo segment block stats:
  • uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
  • eS - expired Stolen, eR - expired Released, eU - expired reUsed
Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOSuS/uR/uU/ eS/eR/eU
26.526,2452,344424.8/54.10/00/0/0/0/0/0

Back to Undo Statistics 
Back to Top

Undo Segment Stats

  • Most recent 35 Undostat rows, ordered by Time desc
End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOSuS/uR/uU/ eS/eR/eU
01-9月 14:547545863250/00/0/0/0/0/0
01-9月 14:4414911,1883350/00/0/0/0/0/0
01-9月 14:344805873250/00/0/0/0/0/0
01-9月 14:246591,1882350/00/0/0/0/0/0
01-9月 14:14172345864250/00/0/0/0/0/0
01-9月 14:04871932,3444540/00/0/0/0/0/0
01-9月 13:548571,7434440/00/0/0/0/0/0
01-9月 13:449881,1914350/00/0/0/0/0/0
01-9月 13:34101365892250/00/0/0/0/0/0
01-9月 13:241,2701211,1923350/00/0/0/0/0/0
01-9月 13:142163125893250/00/0/0/0/0/0
01-9月 13:04732651,1933350/00/0/0/0/0/0
01-9月 12:541,0721,3561,6663430/00/0/0/0/0/0
01-9月 12:44131111,0641330/00/0/0/0/0/0
01-9月 12:34241205923250/00/0/0/0/0/0
01-9月 12:2426841,1943350/00/0/0/0/0/0
01-9月 12:14171885922250/00/0/0/0/0/0
01-9月 12:041,3692641,1963350/00/0/0/0/0/0
01-9月 11:5420735942250/00/0/0/0/0/0
01-9月 11:442112031,1963350/00/0/0/0/0/0
01-9月 11:34551525943250/00/0/0/0/0/0
01-9月 11:2422801,1972350/00/0/0/0/0/0
01-9月 11:14412355941250/00/0/0/0/0/0
01-9月 11:04911891,1973350/00/0/0/0/0/0
01-9月 10:5442845953250/00/0/0/0/0/0
01-9月 10:44173001,1992350/00/0/0/0/0/0
01-9月 10:34211225971250/00/0/0/0/0/0
01-9月 10:247541,2002350/00/0/0/0/0/0
01-9月 10:143916595983250/00/0/0/0/0/0
01-9月 10:041,3642811,2003350/00/0/0/0/0/0

Back to Undo Statistics 
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

  • "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
  • "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
  • "Pct Misses" for both should be very close to 0.0
Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch50.00 00 
ASM db client latch14,6330.00 00 
ASM map operation hash table50.00 00 
ASM network state latch3160.00 00 
AWR Alerted Metric Element list126,0810.00 00 
Change Notification Hash table latch5,9950.00 00 
Consistent RBA5,8530.00 00 
DML lock allocation25,6450.00 00 
Event Group Locks8050.00 00 
FIB s.o chain latch60.00 00 
FOB s.o list latch1,9040.00 00 
File State Object Pool Parent Latch50.00 00 
IPC stats buffer allocation latch50.00 00 
In memory undo latch30,2730.00 06,3670.00
JS Sh mem access452.221.0000 
JS broadcast autostart latch30.00 00 
JS mem alloc latch940.00 020.00
JS queue access latch990.00 00 
JS queue state obj latch130,7280.00 00 
JS slv state obj latch3,6030.080.0000 
KFC FX Hash Latch50.00 00 
KFC Hash Latch50.00 00 
KFCL LE Freelist50.00 00 
KGNFS-NFS:SHM structure50.00 00 
KGNFS-NFS:SVR LIST50.00 00 
KJC message pool free list50.00 00 
KJCT flow control latch50.00 00 
KMG MMAN ready and startup request latch5,9800.00 00 
KTF sga latch1040.00 05,4770.00
KWQMN job cache list latch290.00 00 
KWQS pqsubs latch190.00 00 
KWQS pqueue ctx latch3310.00 00 
Locator state objects pool parent latch50.00 00 
Lsod array latch50.00 00 
MQL Tracking Latch0  03590.00
Managed Standby Recovery State10.00 00 
Memory Management Latch50.00 05,9800.00
Memory Queue50.00 00 
Memory Queue Message Subscriber #150.00 00 
Memory Queue Message Subscriber #250.00 00 
Memory Queue Message Subscriber #350.00 00 
Memory Queue Message Subscriber #450.00 00 
Memory Queue Subscriber50.00 00 
MinActiveScn Latch640.00 00 
Mutex50.00 00 
Mutex Stats50.00 00 
OS process6,4970.00 00 
OS process allocation10,3060.011.0000 
OS process: request allocation1,6020.00 00 
PL/SQL warning settings2,871,3130.000.0000 
PX hash array latch50.00 00 
QMT50.00 00 
Real-time plan statistics latch1,9310.00 020.00
Result Cache: RC Latch20.00 00 
SGA IO buffer pool latch30.00 030.00
SGA blob parent50.00 00 
SGA bucket locks50.00 00 
SGA heap locks50.00 00 
SGA pool locks50.00 00 
SQL memory manager latch6030.00 05,9790.00
SQL memory manager workarea list latch522,6170.00 00 
Shared B-Tree1,6220.00 00 
Streams Generic50.00 00 
Testing50.00 00 
Token Manager50.00 00 
WCR: sync50.00 00 
Write State Object Pool Parent Latch50.00 00 
X$KSFQP50.00 00 
XDB NFS Security Latch50.00 00 
XDB unused session pool50.00 00 
XDB used session pool50.00 00 
active checkpoint queue latch11,8840.00 020.00
active service list40,9970.010.00018,4670.00
alert log latch0  020.00
archive control640.00 00 
begin backup scn array340.00 00 
buffer pool50.00 00 
business card50.00 00 
cache buffer handles23,0820.00 00 
cache buffers chains7,370,1800.000.00056,1060.00
cache buffers lru chain25,7210.00 080,4650.00
cache table scan latch3120.00 03120.00
call allocation7,8200.100.00020.00
cas latch50.00 00 
change notification client cache latch50.00 00 
channel handle pool latch1,6860.00 00 
channel operations parent latch113,2640.00 00 
checkpoint queue latch569,5110.00 016,7400.00
client/application info10,0240.00 00 
compile environment latch1,1450.00 00 
corrupted undo seg latch40.00 00 
cp cmon/server latch50.00 00 
cp pool latch50.00 00 
cp server hash latch50.00 00 
cp sga latch3160.00 00 
cvmap freelist lock50.00 00 
database property service latch80.00 00 
deferred cleanup latch3160.00 00 
dml lock allocation4040.00 00 
done queue latch50.00 00 
dummy allocation2,2970.040.0000 
enqueue hash chains349,3200.000.0000 
enqueues305,2050.000.0000 
fifth spare latch50.00 00 
file cache latch9260.00 00 
flashback copy50.00 00 
gc element50.00 00 
gcs commit scn state50.00 00 
gcs partitioned table hash50.00 00 
gcs pcm hashed value bucket hash50.00 00 
gcs resource freelist50.00 00 
gcs resource hash50.00 00 
gcs resource scan list50.00 00 
gcs shadows freelist50.00 00 
ges domain table50.00 00 
ges enqueue table freelist50.00 00 
ges group table50.00 00 
ges process hash list50.00 00 
ges process parent latch50.00 00 
ges resource hash list50.00 00 
ges resource scan list50.00 00 
ges resource table freelist50.00 00 
ges value block free list50.00 00 
global KZLD latch for mem in SGA1190.00 00 
global tx hash mapping50.00 00 
granule operation50.00 00 
hash table column usage latch1,3830.00 0687,0440.00
hash table modification latch4960.00 020.00
heartbeat check50.00 00 
i/o slave adaptor0  020.00
internal temp table object number allocation latch500.00 00 
intra txn parallel recovery50.00 00 
io pool granule metadata list50.00 00 
job workq parent latch3500.00 03451.16
job_queue_processes free list latch7220.00 020.00
job_queue_processes parameter latch4,2520.00 00 
k2q lock allocation50.00 00 
kcbtsemkid latch50.00 00 
kdlx hb parent latch50.00 00 
kgb parent50.00 00 
kks stats5,1990.00 00 
kokc descriptor allocation latch3,1220.00 00 
ksfv messages50.00 00 
kss move lock1710.00 00 
ksuosstats global area1,2150.00 00 
ksv allocation latch6480.00 00 
ksv class latch3370.00 00 
ksv msg queue latch50.00 00 
ksz_so allocation latch1,6020.00 00 
ktm global data1350.00 00 
kwqbsn:qsga6420.00 00 
lgwr LWN SCN10,1890.00 00 
list of block allocation1,5850.00 00 
loader state object freelist2420.00 00 
lob segment dispenser latch50.00 00 
lob segment hash table latch650.00 00 
lob segment query latch50.00 00 
lock DBA buffer during media recovery50.00 00 
logical standby cache50.00 00 
logminer context allocation50.00 00 
logminer work area50.00 00 
longop free list parent1520.00 01500.00
mapped buffers lru chain50.00 00 
message pool operations parent latch540.00 00 
messages275,6290.030.0000 
mostly latch-free SCN10,2000.090.1100 
msg queue latch50.00 00 
multiblock read objects7900.00 020.00
name-service namespace bucket50.00 00 
ncodef allocation latch3160.00 00 
object queue header heap48,0240.00 04940.00
object queue header operation130,9910.00 00 
object stats modification5870.00 00 
parallel query alloc buffer2,3970.00 00 
parallel query stats50.00 00 
parameter list2,4900.00 00 
parameter table management2,5620.00 00 
peshm50.00 00 
pesom_free_list50.00 00 
pesom_hash_node50.00 00 
post/wait queue1,0070.00 06120.00
process allocation2,2830.00 08000.00
process group creation1,6020.00 00 
process queue50.00 00 
process queue reference50.00 00 
qmn task queue latch2,6208.050.9100 
query server freelists50.00 00 
queued dump request600.00 00 
queuing load statistics50.00 00 
recovery domain hash list50.00 00 
redo allocation39,4230.050.000507,5620.00
redo copy50.00 0507,5640.03
redo writing41,9410.00 00 
resmgr group change latch2,5080.00 00 
resmgr:active threads6,2690.00 03,0090.00
resmgr:actses change group7930.00 00 
resmgr:actses change state970.00 00 
resmgr:free threads list2,4500.200.0000 
resmgr:plan CPU method50.00 00 
resmgr:resource group CPU method100.00 00 
resmgr:schema config3,9080.00 03000.00
resmgr:session queuing50.00 00 
rm cas latch50.00 00 
row cache objects1,784,8260.000.0107130.00
rules engine aggregate statistics190.00 00 
rules engine evaluation context statistics0  020.00
rules engine rule set statistics380.00 00 
second spare latch50.00 00 
sequence cache1,9250.00 00 
session allocation7,2690.00 02,4200.00
session idle bit7,187,2670.000.0000 
session queue latch50.00 00 
session state list latch2,8340.00 00 
session switching4,3310.00 00 
session timer6,6360.00 00 
shared pool8,922,5530.000.0300 
shared pool sim alloc1110.00 00 
shared pool simulator19,9600.00 00 
sim partition latch50.00 00 
simulator hash latch165,6190.00 00 
simulator lru latch10,2840.00 0153,4490.00
sort extent pool6860.00 00 
space background state object latch60.00 00 
space background task latch13,4630.040.50011,9620.00
state object free list120.00 00 
statistics aggregation2,8000.00 00 
tablespace key chain1010.00 00 
temp lob duration state obj allocation170.00 00 
temporary table state object allocation160.00 00 
test excl. parent l050.00 00 
test excl. parent2 l050.00 00 
third spare latch50.00 00 
threshold alerts latch6730.00 00 
transaction allocation4,6560.00 00 
undo global data34,8690.00 00 
virtual circuit buffers50.00 00 
virtual circuit holder50.00 00 
virtual circuit queues50.00 00 

Back to Latch Statistics 
Back to Top

Latch Sleep Breakdown

  • ordered by misses desc
Latch NameGet RequestsMissesSleepsSpin Gets
shared pool8,922,5532477241
qmn task queue latch2,62021119120
row cache objects1,784,82687186
mostly latch-free SCN10,200918
space background task latch13,463633
JS Sh mem access45110
OS process allocation10,306110

Back to Latch Statistics 
Back to Top

Latch Miss Sources

  • only latches with sleeps are shown
  • ordered by name, sleeps desc
Latch NameWhereNoWait MissesSleepsWaiter Sleeps
JS Sh mem accessjsksGetShMemLatch011
OS process allocationksoreq_submit010
PC and Classifier lists for WLMNo latch020
lgwr LWN SCNkcs023010
qmn task queue latchkwqmnmvtsks: delay to ready list01880
qmn task queue latchkwqmnaddtsk: add task030
row cache objectskqreqd: reget010
shared poolkghalo054
shared poolkghfre022
space background task latchktsjCreateTask010

Back to Latch Statistics 
Back to Top

Mutex Sleep Summary

  • ordered by number of sleeps desc
Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglhdgn2 1068380
Library Cachekglpin1 47190
Library Cachekglhdgn1 621190
Library Cachekgllkdl1 8596-0
Library Cachekglpnal1 90170
Library Cachekglpndl1 95150
Library Cachekglpsl1 3820

Back to Latch Statistics 
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics 
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics 
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

  • Total Logical Reads: 3,025,488
  • Captured Segments account for 92.1% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
WLGSUSERSSHUJU1 TABLE641,08821.19
WLGSUSERSSHUJU1 TABLE629,52020.81
WLGSUSERSSHUJU1 TABLE98,6563.26
SYSSYSTEMI_OBJ1 INDEX98,5923.26
WLGSUSERSSHUJU1 TABLE94,2403.11

Back to Segment Statistics 
Back to Top

Segments by Physical Reads

  • Total Physical Reads: 6,899
  • Captured Segments account for 49.6% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYSSYSTEMIDL_UB2$ TABLE3,38349.04
WLGSUSERSSHUJU1 TABLE60.09
WLGSUSERSSHUJU1 TABLE40.06
SYSSYSAUXSYS_LOB0000006207C00004$$ LOB40.06
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX30.04

Back to Segment Statistics 
Back to Top

Segments by Physical Read Requests

  • Total Physical Read Requests: 909
  • Captured Segments account for 16.3% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SYSSYSTEMIDL_UB2$ TABLE10611.66
WLGSUSERSSHUJU1 TABLE60.66
WLGSUSERSSHUJU1 TABLE40.44
SYSSYSAUXSYS_LOB0000006207C00004$$ LOB40.44
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX30.33

Back to Segment Statistics 
Back to Top

Segments by UnOptimized Reads

  • Total UnOptimized Read Requests: 909
  • Captured Segments account for 16.3% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SYSSYSTEMIDL_UB2$ TABLE10611.66
WLGSUSERSSHUJU1 TABLE60.66
WLGSUSERSSHUJU1 TABLE40.44
SYSSYSAUXSYS_LOB0000006207C00004$$ LOB40.44
SYSSYSAUXI_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX30.33

Back to Segment Statistics 
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics 
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics 
Back to Top

Segments by Physical Writes

  • Total Physical Writes: 19,814
  • Captured Segments account for 43.4% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
WLGSUSERSSHUJU1 TABLE1,5427.78
WLGSUSERSSHUJU1 TABLE1,4227.18
WLGSUSERSSHUJU1 TABLE1,4107.12
SYSSYSTEMHISTGRM$ TABLE8974.53
WLGSUSERSSHUJU1 TABLE2591.31

Back to Segment Statistics 
Back to Top

Segments by Physical Write Requests

  • Total Physical Write Requestss: 5,875
  • Captured Segments account for 32.1% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SYSSYSTEMHISTGRM$ TABLE1392.37
WLGSUSERSSHUJU1 TABLE1121.91
WLGSUSERSSHUJU1 TABLE1031.75
WLGSUSERSSHUJU1 TABLE1021.74
SYSSYSAUXSMON_SCN_TIME TABLE941.60

Back to Segment Statistics 
Back to Top

Segments by Direct Physical Writes

  • Total Direct Physical Writes: 175
  • Captured Segments account for 22.9% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXSYS_LOB0000006213C00038$$ LOB2816.00
SYSSYSAUXSYS_LOB0000006207C00004$$ LOB95.14
SYSSYSAUXSYS_LOB0000006021C00008$$ LOB21.14
SYSTEMPSYS_TEMP_0FD9D6608_1C4A2C TABLE10.57

Back to Segment Statistics 
Back to Top

Segments by Table Scans

  • Total Table Scans: 456
  • Captured Segments account for 32.7% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_OBJ2 INDEX388.33
SYSSYSTEMI_OBJ1 INDEX163.51
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__142723844_81INDEX PARTITION102.19
SYSSYSAUXWRH$_SERVICE_WAIT_CLASS_PKWRH$_SERVIC_142723844_81INDEX PARTITION102.19
SYSSYSAUXWRH$_LATCH_PKWRH$_LATCH_142723844_81INDEX PARTITION81.75

Back to Segment Statistics 
Back to Top

Segments by DB Blocks Changes

  • % of Capture shows % of DB Block Changes for each top segment compared
  • with total DB Block Changes for all segments captured by the Snapshot
OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
WLGSUSERSSHUJU1 TABLE161,69633.64
WLGSUSERSSHUJU1 TABLE160,89633.48
SYSSYSTEMHISTGRM$ TABLE28,4485.92
SYSSYSTEMI_H_OBJ#_COL# INDEX25,5685.32
WLGSUSERSSHUJU1 TABLE24,3685.07

Back to Segment Statistics 
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics 
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics 
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics 
Back to Top

 

Dictionary Cache Stats

  • "Pct Misses" should be very low (< 2% in most cases)
  • "Final Usage" is the number of cache entries being used
CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control3760.000 121
dc_constraints1233.330 121
dc_files500.000 05
dc_global_oids6,4580.060 073
dc_histogram_data27,2766.490 1,8095,162
dc_histogram_defs47,73511.770 2,4134,076
dc_object_grants16,8800.410 0289
dc_objects62,3031.350 4052,935
dc_profiles4800.000 01
dc_rollback_segments4,2030.000 022
dc_segments8,6412.080 321964
dc_sequences1811.110 189
dc_table_scns3100.000 00
dc_tablespaces175,7620.000 07
dc_users251,7110.020 0211
global database name17,3940.000 01
outstanding_alerts1486.760 195
sch_lj_objs1323.080 010
sch_lj_oids3710.810 020


Back to Top

 

Library Cache Activity

  • "Pct Misses" should be very low
NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY9,5550.0810,047,8410.0000
CLUSTER1,1280.002950.0000
DBLINK2480.000 00
DIRECTORY10.0020.0000
EDITION5440.001,0040.0000
INDEX2,1290.751,76615.351510
OBJECT ID86100.000 00
PIPE8,662,8610.0013,015,407-0.0100
QUEUE3000.001,0920.0000
RULESET190.00190.0000
SCHEMA1,2450.400 00
SQL AREA22,28912.617,731,4510.06352600
SUBSCRIPTION290.00290.0000
TABLE/PROCEDURE48,7220.6410,073,8940.026273
TEMPORARY INDEX1655.45165100.001560
TEMPORARY TABLE4601.52460100.004530
TRIGGER1,0200.001,2900.0000


Back to Top

 

Memory Statistics

Back to Top

Memory Dynamic Components

  • Min/Max sizes since instance startup
  • Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
  • ordered by Component
ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache1,376.001,376.001,376.001,376.000INI/
KEEP buffer cache0.000.000.000.000STA/
PGA Target1,232.001,232.001,232.001,232.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target1,840.001,840.001,840.001,840.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool16.0016.0016.0016.000STA/
large pool16.0016.0016.0016.000STA/
shared pool400.00400.00400.00400.000STA/
streams pool0.000.000.000.000STA/

Back to Memory Statistics 
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics 
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics 
Back to Top

Process Memory Summary

  • B: Begin Snap E: End Snap
  • All rows below contain absolute values (i.e. not diffed over the interval)
  • Max Alloc is Maximum PGA Allocation size at snapshot time
  • Hist Max Alloc is the Historical Max Allocation for still-connected processes
  • ordered by Begin/End snapshot, Alloc (MB) desc
 CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther56.03 1.701.506103333
 Freeable12.630.001.151.305 1111
 SQL1.631.320.090.281261914
 PL/SQL1.120.860.040.06023131
EOther54.14 1.751.779103131
 Freeable18.940.001.721.525 1111
 PL/SQL0.900.610.030.07012929
 SQL0.360.120.020.030261812

Back to Memory Statistics 
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers1,442,840,576 
Fixed Size2,180,024 
Redo Buffers16,982,016 
Variable Size1,744,833,608 

Back to Memory Statistics 
Back to Top

SGA breakdown difference

  • ordered by Pool, Name
  • N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot
PoolNameBegin MBEnd MB% Diff
javafree memory16.0016.000.00
largePX msg pool7.507.500.00
largefree memory8.508.500.00
sharedASH buffers8.008.000.00
sharedCCUR18.7222.9222.42
sharedFileOpenBlock10.5010.500.00
sharedKCB Table Scan Buffer4.004.000.00
sharedKGLH07.337.654.37
sharedKGLHD9.349.865.55
sharedKGLS12.978.98-30.78
sharedKGLSG5.025.020.00
sharedPCUR12.9316.2625.76
sharedPLDIA4.83 -100.00
sharedPLMCD9.299.805.52
sharedSQLA102.78129.1725.68
shareddb_block_hash_buckets11.1311.130.00
shareddbwriter coalesce buffer4.004.000.00
sharedfree memory106.5773.32-31.20
sharedrow cache7.237.230.00
 buffer_cache1,376.001,376.000.00
 fixed_sga2.082.080.00
 log_buffer16.2016.200.00

Back to Memory Statistics 
Back to Top

 

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics 
Back to Top

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

Shared Server Statistics

Back to Top

Shared Servers Activity

  • Values represent averages for all samples
Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
001010

Back to Shared Server Statistics 
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000

Back to Shared Server Statistics 
Back to Top

Shared Servers Utilization

  • Statistics are combined for all servers
  • Incoming and Outgoing Net % are included in %Busy
Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
17,9940.00100.000.000.00

Back to Shared Server Statistics 
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics 
Back to Top

Shared Servers Dispatchers

  • Ordered by %Busy, descending
  • Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
  • Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots
NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.0017,9940.00100.0000 

Back to Shared Server Statistics 
Back to Top

 

init.ora Parameters

  • if IP/Public/Source at End snap is different a '*' is displayed
Parameter NameBegin valueEnd value (if different)
audit_file_destC:\APP\ADMINISTRATOR\ADMIN\WXH\ADUMP  
audit_trailDB  
compatible11.2.0.0.0  
control_filesC:\APP\ADMINISTRATOR\ORADATA\WXH\CONTROL01.CTL, C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\WXH\CONTROL02.CTL  
db_block_size8192  
db_domain    
db_nameWXH  
db_recovery_file_destc:\app\Administrator\flash_recovery_area  
db_recovery_file_dest_size4102029312  
diagnostic_destC:\APP\ADMINISTRATOR  
dispatchers(PROTOCOL=TCP) (SERVICE=WXHXDB)  
local_listenerLISTENER_WXH  
memory_target3221225472  
open_cursors300  
processes150  
remote_login_passwordfileEXCLUSIVE  
undo_tablespaceUNDOTBS1  


Back to Top

 

 

 

 

 

 

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

 

End of Report

已标记关键词 清除标记
©️2020 CSDN 皮肤主题: 游动-白 设计师:白松林 返回首页