Newgrounds - Technical Difficulties
We seem to be experiencing technical difficulties!
In the meantime, find us on:
Access denied
The owner of this website (www.newgrounds.com) has banned your access based on your browser's signature (3f594ad16a216cf4-ua98).
Ray ID: 3f594ad16a216cf4
Timestamp:
04:17:14 UTC
Your IP address: 114.223.56.77
Requested URL: www.newgrounds.com/bbs/topic/
Error reference number: 1010
Server ID: FL_4F211
User-Agent: Mozilla/5.0 (compatible, MSIE 11, Windows NT 6.3; Trident/7.0; rv:11.0) like Gecko2007款帕萨特领驭用户手册2_图文_百度文库
两大类热门资源免费畅读
续费一年阅读会员，立省24元！
2007款帕萨特领驭用户手册2
&&2007款帕萨特领驭用户手册共3部分,此为第2部分。车型为：SVW7183LJi,SVW7183MJi,SVW7203EPi,SVW7203FPi,SVW7283KKi,分别为1.8T手自一体,1.8T手动档,2.0手动,2.0自动,2.8升。
阅读已结束，下载本文需要
想免费下载更多文档？
定制HR最喜欢的简历
下载文档到电脑，方便使用
还剩67页未读，继续阅读
定制HR最喜欢的简历
你可能喜欢AWR Report 关键参数详细分析 - 小kiss - 博客园
WORKLOAD REPOSITORY report for
Sessions：开始有608个会话，结束有711个会话
Elapsed：采样时间
DB Time：因为多cpu，最大可提供Elapsed*CPU_num的运行时间。
AAS：Avg Active Session=DB Time/Elapsed time，如果 &1 ,说明负载很低，&1000基本系统hang住了
Report Summary
Cache Sizes
&BeginEnd&&
Buffer Cache:
Std Block Size:
Shared Pool Size:
Log Buffer:
buffer cache：所有缓冲池大小之和，不仅default池
如果begin和end之间的变化较大，可以查看期间内存的抖动：
Load Profile （系统负载情况）
&Per SecondPer TransactionPer ExecPer Call
DB Time(s):
DB CPU(s):
Redo size:
36,052.5（b）
Logical reads:块数*次数
Block changes:
Physical reads:
Physical writes:
User calls:
Parses:(分析sql的次数)
Hard parses:(硬解析次数)
W/A MB processed:
Rollbacks:
Transactions:
可以通过Redo size推断每天产生的日志量，并推断日志大小是否合理（每小时日志=36k*60*60，看日志大小推断多久切换一次，看是否合理）
transactions在不同日期中，正常应该差不多
如果某天逻辑读206.6增大很多，可以怀疑是否某个索引失效、sql的执行计划错误
Instance Efficiency Percentages (Target 100%) 命中率指标
PARSE CPU TO PARESE ELAPSD%表示在整个PARSE所占用的时间的中,真正的CPU时间比.PARSE CPU TO PARESE ELAPSD=100*(PARSE CPU/PARESE ELAPSD).我们知道PARSE ELAPSD=PARSE CPU+等待.一般这个值越低,表示解析等待越严重.%NON-PARSE CPU.表示在整个DB　CPU中非PARSE
CPU所占用的百份比,越高表示解析越少,用于执行查询的CPU越多.该值过小表示解析过多.EXECUTE TO
PARSE%表示PARSE/EXECUTE的百份比.该参数是语句执行和分析了多少次的度量.有可能为负数,说明效率极低，这个Parse包括软解析
Shared Pool Statistics 共享池状态
Memory Usage %:共享池使用率，100%并不能说明共享池不足，分配就是要用的
% SQL with executions&1:
% Memory for SQL w/exec&1:重用的sql使用的内存
Top 5 Timed Foreground Events
EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
enq: TX - allocate ITL entry
Configuration
enq: TX - index contention
Concurrency
buffer busy waits
Concurrency
gc buffer busy acquire
gc buffer busy release
sequential read某天突然降低，有可能系统出现瓶颈
Host CPU (CPUs: 128 Cores: 32 Sockets: )
Load Average BeginLoad Average End%User%System%WIO%Idle
Instance CPU
%Total CPU%Busy CPU%DB time waiting for CPU (Resource
Memory Statistics
Host Mem (MB):
SGA use (MB):
PGA use (MB):
% Host Mem used for SGA+PGA:
RAC Statistics
Global Cache Load Profile （全局缓冲区负载，只有rac才有）
Global Cache Efficiency Percentages (Target local+remote 100%)
Global Cache and Enqueue Services - Workload Characteristics
全局缓冲和全局锁
Avg global enqueue get time (ms):一个global cache获取时间1~20ms正常
Avg global cache cr block receive time (ms):一个CR块从发起请求到收到的时间，超过12ms有问题
Avg global cache current
block receive time (ms):
Avg global cache cr block
build time (ms):
Avg global cache cr block send time (ms):
Global cache log flushes for cr blocks served
Avg global cache cr block
flush time (ms):
Avg global cache current block pin time (ms):
Avg global cache current block send time
Global cache log flushes for current blocks
Avg global cache current block flush time
Global Cache and Enqueue Services - Messaging Statistics
消息统计数据
Avg message sent queue time (ms):非直接传输的消息，在队列中的等待时间，0.1ms左右
Avg message sent queue time on ksxp (ms):ipc层面发送一个消息到ack回应，应小于1ms
Avg message received queue time (ms):消息进入队列到开始处理的时间，0.1ms左右
Avg GCS message process time (ms):处理一个buffer相关的gcs时间，应小于0.5ms
Avg GES message process time (ms):处理一个锁消息的时间，应小于0.5ms
% of direct sent messages:直接发送消息
% of indirect sent messages:通过代理发送消息
% of flow controlled messages:流控消息
如果某天消息处理特别慢，可以看看是否消息量特别多
Cluster Interconnect
if IP/Public/Source at End snap is different a '*' is displayed
InterfaceIP AddressPubSourceIPPubSrc
Main Report
More RAC Statistics
Wait Events Statistics
Time Model Statistics（时间模型）
Total time in database user-calls (DB Time): 3971.2s
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
sql execute elapsed time
parse time elapsed：sql解析时间
connection management call elapsed time
PL/SQL execution elapsed time
hard parse (sharing criteria) elapsed time
hard parse elapsed time
repeated bind elapsed time
background elapsed time
background cpu time
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_TIME
AVG_IDLE_TIME
AVG_IOWAIT_TIME
AVG_SYS_TIME
AVG_USER_TIME
13,230,065
IOWAIT_TIME
OS_CPU_WAIT_TIME
VM_IN_BYTES
VM_OUT_BYTES
121,802,752
PHYSICAL_MEMORY_BYTES
268,703,891,456
NUM_CPU_CORES
GLOBAL_RECEIVE_SIZE_MAX
GLOBAL_SEND_SIZE_MAX
TCP_RECEIVE_SIZE_DEFAULT
TCP_RECEIVE_SIZE_MAX
9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN
TCP_SEND_SIZE_DEFAULT
TCP_SEND_SIZE_MAX
9,223,372,036,854,775,807
TCP_SEND_SIZE_MIN
Operating System Statistics - Detail
Snap TimeLoad%busy%user%sys%idle%iowait
08-Dec 19:09:55
08-Dec 19:27:13
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 99.8% of Total DB time 3,971.17 (s)
Total FG Wait Time: 3,939.48 (s) DB CPU time: 24.54 (s)
Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Configuration
Concurrency
System I/O
Application
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
enq: TX - allocate ITL entry
enq: TX - index contention
buffer busy waits
gc buffer busy acquire
gc buffer busy release
gc current block busy
latch: ges resource hash list
gc cr block 2-way
gc current block 2-way
log file sync
latch free
gc current grant busy
latch: cache buffers chains
gc current split
reliable message
library cache: mutex X
Disk file operations I/O
gc cr block busy
enq: HW - contention
enq: US - contention
SQL*Net message to client
gc cr multi block request
row cache lock
enq: TA - contention
wait list latch free
gc current multi block request
enq: TX - contention
read by other session热快冲突
buffer deadlock
control file sequential read
gc current grant 2-way
SQL*Net message from dblink
DFS lock handle
enq: TS - contention
rdbms ipc reply
enq: FB - contention
SQL*Net more data to client
db file sequential read
gc current retry
IPC send completion sync
enq: JQ - contention
gc current block congested
lock deadlock retry
cursor: pin S wait on X
enq: PS - contention
gc cr block congested
PX Deq: Slave Session Stats
KJC: Wait for msg sends to complete
enq: WF - contention
SQL*Net message from client
jobq slave wait
PX Deq: Execution Msg
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
Streams AQ: qmn coordinator waiting for slave to
os thread startup
log file parallel write
gcs log flush sync
control file sequential read
db file parallel write
DFS lock handle
control file parallel write
enq: CO - master slave det
ASM file metadata operation
CSS operation: data query
latch free
enq: WF - contention
CGS wait for IPC msg
CSS initialization
ksxr poll remote instances
row cache process
gc current block 2-way
reliable message
gc cr block 2-way
row cache lock
CSS group membership query
enq: CF - contention
row cache cleanup
db file sequential read
gc current grant busy
Disk file operations I/O
CSS operation: action
LGWR wait for redo copy
PX Deq: reap credit
libcache interrupt action by LCK
enq: PS - contention
gc current block busy
db file async I/O submit
latch: cache buffers chains
rdbms ipc message
gcs remote message
Space Manager: slave idle wait
wait for unread message on broadcast channel
DIAG idle wait
Streams AQ: qmn slave idle wait
class slave wait
smon timer
Streams AQ: waiting for time management or
cleanup tasks
pmon timer
ges remote message
PX Idle Wait
ASM background timer
Streams AQ: qmn coordinator idle wait
dispatcher timer
shared server idle wait
SQL*Net message from client
KSV master wait
PX Deq: Join ACK
PX Deq: Parse Reply
Wait Event Histogram
Units for Total Waits column: K is 1000, M is 1000000, G is
% 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
ASM file metadata operation
CGS wait for IPC msg
CSS group membership query
CSS initialization
CSS operation: action
CSS operation: data query
CSS operation: query
DFS lock handle
Disk file operations I/O
IPC send completion sync
KJC: Wait for msg sends to complete
LGWR wait for redo copy
PX Deq: Signal ACK EXT
PX Deq: Signal ACK RSG
PX Deq: Slave Session Stats
PX Deq: reap credit
SQL*Net message from dblink
SQL*Net message to client
SQL*Net message to dblink
SQL*Net more data to client
Streams AQ: qmn coordinator waiting for slave to
asynch descriptor resize
buffer busy waits
buffer deadlock
control file parallel write
control file sequential read
cursor: mutex X
cursor: pin S wait on X
db file async I/O submit
db file parallel write
db file sequential read
direct path write
enq: CF - contention
enq: CO - master slave det
enq: CR - block range reuse ckpt
enq: DR - contention
enq: FB - contention
enq: HW - contention
enq: JQ - contention
enq: JS - job run lock - synchronize
enq: MW - contention
enq: PS - contention
enq: TA - contention
enq: TD - KTF dump entries
enq: TK - Auto Task Serialization
enq: TM - contention
enq: TS - contention
enq: TX - allocate ITL entry
enq: TX - contention
enq: TX - index contention
enq: US - contention
enq: WF - contention
gc buffer busy acquire
gc buffer busy release
gc cr block 2-way
gc cr block busy
gc cr block congested
gc cr grant 2-way
gc cr multi block request
gc current block 2-way
gc current block busy
gc current block congested
gc current grant 2-way
gc current grant busy
gc current grant congested
gc current multi block request
gc current retry
gc current split
gcs log flush sync
global enqueue expand wait
ksxr poll remote instances
latch free
latch: active service list
latch: cache buffers chains
latch: call allocation
latch: enqueue hash chains
latch: gc element
latch: ges resource hash list
latch: row cache objects
latch: shared pool
libcache interrupt action by LCK
library cache lock
library cache pin
library cache: mutex X
lock deadlock retry
lock escalate retry
log file parallel write
log file sync
os thread startup
rdbms ipc reply
read by other session
reliable message
row cache cleanup
row cache lock
row cache process
wait list latch free
ASM background timer
DIAG idle wait
KSV master wait
PX Deq: Execute Reply
PX Deq: Execution Msg
PX Deq: Join ACK
PX Deq: Parse Reply
PX Idle Wait
SQL*Net message from client
Space Manager: slave idle wait
Streams AQ: RAC qmn coordinator idle wait
Streams AQ: qmn coordinator idle wait
Streams AQ: qmn slave idle wait
Streams AQ: waiting for time management or
cleanup tasks
class slave wait
dispatcher timer
gcs remote message
ges remote message
jobq slave wait
pmon timer
rdbms ipc message
shared server idle wait
smon timer
wait for unread message on broadcast channel
Wait Event Histogram Detail (64 msec to 2 sec)
Units for Total Waits column: K is 1000, M is 1000000, G is
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
% 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
ASM file metadata operation
CSS initialization
buffer busy waits
enq: TX - allocate ITL entry
enq: TX - index contention
enq: WF - contention
gc buffer busy acquire
gc buffer busy release
gc current block busy
gc current grant busy
gc current split
log file parallel write
os thread startup
reliable message
Wait Event Histogram Detail (4 sec to 2 min)
Units for Total Waits column: K is 1000, M is 1000000, G is
Units for % of Total Waits: s is 1024 milliseconds
(approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds
or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including
% 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 4s to 2m&2s&4s&8s&16s&32s& 1m& 2m&=2m
Streams AQ: qmn coordinator waiting for slave to
enq: TX - allocate ITL entry
Wait Event Histogram Detail (4 min to 1 hr)
No data exists for this section of the report.
Service Statistics& 多个应用使用不同的service
ordered by DB Time
Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$BACKGROUND
Service Wait Class Stats
每个service在各个wait class上的等待情况
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
SYS$BACKGROUND
SQL Statistics
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 1.0% of Total DB Time (s): 3,971
Captured PL/SQL account for 0.0% of Total DB Time (s): 3,971
Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IOSQL IdSQL ModuleSQL Text
JDBC Thin Client
INSERT INTO S_WKST_ORG_EXT (AP...
PL/SQL Developer
select dbms_workload_reposito...
JDBC Thin Client
update S_ATTACH_INFO set APP_N...
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
update S_95598_WKST set HANDLE...
PL/SQL Developer
select value from v$sesstat wh...
JDBC Thin Client
select t2.* from (select t1.*,...
PL/SQL Developer
select t.app_no, t.handle_stat...
JDBC Thin Client
update S_COMM_REC set HANDLE_I...
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 24.8% of Total CPU Time (s): 25
Captured PL/SQL account for 0.1% of Total CPU Time (s): 25
CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
JDBC Thin Client
INSERT INTO S_WKST_ORG_EXT (AP...
PL/SQL Developer
select dbms_workload_reposito...
JDBC Thin Client
update S_ATTACH_INFO set APP_N...
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
select * from (select t.org_no...
PL/SQL Developer
select value from v$sesstat wh...
JDBC Thin Client
update S_95598_WKST set HANDLE...
insert into wrh$_system_event ...
insert into wrh$_bg_event_summ...
JDBC Thin Client
SELECT 1 FROM DUAL
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
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 27.9% of Total User I/O Wait Time (s):
Captured PL/SQL account for 0.0% of Total User I/O Wait Time
User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
JDBC Thin Client
insert into sys.aud$( sessioni...
PL/SQL Developer
select dbms_workload_reposito...
select q_name, state, delay, e...
JDBC Thin Client
INSERT INTO S_WKST_ORG_EXT (AP...
select us#, status$, user#, ts...
select count(*) from undo$
JDBC Thin Client
SELECT ORG_NO, CALL_DEPT, SUM(...
INSERT /*+ APPEND LEADING(@"SE...
JDBC Thin Client
update S_95598_WKST set HANDLE...
select /*+ rule */ name, file#...
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: 1,463,934
Captured SQL account for 21.0% of Total
Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
JDBC Thin Client
INSERT INTO S_WKST_ORG_EXT (AP...
JDBC Thin Client
update S_ATTACH_INFO set APP_N...
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
select * from (select t.org_no...
select us#, status$, user#, ts...
PL/SQL Developer
select t.app_no, t.handle_stat...
JDBC Thin Client
update S_95598_WKST set HANDLE...
JDBC Thin Client
update S_ATTACH_INFO set HANDL...
PL/SQL Developer
select dbms_workload_reposito...
JDBC Thin Client
begin pkg_bs_ywjk_job.p_stat_s...
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: 4
Captured SQL account for 50.0% of Total
Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
select q_name, state, delay, e...
PL/SQL Developer
select dbms_workload_reposito...
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
select S_95598_WKST_RELA.RELA_...
select privilege# from sysauth...
update seg$ set type#=:4, bloc...
insert into sys.col_usage$ (ob...
select SYS_CONTEXT('USERENV', ...
delete from dependency$ where ...
JDBC Thin Client
select app_no, seat_emp_no, em...
SQL ordered by Physical Reads (UnOptimized)
UnOptimized Read Reqs = Physical Read Reqts - Optimized Read
%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: 4
Captured SQL account for 8.6E+03% of Total
Total UnOptimized Read Requests: 4
Captured SQL account for 8.6E+03% 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
PL/SQL Developer
select dbms_workload_reposito...
select q_name, state, delay, e...
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
select S_95598_WKST_RELA.RELA_...
select privilege# from sysauth...
update seg$ set type#=:4, bloc...
insert into sys.col_usage$ (ob...
select SYS_CONTEXT('USERENV', ...
delete from dependency$ where ...
JDBC Thin Client
select app_no, seat_emp_no, em...
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: 50,972
Captured SQL account for 67.0% of Total
Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
JDBC Thin Client
INSERT INTO S_WKST_ORG_EXT (AP...
JDBC Thin Client
update S_ATTACH_INFO set APP_N...
JDBC Thin Client
SELECT 1 FROM DUAL
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
update S_COMM_REC set HANDLE_I...
JDBC Thin Client
update S_ATTACH_INFO set HANDL...
select file# from file$ where ...
JDBC Thin Client
select app_no, seat_emp_no, em...
select /*+ connect_by_filterin...
SQL ordered by Parse Calls
Total Parse Calls: 4,508
Captured SQL account for 67.9% of Total
Parse CallsExecutions % Total ParsesSQL IdSQL ModuleSQL Text
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
select * from (select t.org_no...
JDBC Thin Client
update S_ATTACH_INFO set APP_N...
JDBC Thin Client
INSERT INTO S_WKST_ORG_EXT (AP...
JDBC Thin Client
update S_ATTACH_INFO set HANDL...
JDBC Thin Client
update S_COMM_REC set HANDLE_I...
select file# from file$ where ...
select privilege# from sysauth...
select /*+ connect_by_filterin...
select SYS_CONTEXT('USERENV', ...
select value$ from props$ wher...
JDBC Thin Client
insert into sys.aud$( sessioni...
select decode(failover_method,...
JDBC Thin Client
SELECT 1 FROM DUAL
update seg$ set type#=:4, bloc...
select us# from undo$ where st...
select /*+ rule */ name, file#...
select type#, blocks, extents,...
select us#, status$, user#, ts...
update undo$ set name=:2, file...
select count(*) from undo$
SQL ordered by Sharable Memory
Only Statements with Sharable Memory greater than 1048576 are
Sharable Mem (b)Executions % TotalSQL IdSQL ModuleSQL Text
select OBJOID, CLSOID, RUNTIME...
SELECT OBJOID, CLSOID, DECODE(...
SQL ordered by Version Count
No data exists for this section of the report.
SQL ordered by Cluster Wait Time
%Total - Cluster Time as a percentage of Total Cluster Wait Time
%Clu - Cluster Time as a percentage of Elapsed Time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Only SQL with Cluster Wait Time & .005 seconds is reported
Total Cluster Wait Time (s): 214
Captured SQL account for 7.9% of Total
Cluster Wait Time (s)Executions%TotalElapsed Time(s)%Clu%CPU%IOSQL IdSQL ModuleSQL Text
JDBC Thin Client
INSERT INTO S_WKST_ORG_EXT (AP...
JDBC Thin Client
update S_95598_WKST set HANDLE...
JDBC Thin Client
select t2.* from (select t1.*,...
JDBC Thin Client
select count(1) record_count f...
PL/SQL Developer
select t.app_no, t.handle_stat...
JDBC Thin Client
select S_95598_WKST.app_no app...
PL/SQL Developer
select dbms_workload_reposito...
JDBC Thin Client
insert into sys.aud$( sessioni...
JDBC Thin Client
SELECT CALL_DEPT, ORG_NO, '01'...
JDBC Thin Client
begin pkg_bs_ywjk_job.p_stat_s...
select /*+ rule */ name, file#...
JDBC Thin Client
SELECT ORG_NO, CALL_DEPT, SUM(...
select us#, status$, user#, ts...
JDBC Thin Client
select S_SRV_REQ.ID id, S_SRV_...
update seg$ set type#=:4, bloc...
select job, nvl2(last_date, 1,...
insert into wrh$_sysstat (snap...
insert into wrh$_bg_event_summ...
Complete List of SQL Text
SQL IdSQL Text
0b2fbsrvnaspd
select * from (select t.org_no,
to_char(to_date(t.release_date, 'yyyymmdd'), 'yyyy-mm-dd') as
release_date, to_char(t.valid_date, 'yyyy-mm-dd') valid_date, t.content
from s_issue_info t, s_assiinfo_org_ext e where t.pub_id= e.info_id and
t.org_no = e.org_no and t.release_status = '04' and t.release_mode = '09'
and t.valid_flag = '1' and t.valid_date &= sysdate and e.callcenter_no
= :1 order by t.valid_date nulls last, t.release_date nulls last) where
rownum & :2
0d268wm5u3g4z
select S_95598_WKST_RELA.RELA_ID,
S_95598_WKST_RELA.APP_NO, S_95598_WKST_RELA.RELA_APP_NO,
S_95598_WKST_RELA.RELA_TYPE, S_95598_WKST_RELA.RELA_REMARK from
S_95598_WKST_RELA where app_no = :1
0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or
grantee#=1) and privilege#&0
0kkhhb2w93cx0
update seg$ set type#=:4, blocks=:5, extents=:6,
minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12,
lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14),
cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17),
scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and
0sfgqjz5cs52w
select q_name, state, delay, expiration, rowid, msgid,
dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corrid,
time_manager_info, sender_name, sender_address, sender_protocol from
"SYS"."ALERT_QT" where msgid = :1
0v3dvmc22qnam
insert into sys.col_usage$ (obj#, intcol#, equality_preds,
equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds,
timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1),
decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1),
decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1),
decode(bitand(:flag, 32), 0, 0, 1), :time)
0ws7ahf1d78qa
select SYS_CONTEXT('USERENV', 'SERVER_HOST'),
SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV',
'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER,
STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where
INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1gfaj4z5hn1kf
delete from dependency$ where d_obj#=:1
1k3umkr2qg266
select app_no, seat_emp_no, emp_schema_id, seat_job_no,
base_name, service_star, cust_service_dept from s_seat_emp_info where
seat_emp_no = :1
2a6ynwxuu6bxy
select dbms_workload_repository.create_snapshot() from
3nz260v5dwqnv
select value from v$sesstat where sid = :sid order by
statistic#
459f3z9u4fb3u
select value$ from props$ where name =
'GLOBAL_DB_NAME'
46dkb8cmt2r05
update S_ATTACH_INFO set HANDLE_ID = :1 where REQ_NO = :2
4dy1xm4nxc0gf
insert into wrh$_system_event (snap_id, dbid,
instance_number, event_id, total_waits, total_timeouts, time_waited_micro,
total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id,
:dbid, :instance_number, event_id, total_waits, total_timeouts,
time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg
from v$system_event order by event_id
4vs91dcv7u1p6
insert into sys.aud$( sessionid, entryid, statement,
ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator,
obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions,
ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1,
spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#,
process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid)
values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9,
:10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24,
:25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
4xu4fszrw4d9g
update S_ATTACH_INFO set APP_NO = :1 , ORG_NO = :2 where
REQ_NO = :3
4yfm49pfr4bwy
SELECT ORG_NO, CALL_DEPT, SUM(ACCETP_NUM) ACCETP_NUM,
SUM(SEND_NUM) SEND_NUM, SUM(DISPENSE_NUM) DISPENSE_NUM, SUM(DEAL_NUM)
DEAL_NUM, SUM(CALLBACK_NUM) CALLBACK_NUM FROM (SELECT SUBSTR(A.ORG_NO, 1,
5) ORG_NO, E.CUST_SERVICE_DEPT CALL_DEPT, COUNT(A.APP_NO) ACCETP_NUM,
SUM(CASE WHEN A.SEND_DATE IS NOT NULL THEN 1 ELSE 0 END) SEND_NUM, 0
DISPENSE_NUM, 0 DEAL_NUM, 0 CALLBACK_NUM FROM S_95598_WKST A,
S_SEAT_EMP_INFO E WHERE A.HANDLE_TIME &= TRUNC(SYSDATE) AND
A.HANDLE_TIME &= SYSDATE AND A.HANDLE_STATUS_CODE != '缁堟?' AND A.EMP_NO
= E.SEAT_EMP_NO GROUP BY SUBSTR(A.ORG_NO, 1, 5), E.CUST_SERVICE_DEPT UNION
ALL SELECT B.ORG_NO, B.CALL_DEPT, 0 ACCETP_NUM, 0 SEND_NUM, SUM(CASE WHEN
B.ACT_TYPE = '001' THEN 1 ELSE 0 END) DISPENSE_NUM, SUM(CASE WHEN
B.ACT_TYPE = '002' THEN 1 ELSE 0 END) DEAL_NUM, SUM(CASE WHEN B.ACT_TYPE =
'003' THEN 1 ELSE 0 END) CALLBACK_NUM FROM SY_REP_S_MO_S_WKLIST_RELA B
GROUP BY B.ORG_NO, B.CALL_DEPT) GROUP BY ORG_NO, CALL_DEPT
select S_SRV_REQ.ID id, S_SRV_REQ.ATTACH_ID attachId,
S_SRV_REQ.SRV_MODE srvMode, S_SRV_REQ.BUSI_TYPE_CODE busiTypeCode,
S_SRV_REQ.CUST_NO custNo, S_SRV_REQ.CALLING_NO callingNo,
to_char(S_SRV_REQ.REQ_DATE, 'yyyy-mm-dd hh24:mi:ss') as reqDate,
S_SRV_REQ.SRV_CONTENT srvContent, S_SRV_REQ.SRV_NO srvNo,
to_char(S_SRV_REQ.REQ_FINISH_DATE, 'yyyy-mm-dd hh24:mi:ss') as
reqFinishDate , S_SRV_REQ.CUST_NAME custName,
S_SRV_REQ.IMPORTANT_CUST_LEVEL importantCustLevel, S_SRV_REQ.CONTACT_NAME
contactName, S_SRV_REQ.TEL tel, S_SRV_REQ.TEL2 tel2,
S_SRV_REQ.CONTACT_ADDR contactAddr, S_SRV_REQ.ORG_NO orgNo,
S_SRV_REQ.S_A_ATTACH_ID sAAttactId, S_SRV_REQ.CALLID callId from S_SRV_REQ
where S_SRV_REQ.ID = :1
586b2udq6dbng
insert into wrh$_sysstat (snap_id, dbid, instance_number,
stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value
from v$sysstat order by stat_id
5ag28m6ruw3g7
select * from (select t.org_no, to_char(t.start_time,
'yyyy-mm-dd HH24:mi:ss') as startTime, to_char(t.end_time, 'yyyy-mm-dd
HH24:mi:ss') as endTime, t.announce_subject, t.ns_sub_type, t.ns_content
from s_info_announce t, s_assiinfo_org_ext e where t.ns_no = e.info_id and
t.org_no = e.org_no and ((t.end_time &= trunc(sysdate) and t.end_time
&= trunc(sysdate + :1 + 1)) or ((t.start_time & trunc(sysdate + :2 +
1)) and t.end_time &= trunc(sysdate + :3 + 1))) and e.callcenter_no =
:4 order by t.end_time nulls last) where rownum & :5
5ansr7r9htpq3
update undo$ set name=:2, file#=:3, block#=:4, status$=:5,
user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11,
ts#=:12, spare1=:13 where us#=:1
5ms6rbzdnq16t
select job, nvl2(last_date, 1, 0) from sys.job$ where
(((:1 &= next_date) and (next_date &= :2)) or ((last_date is null)
and (next_date & :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5))
and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job
& ) or (dbms_logstdby.db_is_logstdby = 1 and job &=
)) order by next_date, job
5ur69atw3vfhj
select decode(failover_method, NULL, 0 , 'BASIC', 1,
'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 ,
'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries,
failover_delay, flags from service$ where name = :1
6txz8hh5s94kr
select count(1) record_count from (select t1.APP_NO,
t1.BUSI_TYPE_CODE, t1.HANDLE_STATUS_CODE, t1.EMP_NO,
to_char(t1.HANDLE_TIME, 'yyyy-MM-dd hh24:mi') handleTime,
t1.ACCEPT_CONTENT, t1.CALLING_NO from S_95598_WKST t1, S_WKST_ORG_EXT t2
where t1.HANDLE_STATUS_CODE = '涓氬姟鍙楃悊' and t1.APP_NO = t2.APP_NO and
t1.ORG_NO = t2.ORG_NO AND t1.busi_type_code in (:1 , :2 , :3 , :4 , :5 ,
:6 , :7 )and t2.CALLCENTER_NO = :8 order by HANDLE_TIME desc)
7am4w4pp3nwtm
select count(*) from undo$
7bd391hat42zk
select /*+ rule */ name, file#, block#, status$, user#,
undosqn, xactsqn, scnbas, scnwrp, DECODE(inst#, 0, NULL, inst#), ts#,
spare1 from undo$ where us#=:1
84k66tf2s7y1c
insert into wrh$_bg_event_summary (snap_id, dbid,
instance_number, event_id, total_waits, total_timeouts, time_waited_micro)
select :snap_id, :dbid, :instance_number, event_id, total_waits -
total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro -
time_waited_micro_fg from v$system_event where (total_waits -
total_waits_fg) & 0 order by event_id
9dhn1b8d88dpf
select 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,
= 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, ) && 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, ), 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,
), 0, q.schedule_limit, decode(pj.schedule_limit, NULL,
q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, ),
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, ), 0, sl.program_oid,
spj.program_oid) program_oid, decode(bitand(sl.flags, ), 0,
NULL, spj.priority) priority, decode(bitand(sl.flags, ), 0,
NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, ), 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.obj# 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,
= 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,
) && 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.owner# = 0 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.owner# = 0 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
9dngn8muk6pzv
select S_95598_WKST.app_no appNo, S_95598_WKST.id id,
S_95598_WKST.busi_type_code busiTypeCode, S_95598_WKST.busi_sub_type
busiSubType, S_95598_WKST.city_code cityCode, S_95598_WKST.county_code
countyCode, S_95598_WKST.urban_rural_flag urbanRuralFlag,
S_95598_WKST.org_no orgNo, S_95598_WKST.emp_no empNo, S_95598_WKST.g_ps_no
gpsNo, to_char(S_95598_WKST.handle_time, 'yyyy-mm-dd hh24:mi:ss') as
handleTime, S_95598_WKST.accept_mode acceptMode, S_95598_WKST.target_dept
targetDept, S_95598_WKST.record_no recordNo, S_95598_WKST.accept_content
acceptContent, S_95598_WKST.handle_opinion handleOpinion,
to_char(S_95598_WKST.over_time, 'yyyy-mm-dd hh24:mi:ss') as overTime,
S_95598_WKST.reply_flag replyFlag, S_95598_WKST.reply_date replyDate,
S_95598_WKST.reply_mode replyMode, S_95598_WKST.reply_content
replyContent, S_95598_WKST.cons_opinion consOpinion,
S_95598_WKST.reply_tel replyTel, to_char(S_95598_WKST.send_date,
'yyyy-mm-dd hh24:mi:ss') as sendDate, S_95598_WKST.iden_mode idenMode,
S_95598_WKST.cert_type_code certTypeCode, S_95598_WKST.cert_no certNo,
S_95598_WKST.handle_status_code handleStatusCode,
S_95598_WKST.retvisit_flag retvisitFlag, S_95598_WKST.important_cust_level
importantCustLevel, S_95598_WKST.contact_name contactName,
S_95598_WKST.tel tel, S_95598_WKST.tel2 tel2, S_95598_WKST.contact_addr
contactAddr, S_95598_WKST.cust_name custName, S_95598_WKST.cust_no custNo,
S_95598_WKST.app_knwlg_no appKnwlgNo, S_95598_WKST.area area,
S_95598_WKST.elec_addr elecAddr, S_95598_WKST.app_reject_flag
appRejectFlag, S_95598_WKST.remark remark, S_95598_WKST.CALLING_NO
callingNo, to_char(S_95598_WKST.WARN_TIME, 'yyyy-mm-dd hh24:mi:ss') as
warnTime, to_char(S_95598_WKST.ARC_TIME, 'yyyy-mm-dd hh24:mi:ss') as
arcTime, S_95598_WKST.SPOT_CHECK_FLAG spotCheckFlag, S_SRV_REQ.ATTACH_ID
attachId, S_SRV_REQ.SRV_MODE srvMode, to_char(S_SRV_REQ.REQ_DATE,
'yyyy-mm-dd hh24:mi:ss') as reqDate, S_SRV_REQ.SRV_CONTENT srvContent,
S_SRV_REQ.SRV_NO srvNo, to_char(S_SRV_REQ.REQ_FINISH_DATE, 'yyyy-mm-dd
hh24:mi:ss') as reqFinishDate , S_SRV_REQ.S_A_ATTACH_ID saAttactId,
S_SRV_REQ.CALLID callId, S_MAP_AREA.MAP_AREA_SITE from S_95598_WKST,
S_SRV_REQ, S_MAP_AREA where S_95598_WKST.id = S_SRV_REQ.id(+) and
S_95598_WKST.APP_NO = S_MAP_AREA.APP_NO(+) and S_95598_WKST.app_no = :1
9g29q8zwxdc86
INSERT INTO S_WKST_ORG_EXT (APP_NO, ORG_NO, CALLCENTER_NO,
PROV_ORG_NO, CITY_ORG_NO, COUN_ORG_NO) VALUES (:1 , :2 , :3 , :4 , :5 , :6
9tgj4g8y4rwy8
select type#, blocks, extents, minexts, maxexts, extsize,
extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint,
hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$
where ts#=:1 and file#=:2 and block#=:3
a7pj5gstgxpkr
select us#, status$, user#, ts#, spare1 from undo$ where
ts# = :1 order by us# desc
ap9qj4w3z2br9
select us# from undo$ where status$ = :1 and xactsqn &
:2 order by us# desc
aqfygsn9zu3ga
SELECT CALL_DEPT, ORG_NO, '01' CODE, TOTAL_NUM, LOSE_NUM,
DECODE(TOTAL_NUM, 0, 0, (TOTAL_NUM - LOSE_NUM) / TOTAL_NUM) RATIONS,
AVE_DEAL_TIME FROM (SELECT SUBSTR(A.ORG_NO, 1, 5) ORG_NO,
E.CUST_SERVICE_DEPT CALL_DEPT, COUNT(1) TOTAL_NUM, COUNT(CASE WHEN
PKG_BS_RPT_BUSI.ISTIMELYARRIVE(A.APP_NO) & 0 THEN A.APP_NO END)
LOSE_NUM, SUM((C.ARRIVAL_TIME - NVL(D.REQ_FINISH_DATE, A.HANDLE_TIME)) *
1440) AVE_DEAL_TIME FROM S_95598_WKST A, S_FAULT_HANDLE C, S_SRV_REQ D,
S_SEAT_EMP_INFO E WHERE A.APP_NO = C.APP_NO AND A.ID = D.ID AND A.EMP_NO =
E.SEAT_EMP_NO AND A.HANDLE_TIME &= TRUNC(SYSDATE) AND A.HANDLE_TIME
&= SYSDATE AND A.BUSI_TYPE_CODE = :B1 AND A.ARC_TIME IS NOT NULL AND
A.HANDLE_STATUS_CODE != '缁堟?' AND C.ARRIVAL_TIME IS NOT NULL AND NOT
EXISTS (SELECT 1 FROM S_95598_WKST_RELA R WHERE R.APP_NO = A.APP_NO) GROUP
BY SUBSTR(A.ORG_NO, 1, 5), E.CUST_SERVICE_DEPT) UNION ALL SELECT
CALL_DEPT, ORG_NO, '02' CODE, TOTAL_NUM, LOSE_NUM, DECODE(TOTAL_NUM, 0, 0,
(TOTAL_NUM - LOSE_NUM) / TOTAL_NUM) RATIONS, AVE_DEAL_TIME FROM (SELECT
SUBSTR(A.ORG_NO, 1, 5) ORG_NO, E.CUST_SERVICE_DEPT CALL_DEPT,
COUNT(A.APP_NO) TOTAL_NUM, COUNT(CASE WHEN B.WKST_NO IS NULL THEN 1 ELSE 0
END) LOSE_NUM, SUM(NVL((B.RETVISIT_TIME - A.HANDLE_TIME) * 1440, 0))
AVE_DEAL_TIME FROM S_95598_WKST A, S_RETVISIT B, S_SEAT_EMP_INFO E WHERE
A.APP_NO = B.WKST_NO(+) AND A.EMP_NO = E.SEAT_EMP_NO AND A.BUSI_TYPE_CODE
= :B4 AND B.RETVISIT_STATE(+) = '04' AND A.HANDLE_STATUS_CODE != '缁堟?' AND
A.HANDLE_TIME &= :B3 AND A.HANDLE_TIME & :B2 GROUP BY
SUBSTR(A.ORG_NO, 1, 5), E.CUST_SERVICE_DEPT)
b4qw7n9wg64mh
INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2"
"A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO
WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id,
sample_time , session_id, session_serial#, session_type , flags , user_id
, sql_id, sql_child_number, sql_opcode, force_matching_signature ,
top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value,
sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id,
sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id ,
plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id,
qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time,
time_waited , blocking_session, blocking_session_serial#, blocking_inst_id
, current_obj#, current_file#, current_block#, current_row# ,
top_level_call#, consumer_group_id, xid, remote_instance#, time_model ,
service_hash, program, module, action, client_id, machine, port, ecid ,
dbreplay_file_id, dbreplay_call_counter , tm_delta_time,
tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests,
delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes,
delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT
/*+ PARAM('_module_action_old_length', 0) */:snap_id, :dbid,
:instance_number, a.sample_id, a.sample_time , a.session_id,
a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL),
a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode,
a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode ,
a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#,
a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start ,
a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id,
a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id,
a.qc_session_serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 ,
a.wait_time, a.time_waited , a.blocking_session,
a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#,
a.current_file#, a.current_block#, a.current_row# , a.top_level_call#,
a.consumer_group_id, a.xid, a.remote_instance# , a.time_model ,
a.service_hash , substrb(a.program, 1, 64) , a.module, a.action,
a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id,
a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null),
a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null),
a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null),
a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null),
a.delta_time), decode(a.delta_time, 0, to_number(null),
decode(a.delta_read_io_requests, 0, to_number(null),
a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null),
decode(a.delta_write_io_requests, 0, to_number(null),
a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null),
decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)),
decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0,
to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0,
to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null),
a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0,
to_number(null), a.pga_allocated), decode(a.pga_allocated, 0,
to_number(null), decode(a.temp_space_allocated, 0, to_number(null),
a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id
FROM x$kewash h WHERE ( (h.sample_id &= :begin_flushing) and
(h.sample_id & :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr
WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id
and a.need_awr_sample = 'Y')
bkkg0bf0whuk8
update S_95598_WKST set HANDLE_STATUS_CODE = :1 where
APP_NO = :2 or exists (select 1 from S_95598_WKST_RELA b where
b.APP_NO=S_95598_WKST.APP_NO and b.RELA_APP_NO = :3 and b.RELA_TYPE like
bn4b3vjw2mj3u
SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0,
RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST,
:1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM
( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME,
a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE,
a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags,
4194304), 4194304, b.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, a.instance_id
INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v
, v$instance i where a.program_oid = b.obj#(+) 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, )
&& 0 ) union all select c.obj#, c.class_oid, c.next_run_date,
c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags,
), 0, d.priority, pj.priority), decode(bitand(c.flags,
), 0, d.schedule_limit, decode(pj.schedule_limit, NULL,
d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, ),
0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0,
c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW,
decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id
INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d,
(select sl.obj# obj#, decode(bitand(sl.flags, ), 0,
sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags,
), 0, NULL, spj.priority) priority, decode(bitand(sl.flags,
), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags,
), 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# = c.obj# and pj.program_oid
= d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, )
&& 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS,
515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS,
) = 0) OR (BITAND(STATUS, 1024) && 0)) AND BITAND(FLAGS,
4096) = 0 AND (RUNTIME &= :4 OR BITAND(FLAGS, 16384) && 0) and
((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from
sys.scheduler$_class e where bitand(e.flags, :5) && 0 and
lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7))
ORDER BY 3, 2, 4, 7 DESC, 1
bsa0wjtftg3uw
select file# from file$ where ts#=:1
bunvx480ynf57
SELECT 1 FROM DUAL
c94wbx67mf16d
select t.app_no, t.handle_status_code from bs.s_95598_wkst
t order by app_no desc
cjumg88sux8mx
update S_COMM_REC set HANDLE_ID = :1 where APP_NO = :2 and
HANDLE_ID is null
cm5vu20fhtnq1
select /*+ connect_by_filtering */ privilege#, level from
sysauth$ connect by grantee#=prior privilege# and privilege#&0 start
with grantee#=:1 and privilege#&0
fjqvabzqgh6cs
select t2.* from (select t1.*, rownum rownumber from
(select t1.APP_NO, t1.BUSI_TYPE_CODE, t1.HANDLE_STATUS_CODE, t1.EMP_NO,
to_char(t1.HANDLE_TIME, 'yyyy-MM-dd hh24:mi') handleTime,
t1.ACCEPT_CONTENT, t1.CALLING_NO from S_95598_WKST t1, S_WKST_ORG_EXT t2
where t1.HANDLE_STATUS_CODE = '涓氬姟鍙楃悊' and t1.APP_NO = t2.APP_NO and
t1.ORG_NO = t2.ORG_NO AND t1.busi_type_code in (:1 , :2 , :3 , :4 , :5 ,
:6 , :7 )and t2.CALLCENTER_NO = :8 order by HANDLE_TIME desc) t1 where
rownum &= :9 ) t2 where t2.rownumber &= :10
gnz4gwht3wvu8
begin pkg_bs_ywjk_job.p_stat_serprominese_job(:1 , :2 );
Instance Activity Statistics
Instance Activity Stats 前期不要关注这部分
Ordered by statistic name
StatisticTotalper Secondper Trans
Batched IO (bound) vector count
Batched IO (full) vector count
Batched IO block miss count
Batched IO buffer defrag count
Batched IO double miss count
Batched IO same unit count
Batched IO single block count
Batched IO slow jump count
Batched IO vector block count
Batched IO vector read count
Block Cleanout Optim referenced
CCursor + sql area evicted
CPU used by this session
CPU used when call started
CR blocks created
Cached Commit SCN referenced
Clusterwide global transactions
Commit SCN cached
DBWR checkpoint buffers written
DBWR checkpoints
DBWR fusion writes
DBWR object drop buffers written
DBWR tablespace checkpoint buffers written
DBWR transaction table writes
DBWR undo block writes
DFO trees parallelized
DX/BB enqueue lock background get time
DX/BB enqueue lock background gets
DX/BB enqueue lock foreground requests
DX/BB enqueue lock foreground wait time
Effective IO time
GTX processes spawned by autotune
GTX processes stopped by autotune
HSC Heap Segment Block Changes
Heap Segment Array Inserts
Heap Segment Array Updates
LOB table id lookup cache misses
Number of read IOs issued
PX local messages recv'd
PX local messages sent
PX remote messages recv'd
PX remote messages sent
Parallel operations not downgraded
Requests to/from client
RowCR attempts
RowCR hits
SMON posted for undo segment shrink
SQL*Net roundtrips to/from client
SQL*Net roundtrips to/from dblink
active txn count during cleanout
application wait time
background timeouts
branch node splits
buffer is not pinned count
buffer is pinned count
bytes received via SQL*Net from client
31,199,515
bytes received via SQL*Net from dblink
bytes sent via SQL*Net to client
bytes sent via SQL*Net to dblink
calls to get snapshot scn: kcmgss
calls to kcmgas
calls to kcmgcs
cell physical IO interconnect bytes
164,509,696
158,567.69
change write time
cleanout - number of ktugct calls
cleanouts and rollbacks - consistent read gets
cleanouts only - consistent read gets
cluster key scan block gets
cluster key scans
cluster wait time
commit batch performed
commit batch requested
commit batch/immediate performed
commit batch/immediate requested
commit cleanout failures: block lost
commit cleanout failures: callback failure
commit cleanout failures: cannot pin
commit cleanouts
commit cleanouts successfully completed
commit immediate performed
commit immediate requested
commit txn count during cleanout
concurrency wait time
consistent changes
consistent gets
consistent gets - examination
consistent gets direct
consistent gets from cache
consistent gets from cache (fastpath)
cursor authentications
data blocks consistent reads - undo records
db block changes
db block gets
db block gets direct
db block gets from cache
db block gets from cache (fastpath)
deferred (CURRENT) block cleanout
applications
enqueue conversions
enqueue releases
enqueue requests
enqueue timeouts
enqueue waits
exchange deadlocks
execute count
failed probes on index block reclamation
file io wait time
free buffer inspected
free buffer requested
gc blocks compressed
gc cr block flush time
gc cr block receive time
gc cr blocks received
gc cr blocks served
gc current block flush time
gc current block pin time
gc current block receive time
gc current blocks received
gc current blocks served
gc kbytes saved
gc kbytes sent
gc local grants
gc read waits
gc remote grants
gcs messages sent
ges messages sent
global enqueue get time
global enqueue gets async
global enqueue gets sync
global enqueue releases
heap block compress
immediate (CR) block cleanout applications
immediate (CURRENT) block cleanout
applications
in call idle wait time
index crx upgrade (positioned)
index crx upgrade (prefetch)
index fast full scans (full)& (全索引扫描)
index fetch by key
index scans kdiixs1
leaf node 90-10 splits
leaf node splits
lob writes
lob writes unaligned
logical read bytes from cache
11,955,085,312
11,523,273.68
1,687,379.72
logons cumulative
max cf enq hold time
messages received
messages sent
min active SCN optimization applied on CR
no work - consistent read gets
non-idle wait count
non-idle wait time
opened cursors cumulative
parse count (describe)
parse count (failures)
parse count (hard)
parse count (total)
parse time cpu
parse time elapsed
physical read IO requests
physical read bytes
physical read total IO requests
physical read total bytes
52,264,960
physical read total multi block requests
physical reads
physical reads cache
physical reads cache prefetch
physical reads direct
physical reads direct (lob)
physical reads direct temporary tablespace
physical reads prefetch warmup
physical write IO requests
physical write bytes
62,709,760
physical write total IO requests
physical write total bytes
112,244,736
108,190.51
physical write total multi block requests
physical writes
physical writes direct
physical writes direct (lob)
physical writes direct temporary tablespace
physical writes from cache
physical writes non checkpoint
pinned buffers inspected
pinned cursors current
process last non-idle time
queries parallelized
recursive calls
recursive cpu usage
redo blocks checksummed by FG (exclusive)
redo blocks written
redo entries
redo ordering marks
37,403,464
redo size for direct writes
redo subscn max counts
redo synch time
redo synch time (usec)
redo synch writes
redo wastage
redo write broadcast ack count
redo write broadcast ack time
redo write time
redo writes
remote Oradebug requests
rollback changes - undo records applied
rollbacks only - consistent read gets
root node splits
rows fetched via callback
session connect time
session cursor cache hits
session logical reads
shared hash latch upgrades - no wait
shared hash latch upgrades - wait
sorts (memory)
sorts (rows)
sql area evicted
sql area purged
switch current to new buffer
table fetch by rowid
table fetch continued row(行迁移次数，最好小于200次/s)
table scan blocks gotten
table scan rows gotten
table scans (direct read)
table scans (long tables)& (全表扫描)
table scans (rowid ranges)
table scans (short tables)
temp space allocated (bytes)
total cf enq hold time
total number of cf enq holders
total number of times SMON posted
transaction lock background get time
transaction lock background gets
transaction lock foreground requests
transaction lock foreground wait time
transaction rollbacks
undo change vector size
10,545,948
user I/O wait time
user calls
user commits
user rollbacks
workarea executions - onepass
workarea executions - optimal
write clones created in foreground
Instance Activity Stats - Absolute Values
Statistics with absolute values (should not be diffed)
StatisticBegin ValueEnd Value
session pga memory max
3,322,111,304
3,526,161,816
session cursor cache count所有会话缓存过cursor的数量
session uga memory
1,808,815,188,312
1,821,747,747,488
opened cursors current
workarea memory allocated
logons current
session uga memory max
3,845,153,024
3,915,268,736
session pga memory
2,730,749,480
2,922,332,024
Instance Activity Stats - Thread Activity
Statistics identified by '(derived)' come from sources other
than SYSSTAT
StatisticTotalper Hour
log switches (derived)
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)
Buffer Cache Reads
Direct Writes
Streams AQ
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 File
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)
DBWR (Data File)
Others (Control File)
Others (Data File)
LGWR (Log File)
Buffer Cache Reads
Buffer Cache Reads (Data File)
Streams AQ
Streams AQ (Data File)
Direct Writes
Direct Writes (Data File)
Tablespace IO Stats
ordered by IOs (Reads + Writes) desc
TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
File IO Stats
ordered by Tablespace, File
TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
+DGROUP1/calldb/datafile/data_bs01.dbf
+DGROUP1/calldb/datafile/data_bs02.dbf
+DGROUP1/calldb/datafile/idx_bs01.dbf
+DGROUP1/calldb/datafile/sysaux.263.
+DGROUP1/calldb/datafile/system.264.
+DGROUP1/calldb/datafile/undotbs1.262.
Buffer Pool Statistics
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 Wait这个高了可能是db buffer小了，或者dbwr写得慢Writ Comp WaitBuffer Busy Waits
Checkpoint Activity
Total Physical Writes: 7,655
MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
Advisory Statistics
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
MTTR Advisory
No data exists for this section of the report.
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
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
PGA Aggr Target Stats
B: Begin Snap E: End Snap (rows dentified with B or E contain
data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual +
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto
%Man W/A Mem - percentage of workarea memory under manual
&PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M)当时实际的 W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
PGA Aggr Target Histogram
Optimal Executions are purely in-memory operations
1-pass过高，sql解析时定下用多少pga，实际时如果不够用不会多申请pga，去硬盘sort
有可能是pga过小，如果1-pass的是32k的小pga，那怀疑第一点
Low OptimalHigh OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
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 Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
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)
SGA Target Advisory
No data exists for this section of the report.
Streams Pool Advisory
Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
Java Pool Advisory
No data exists for this section of the report.
Wait Statistics
Buffer Wait Statistics
ordered by wait time desc, waits desc
ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block
undo header
2nd level bmb
1st level bmb
system undo header
file header block
undo block
segment header
system undo block
Enqueue Activity
only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with
ordered by Wait Time desc, Waits desc
Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (allocate ITL entry)
TX-Transaction (index contention)
HW-Segment High Water Mark
US-Undo Segment
CO-KTUCLO Master Slave enq (master slave det)
TA-Instance Undo
TX-Transaction
WF-AWR Flush
TS-Temporary Segment
FB-Format Block
CF-Controlfile Transaction
JQ-Job Queue
PS-PX Process Reservation
DR-Distributed Recovery
TK-Auto Task Serialization (Auto Task
Serialization)
CR-Reuse Block Range (block range reuse ckpt)
JS-Job Scheduler (job run lock - synchronize)
MW-MWIN Schedule
TD-KTF map table enqueue (KTF dump entries)
Undo Statistics
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
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
0/0/0/0/0/0
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
08-Dec 19:23
0/0/0/0/0/0
08-Dec 19:13
0/0/0/0/0/0
Latch Statistics
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
"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 latch
AQ dequeue txn counter latch
ASM Keyed state latch
ASM allocation
ASM db client latch
ASM map operation freelist
ASM map operation hash table
ASM network background latch
ASM network state latch
AWR Alerted Metric Element list
Change Notification Hash table latch
Consistent RBA
DML lock allocation
Event Group Locks
FOB s.o list latch
File State Object Pool Parent Latch
I/O Staticstics latch
IPC other latch
IPC stats buffer allocation latch
In memory undo latch
JS Sh mem access
JS broadcast add buf latch
JS broadcast drop buf latch
JS broadcast load blnc latch
JS mem alloc latch
JS queue access latch
JS queue state obj latch
JS slv state obj latch
KFC FX Hash Latch
KFC Hash Latch
KFCL LE Freelist
KFK SGA Libload latch
KGNFS-NFS:SHM structure
KGNFS-NFS:SVR LIST
KJC message pool free list
KJCT flow control latch
KMG MMAN ready and startup request latch
KSXR large replies
KTF sga latch
KWQMN job cache list latch
KWQP Prop Status
KWQS pqsubs latch
KWQS pqueue ctx latch
Locator state objects pool parent latch
Lsod array latch
MQL Tracking Latch
Memory Management Latch
Memory Queue
Memory Queue Message Subscriber #1
Memory Queue Message Subscriber #2
Memory Queue Message Subscriber #3
Memory Queue Message Subscriber #4
Memory Queue Subscriber
MinActiveScn Latch
Mutex Stats
OS process
OS process allocation
OS process: request allocation
PL/SQL warning settings
PX hash array latch
Real-time plan statistics latch
SGA blob parent
SGA bucket locks
SGA heap locks
SGA pool locks
SQL memory manager latch
SQL memory manager workarea list latch
Shared B-Tree
Streams Generic
Token Manager
Write State Object Pool Parent Latch
XDB NFS Security Latch
XDB unused session pool
XDB used session pool
active checkpoint queue latch
active service list
archive control
archive process latch
begin backup scn array
buffer pool
business card
cache buffer handles
cache buffers chains
cache buffers lru chain
call allocation
change notification client cache latch
channel handle pool latch
channel operations parent latch
checkpoint queue latch
client/application info
compile environment latch
corrupted undo seg latch
cp cmon/server latch
cp pool latch
cp server hash latch
cp sga latch
cvmap freelist lock
deferred cleanup latch
dml lock allocation
done queue latch
dummy allocation
enqueue freelist latch
enqueue hash chains
error message lists
fifth spare latch
file cache latch
flashback copy
fourth Audit Vault latch
gc element
gcs commit scn state
gcs opaque info freelist
gcs partitioned table hash
gcs pcm hashed value bucket hash
gcs resource freelist
gcs resource hash
gcs resource scan list
gcs shadows freelist
ges caches resource lists
ges deadlock list
ges domain table
ges enqueue table freelist
ges group table
ges process hash list
ges process parent latch
ges process table freelist
ges resource hash list
ges resource scan list
ges resource table freelist
ges timeout list
ges value block free list
global KZLD latch for mem in SGA
global tx hash mapping
granule operation
hash table column usage latch
hash table modification latch
heartbeat check
heartbeat structure management
interrupt manipulation
intra txn parallel recovery
io pool granule metadata list
job workq parent latch
job_queue_processes free list latch
job_queue_processes parameter latch
k2q global data latch
k2q lock allocation
kdlx hb parent latch
kgb parent
kgnfs mount latch
kokc descriptor allocation latch
ksfv messages
ksim group membership cache
ksim membership request latch
kss m