timed statistics and statspack report

# Thread: timed statistics and statspack report

Join Date
Jan 2001
Posts
2,828

## timed statistics and statspack report

Hi Folks

I need to prove it to management that runing a statspack report without the setting the timed_statistics parameter equal to true is pretty useless.Does somebody have a document that provides me arguments which can strengthen my case.

regards
Hrishy

2. Pando & Company
Join Date
Jun 2000
Location
Posts
7,447
well if you dont set timed_statistics to true in the time columns inside statspack report you get all zeros, isnt that a good proof?

3. tell them to unhook the speedomoter from their car, tell em it's the same thing, you'll never know how fast your going.

Mt Hanky I smell an international Smack a Manager Day coming on. Are we done celebrating Smack a developer day?

Join Date
Jan 2001
Posts
2,828
Hi

Well thats obivious but since the wait count values are not zero and hence management wants me to go ahead..and do the analysis

regards
Hrishy

5. Originally posted by stmontgo
tell them to unhook the speedomoter from their car, tell em it's the same thing, you'll never know how fast your going.

Mr Hanky I smell an international Smack a Manager Day coming on. Are we done celebrating Smack a developer day?

6. Originally posted by hrishy
Well thats obivious but since the wait count values are not zero and hence management wants me to go ahead..and do the analysis
Tell them they will have to wait for their report. Tell them they will only have to wait once BUT refuse to say how long.

7. Originally posted by DaPi
Tell them they will have to wait for their report. Tell them they will only have to wait once BUT refuse to say how long.
Good one

hrishy,

show them the following output.

1 select event, total_Waits, time_waited, time_waited/total_Waits ratio from v\$system_event
2* order by 4
SQL> /

EVENT TOTAL_WAITS TIME_WAITED RATIO
---------------------------------------- ----------- ----------- ---------
Null event 1 0 .00
process startup 6 0 .00
row cache lock 6 0 .00
instance state change 2 0 .00
library cache load lock 1 0 .00
SQL*Net message to client 43428308 6674 .00
control file sequential read 20316552 72123 .00
SQL*Net more data from client 494200 3896 .01
file identify 1640 14 .01
SQL*Net more data to client 967456 15492 .02
refresh controlfile command 3384027 93470 .03
db file sequential read 14781104 434406 .03
LGWR wait for redo copy 2967 96 .03
file open 61494 2506 .04
buffer busy waits 58427 5080 .09
db file scattered read 50092015 5373244 .11
library cache pin 7 2 .29
log file sequential read 97778 28377 .29
direct path read 1308378 432086 .33
latch free 21245 9365 .44
log file parallel write 609272 358121 .59
local write wait 6 7 1.17
db file parallel read 25 30 1.20
rdbms ipc reply 416 540 1.30
direct path write 1102171 1768816 1.60
log file sync 254377 494635 1.94
control file parallel write 455872 1224963 2.69
log file single write 818 2204 2.69
library cache lock 2 13 6.50
db file parallel write 62358 407415 6.53
SQL*Net message from client 43428348 669025305 15.41
log buffer space 933 16085 17.24
SQL*Net break/reset to client 299 7643 25.56
log file switch completion 293 11706 39.95
rdbms ipc message 6172950 283683546 45.96
pmon timer 463261 57165842 123.40
enqueue 913 128797 141.07
smon timer 4674 57132985 12223.57

Tell them that some events wait for longer and others wait for shorter period. so, the no of waits do not give exact picture.

Join Date
Jan 2001
Posts
2,828
Hi All

Code:
```Top 5 Wait Events
~~~~~~~~~~~~~~~~~                       Wait     % Total
Event                         Waits  Time (cs)   Wt Time
---------------------------- ------ ------------ -------
db file scattered read       56,100            0     .00
db file sequential read      38,457            0     .00
SQL*Net message to dblink    19,606            0     .00
SQL*Net message from dblink  19,600            0     .00
direct path read             11,006            0     .00```
now this means that there were 56,100 waits maybe in 100,000cs or maybe in 15secs
if former the wait event maybe significant if later then they can be ignored

can i base my arguments like above

regards
Hrishy
Last edited by marist89; 04-29-2004 at 08:08 AM.

9. Member
Join Date
May 2003
Location
Pretoria, Rep of South Africa
Posts
191
Base your argument by confusing them...the fact is you know more...and then smack them!!

or ask them on what knowledge do they base this question...and then smack them!!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•