Service Time and Wait Time Totals for Session

Service Time Totals for Session

Wait Time Totals for Session

Tuning Diagnosis for Session

Tuning Advices for Session

File Statistics Part

File Statistics

Unknown Statistics

Performance tips

Compression

iStatsPackAnalyzer Error Codes Manual

Generic User Manual

Introduction

iStatsPackAnalyzer is a web based tool which analyzes STATSPACK files of Oracle; finds bottlenecks and offers information on how to tune them.

STATSPACK Package

STATSPACK package is an Oracle performance diagnosis package. It's one of the best performance diagnosis resources for Oracle tuning. See the following Metaling notes to get STATSPACK reports:

Note:149113.1 Installing and Configuring StatsPack Package
Note:149121.1 Gathering a StatsPack snapshot
Note:149124.1 Creating a StatsPack performance report

User Interface

The user interface of iStatsPackAnalyzer is as below:

iStatsPackAnalyzer user interface consists of the following items:

Instance

If it's selected, instance level analysis is printed.

Session

If it's selected, session level analysis is printed if STATSPACK file includes session level information.

Tuning advice

If it's selected, tuning advice is printed by depending on the Minimum advice limit option.

This is a limit that determines whether tuning advice appears for an event in iStatsPackAnalyzer output. If event time is less than this parameter, tuning advice will not appear. This prevents iStatsPackAnalyzer from calculating tuning advices for low-impact events.

File name

STATSPACK file name to be uploaded. See the Compression of request section to reduce uploading time.

See STATSPACK Package section to see how STATSPACK files are generated.

STATSPACK File Information

STATSPACK file information consists of the following section:

Instance Information
Snapshot Information
SGA Summary Information
Corrupted (Ignored) Lines

Instance Information

This section shows instance information.

Sample

INSTANCE INFORMATION

Instance Number	Instance Name	DB Name	DB ID	Release	Cluster	Host
----------------	------------	------------	-----------	-----------	--------	------------
1	LIFE	LIFE	4122711171	8.1.7.4.0	NO	life
----------------	------------	------------	-----------	-----------	--------	------------

Column information

Name	Definition	Oracle Availability
Instance Number	Instance number.	8.1.7, 9.0.1, 9.2.0
Instance Name	Instance name.	8.1.7, 9.0.1, 9.2.0
DB Name	Database name.	8.1.7, 9.0.1, 9.2.0
DB ID	Database ID.	8.1.7, 9.0.1, 9.2.0
Release	Oracle release.	8.1.7, 9.0.1, 9.2.0
Cluster	OPS/RAC identifier.	8.1.7, 9.0.1, 9.2.0
Host	Host name.	8.1.7, 9.0.1, 9.2.0

Snapshot Information

This section shows snapshot information.

Sample

SNAPSHOT INFORMATION

Snapshot	Snapshot Time	Sessions
-----------------------	-------------------	---------
Begin Snap: 560	07-Mar-03 14:30:03	48
End Snap: 561	07-Mar-03 15:30:02	48
Elapsed:	59.98 (mins)
-----------------------	-------------------	---------

Column information

Name	Definition	Oracle Availability
Snapshot	Begin Snapshod ID, End Snapshot ID and Elapsed lable.	8.1.7, 9.0.1, 9.2.0
Snapshot Time	Begin-end snapshot dates and snapshot interval time.	8.1.7, 9.0.1, 9.2.0
Sessions	Number of sessions at begin-end snapshots.	8.1.7, 9.0.1, 9.2.0

SGA Summary Information

This section shows SGA summary information.

Sample

SGA SUMMARY INFORMATION

SGA Region	Size
-----------------	----------------
Database Buffers	1,556,480,000
Fixed Size	73,888
Redo Buffers	3,162,112
Variable Size	2,241,544,192
-----------------	----------------
total	3,801,260,192

Column information

Name	Definition	Oracle Availability
SGA Region	SGA region name.	8.1.7, 9.0.1, 9.2.0
Size	Size in bytes.	8.1.7, 9.0.1, 9.2.0

Corrupted (Ignored) Lines

This section shows logically corrupted lines in STATSPACK reports. Values of corrupted lines are not included in analysis results. They are ignored.

Sample

CORRUPTED (IGNORED) LINEs

Errror Code	Explanation	Line
-----------	-------------------------------------	--------------------------------------------------------------------
spa-05 [4]	Unparseable number: "###########"	SQL*Net message from client 8,788,151 0 ########### 212 249.7
spa-05 [4]	Unparseable number: "######"	UBT 168 0 ###### 43.3 242 0 0 0.0
spa-05 [4]	Unparseable number: "######"	UBT /system/oradata/UBT/temp.dbf 163 0 ###### 44.6 237 0 0
-----------	-------------------------------------	--------------------------------------------------------------------

Column information

Name	Definition	Oracle Availability
Error code	iStatsPackAnalyzer error code.	8.1.7, 9.0.1, 9.2.0
Explanation	Error code explanation.	8.1.7, 9.0.1, 9.2.0
Line	Corrupted line.	8.1.7, 9.0.1, 9.2.0

Overall Part

Overall part is the time totals for background and also foreground processes. It doesn't mean the sum of background and foreground processes. Because, time spent in foreground processes may include time spent in background processes.

Overall Service Time and Non-Idle Wait Time Totals

This section shows overall CPU and non-idle wait times of foreground and background processes. It consits of two sections:

Chart Section
Table Section

Chart Section

This section shows Overall CPU and non-idle wait time totals in a chart.

Sample

OVERALL SERVICE TIME AND NON-IDLE WAIT TIME TOTALS

Table Section

This section shows Overall CPU and non-idle wait time totals in a table.

Sample

Event	Foreground	Background
--------------	-----------	-----------
Service	13,926.56	N/A
Non-idle wait	9,241.34	642.39
--------------	-----------	-----------
total	23,167.90	642.39+

Column information

Name	Definition	Oracle Availability
Event	Event name.	8.1.7, 9.0.1, 9.2.0
Foreground	Foreground processes time in seconds.	8.1.7, 9.0.1, 9.2.0
Background	Background processes time in seconds.	8.1.7, 9.0.1, 9.2.0

Note that CPU time for background processes, except SNP processes, are not recorded by Oracle.

Foreground Processes Part

Foreground Processes Part shows tuning information for foreground processes. It consists of the following section:

Service Time Totals for Foreground Processes
Non-Idle Wait Time Totals for Foreground Processes
Idle (Ignorable) Wait Time Totals for Foreground Processes
Tuning Diagnosis
Tuning Advices

Service Time Totals for Foreground Processes

This section shows CPU statistics of foreground processes.

Sample

SERVICE TIME TOTALS FOR FOREGROUND PROCESSES

Event	Total	per Call	per Transaction	per Logon	per Second
----------------------------	-----------	---------	----------------	----------	-----------
execute and fetch time cpu	13,376.15	0.00	0.38	85.20	3.72
parse time cpu	550.41	0.00	0.02	3.51	0.15
----------------------------	-----------	---------	----------------	----------	-----------
total	13,926.56	0.00	0.40	88.70	3.87

Column information

Name	Definition	Oracle Availability
Event	Event name.	8.1.7, 9.0.1, 9.2.0
Total	Service time in seconds.	8.1.7, 9.0.1, 9.2.0
per Call	Service time per call.	8.1.7, 9.0.1, 9.2.0
per Transaction	Service time per transaction.	8.1.7, 9.0.1, 9.2.0
per Logon	Service time per logon.	8.1.7, 9.0.1, 9.2.0
per Second	Service time per second.	8.1.7, 9.0.1, 9.2.0

Non-Idle Wait Time Totals for Foreground Processes

This section shows non-idle wait totals for foreground processes.

Sample

NON-IDLE WAIT TIME TOTALS FOR FOREGROUND PROCESSES

Event	Time	Count	Timeout	Time/Count	Timeout/Count
--------------------------------	-----------	-----------	----------	-----------	--------------
db file sequential read	3,637.39	1,303,618	0	0.003	0.00
SQL*Net break/reset to clien	3,237.65	2,590,337	0	0.001	0.00
log file sync	635.97	36,507	22	0.017	0.00
SQL*Net more data to client	513.72	1,750,724	0	0.000	0.00
db file parallel write	299.41	11,775	0	0.025	0.00
db file scattered read	273.40	88,968	0	0.003	0.00
log file parallel write	257.72	35,585	1	0.007	0.00
latch free	231.64	22,464	18,427	0.010	0.01
SQL*Net message to client	58.98	8,788,167	0	0.000	0.00
log file sequential read	44.49	16,020	0	0.003	0.00
control file parallel write	34.71	1,221	0	0.028	0.00
buffer busy waits	4.51	832	0	0.005	0.00
direct path read	4.36	327	0	0.013	0.00
direct path write	2.58	284	0	0.009	0.00
file open	1.59	3,214	0	0.000	0.00
log file switch completion	1.21	17	0	0.071	0.00
refresh controlfile command	0.64	320	0	0.002	0.00
SQL*Net more data from clien	0.63	32	0	0.020	0.00
control file sequential read	0.34	1,995	0	0.000	0.00
LGWR wait for redo copy	0.16	87	1	0.002	0.00
log file single write	0.12	20	0	0.006	0.00
db file parallel read	0.10	4	0	0.025	0.00
file identify	0.02	40	0	0.001	0.00
--------------------------------	-----------	-----------	----------	-----------	--------------
total	9,241.34	14,652,558	18,451	N/A	N/A

Column information

Name	Definition	Oracle Availability
Event	Event name.	8.1.7, 9.0.1, 9.2.0
Time	Wait time in seconds.	8.1.7, 9.0.1, 9.2.0
Count	Number of wait calls.	8.1.7, 9.0.1, 9.2.0
Timeout	Number of wait timeouts.	8.1.7, 9.0.1, 9.2.0
Time/Count	Time per count.	8.1.7, 9.0.1, 9.2.0
Timeout/Count	Timeout per count.	8.1.7, 9.0.1, 9.2.0

Idle (Ignorable) Wait Time Totals for Foreground Processes

This section has the same meaning like in Non-Idle Wait Time Totals for Foreground Processes section except It shows Idle(Ignorable) waits only.

Sample

IDLE (IGNORABLE) WAIT TIME TOTALS FOR FOREGROUND PROCESSES

Event	Time	Count	Timeout	Time/Count	Timeout/Count
--------------------------------	-----------	-----------	----------	-----------	--------------
SQL*Net message from client	32,008.74	10	0	3,200.874	0.00
--------------------------------	-----------	-----------	----------	-----------	--------------
total	32,008.74	10	0	N/A	N/A

Tuning Diagnosis

This section shows tuning diagnosis information to get tuning advice. It is optional. To see this section in analysis report, Tuning advice option should be selected. If there is no foreground process event which has greater than or equal to Minimum advice limit time, this section is not printed even if Tuning advice option is selected.

This section consits of two sections:

Chart section
Table section

Chart section

Just first 7 events which have highest time costs are shown in the chart. Other events are shown as Others.

Sample

TUNING DIAGNOSIS

Table section

This section shows tuning diagnosis table with tuning advice HTML links. Events are ordered by their event times in descending order.

Sample

Event	Time	Definition	Statistic Diagnosis	Built-in Diagnosis
execute and fetch time cpu	13,376.15	Total CPU time for execute and fetch calls.	Logical-IO statistics Logical-IO advices Consistent mode statistics Consistent mode advices Current mode statistics Current mode advices Block cleanout statistics Block cleanout advices Full scan statistics Full scan advices Table ROWID access statistics Table ROWID access advices	Buffer gets SQL table Buffer gets SQL advices
db file sequential read	3,637.39	Total wait time waited for IO completion of: - Single block read - Multiple blocks sort read for pre-Oracle8	Table ROWID access statistics Table ROWID access advices	Tablespace Read-IO table Datafile Read-IO table Read-IO advices Physical reads SQL table Physical reads SQL advices
log file sync	635.97	Total wait time of processes after COMMIT/ROLLBACK. It consists of 3 parts: - Posting LGWR. - Waiting for LGWR to write redolog buffers to online redolog files. - Posting processes by LGWR after redelog buffers are written to redolog file.	redolog statistics log file sync advices	If redo logfiles are on the same physical disks with the datafiles, Check: Tablespace Read-IO table Datafile Read-IO table Read-IO advices Tablespace Write-IO table Datafile Write-IO table Write-IO advices
parse time cpu	550.41	Total CPU time for parse calls.	Parse statistics Parse advices
SQL*Net more data to client	513.72	Total wait time waited for sending data/messages in multiple SQLNet packages from server process to client, because of: - data/messages don't fit in single SQLNet package.	SQLNet statistics SQLNet more data to client advices
db file scattered read	273.40	Total wait time waited for IO completion of: - Full Table Scan(FTS) - Index Fast Full Scan	db file scattered read statistics Full scan advices	Tablespace Read-IO table Datafile Read-IO table Read-IO advices Physical reads SQL table Physical reads SQL advices
latch free	231.64	Total wait time waited for entering critical sections of Oracle code to prevent data structures from concurent modifications.		Willing to wait latch table No-wait(immediate) latch table Latch miss sources table latch free advices

Column information

Name	Definition	Oracle Availability
Event	Event name.	8.1.7, 9.0.1, 9.2.0
Time	Elapsed time of event in seconds.	8.1.7, 9.0.1, 9.2.0
Definition	Definition of event.	8.1.7, 9.0.1, 9.2.0
Statistic Diagnosis	HTML links for statistics and their tuning advices.	8.1.7, 9.0.1, 9.2.0
Built-in Diagnosis	HTML links for built-in statistic tables and their tuning advices.	8.1.7, 9.0.1, 9.2.0

Tuning Advices

After events are ordered by their event times in Tuning Diagnosis table, Statistics Diagnosis and Built-in Diagnosis information of higher impacted events are printed firstly. While printing for an event, Statistics Diagnosis information of an event are printed first from top links to bottom links, then Built-in Diagnosis information of this event is printed in the same order. Then, Statistics Diagnosis and Built-in Diagnosis of other lower impacted events are printed.

Here is a table which explains the print order (TimeA>=TimeB):

Event	Time	Definition	Statistic Diagnosis	Built-in Diagnosis
eventA	TimeA	DefinitionA	A1 A2	A3 A4
EventB	TimeB	DefinitionB	B1 B2	B3 B4

Print order of Statistics Diagnosis information and Built-in Diagnosis information for the sample Tuning Diagnosis table given above is A1,A2,A3,A4,B1,B2,B3,B4.

Tuning advices section consists of the following sections:

Statistic Diagnosis Information
Built-in Diagnosis Information

Statistic Diagnosis Information

Statistic Diagnosis Information consists of the following sections:

Grouped statistics
Tuning advices text

Grouped Statistics

iStatspackAnalyzer provides some pre-defined grouped statistics.

Sample

The following table shows the grouped statistics related to consistent mode operations.

CONSISTENT MODE STATISTICS

Statistic	Total	per Call	per Transaction	per Logon	per Second
----------------------------	-----------	---------	----------------	----------	-----------
consistent gets	52,889,320	5.15	1,502.58	336,874.66	14,696.38
no work - consistent read gets	38,621,133	3.76	1,097.22	245,994.47	10,731.67
consistent changes	102,448	0.01	2.91	652.54	28.47
data blocks consistent reads - undo records applied	102,434	0.01	2.91	652.45	28.46
CR blocks created	28,442	0.00	0.81	181.16	7.90
immediate (CR) block cleanout applications	23,001	0.00	0.65	146.50	6.39
cleanouts and rollbacks - consistent read gets	17,263	0.00	0.49	109.96	4.80
rollbacks only - consistent read gets	11,300	0.00	0.32	71.97	3.14
cleanouts only - consistent read gets	5,738	0.00	0.16	36.55	1.59
current blocks converted for CR	0	0.00	0.00	0.00	0.00
----------------------------	-----------	---------	----------------	----------	-----------

Column information

Name	Definition	Oracle Availability
Statistic	Statistic name.	8.1.7, 9.0.1, 9.2.0
Total	Statistic value.	8.1.7, 9.0.1, 9.2.0
per Call	Statistic value per call.	8.1.7, 9.0.1, 9.2.0
per Transaction	Statistic value per transaction.	8.1.7, 9.0.1, 9.2.0
per Logon	Statistic value per logon.	8.1.7, 9.0.1, 9.2.0
per Second	Statistic value per second.	8.1.7, 9.0.1, 9.2.0

Tuning advices text

iStatspackAnalyzer provides some pre-defined tuning advices.

Sample

The following table shows the tuning advices text related to consistent mode operations.

CONSISTENT MODE ADVICES

Advice
consistent gets = 52,889,320.00 52,889,320.00 logical IO had been done in consistent mode for statements such as SELECT. Blocks are requested in consistent mode in order to be read. If it's unacceptable, do the followings: - Check missing index(es). - If CPU utilization is low in multiple-CPUs environment, use Parallel Query. - If CPU utilization is high, increase CPU power, or add more CPUs if bottleneck is not only in a single process/thread. no work - consistent read gets = 38,621,132.00 38,621,132.00 logical IO had been done in consistent mode that requires neither block cleanouts nor rollbacks. cleanouts only - consistent read gets = 5,738.00 5,738.00 logical IO had been done in consistent mode that requires only block cleanouts, no rollbacks. Normally, this is not tunable. Next coming process always tries to clean out dirtied blocks. To clean out dirtied blocks, do the followings: - Do Full Table Scan(FTS) against dirtied tables. - Export dirtied tables to /dev/null device (faster). Since both options do FTS, dirtied blocks will be cleaned out during FTS. Note that, as of Oracle 7.3, select count() from table_name* doesn't clean out dirtied blocks. rollbacks only - consistent read gets = 11,300.00 11,300.00 logical IO had been done in consistent mode that requires only rollbacks, no block cleanouts. Normally, this is not tunable. But, If it's unacceptable, don't run many small transactions and long-running queries on the same table at the same time. In order to obtain read-consistent image of the blocks, the queries may need to roll back many modifications done by other transactions. cleanouts and rollbacks - consistent read gets = 17,263.00 17,263.00 logical IO had been done in consistent mode that requires both block cleanouts and rollbacks. CR blocks created = 28,442.00 28,442.00 CURRENT mode blocks had been cloned to create CR(consistent read) mode blocks. Since CURRENT mode blocks are in exclusive mode, they can not be used in CR mode. To access a block in CR mode, a new block is cloned from CURRENT mode blocks to CR mode in share mode.

Advice

consistent gets = 52,889,320.00

52,889,320.00 logical IO had been done in consistent mode for statements such as SELECT. Blocks are requested in consistent mode in order to be read. If it's unacceptable, do the followings:

- Check missing index(es).
- If CPU utilization is low in multiple-CPUs environment, use Parallel Query.
- If CPU utilization is high, increase CPU power, or add more CPUs if bottleneck is not only in a single process/thread.

no work - consistent read gets = 38,621,132.00

38,621,132.00 logical IO had been done in consistent mode that requires neither block cleanouts nor rollbacks.

cleanouts only - consistent read gets = 5,738.00

5,738.00 logical IO had been done in consistent mode that requires only block cleanouts, no rollbacks. Normally, this is not tunable. Next coming process always tries to clean out dirtied blocks. To clean out dirtied blocks, do the followings:

- Do Full Table Scan(FTS) against dirtied tables.
- Export dirtied tables to /dev/null device (faster).

Since both options do FTS, dirtied blocks will be cleaned out during FTS. Note that, as of Oracle 7.3, select count(*) from table_name doesn't clean out dirtied blocks.

rollbacks only - consistent read gets = 11,300.00

11,300.00 logical IO had been done in consistent mode that requires only rollbacks, no block cleanouts. Normally, this is not tunable. But, If it's unacceptable, don't run many small transactions and long-running queries on the same table at the same time. In order to obtain read-consistent image of the blocks, the queries may need to roll back many modifications done by other transactions.

cleanouts and rollbacks - consistent read gets = 17,263.00

17,263.00 logical IO had been done in consistent mode that requires both block cleanouts and rollbacks.

CR blocks created = 28,442.00

28,442.00 CURRENT mode blocks had been cloned to create CR(consistent read) mode blocks. Since CURRENT mode blocks are in exclusive mode, they can not be used in CR mode. To access a block in CR mode, a new block is cloned from CURRENT mode blocks to CR mode in share mode.

Column information

Name	Definition	Oracle Availability
Advice	Tuning advice text.	8.1.7, 9.0.1, 9.2.0

Built-in Diagnosis Information

Built-in Diagnosis Information consists of the specific statistics and their tuning advices. They have different formats and can not be grouped together. For example, the format of enqueue portion in STATSPACK file is different than the format of tablespace portion.

Built-in diagnosis information consists of the following items:

tablespace read-io table
tablespace write-io table
datafile read-io table
datafile write-io table
buffer pool table
buffer wait table
rollback segment table
rollback segment storage table
willing to wait latch table
no-wait(immediate) latch table
latch miss sources table
dictionary cache table
library cache table
tablespace buffer wait table
datafile buffer wait table
buffer gets sql table
physical reads sql table
enqueue table

Tablespace Read-IO Table

This section shows read-IO statistics of tablespaces.

Sample

TABLESPACE READ-IO TABLE

Tablespace	Time	Block	Call	Time/Call (ms)	Block/Call	Time (%)
---------------	-----------	------------	-----------	---------------	-----------	---------
WBDATA	261.01	11,600	9,667	27.00	1.20	54%
WBINDX	120.14	12,321	10,268	11.70	1.20	25%
RBS	23.33	92	92	253.60	1.00	5%
SMINDX	15.48	516	516	30.00	1.00	3%
SMDATA	13.75	922	401	34.30	2.30	3%
SYSTEM	13.65	362	362	37.70	1.00	3%
TEMP	12.47	4,250	154	81.00	27.60	3%
TOOLS	10.51	22	22	477.70	1.00	2%
ARCDATA	4.73	22	22	215.00	1.00	1%
INTRFC	4.58	22	22	208.20	1.00	1%
PSTATS	4.07	163	163	25.00	1.00	1%
---------------	-----------	------------	-----------	---------------	-----------	---------
total	483.73	30,292	21,689	N/A	N/A	100%

Column information

Name	Definition	Oracle Availability
Tablespace	Tablespace name.	8.1.7, 9.0.1, 9.2.0
Time	Physical read time in seconds.	8.1.7, 9.0.1, 9.2.0
Block	Number of physical blocks.	8.1.7, 9.0.1, 9.2.0
Call	Number of physical reads.	8.1.7, 9.0.1, 9.2.0
Time/Call (ms)	Phsysical read time per call in milliseconds.	8.1.7, 9.0.1, 9.2.0
Block/Call	Physical blocks per call.	8.1.7, 9.0.1, 9.2.0
Time (%)	Percentage of time.	8.1.7, 9.0.1, 9.2.0

Tablespace Write-IO Table

This section shows write-IO statistics of tablespaces.

Sample

TABLESPACE WRITE-IO TABLE

Tablespace	Call
---------------	-----------
RBS	250,512
WBINDX	131,097
WBDATA	66,938
SMINDX	2,804
TEMP	552
PSTATS	379
SYSTEM	283
SMDATA	173
ARCDATA	22
INTRFC	22
TOOLS	22
---------------	-----------
total	452,804

Column information

Name	Definition	Oracle Availability
Tablespace	Tablespace name.	8.1.7, 9.0.1, 9.2.0
Call	Number of physical writes.	8.1.7, 9.0.1, 9.2.0

Datafile Read-IO Table

This section shows read-IO statistics of datafiles.

Sample

DATAFILE READ-IO TABLE

Datafile	Tablespace	Time	Block	Call	Time/Call (ms)	Block/Call	Time (%)
------------------------------------------------	---------------	-----------	------------	-----------	---------------	-----------	---------
D:\ORACLE\ORADATA\CSDEVUT2\WBDATA02.DBF	WBDATA	200.63	9,441	7,868	25.50	1.20	41%
D:\ORACLE\ORADATA\CSDEVUT2\WBINDX02.DBF	WBINDX	83.97	9,688	8,074	10.40	1.20	17%
D:\ORACLE\ORADATA\CSDEVUT2\WBDATA01.DBF	WBDATA	60.45	1,978	1,799	33.60	1.10	12%
D:\ORACLE\ORADATA\CSDEVUT2\WBINDX01.DBF	WBINDX	35.98	2,632	2,194	16.40	1.20	7%
D:\ORACLE\ORADATA\CSDEVUT2\SYSTEM01.DBF	SYSTEM	13.65	362	362	37.70	1.00	3%
D:\ORACLE\ORADATA\CSDEVUT2\TEMP01.DBF	TEMP	12.47	4,250	154	81.00	27.60	3%
D:\ORACLE\ORADATA\CSDEVUT2\RBS01.DBF	RBS	11.79	45	45	262.00	1.00	2%
D:\ORACLE\ORADATA\CSDEVUT2\RBS02.DBF	RBS	11.54	47	47	245.50	1.00	2%
D:\ORACLE\ORADATA\CSDEVUT2\TOOLS01.DBF	TOOLS	10.51	22	22	477.70	1.00	2%
D:\ORACLE\ORADATA\CSDEVUT2\SMINDX02.DBF	SMINDX	9.98	458	458	21.80	1.00	2%
D:\ORACLE\ORADATA\CSDEVUT2\SMDATA01.DBF	SMDATA	8.17	708	373	21.90	1.90	2%
D:\ORACLE\ORADATA\CSDEVUT2\SMDATA02.DBF	SMDATA	5.58	207	28	199.30	7.39	1%
D:\ORACLE\ORADATA\CSDEVUT2\SMINDX01.DBF	SMINDX	5.47	58	58	94.30	1.00	1%
D:\ORACLE\ORADATA\CSDEVUT2\ARCDATA01.DBF	ARCDATA	4.73	22	22	215.00	1.00	1%
D:\ORACLE\ORADATA\CSDEVUT2\INTRFC01.DBF	INTRFC	4.58	22	22	208.20	1.00	1%
D:\ORACLE\ORADATA\CSDEVUT2\PSTATS01.DBF	PSTATS	4.07	163	163	25.00	1.00	1%
------------------------------------------------	---------------	-----------	------------	-----------	---------------	-----------	---------
total		483.58	30,103	21,689	N/A	N/A	100%

Column information

Name	Definition	Oracle Availability
Datafile	Datafile name.	8.1.7, 9.0.1, 9.2.0
Tablespace	Tablespace name.	8.1.7, 9.0.1, 9.2.0
Time	Physical read time in seconds.	8.1.7, 9.0.1, 9.2.0
Block	Number of physical blocks.	8.1.7, 9.0.1, 9.2.0
Call	Number of physical reads.	8.1.7, 9.0.1, 9.2.0
Time/Call (ms)	Phsysical read time per call.	8.1.7, 9.0.1, 9.2.0
Block/Call	Physical blocks per call.	8.1.7, 9.0.1, 9.2.0
Time (%)	Percentage of time.	8.1.7, 9.0.1, 9.2.0

Datafile Write-IO Table

This section shows write-IO statistics of datafiles.

Sample

DATAFILE WRITE-IO TABLE

Datafile	Tablespace	Call
------------------------------------------------	---------------	-----------
D:\ORACLE\ORADATA\CSDEVUT2\RBS01.DBF	RBS	150,189
D:\ORACLE\ORADATA\CSDEVUT2\WBINDX02.DBF	WBINDX	110,416
D:\ORACLE\ORADATA\CSDEVUT2\RBS02.DBF	RBS	100,323
D:\ORACLE\ORADATA\CSDEVUT2\WBDATA02.DBF	WBDATA	39,157
D:\ORACLE\ORADATA\CSDEVUT2\WBDATA01.DBF	WBDATA	27,781
D:\ORACLE\ORADATA\CSDEVUT2\WBINDX01.DBF	WBINDX	20,681
D:\ORACLE\ORADATA\CSDEVUT2\SMINDX02.DBF	SMINDX	2,782
D:\ORACLE\ORADATA\CSDEVUT2\TEMP01.DBF	TEMP	552
D:\ORACLE\ORADATA\CSDEVUT2\PSTATS01.DBF	PSTATS	379
D:\ORACLE\ORADATA\CSDEVUT2\SYSTEM01.DBF	SYSTEM	283
D:\ORACLE\ORADATA\CSDEVUT2\SMDATA01.DBF	SMDATA	151
D:\ORACLE\ORADATA\CSDEVUT2\ARCDATA01.DBF	ARCDATA	22
D:\ORACLE\ORADATA\CSDEVUT2\INTRFC01.DBF	INTRFC	22
D:\ORACLE\ORADATA\CSDEVUT2\SMDATA02.DBF	SMDATA	22
D:\ORACLE\ORADATA\CSDEVUT2\SMINDX01.DBF	SMINDX	22
D:\ORACLE\ORADATA\CSDEVUT2\TOOLS01.DBF	TOOLS	22
------------------------------------------------	---------------	-----------
total		452,804

Column information

Name	Definition	Oracle Availability
Datafile	Datafile name.	8.1.7, 9.0.1, 9.2.0
Tablespace	Tablespace name.	8.1.7, 9.0.1, 9.2.0
Call	Number of physical writes.	8.1.7, 9.0.1, 9.2.0

Buffer Pool Table

This section shows buffer pool statistics.

Sample

BUFFER POOL TABLE

Name	Buffer Gets	Consistent Gets	Physical Reads	Physical Writes	Free Buffer Waits	Write Complete Waits	Buffer Busy Waits
-------------	-----------------	----------------	---------------	----------------	------------------	---------------------	------------------
Default	202,798	38,491,332	22,146	378,019	0	0	35,920
Keep	556	45,126,064	509	142	0	0	219
Recycle	1,041,969	52,938,472	2,555	73,794	0	0	3,615
-------------	-----------------	----------------	---------------	----------------	------------------	---------------------	------------------
total	1,245,323	136,555,868	25,210	451,955	0	0	39,754

Column information

Name	Definition	Oracle Availability
Name	Buffer pool name.	8.1.7, 9.0.1, 9.2.0
Buffers	Number of buffers.	9.2.0
Cache Hit Ratio (%)	Cache hit ratio.	9.2.0
Buffer Gets	Number of buffer gets.	8.1.7, 9.0.1, 9.2.0
Consistent Gets	Number of consistent gets.	8.1.7
Physical Reads	Number of physical reads.	8.1.7, 9.0.1, 9.2.0
Physical Writes	Number of physical writes.	8.1.7, 9.0.1, 9.2.0
Free Buffer Waits	Number of free buffer waits.	8.1.7, 9.0.1, 9.2.0
Write Complete Waits	Number of write complete waits.	8.1.7, 9.0.1, 9.2.0
Buffer Busy Waits	Number of buffer busy waits.	8.1.7, 9.0.1, 9.2.0

Buffer Wait Table

This section shows buffer wait statistics.

Sample

BUFFER WAIT TABLE

Name	Time	Count	Time/Count	Time (%)
-------------	--------	--------	-----------	---------
data block	105.38	19,676	0.005	94%
undo block	6.15	19,434	0.000	5%
undo header	0.50	611	0.001	0%
segment header	0.15	51	0.003	0%
-------------	--------	--------	-----------	---------
total	112.18	39,772	N/A	100%

Column information

Name	Definition	Oracle Availability
Name	Name of buffer class.	8.1.7, 9.0.1, 9.2.0
Time	Wait time in seconds.	8.1.7, 9.0.1, 9.2.0
Count	Number of waits.	8.1.7, 9.0.1, 9.2.0
Time/Count	Wait time per count.	8.1.7, 9.0.1, 9.2.0
Time (%)	Percentage of time.	8.1.7, 9.0.1, 9.2.0

Rollback Segment Table

This section shows rollback segment statistics.

Sample

ROLLBACK SEGMENT TABLE

RBS No	Waits	Gets	Waits/Gets	Undo Bytes Written	Wraps	Shrinks	Extends
-------	------------	------------	-----------	-------------------	--------	--------	--------
31	7	79,297	0.00	453,394,996	0	0	0
16	3	12,594	0.00	30,401,326	65	0	0
11	2	11,876	0.00	26,980,624	58	0	0
43	2	11,700	0.00	26,146,140	57	0	0
52	1	16,361	0.00	38,334,434	0	0	0
2	1	13,513	0.00	30,517,614	66	0	0
50	1	12,557	0.00	29,993,880	65	0	0
19	1	12,169	0.00	28,412,860	61	0	0
35	1	12,091	0.00	27,839,604	60	0	0
29	1	11,683	0.00	26,462,412	57	0	0
28	1	11,529	0.00	26,163,556	56	0	0
30	1	11,355	0.00	24,846,344	53	0	0
1	0	14,259	0.00	32,284,814	69	0	0
3	0	13,183	0.00	29,457,518	64	0	0
7	0	12,674	0.00	29,421,182	64	0	0
17	0	12,529	0.00	29,976,130	64	0	0
4	0	12,484	0.00	28,151,458	60	0	0
5	0	12,460	0.00	28,723,534	62	0	0
45	0	12,390	0.00	28,912,162	63	0	0
8	0	12,347	0.00	29,539,560	63	0	0
6	0	12,319	0.00	28,800,250	62	0	0
39	0	12,275	0.00	28,620,346	61	0	0
22	0	12,255	0.00	29,128,872	62	0	0
21	0	12,229	0.00	28,343,612	62	0	0
38	0	12,220	0.00	28,412,606	62	0	0
23	0	12,189	0.00	28,736,864	61	0	0
40	0	12,188	0.00	29,742,112	63	0	0
48	0	12,171	0.00	27,728,024	60	0	0
37	0	12,138	0.00	28,778,764	62	0	0
41	0	12,135	0.00	28,849,960	61	0	0
33	0	12,126	0.00	27,946,414	60	0	0
47	0	12,107	0.00	28,226,102	60	0	0
18	0	12,074	0.00	27,781,542	59	0	0
26	0	12,006	0.00	28,361,842	61	0	0
44	0	11,995	0.00	27,680,296	59	0	0
15	0	11,956	0.00	27,927,454	59	0	0
46	0	11,901	0.00	27,724,684	59	0	0
25	0	11,867	0.00	27,445,942	58	0	0
27	0	11,829	0.00	27,098,268	58	0	0
12	0	11,823	0.00	26,705,796	57	0	0
10	0	11,803	0.00	27,026,176	58	0	0
20	0	11,765	0.00	26,267,922	57	0	0
49	0	11,715	0.00	26,616,374	57	0	0
9	0	11,698	0.00	25,633,088	55	0	0
34	0	11,698	0.00	26,918,856	58	0	0
13	0	11,685	0.00	27,051,290	58	0	0
14	0	11,660	0.00	26,360,998	57	0	0
36	0	11,607	0.00	25,973,108	55	0	0
24	0	11,430	0.00	25,497,370	54	0	0
32	0	11,417	0.00	25,569,272	55	0	0
42	0	11,243	0.00	25,223,424	54	0	0
51	0	11,227	0.00	24,158,282	52	0	0
0	0	63	0.00	0	0	0	0
-------	------------	------------	-----------	-------------------	--------	--------	--------
total	22	699,865	N/A	1,882,296,058	2,983	0	0

Column information

Name	Definition	Oracle Availability
RBS No	Rollback segment number.	8.1.7, 9.0.1, 9.2.0
Waits	Number of waits.	8.1.7, 9.0.1, 9.2.0
Gets	Number of gets.	8.1.7, 9.0.1, 9.2.0
Waits/Gets	Waits per get.	8.1.7, 9.0.1, 9.2.0
Undo Bytes Written	Undo Bytes Written.	8.1.7, 9.0.1, 9.2.0
Wraps	Number of wraps.	8.1.7, 9.0.1, 9.2.0
Shrinks	Number of shrinks.	8.1.7, 9.0.1, 9.2.0
Extends	Number of extends.	8.1.7, 9.0.1, 9.2.0

Rollback Segment Storge Table

This section shows rollback segment storage statistics.

Sample

ROLLBACK SEGMENT STORAGE TABLE

RBS No	Segment Size	Avg Active	Optimal Size	Maximum Size
-------	---------------	---------------	---------------	---------------
0	401,408	8,192	0	401,408
1	8,380,416	523,438	0	8,380,416
2	8,380,416	523,190	0	8,380,416
3	8,380,416	523,007	0	8,380,416
4	8,380,416	523,113	0	8,380,416
5	8,380,416	523,040	0	8,380,416
6	8,380,416	523,131	0	8,380,416
7	8,380,416	522,934	0	8,380,416
8	8,380,416	523,368	0	8,380,416
9	8,380,416	522,459	0	8,380,416
10	8,380,416	522,307	0	8,380,416
11	8,380,416	522,732	0	8,380,416
12	8,380,416	522,178	0	8,380,416
13	8,380,416	522,892	0	8,380,416
14	8,380,416	522,764	0	8,380,416
15	8,380,416	522,703	0	8,380,416
16	8,380,416	523,295	0	8,380,416
17	8,380,416	523,350	0	8,380,416
18	8,380,416	522,955	0	8,380,416
19	8,380,416	522,532	0	8,380,416
20	8,380,416	522,259	0	8,380,416
21	8,380,416	522,987	0	8,380,416
22	8,380,416	522,789	0	8,380,416
23	8,380,416	523,003	0	8,380,416
24	8,380,416	521,606	0	8,380,416
25	8,380,416	522,688	0	8,380,416
26	8,380,416	522,623	0	8,380,416
27	8,380,416	522,587	0	8,380,416
28	8,380,416	522,416	0	8,380,416
29	8,380,416	522,709	0	8,380,416
30	8,380,416	521,966	0	8,380,416
31	1,048,567,808	0	0	1,048,567,808
32	8,380,416	522,258	0	8,380,416
33	8,380,416	522,528	0	8,380,416
34	8,380,416	522,461	0	8,380,416
35	8,380,416	522,609	0	8,380,416
36	8,380,416	522,301	0	8,380,416
37	8,380,416	522,862	0	8,380,416
38	8,380,416	522,862	0	8,380,416
39	8,380,416	523,121	0	8,380,416
40	8,380,416	548,444	0	8,380,416
41	8,380,416	523,208	0	8,380,416
42	8,380,416	522,162	0	8,380,416
43	8,380,416	522,603	0	8,380,416
44	8,380,416	522,578	0	8,380,416
45	8,380,416	523,246	0	8,380,416
46	8,380,416	522,848	0	8,380,416
47	8,380,416	522,807	0	8,380,416
48	8,380,416	522,992	0	8,380,416
49	8,380,416	522,511	0	8,380,416
50	8,380,416	523,497	0	8,380,416
51	8,380,416	521,191	0	8,380,416
52	524,279,808	0	0	524,279,808
-------	---------------	---------------	---------------	---------------

Column information

Name	Definition	Oracle Availability
RBS No	Rollback segment number.	8.1.7, 9.0.1, 9.2.0
Segment Size	Rollback segment size.	8.1.7, 9.0.1, 9.2.0
Avg Active	Average active size.	8.1.7, 9.0.1, 9.2.0
Optimal Size	Optimal size.	8.1.7, 9.0.1, 9.2.0
Maximum Size	Maximum size.	8.1.7, 9.0.1, 9.2.0

Willing to Wait Latch Table

This section shows willing to wait latch statistics.

Sample

WILLING TO WAIT LATCH TABLE

Name	Sleeps	Misses	Gets	Sleeps/Miss (%)	Misses/Get (%)	Spin	Sleep1	Sleep2	Sleep3	Sleep4
--------------------------	-----------	-----------	--------------	----------------	---------------	-----	-------	-------	-------	-------
library cache	199,450	253,701	43,702,832	78.62	0.58	139,118	37,669	69,170	7,744	0
cache buffers chains	14,540	281,600	438,332,606	5.16	0.06	269,949	8,787	2,839	25	0
redo allocation	438	18,353	16,171,919	2.39	0.11	18,014	241	97	1	0
checkpoint queue latch	219	236	3,017,636	92.80	0.01	107	39	90	0	0
cache buffers lru chain	82	1,556	20,537,246	5.27	0.01	1,488	54	14	0	0
row cache objects	59	6,479	7,804,627	0.91	0.08	6,430	39	10	0	0
redo writing	37	382	700,847	9.69	0.05	354	22	4	2	0
session allocation	21	211	1,231,533	9.95	0.02	194	13	4	0	0
session idle bit	16	867	8,150,808	1.85	0.01	854	10	3	0	0
latch wait list	16	45	115,415	35.56	0.04	34	6	5	0	0
undo global data	15	382	1,156,659	3.93	0.03	370	9	3	0	0
messages	11	128	1,145,119	8.59	0.01	118	9	1	0	0
transaction allocation	8	48	719,095	16.67	0.01	41	6	1	0	0
enqueue hash chains	6	134	1,424,675	4.48	0.01	128	6	0	0	0
enqueues	4	220	2,053,293	1.82	0.01	216	4	0	0	0
shared pool	4	127	1,014,373	3.15	0.01	125	1	0	1	0
list of block allocation	2	30	599,075	6.67	0.01	28	2	0	0	0
dml lock allocation	1	36	944,039	2.78	0.00	35	1	0	0	0
cache buffer handles	0	0	2,265,156	0.00	0.00	0	0	0	0	0
JOX SGA heap latch	0	0	777,494	0.00	0.00	0	0	0	0	0
sequence cache	0	0	66,509	0.00	0.00	0	0	0	0	0
user lock	0	0	13,680	0.00	0.00	0	0	0	0	0
channel operations parent lat	0	0	10,272	0.00	0.00	0	0	0	0	0
active checkpoint queue latch	0	0	10,258	0.00	0.00	0	0	0	0	0
channel handle pool latch	0	0	6,842	0.00	0.00	0	0	0	0	0
process group creation	0	0	6,841	0.00	0.00	0	0	0	0	0
Token Manager	0	0	5,455	0.00	0.00	0	0	0	0	0
event group latch	0	0	3,429	0.00	0.00	0	0	0	0	0
process allocation	0	0	3,429	0.00	0.00	0	0	0	0	0
longop free list	0	0	2,435	0.00	0.00	0	0	0	0	0
library cache load lock	0	0	1,356	0.00	0.00	0	0	0	0	0
job_queue_processes parameter	0	0	257	0.00	0.00	0	0	0	0	0
ncodef allocation latch	0	0	257	0.00	0.00	0	0	0	0	0
session switching	0	0	257	0.00	0.00	0	0	0	0	0
transaction branch allocation	0	0	257	0.00	0.00	0	0	0	0	0
sort extent pool	0	0	219	0.00	0.00	0	0	0	0	0
multiblock read objects	0	0	186	0.00	0.00	0	0	0	0	0
loader state object freelist	0	0	52	0.00	0.00	0	0	0	0	0
ktm global data	0	0	51	0.00	0.00	0	0	0	0	0
archive process latch	0	0	48	0.00	0.00	0	0	0	0	0
archive control	0	0	46	0.00	0.00	0	0	0	0	0
shared java pool	0	0	3	0.00	0.00	0	0	0	0	0
--------------------------	-----------	-----------	--------------	----------------	---------------	-----	-------	-------	-------	-------

Column information

Name	Definition	Oracle Availability
Name	Latch name.	8.1.7, 9.0.1, 9.2.0
Wait Time	Wait time in seconds.	9.2.0
Sleeps	Number of sleeps.	8.1.7, 9.0.1, 9.2.0
Misses	Number of misses.	8.1.7, 9.0.1, 9.2.0
Gets	Number of gets.	8.1.7, 9.0.1, 9.2.0
Sleeps/Miss (%)	Sleeps per miss percentage.	8.1.7, 9.0.1, 9.2.0
Misses/Get (%)	Misses per get percentage.	8.1.7, 9.0.1, 9.2.0
Spin	Number of spin.	8.1.7, 9.0.1, 9.2.0
Sleep1	Number of 1 sleep.	8.1.7, 9.0.1, 9.2.0
Sleep2	Number of 2 sleeps.	8.1.7, 9.0.1, 9.2.0
Sleep3	Number of 3 sleeps.	8.1.7, 9.0.1, 9.2.0
Sleep4	Number of 4 or more sleeps.	8.1.7, 9.0.1, 9.2.0

No-Wait(Immediate) Latch Table

This section shows no-wait(immediate) latch statistics.

Sample

NO-WAIT(IMMEDIATE) LATCH TABLE

Name	Gets	Misses/Get (%)
--------------------------	--------------	---------------
cache buffers chains	579,536	0.20
cache buffers lru chain	308,517	0.00
latch wait list	115,953	0.00
process allocation	3,429	0.00
JOX SGA heap latch	2	0.00
--------------------------	--------------	---------------

Column information

Name	Definition	Oracle Availability
Name	Latch name.	8.1.7, 9.0.1, 9.2.0
Gets	Latch gets.	8.1.7, 9.0.1, 9.2.0
Misses/Get (%)	Misses per get percentage.	8.1.7, 9.0.1, 9.2.0

Latch Miss Sources Table

This section shows latch miss sources and their statistics.

Sample

LATCH MISS SOURCES TABLE

Name	Where	Sleeps	Waiter Sleeps	No Wait Misses
------------------------	--------------------------	----------	--------------	---------------
library cache	kglhdgn: child:	160,285	34,450	0
library cache	kglget: child: KGLDSBRD	31,636	6,273	0
cache buffers chains	kcbgtcr: kslbegin	6,641	3,172	0
library cache	kglget: child: KGLDSBYD	5,004	1,063	0
cache buffers chains	kcbchg: kslbegin: bufs not	4,939	4,440	0
cache buffers chains	kcbgcur: kslbegin	1,736	547	0
library cache	kglpnal: child: alloc spac	787	42,649	0
cache buffers chains	kcbrls: kslbegin	456	2,933	0
cache buffers chains	kcbget: pin buffer	413	205	0
redo allocation	kcrfwr: redo allocation	407	421	0
library cache	kglpnal: child: before pro	325	25,147	0
library cache	kglupc: child	319	31,074	0
library cache	kglpnc: child	269	25,093	0
library cache	kglpnp: child	268	26,619	0
checkpoint queue latch	kcbk0rrd: update recovery	212	0	0
cache buffers chains	kcbzwb	188	50	0
library cache	kglhdgc: child:	172	1,010	0
library cache	kglic	130	186	0
library cache	kglpin	129	1,223	0
cache buffers chains	kcbchg: kslbegin: call CR	81	2,876	0
row cache objects	kqrpre: find obj	46	51	0
library cache	kglobpn: child:	39	1,670	0
cache buffers lru chain	kcbzgb: multiple sets nowa	35	0	0
library cache	kglhdgh: child:	30	185	0
cache buffers chains	kcbget: exchange rls	27	7	0
library cache	kgllkdl: child: cleanup	25	144	0
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	25	76	0
cache buffers lru chain	kcbzgb: posted for free bu	22	5	0
cache buffers chains	kcbnlc	20	199	0
cache buffers chains	kcbesc: escalate	20	14	0
session allocation	ksuxds: KSUSFCLC not set	18	1	0
redo writing	kcrfsr	18	0	0
redo writing	kcrfwi: after write	17	1	0
redo allocation	kcrfwi: before write	16	9	0
redo allocation	kcrfwi: more space	15	8	0
latch wait list	kslfre	12	16	16
cache buffers chains	kcbget: exchange	11	25	0
row cache objects	kqreqd: rel enqueue	9	1	0
session idle bit	ksupuc: clear busy	8	3	0
session idle bit	ksupuc: set busy	7	13	0
undo global data	ktudba: KSLBEGIN	7	10	0
transaction allocation	ktcxba	7	5	0
messages	ksarcv	6	0	0
library cache	kgllkdl: child: free pin	5	2,064	0
library cache	kglati	5	5	0
undo global data	ktubnd	5	1	0
checkpoint queue latch	kcbbwthc: thread checkpoin	4	75	0
messages	ksarcv: after wait	4	1	0
latch wait list	kslges	4	0	38
cache buffers chains	kcbzgb: scan from tail. no	4	0	0
row cache objects	kqreqd	3	7	0
shared pool	kghupr1	3	4	0
enqueue hash chains	ksqgtl3	3	3	0
enqueue hash chains	ksqrcl	3	3	0
redo writing	kcrfss	2	35	0
session allocation	ksucri	2	13	0
enqueues	ksqgtl2	2	2	0
enqueues	ksqrcl	2	1	0
undo global data	setdrv	2	0	0
checkpoint queue latch	kcbswcu: Switch buffers	1	71	0
cache buffers chains	kcbcge	1	68	0
checkpoint queue latch	kcbkllrba: compute lowest	1	16	0
messages	ksaamb: after wakeup	1	10	0
session allocation	ksuxds: not user session	1	7	0
undo global data	ktudnx: KSLBEGIN	1	4	0
transaction allocation	ktcdso	1	3	0
checkpoint queue latch	kcbbxsv: move to being wri	1	2	0
list of block allocation	ktlbbl	1	2	0
dml lock allocation	ktaiam	1	0	0
list of block allocation	ktlabl	1	0	0
row cache objects	kqrpsc: incr stat	1	0	0
session idle bit	ksuxds	1	0	0
shared pool	kghalo	1	0	0
------------------------	--------------------------	----------	--------------	---------------
total		214,904	214,271	54

Column information

Name	Definition	Oracle Availability
Name	Latch name.	8.1.7, 9.0.1, 9.2.0
Where	Latch location in Oracle source code.	8.1.7, 9.0.1, 9.2.0
Sleeps	Number sleeps while latch was held from location.	8.1.7, 9.0.1, 9.2.0
Waiter Sleeps	Number sleeps while requesting latch from location.	8.1.7, 9.0.1, 9.2.0
No Wait Misses	Number of no-wait misses.	8.1.7, 9.0.1, 9.2.0

Dictionary Cache Table

This section shows dictionary cache statistics.

Sample

DICTIONARY CACHE TABLE

Name	Gets	GetMisses/Get (%)	Scans	ScanMisses/Scan (%)	Modifications	Final Usage	Final Usage (%)
----------------------	------------	------------------	---------	--------------------	--------------	------------	----------------
dc_users	1,186,039	0.00	0	0.00	0	35	92.00
dc_usernames	807,839	0.00	0	0.00	0	11	52.00
dc_rollback_segments	549,854	0.00	0	0.00	0	54	84.00
dc_user_grants	27,624	0.00	0	0.00	0	34	87.00
dc_object_ids	25,482	1.40	0	0.00	0	479	99.00
dc_histogram_defs	7,558	33.70	0	0.00	0	2,881	100.00
dc_objects	5,420	5.50	0	0.00	0	1,125	99.00
dc_segments	4,858	8.70	0	0.00	84	548	99.00
dc_profiles	3,436	0.00	0	0.00	0	1	6.00
dc_sequences	1,085	0.10	0	0.00	1,072	46	78.00
dc_files	982	0.00	0	0.00	0	16	70.00
dc_free_extents	285	9.10	135	0.00	114	121	61.00
dc_tablespaces	282	0.40	0	0.00	0	4	67.00
dc_synonyms	204	21.60	0	0.00	0	68	94.00
dc_used_extents	84	100.00	0	0.00	84	84	93.00
dc_tablespace_quotas	64	1.60	0	0.00	64	3	13.00
dc_constraints	0	0.00	0	0.00	0	0	0.00
dc_database_links	0	0.00	0	0.00	0	0	0.00
dc_global_oids	0	0.00	0	0.00	0	0	0.00
dc_histogram_data	0	0.00	0	0.00	0	0	0.00
dc_histogram_data_valu	0	0.00	0	0.00	0	0	0.00
dc_outlines	0	0.00	0	0.00	0	0	0.00
dc_sequence_grants	0	0.00	0	0.00	0	0	0.00
ifs_acl_cache_entries	0	0.00	0	0.00	0	0	0.00
----------------------	------------	------------------	---------	--------------------	--------------	------------	----------------
total	2,621,096	N/A	135	N/A	1,418	5,510	N/A

Column information

Name	Definition	Oracle Availability
Name	Cache name.	8.1.7, 9.0.1, 9.2.0
Gets	Number of get requests.	8.1.7, 9.0.1, 9.2.0
GetMisses/Get (%)	Get misses per get percentage.	8.1.7, 9.0.1, 9.2.0
Scans	Number of scan requests.	8.1.7, 9.0.1, 9.2.0
ScanMisses/Scan (%)	Scan misses per scan percentage.	8.1.7, 9.0.1, 9.2.0
Modifications	Number of inserts, updates, and deletions.	8.1.7, 9.0.1, 9.2.0
Final Usage	Number of cache entries that contain valid data.	8.1.7, 9.0.1, 9.2.0
Final Usage (%)	Final usage percentage.	8.1.7

Library Cache Table

This section shows library cache statistics.

Sample

LIBRARY CACHE TABLE

Name	Gets	GetMisses/Get (%)	Pins	PinMisses/Pin (%)	Reloads	Invalidations
---------------	------------	------------------	--------------	------------------	----------	--------------
SQL AREA	732,247	0.00	8,883,242	0.00	1	0
TABLE/PROCEDURE	952,163	0.00	7,297,152	0.00	0	0
BODY	122,162	0.00	122,147	0.00	0	0
TRIGGER	9,975	0.00	9,975	0.00	0	0
CLUSTER	327	0.00	117	0.00	0	0
INDEX	0	0.00	0	0.00	0	0
OBJECT	0	0.00	0	0.00	0	0
PIPE	0	0.00	0	0.00	0	0
---------------	------------	------------------	--------------	------------------	----------	--------------
total	1,816,874	N/A	16,312,633	N/A	1	0

Column information

Name	Definition	Oracle Availability
Name	Library cache name.	8.1.7, 9.0.1, 9.2.0
Gets	The number of lock requests for objects.	8.1.7, 9.0.1, 9.2.0
GetMisses/Get (%)	Get misses per get percentage.	8.1.7, 9.0.1, 9.2.0
Pins	The number of pin requests for objects.	8.1.7, 9.0.1, 9.2.0
PinMisses/Pin (%)	Pin misses per pin percentage.	8.1.7, 9.0.1, 9.2.0
Reloads	Number of reloding objecs from disk.	8.1.7, 9.0.1, 9.2.0
Invalidations	Number of object invalidations because of dependent object modifications.	8.1.7, 9.0.1, 9.2.0

Tablespace Buffer Wait Table

This section shows buffer wait statistics of tablespaces.

Sample

TABLESPACE BUFFER WAIT TABLE

Tablespace	Time	Call	Time/Call (ms)	Time (%)
---------------	-----------	-----------	---------------	---------
WBDATA	92.19	9,913	9.30	82%
WBINDX	11.25	9,376	1.20	10%
RBS	6.01	20,032	0.30	5%
SMINDX	1.46	257	5.70	1%
SMDATA	1.20	176	6.80	1%
TEMP	0.00	0	0.00	0%
SYSTEM	0.00	0	0.00	0%
PSTATS	0.00	0	0.00	0%
ARCDATA	0.00	0	0.00	0%
INTRFC	0.00	0	0.00	0%
TOOLS	0.00	0	0.00	0%
---------------	-----------	-----------	---------------	---------
total	112.11	39,754	N/A	100%

Column information

Name	Definition	Oracle Availability
Tablespace	Tablespace name.	8.1.7, 9.0.1, 9.2.0
Time	Buffer wait time in seconds.	8.1.7, 9.0.1, 9.2.0
Call	Number of buffer waits.	8.1.7, 9.0.1, 9.2.0
Time/Call (ms)	Buffer wait time per call in milliseconds.	8.1.7, 9.0.1, 9.2.0
Time (%)	Percentage of time.	8.1.7, 9.0.1, 9.2.0

Datafile Buffer Wait Table

This section shows buffer wait statistics of datafiles.

Sample

DATAFILE BUFFER WAIT TABLE

Datafile	Tablespace	Time	Call	Time/Call (ms)	Time (%)
------------------------------------------------	---------------	-----------	-----------	---------------	---------
D:\ORACLE\ORADATA\CSDEVUT2\WBDATA02.DBF	WBDATA	89.11	8,823	10.10	80%
D:\ORACLE\ORADATA\CSDEVUT2\WBINDX02.DBF	WBINDX	10.42	8,014	1.30	9%
D:\ORACLE\ORADATA\CSDEVUT2\RBS02.DBF	RBS	3.31	11,023	0.30	3%
D:\ORACLE\ORADATA\CSDEVUT2\RBS01.DBF	RBS	2.70	9,009	0.30	2%
D:\ORACLE\ORADATA\CSDEVUT2\WBDATA01.DBF	WBDATA	2.51	1,090	2.30	2%
D:\ORACLE\ORADATA\CSDEVUT2\SMINDX02.DBF	SMINDX	1.46	257	5.70	1%
D:\ORACLE\ORADATA\CSDEVUT2\SMDATA01.DBF	SMDATA	1.20	176	6.80	1%
D:\ORACLE\ORADATA\CSDEVUT2\WBINDX01.DBF	WBINDX	0.95	1,362	0.70	1%
D:\ORACLE\ORADATA\CSDEVUT2\ARCDATA01.DBF	ARCDATA	0.00	0	0.00	0%
D:\ORACLE\ORADATA\CSDEVUT2\INTRFC01.DBF	INTRFC	0.00	0	0.00	0%
D:\ORACLE\ORADATA\CSDEVUT2\PSTATS01.DBF	PSTATS	0.00	0	0.00	0%
D:\ORACLE\ORADATA\CSDEVUT2\SMDATA02.DBF	SMDATA	0.00	0	0.00	0%
D:\ORACLE\ORADATA\CSDEVUT2\SMINDX01.DBF	SMINDX	0.00	0	0.00	0%
D:\ORACLE\ORADATA\CSDEVUT2\SYSTEM01.DBF	SYSTEM	0.00	0	0.00	0%
D:\ORACLE\ORADATA\CSDEVUT2\TEMP01.DBF	TEMP	0.00	0	0.00	0%
D:\ORACLE\ORADATA\CSDEVUT2\TOOLS01.DBF	TOOLS	0.00	0	0.00	0%
------------------------------------------------	---------------	-----------	-----------	---------------	---------
total		111.66	39,754	N/A	100%

Column information

Name	Definition	Oracle Availability
Datafile	Datafile name.	8.1.7, 9.0.1, 9.2.0
Tablespace	Tablespace name.	8.1.7, 9.0.1, 9.2.0
Time	Buffer wait time in seconds.	8.1.7, 9.0.1, 9.2.0
Call	Number of buffer waits.	8.1.7, 9.0.1, 9.2.0
Time/Call (ms)	Buffer wait time per call in milliseconds.	8.1.7, 9.0.1, 9.2.0
Time (%)	Percentage of time.	8.1.7, 9.0.1, 9.2.0

Buffer Gets SQL Table

This section shows buffer gets statistics of SQLs.

Sample

BUFFER GETS SQL TABLE

Reads	Executions	Reads/Execution	Hash	SQL
-----------	-----------	----------------	-----------	-----------------------------------------------------------------------
66,266,409	55,524	1,193.47	1669412826	SELECT DISTINCTPRD_BUNDLE_ID,TPC_PRD_ID,NVL(TPC_SELECTED,'N') TPC_SELECTED,TPC_SERIAL_NO,NVL(TPC_RECOMMENDED,'N')TPC_RECOMMENDED,PRD_CODE,PRD_DESCRIPTION,PRD_DB_DESCRIPTION,TO_CHAR(NVL(PRD_FIXED_PRICE,CAT_PRICE),'999,999,999.99') PRD_MODEL_PRICE,PRD_PROMOTEXT_1 \|\| PRD_PROMOTEXT_2\|\| PRD_PROMOTEXT_3 \|\|PRD_PROMOTEXT
31,936,821	3,971	8,042.51	3524053626	BEGIN proc_ConfigdirPage(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24) ;END;
15,046,833	3,966	3,793.96	3112152231	BEGIN proc_dellware_update(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20) ; END;
11,679,346	3,966	2,944.87	4045111794	BEGIN proc_Updatesg02(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12); END;
10,349,713	521	19,865.09	1020675732	BEGIN Insert_Mail_qt_confirm(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22); END;
10,325,562	521	19,818.74	3603171641	SELECT CIQ_PIQ_SERIAL_NO CIQ_PIQ_SERIAL_NO,CIQ_PRD_CODE CIQ_PRD_CODE,TO_CHAR(NVL(CIQ_RATE,0),'999999999990.00') CIQ_RATE,CIQ_STOCK_CODE PRD_STOCK_CODE,PRD_DESCRIPTION PRD_DESCRIPTION,PRD_DB_DESCRIPTION PRD_DB_DESCRIPTION,QUANTITY CIQ_TOTAL_QUANTITY,ROWNUMROW_NUM,CIQ_ORDER_SEQUENCE,CIQ_PIQ_QT_NUMBER FROM(SELECT PIQ_
8,855,563	3,966	2,232.87	3887540867	SELECT DISTINCTPRD_BUNDLE_ID,TPC_PRD_ID,TPC_SERIAL_NO,NVL(TPC_SELECTED,'N') TPC_SELECTED,NVL(TPC_RECOMMENDED,'N')TPC_RECOMMENDED,PRD_CODE,PRD_DESCRIPTION,PRD_DB_DESCRIPTION,TO_CHAR(NVL(PRD_FIXED_PRICE,CAT_PRICE),'999,999,999.99') PRD_MODEL_PRICE,PRD_PROMOTEXT_1 \|\| PRD_PROMOTEXT_2\|\| PRD_PROMOTEXT_3 \|\|PRD_PROMOTEXT
8,785,278	3,966	2,215.15	2422768306	SELECT COUNT(1)FROM WB_TEMP_PROMO_CATALOG WHERETPC_SESSION_ID = :b1 AND TPC_PRD_ID_PARENT = :b2 ANDTPC_SERIAL_NO_PARENT= :b3
7,659,995	4,741	1,615.69	456641369	INSERT INTO WB_TEMP_STRUCTURE_GROUPS ( TSG_SERIAL_NUMBER,TSG_BMD_PRD_ID,TSG_BMD_SERIAL_NUMBER,TSG_QUANTITY,TSG_ORG_QUANTITY,TSG_SESSIONID,TSG_SELECTED,TSG_IS_PART_MANDATORY,TSG_MUTUALLY_EXCUSIVE,TSG_MINIMUM_QUANTITY,TSG_MAXIMUM_QUANTITY,TSG_IS_QUANTITY_ALTERABLE,TSG_ORDER_SEQUENCE,TSG_PRD_CODE,TSG_ATTACHED_PRD_CODE,TSG
7,095,097	4	1,773,774.25	1128028993	DECLARE job BINARY_INTEGER := :job; next_date DATE:= :mydate;broken BOOLEAN:= FALSE; BEGIN Wbpckg11.Wb_House_Keep; :mydate := next_date; IFbroken THEN:b := 1; ELSE :b := 0;END IF; END;
6,793,699	8,652	785.22	36260941	BEGIN WB_GEN_VALID_STR.GET_VALIDATE_FLAG(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21); END;
6,289,650	1,564	4,021.52	22295402	SELECT COUNT(1)ACOUNT FROM WB_QUOTATION_EXPORT_COMPLIANCE,WB_TEMP_VARIABLE_STORES WHEREQEC_QT_NUMBER =TVS_QT_NUMBER AND TVS_SESSION_ID =:b1 AND TRIM(LTRIM(QEC_RED_FLAG))IS NULL ANDTRIM(LTRIM(QEC_DIVERSION_RISK10)) IS NULL
5,568,463	8,656	643.31	53363678	INSERT INTO WB_COMPONENTS_IN_QUOTATION ( CIQ_PIQ_QT_NUMBER,CIQ_PIQ_SERIAL_NO,CIQ_SERIAL_NO,CIQ_ATTACHED_PRD_CODE,CIQ_PRD_CODE,CIQ_QUANTITY,CIQ_TOTAL_QUANTITY,CIQ_RATE,CIQ_NET_RATE,CIQ_DISCOUNT_AMOUNT,CIQ_ORIGINAL_QUANTIY,CIQ_COST_RATE,CIQ_IS_DISCOUNT_APPLICABLE,CIQ_MAXIMUM_QUANTITY,CIQ_MINIMUM_QUANTITY,CIQ_PSG_CODE,CIQ
4,688,350	21,605	217.00	589960720	DELETE FROM WB_TEMP_STRUCTURE_GROUPS WHERETSG_SESSIONID = :b1
4,626,318	770	6,008.21	2342899441	BEGIN proc_buyitPage(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17) ; END;
4,479,907	7,832	572.00	24163229	SELECT COUNT(*)FROM DM_BILL_OF_MATERIAL_DETAILS,DM_PRODUCTSWHERE BMD_PRD_PRD_CODE = :b1AND BMD_PRD_PRD_CODE_CONSIST_OF =PRD_CODE AND PRD_IS_LTO = ISM_25254040.FN_4000('Y',:b2)
4,233,938	1,043	4,059.38	2344518344	BEGIN Check_Mandatory_Export_Info(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14) ; END;
4,195,083	4,741	884.85	1724127739	INSERT INTO WB_TEMP_STRUCTURE_GROUPS ( TSG_SERIAL_NUMBER,TSG_BMD_PRD_ID,TSG_BMD_SERIAL_NUMBER,TSG_QUANTITY,TSG_ORG_QUANTITY,TSG_SESSIONID,TSG_SELECTED,TSG_IS_PART_MANDATORY,TSG_MUTUALLY_EXCUSIVE,TSG_MINIMUM_QUANTITY,TSG_MAXIMUM_QUANTITY,TSG_IS_QUANTITY_ALTERABLE,TSG_ORDER_SEQUENCE,TSG_PRD_CODE,TSG_ATTACHED_PRD_CODE,TSG
4,133,127	4,736	872.70	1611651382	DELETE FROM WB_COMPONENTS_IN_QUOTATION WHERE CIQ_PIQ_QT_NUMBER =:b1 AND CIQ_PIQ_SERIAL_NO= :b2
3,673,089	3,970	925.21	3111673923	SELECT DECODE(:b1,'Y',NVL(TSG_DB_DESCRIPTION,TSG_DESCRIPTION),TSG_DESCRIPTION)NTSG_DESCRIPTION,TSG_BMD_PRD_ID,TSG_QUANTITY,TSG_PRD_CODE_CONSIST_OF,TSG_PSG_CODE,TSG_SELECTED,DECODE(TSG_SELECTE
-----------	-----------	----------------	-----------	-----------------------------------------------------------------------

Column information

Name	Definition	Oracle Availability
CPU Time	CPU time in seconds.	9.2.0
Elapsed Time	Elapsed time in seconds.	9.2.0
Reads	Number of logical reads.	8.1.7, 9.0.1, 9.2.0
Executions	Number of executions.	8.1.7, 9.0.1, 9.2.0
Reads/Execution	Reads per execution.	8.1.7, 9.0.1, 9.2.0
Hash	Hash value.	8.1.7, 9.0.1, 9.2.0
SQL	Statement text.	8.1.7, 9.0.1, 9.2.0

Pyhsical Reads SQL Table

This section shows pyhsical read statistics of SQLs.

Sample

PHYSICAL READS SQL TABLE

Reads	Executions	Reads/Execution	Hash	SQL
-----------	-----------	----------------	-----------	-----------------------------------------------------------------------
7,222	3,971	1.82	3524053626	BEGIN proc_ConfigdirPage(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24) ;END;
6,947	8,656	0.80	53363678	INSERT INTO WB_COMPONENTS_IN_QUOTATION ( CIQ_PIQ_QT_NUMBER,CIQ_PIQ_SERIAL_NO,CIQ_SERIAL_NO,CIQ_ATTACHED_PRD_CODE,CIQ_PRD_CODE,CIQ_QUANTITY,CIQ_TOTAL_QUANTITY,CIQ_RATE,CIQ_NET_RATE,CIQ_DISCOUNT_AMOUNT,CIQ_ORIGINAL_QUANTIY,CIQ_COST_RATE,CIQ_IS_DISCOUNT_APPLICABLE,CIQ_MAXIMUM_QUANTITY,CIQ_MINIMUM_QUANTITY,CIQ_PSG_CODE,CIQ
4,340	4	1,085.00	3309499534	BEGIN KayR_DB_Health_Stats('d:\common_log'); END;
4,253	4	1,063.25	1817617416	SELECT POOL NAME,ROUND(BYTES/ 1024 / 1024,0) SIZE_MB FROM V$SGASTAT WHERENAME = 'freememory' UNIONSELECT'Db Block Buffer',ROUND(COUNT(0) * 8192/ 1024 / 1024,0) FROM V$BH WHERE STATUS = 'free' GROUP BYSTATUS
3,414	4	853.50	1128028993	DECLARE job BINARY_INTEGER := :job; next_date DATE:= :mydate;broken BOOLEAN:= FALSE; BEGIN Wbpckg11.Wb_House_Keep; :mydate := next_date; IFbroken THEN:b := 1; ELSE :b := 0;END IF; END;
3,391	3,966	0.86	3112152231	BEGIN proc_dellware_update(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20) ; END;
3,215	4,736	0.68	453126047	INSERT INTO WB_COMPONENTS_IN_QUOTATION ( CIQ_PIQ_QT_NUMBER,CIQ_PIQ_SERIAL_NO,CIQ_SERIAL_NO,CIQ_ATTACHED_PRD_CODE,CIQ_PRD_CODE,CIQ_QUANTITY,CIQ_TOTAL_QUANTITY,CIQ_RATE,CIQ_NET_RATE,CIQ_DISCOUNT_AMOUNT,CIQ_ORIGINAL_QUANTIY,CIQ_COST_RATE,CIQ_MAXIMUM_QUANTITY,CIQ_MINIMUM_QUANTITY,CIQ_PSG_CODE,CIQ_DEPENDANT,CIQ_PRD_CODE_DEP
3,059	3,966	0.77	4045111794	BEGIN proc_Updatesg02(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12); END;
2,155	3,966	0.54	2809974057	INSERT INTO WB_TEMP_PROMO_CATALOG ( TPC_SESSION_ID,TPC_PRD_ID )SELECT :b1,PRD_ID FROM WB_CATALOG_LIST,WB_PRODUCTS,HA_COMPANIES,SO_COST_CENTRES WHERE CAT_BG_CODE = :b2AND PRD_CS_CODE = CAT_CS_CODE ANDCAT_PRD_ID =PRD_ID AND CAT_CS_CODE = :b3 ANDCAT_STORE_CODE= :b4 AND CAT_LANG = :b5 AND PRD_CS_CODE = CS_C
1,825	1,651	1.11	2780309133	BEGIN Check_Mandatory_PiqCiq_Info(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) ;END;
1,784	21,605	0.08	589960720	DELETE FROM WB_TEMP_STRUCTURE_GROUPS WHERETSG_SESSIONID = :b1
1,749	1,651	1.06	2846485534	SELECT COUNT(1)FROM WB_COMPONENTS_IN_QUOTATIONWHERE CIQ_PIQ_QT_NUMBER = :b1
1,209	3,966	0.30	2422768306	SELECT COUNT(1)FROM WB_TEMP_PROMO_CATALOG WHERETPC_SESSION_ID = :b1 AND TPC_PRD_ID_PARENT = :b2 ANDTPC_SERIAL_NO_PARENT= :b3
1,094	20,830	0.05	3348208412	DELETE FROM WB_TEMP_PROMO_CATALOG WHERE TPC_SESSION_ID = :b1
1,070	770	1.39	2342899441	BEGIN proc_buyitPage(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17) ; END;
1,060	621	1.71	1597622212	BEGIN wbpckg12.Qt_Transfer_Pub(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18); END;
603	621	0.97	2557593051	INSERT INTO DM_QUOTATIONS (QT_CS_CODE,QT_NUMBER,QT_REFERENCE_NUMBER,QT_DATE,QT_VALID_TILL,QT_CBD_NUMBER,QT_CUSTOMER_CODE,QT_CONTACT_PERSON,QT_CUSTOMER_PO_NO,QT_CREATED_BY,QT_PLT_CODE,QT_CCY_CODE_LOCAL,QT_CCY_CODE_SALES,QT_CONVERSION_RATE,QT_LCY_USD_CONVERSION_RATE,QT_SELL_USD_CONVERSION_RATE,QT_SELLING_CCY_DUTY_RATE,Q
505	85	5.94	1804737247	Select DDATE \|\|':00 To ' \|\|decode(substr(DDATE,13,2),'23','00',lpad(to_char(to_number(substr(DDATE,13,2))+1),2,'0')) \|\| ':00'Date_ , sum(hits) hits , Sum(WBCOUNT) Temp_Qt , Sum(DMCOUNT) Confirmed_Qt , sum(savedcarts)Saved_Carts From ( select to_char(qt_date,'DD-MON-YYYY HH24') DDATE,count(1) DMCOUNT,0WBCOUNT , 0 h
452	621	0.73	86492733	SELECT COUNT(*)FROM WB_LOG_DETAILS WHERE LD_UID= :b1 AND LD_LM_TNAME = 'DM_CUSTOMER_BASIC_DETAILS'
426	3,915	0.11	4112737624	BEGIN proc_update_dellware02(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13); END;
395	8,656	0.05	2885998655	INSERT INTO WB_PRODUCTS_IN_QUOTATION ( PIQ_QT_NUMBER,PIQ_SERIAL_NO,PIQ_PRD_CODE,PIQ_PRD_ID,PIQ_QUANTITY,PIQ_DESCRIPTION,PIQ_CONFIGURATION_TYPE,PIQ_CONFIG_COST,PIQ_NET_AMOUNT,PIQ_MARGIN_AMT_LCY,PIQ_RATE,PIQ_NET_RATE,PIQ_DISCOUNT_RATE,PIQ_DISCOUNT_AMOUNT,PIQ_STOCK_CODE,PIQ_IS_DISCOUNT_APPLICABLE,PIQ_PSG_CODE,PIQ_IS_CUSTO
378	302,760	0.00	957291575	INSERT INTO WB_COMPONENTS_IN_QUOTATION ( CIQ_PIQ_QT_NUMBER,CIQ_PIQ_SERIAL_NO,CIQ_SERIAL_NO,CIQ_ATTACHED_PRD_CODE,CIQ_PRD_CODE,CI
-----------	-----------	----------------	-----------	-----------------------------------------------------------------------

Column information

Name	Definition	Oracle Availability
Elapsed Time	Elapsed time in seconds.	9.2.0
Reads	Number of logical reads.	8.1.7, 9.0.1, 9.2.0
Executions	Number of executions.	8.1.7, 9.0.1, 9.2.0
Reads/Execution	Reads per execution.	8.1.7, 9.0.1, 9.2.0
Hash	Hash value.	8.1.7, 9.0.1, 9.2.0
SQL	Statement text.	8.1.7, 9.0.1, 9.2.0

Enqueue Table

This section shows enqueue statistics.

Sample

ENQUEUE TABLE

Name	Wait Time	Waits	WaitTime/Wait	Requests	Successful Gets	Failed Gets
-----	----------	----------	--------------	---------	----------------	------------
TX	1.70	34	0.05	109,512	109,491	18
SQ	0.01	3	0.00	1,082	1,082	0
CU	0.00	1	0.00	7,371	7,371	0
-----	----------	----------	--------------	---------	----------------	------------

Column information

Name	Definition	Oracle Availability
Name	Enqueue name.	8.1.7, 9.0.1, 9.2.0
Wait Time	Wait time in seconds.	9.2.0
Waits	Number of waits.	8.1.7, 9.0.1, 9.2.0
WaitTime/Wait	Wait time per wait.	9.2.0
Requests	Number of requests.	9.2.0
Successful Gets	Number of successful gets.	9.2.0
Failed Gets	Number of failed gets.	9.2.0
Gets	Number of gets.	8.1.7
Waits/Get	Waits per get.	8.1.7

Background Processes Part

Background Processes Part shows the tuning information for background processes. It consists of the following section:

Non-Idle Wait Time Totals for Background Processes
Idle (Ignorable) Wait Time Totals for Background Processes

Non-Idle Wait Time Totals for Background Processes

This section has the same meaning like in Non-Idle Wait Time Totals for Foreground Processes except It includes background processes information only.

Idle (Ignorable) Wait Time Totals for Background Processes

This section has the same meaning like in Idle (Ignorable) Wait Time Totals for Foreground Processes except It includes background processes information only.

Session Part

Session Part shows the tuning information for session. It consists of the following section:

Service Time and Wait Time Totals for Session
Service Time Totals for Session
Wait Time Totals for Session
Tuning Diagnosis for Session
Tuning Advices for Session

Service Time and Wait Time Totals for Session

This section shows CPU and wait times of session. It consits of two sections:

Chart Section
Table Section

Chart Section

This section shows CPU and wait time totals in a chart.

Sample

SERVICE TIME AND WAIT TIME TOTALS FOR SESSION 43 SERIAL 3638

Table Section

This section shows CPU and wait time totals in a table.

Sample

Event	Time
--------------	-----------
Service	37.16
Wait	130.00
--------------	-----------
total	167.16

Column information

Name	Definition	Oracle Availability
Event	Event name.	8.1.7, 9.0.1, 9.2.0
Time	Time in seconds.	8.1.7, 9.0.1, 9.2.0

Service Time Totals for Session

This section has the same meaning like in Service Time Totals for Foreground Processes except It includes session information only.

Wait Time Totals for Session

This section has the same meaning like in Non-Idle Wait Time Totals for Foreground Processes except It includes session information only and no event is accepted idle in session level.

Tuning Diagnosis for Session

This section has the same meaning like in Tuning Diagnosis section except It includes session information only and no built-in diagnosis is available in session level.

Tuning Advices for Session

This section has the same meaning like in Tuning Advices section except It includes session information only and no built-in diagnosis is available in session level.

File Statistics Part

This section shows STATSPACK file statistics. It consists of two sections:

File Statistics
Unknown Statistics

File Statistics

This section shows STATSPACK file statistics.

Sample

FILE STATISTICS

Name	Value
---------------------------------------	---------------------------------------
File name	D:\dunal\sp_61_62.lst
Corrupted lines	3
Unknown statistics	14

Column information

Name	Definition	Oracle Availability
Name	File statistic name.	8.1.7, 9.0.1, 9.2.0
Value	Statistic value.	8.1.7, 9.0.1, 9.2.0

Unknown Statistics

This section shows the statistics which are not defined in iStatsPackAnalyzer.

Sample

UNKNOWN STATISTICS

Statistic
----------------------------
active txn count during cleanout
cleanout - number of ktugct calls
commit txn count during cleanout
consistent gets - examination
index fetch by key
index scans kdiixs1
leaf node 90-10 splits
parse count (failures)
prefetch clients - default
shared hash latch upgrades - no w
shared hash latch upgrades - wait
transaction tables consistent rea
workarea executions - onepass
workarea executions - optimal
----------------------------

Column information

Name	Definition	Oracle Availability
Statistic	Statistic name undefined in iStatsPackAnalyzer.	8.1.7, 9.0.1, 9.2.0

iStatsPackAnalyzer 1.2.1 User Manual

info@ubTools.com
http://www.ubTools.com