ASH Report For UPRR/uprr

DB NameDB IdInstanceInst numReleaseRACHost
UPRR1058789863uprr111.2.0.3.0NOcnuctdb130

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
1616,311M (100%)5,600M (34.3%)1,024M (6.3%)32.0M (0.2%)

Sample TimeData Source
Analysis Begin Time:24-Apr-13 15:29:41V$ACTIVE_SESSION_HISTORY
Analysis End Time:24-Apr-13 15:59:41V$ACTIVE_SESSION_HISTORY
Elapsed Time: 30.0 (mins)  
Sample Count: 3,900 
Average Active Sessions: 2.17 
Avg. Active Session per CPU: 0.14 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
CPU + Wait for CPUCPU35.560.77
log file sequential readSystem I/O16.180.35
Disk file operations I/OUser I/O1.670.04

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
row cache lockConcurrency45.971.00

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
row cache lock45.97"2","0","3"45.97 cache idmoderequest
log file sequential read16.18"0","391168","2048"0.18 log#block#blocks
Disk file operations I/O1.69"2","0","3"1.49 FileOperationfilenofiletype

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$USERSJDBC Thin Client50.03UNNAMED50.03
SYS$BACKGROUNDUNNAMED46.51UNNAMED46.51
uprrPL/SQL Developer3.44SQL 窗口 - 新建3.38

Back to Load Profile
Back to Top

Top Client IDs

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
INSERT346.951.02
SELECT756.410.14

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution53.101.15

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL with Top Events

SQL IDPlanhashSampled # of Executions% ActivityEvent% EventTop Row Source% RwSrcSQL Text
3g3k82x8rr54f139710265416645.67 CPU + Wait for CPU27.95** Row Source Not Available **27.95 insert into DF2_GL_BALANCE_QUE...
log file sequential read16.05** Row Source Not Available **16.05
Disk file operations I/O1.64** Row Source Not Available **1.64
gb3kwkhf2yrhp361836218011.74 CPU + Wait for CPU1.74FIXED TABLE - FIXED INDEX1.69 select * from v$access t where...

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
3g3k82x8rr54f139710265416645.67 ** Row Source Not Available **45.67CPU + Wait for CPU27.95 insert into DF2_GL_BALANCE_QUE...
gb3kwkhf2yrhp361836218011.74 FIXED TABLE - FIXED INDEX1.69CPU + Wait for CPU1.69 select * from v$access t where...

Back to Top SQL
Back to Top

Top SQL using literals

No data exists for this section of the report.

Back to Top SQL
Back to Top

Top Parsing Module/Action

No data exists for this section of the report.

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
3g3k82x8rr54finsert into DF2_GL_BALANCE_QUERY( Account, Account_Desc, Dept_ID, Dept_ID_Desc, Oper_Unit, Oper_Unit_Desc, Product, Product_Desc, C_Class, C_Class_Desc, Affiliate, Affiliate_Desc, Project_ID, Project_ID_Desc, Tran_Ccy, Tran_Amt, Base_Ccy, Base_Amt, branch, DATA_DATE) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 )
gb3kwkhf2yrhpselect * from v$access t where t.TYPE = 'TABLE' AND T.OBJECT='DF2_GL_BALANCE_QUERY'

Back to Top SQL
Back to Top

Top PL/SQL Procedures

No data exists for this section of the report.


Back to Top

Top Java Workload

No data exists for this section of the report.


Back to Top

Top Call Types

Call TypeCount% ActivityAvg Active Sessions
V8 Bundled Exec1,94749.921.08
FETCH1363.490.08


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
926, 145.97row cache lock45.97 SYSoracle@cnuctdb130 (SMON)1,793/1,800 [100%]0
1168,2386940.00CPU + Wait for CPU24.26 DATACOREJDBC Thin Client946/1,800 [ 53%]0
log file sequential read14.28 557/1,800 [ 31%]0
Disk file operations I/O1.44 56/1,800 [ 3%]0
1009, 2835.97CPU + Wait for CPU3.85 DATACOREJDBC Thin Client150/1,800 [ 8%]0
log file sequential read1.90 74/1,800 [ 4%]0
315,542713.31CPU + Wait for CPU3.31 DATACOREplsqldev.exe129/1,800 [ 7%]0
1009, 2871.21CPU + Wait for CPU1.18 DATACOREJDBC Thin Client46/1,800 [ 3%]1

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
1168,23869( 1)40.00row cache lock40.00 DATACOREJDBC Thin Client1,560/1,800 [ 87%]0
1009, 283( 1)5.97row cache lock5.97 DATACOREJDBC Thin Client233/1,800 [ 13%]0

Back to Top Sessions
Back to Top

Top Sessions running PQs

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Objects/Files/Latches

Back to Top

Top DB Objects

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top Latches

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEventEvent Count% Event
15:29:41 (19 secs)43row cache lock200.51
CPU + Wait for CPU180.46
log file sequential read40.10
15:30:00 (3.0 min)381row cache lock1784.56
CPU + Wait for CPU1333.41
log file sequential read631.62
15:33:00 (3.0 min)374row cache lock1774.54
CPU + Wait for CPU1313.36
log file sequential read561.44
15:36:00 (3.0 min)367row cache lock1814.64
CPU + Wait for CPU1162.97
log file sequential read651.67
15:39:00 (3.0 min)449CPU + Wait for CPU1975.05
row cache lock1794.59
log file sequential read641.64
15:42:00 (3.0 min)428row cache lock1804.62
CPU + Wait for CPU1784.56
log file sequential read611.56
15:45:00 (3.0 min)371row cache lock1804.62
CPU + Wait for CPU1203.08
log file sequential read641.64
15:48:00 (3.0 min)411row cache lock1794.59
CPU + Wait for CPU1624.15
log file sequential read621.59
15:51:00 (3.0 min)365row cache lock1804.62
CPU + Wait for CPU1142.92
log file sequential read621.59
15:54:00 (3.0 min)383row cache lock1814.64
CPU + Wait for CPU1353.46
log file sequential read601.54
15:57:00 (2.7 min)328row cache lock1584.05
CPU + Wait for CPU952.44
log file sequential read701.79


Back to Top

End of Report