Home » RDBMS Server » Server Utilities » statspack report
| statspack report [message #73718] |
Thu, 24 June 2004 01:03 |
Sanjiv Gore
Messages: 2
Registered: June 2004
|
Junior Member |
|
|
hi all!
plz tell me how to do analysis of report.txt.where to look at to derive conclusions.i have two files given below.that i have to analyse.
thanks in advance!!!
REPORT_9JULY.TXT
######################################################
SQL>
SQL> set charwidth 12
unknown SET option "charwidth"
SQL> set numwidth 10
SQL> Rem Select Library cache statistics. The pin hit rate shoule be high.
SQL> select namespace library,
2 gets,
3 round(decode(gethits,0,1,gethits)/decode(gets,0,1,gets),3)
4 gethitratio,
5 pins,
6 round(decode(pinhits,0,1,pinhits)/decode(pins,0,1,pins),3)
7 pinhitratio,
8 reloads, invalidations
9 from stats$lib;
LIBRARY GETS GETHITRATIO PINS PINHITRATIO RELOADS INVALIDATIONS
--------------- ---------- ----------- ---------- ----------- ---------- -------------
BODY 1 1 1 1 0 0
CLUSTER 0 1 0 1 0 0
INDEX 0 1 0 1 0 0
OBJECT 0 1 0 1 0 0
PIPE 0 1 0 1 0 0
SQL AREA 21812 .904 53921 .876 2359 2
TABLE/PROCEDURE 7932 .995 17141 .993 66 0
TRIGGER 0 1 0 1 0 0
8 rows selected.
SQL>
SQL> set charwidth 27;
unknown SET option "charwidth"
SQL> set numwidth 12;
SQL> Rem The total is the total value of the statistic between the time
SQL> Rem bstat was run and the time estat was run. Note that the estat
SQL> Rem script logs on as "internal" so the per_logon statistics will
SQL> Rem always be based on at least one logon.
SQL> select n1.name "Statistic",
2 n1.change "Total",
3 round(n1.change/trans.change,2) "Per Transaction",
4 round(n1.change/logs.change,2) "Per Logon",
5 round(n1.change/(to_number(to_char(end_time, 'J'))*60*60*24 -
6 to_number(to_char(start_time, 'J'))*60*60*24 +
7 to_number(to_char(end_time, 'SSSSS')) -
8 to_number(to_char(start_time, 'SSSSS')))
9 , 2) "Per Second"
10 from stats$stats n1, stats$stats trans, stats$stats logs, stats$dates
11 where trans.name='user commits'
12 and logs.name='logons cumulative'
13 and n1.change != 0
14 order by n1.name;
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
CPU used by this session 99304 259.96
763.88 23.62
CPU used when call started 99453 260.35
765.02 23.65
CR blocks created 141 .37
1.08 .03
DBWR checkpoints 166 .43
1.28 .04
DBWR timeouts 1293 3.38
9.95 .31
SQL*Net roundtrips to/from client 92050 240.97
708.08 21.89
background timeouts 4277 11.2
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
32.9 1.02
bytes received via SQL*Net from client 7101430 18590.13
54626.38 1688.81
bytes sent via SQL*Net to client 39121486 102412.27
300934.51 9303.56
calls to get snapshot scn: kcmgss 12279 32.14
94.45 2.92
calls to kcmgas 391 1.02
3.01 .09
calls to kcmgcs 36 .09
.28 .01
calls to kcmgrs 13614 35.64
104.72 3.24
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
change write time 6 .02
.05 0
cleanouts and rollbacks - consistent read gets 15 .04
.12 0
cleanouts only - consistent read gets 17 .04
.13 0
cluster key scan block gets 251 .66
1.93 .06
cluster key scans 42 .11
.32 .01
commit cleanout number successfully completed 716 1.87
5.51 .17
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
consistent changes 154 .4
1.18 .04
consistent gets 9179584 24030.32
70612.18 2183.02
cursor authentications 5161 13.51
39.7 1.23
data blocks consistent reads - undo records applied 154 .4
1.18 .04
db block changes 3011 7.88
23.16 .72
db block gets 200350 524.48
1541.15 47.65
deferred (CURRENT) block cleanout applications 656 1.72
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
5.05 .16
enqueue releases 2001 5.24
15.39 .48
enqueue requests 1995 5.22
15.35 .47
enqueue waits 6 .02
.05 0
execute count 12082 31.63
92.94 2.87
free buffer inspected 17 .04
.13 0
free buffer requested 1358486 3556.25
10449.89 323.06
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
immediate (CR) block cleanout applications 32 .08
.25 .01
logons cumulative 130 .34
1 .03
logons current -6 -.02
-.05 0
messages received 559 1.46
4.3 .13
messages sent 559 1.46
4.3 .13
no work - consistent read gets 9176497 24022.24
70588.44 2182.28
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
opened cursors cumulative 12435 32.55
95.65 2.96
opened cursors current -9 -.02
-.07 0
parse count 21203 55.51
163.1 5.04
parse time cpu 1508 3.95
11.6 .36
parse time elapsed 1520 3.98
11.69 .36
physical reads 1402959 3672.67
10791.99 333.64
physical writes 521 1.36
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
4.01 .12
process last non-idle time 31175767905 81611957.87
239813599.27 7413975.72
recursive calls 8538 22.35
65.68 2.03
recursive cpu usage 31 .08
.24 .01
redo blocks written 814 2.13
6.26 .19
redo entries 1549 4.05
11.92 .37
redo size 339351 888.35
2610.39 80.7
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
redo small copies 1549 4.05
11.92 .37
redo synch time 83 .22
.64 .02
redo synch writes 391 1.02
3.01 .09
redo wastage 59408 155.52
456.98 14.13
redo write time 98 .26
.75 .02
redo writes 447 1.17
3.44 .11
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
rollback changes - undo records applied 25 .07
.19 .01
rollbacks only - consistent read gets 126 .33
.97 .03
session connect time 31175767905 81611957.87
239813599.27 7413975.72
session logical reads 9334737 24436.48
71805.67 2219.91
session pga memory 20457300 53553.14
157363.85 4864.99
session pga memory max 20587904 53895.04
158368.49 4896.05
session uga memory 316224 827.81
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
2432.49 75.2
session uga memory max 8899820 23297.96
68460.15 2116.49
sorts (disk) 146 .38
1.12 .03
sorts (memory) 11732 30.71
90.25 2.79
sorts (rows) 4804342 12576.81
36956.48 1142.53
table fetch by rowid 2507 6.56
19.28 .6
table fetch continued row 2 .01
.02 0
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
table scan blocks gotten 9171997 24010.46
70553.82 2181.21
table scan rows gotten 195553378 511919.84
1504256.75 46504.97
table scans (long tables) 2005 5.25
15.42 .48
table scans (short tables) 74114 194.02
570.11 17.63
total number commit cleanout calls 716 1.87
5.51 .17
transaction rollbacks 6 .02
.05 0
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
user calls 92124 241.16
708.65 21.91
user commits 382 1
2.94 .09
user rollbacks 113 .3
.87 .03
write requests 243 .64
1.87 .06
80 rows selected.
SQL>
SQL>
SQL> set numwidth 27
SQL> Rem Average length of the dirty buffer write queue. If this is larger
SQL> Rem than the value of:
SQL> Rem 1. (db_files * db_file_simultaneous_writes)/2
SQL> Rem or
SQL> Rem 2. 1/4 of db_block_buffers
SQL> Rem which ever is smaller and also there is a platform specific limit
SQL> Rem on the write batch size (normally 1024 or 2048 buffers). If the average
SQL> Rem length of the dirty buffer write queue is larger than the value
SQL> Rem calculated before, increase db_file_simultaneous_writes or db_files.
SQL> Rem Also check for disks that are doing many more IOs than other disks.
SQL> select queue.change/writes.change "Average Write Queue Length"
2 from stats$stats queue, stats$stats writes
3 where queue.name = 'summed dirty queue length'
4 and writes.name = 'write requests';
Average Write Queue Length
---------------------------
0
SQL>
SQL>
SQL> set charwidth 32;
unknown SET option "charwidth"
SQL> set numwidth 13;
SQL> Rem System wide wait events for non-background processes (PMON,
SQL> Rem SMON, etc). Times are in hundreths of seconds. Each one of
SQL> Rem these is a context switch which costs CPU time. By looking at
SQL> Rem the Total Time you can often determine what is the bottleneck
SQL> Rem that processes are waiting for. This shows the total time spent
SQL> Rem waiting for a specific event and the average time per wait on
SQL> Rem that event.
SQL> select n1.event "Event Name",
2 n1.event_count "Count",
3 n1.time_waited "Total Time",
4 round(n1.time_waited/n1.event_count, 2) "Avg Time"
5 from stats$event n1
6 where n1.event_count > 0
7 order by n1.time_waited desc;
Event Name Count Total Time
---------------------------------------------------------------- ------------- -------------
Avg Time
-------------
SQL*Net message from client 92260 7561694
81.96
rdbms ipc message 69 420083
6088.16
db file scattered read 173123 148715
.86
direct access I/O 898 9869
10.99
enqueue 31 8214
264.97
db file sequential read 4501 4307
.96
SQL*Net more data to client 13093 261
Event Name Count Total Time
---------------------------------------------------------------- ------------- -------------
Avg Time
-------------
.02
latch free 30 251
8.37
rdbms ipc reply 75 103
1.37
log file sync 371 83
.22
control file sequential read 24 41
1.71
SQL*Net message to client 92253 31
0
buffer busy waits 10 12
1.2
Event Name Count Total Time
---------------------------------------------------------------- ------------- -------------
Avg Time
-------------
SQL*Net break/reset to client 32 1
.03
SQL*Net more data from client 221 0
0
15 rows selected.
SQL>
SQL>
SQL> Rem System wide wait events for background processes (PMON, SMON, etc)
SQL> select n1.event "Event Name",
2 n1.event_count "Count",
3 n1.time_waited "Total Time",
4 round(n1.time_waited/n1.event_count, 2) "Avg Time"
5 from stats$bck_event n1
6 where n1.event_count > 0
7 order by n1.time_waited desc;
Event Name
----------------------------------------------------------------------------------------------------
Count Total Time Avg Time
------------- ------------- -------------
rdbms ipc message
4751 2040532 429.5
pmon timer
1395 420529 301.45
smon timer
14 420047 30003.36
db file parallel write
243 416 1.71
log file parallel write
448 98 .22
control file parallel write
12 25 2.08
db file sequential read
Event Name
----------------------------------------------------------------------------------------------------
Count Total Time Avg Time
------------- ------------- -------------
7 15 2.14
control file sequential read
7 9 1.29
db file single write
7 3 .43
latch free
1 0 0
log file sync
2 0 0
11 rows selected.
SQL>
SQL>
SQL> set charwidth 18;
unknown SET option "charwidth"
SQL> set numwidth 11;
SQL> Rem Latch statistics. Latch contention will show up as a large value for
SQL> Rem the 'latch free' event in the wait events above.
SQL> Rem Sleeps should be low. The hit_ratio should be high.
SQL> select name latch_name, gets, misses,
2 round((gets-misses)/decode(gets,0,1,gets),3)
3 hit_ratio,
4 sleeps,
5 round(sleeps/decode(misses,0,1,misses),3) "SLEEPS/MISS"
6 from stats$latches
7 where gets != 0
8 order by name;
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
cache buffers chains 20580240 16 1
16 1
cache buffers lru chain 1358781 8 1
8 1
dml lock allocation 1483 0 1
0 0
enqueue hash chains 4082 0 1
0 0
enqueues 6251 0 1
0 0
ktm global data 14 0 1
0 0
latch wait list 12 0 1
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
0 0
library cache 385387 6 1
6 1
library cache load lock 224 0 1
0 0
list of block allocation 781 0 1
0 0
loader state object freelist 292 0 1
0 0
messages 11057 0 1
0 0
modify parameter values 130 0 1
0 0
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
multiblock read objects 350157 1 1
1 1
process allocation 60 0 1
0 0
redo allocation 4760 0 1
0 0
row cache objects 154012 0 1
0 0
sequence cache 183 0 1
0 0
session allocation 1979 0 1
0 0
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
session idle bit 185027 0 1
0 0
session switching 66 0 1
0 0
shared pool 132769 0 1
0 0
sort extent pool 764 0 1
0 0
system commit number 16838 0 1
0 0
transaction allocation 1244 0 1
0 0
undo global data 1415 0 1
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
0 0
user lock 248 0 1
0 0
27 rows selected.
SQL>
SQL> set numwidth 16
SQL> Rem Statistics on no_wait gets of latches. A no_wait get does not
SQL> Rem wait for the latch to become free, it immediately times out.
SQL> select name latch_name,
2 immed_gets nowait_gets,
3 immed_miss nowait_misses,
4 round((immed_gets/immed_gets+immed_miss), 3)
5 nowait_hit_ratio
6 from stats$latches
7 where immed_gets + immed_miss != 0
8 order by name;
LATCH_NAME NOWAIT_GETS NOWAIT_MISSES
---------------------------------------------------------------- ---------------- ----------------
NOWAIT_HIT_RATIO
----------------
cache buffers chains 2650438 6
7
cache buffers lru chain 1361234 26
27
library cache 994 0
1
process allocation 60 0
1
row cache objects 973 0
1
SQL>
SQL> Rem Buffer busy wait statistics. If the value for 'buffer busy wait' in
SQL> Rem the wait event statistics is high, then this table will identify
SQL> Rem which class of blocks is having high contention. If there are high
SQL> Rem 'undo header' waits then add more rollback segments. If there are
SQL> Rem high 'segment header' waits then adding freelists might help. Check
SQL> Rem v$session_wait to get the addresses of the actual blocks having
SQL> Rem contention.
SQL> select * from stats$waitstat
2 where count != 0
3 order by count desc;
CLASS COUNT TIME
------------------ ---------------- ----------------
data block 10 12
SQL>
SQL>
SQL> set numwidth 19;
SQL> Rem Waits_for_trans_tbl high implies you should add rollback segments.
SQL> select * from stats$roll;
UNDO_SEGMENT TRANS_TBL_GETS TRANS_TBL_WAITS UNDO_BYTES_WRITTEN SEGMENT_SIZE_BYTES
------------------- ------------------- ------------------- ------------------- -------------------
XACTS SHRINKS WRAPS
------------------- ------------------- -------------------
0 15 0 0 714752
0 0 0
1 226 0 26663 10545152
0 0 0
2 224 0 26400 10545152
0 0 0
3 227 0 24301 10545152
-1 0 0
4 239 0 30775 10545152
1 0 0
SQL>
SQL> set charwidth 39
unknown SET option "charwidth"
SQL> Rem The init.ora parameters currently in effect:
SQL> select name, value from v$parameter where isdefault = 'FALSE'
2 order by name;
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
always_anti_join
NESTED_LOOPS
audit_trail
NONE
background_dump_dest
'd:orawinorclbdump'
cache_size_threshold
1280
compatible
7.3.0.0.0
control_files
D:ORAWINorclcontrolcontrol01.ora, D:ORAWINorclcontrolcontrol02.ora
cpu_count
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
1
db_block_buffers
12800
db_block_lru_latches
1
db_block_size
2048
db_files
20
db_name
oracle
distributed_transactions
16
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
dml_locks
100
enqueue_resources
155
gc_freelist_groups
50
gc_releasable_locks
12800
log_archive_dest
d:orawinorclarchive
log_archive_start
TRUE
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
log_buffer
3145728
log_checkpoint_interval
1536
log_simultaneous_copies
0
max_dump_file_size
10240
mts_max_dispatchers
0
mts_max_servers
0
mts_servers
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
0
optimizer_mode
CHOOSE
processes
50
remote_login_passwordfile
SHARED
rollback_segments
rbs01, rbs02, rbs03, rbs04
sequence_cache_hash_buckets
10
sessions
60
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
shared_pool_size
15728640
snapshot_refresh_processes
1
sort_area_retained_size
262144
sort_area_size
262144
sort_direct_writes
TRUE
temporary_table_locks
60
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
text_enable
TRUE
timed_statistics
TRUE
transactions
66
transactions_per_rollback_segment
16
unlimited_rollback_segments
TRUE
user_dump_dest
'd:orawinorcludump'
44 rows selected.
SQL>
SQL> set charwidth 15;
unknown SET option "charwidth"
SQL> set numwidth 8;
SQL> Rem get_miss and scan_miss should be very low compared to the requests.
SQL> Rem cur_usage is the number of entries in the cache that are being used.
SQL> select * from stats$dc
2 where get_reqs != 0 or scan_reqs != 0 or mod_reqs != 0;
NAME GET_REQS GET_MISS SCAN_REQS SCAN_MISS MOD_REQS COUNT CUR_USAGE
-------------------------------- -------- -------- --------- --------- -------- -------- ---------
dc_tablespaces 171 1 0 0 0 13 4
dc_free_extents 14 0 0 0 0 15 3
dc_segments 7754 3 0 0 0 176 175
dc_rollback_segments 140 0 0 0 0 18 6
dc_users 680 0 0 0 0 16 12
dc_user_grants 354 0 0 0 0 24 9
dc_objects 7980 7 0 0 0 272 270
dc_tables 9029 3 0 0 0 238 232
dc_columns 242675 178 19698 13 0 2569 2567
dc_table_grants 342 0 0 0 0 78 71
dc_indexes 105 0 7843 3 0 88 56
dc_constraint_defs 42 0 655 3 0 71 70
dc_constraint_defs 4 1 167 2 0 6 5
dc_synonyms 19 0 0 0 0 46 36
dc_usernames 220 0 0 0 0 20 9
dc_object_ids 26 0 0 0 0 39 38
dc_sequences 3 0 0 0 3 14 1
17 rows selected.
SQL>
SQL>
SQL> set charwidth 80;
unknown SET option "charwidth"
SQL> set numwidth 10;
SQL> Rem Sum IO operations over tablespaces.
SQL> select
2 table_space||' '
3 table_space,
4 sum(phys_reads) reads, sum(phys_blks_rd) blks_read,
5 sum(phys_rd_time) read_time, sum(phys_writes) writes,
6 sum(phys_blks_wr) blks_wrt, sum(phys_wrt_tim) write_time,
7 sum(megabytes_size) megabytes
8 from stats$files
9 group by table_space
10 order by table_space;
TABLE_SPACE READS
------------------------------------------------------------------------------- ----------
BLKS_READ READ_TIME WRITES BLKS_WRT WRITE_TIME MEGABYTES
---------- ---------- ---------- ---------- ---------- ----------
CFS 0
0 0 6 6 236345808 105
INDX 0
0 0 0 0 0 52
NEWCFS 175915
1358333 150452 281 281 3950456470 105
SYSTEM 1
1 2 85 85 408149945 157
TEMP 1728
44859 2710 3089 47305 40 220
UNDOTBS 0
0 0 149 149 157553508 52
USERS 0
TABLE_SPACE READS
------------------------------------------------------------------------------- ----------
BLKS_READ READ_TIME WRITES BLKS_WRT WRITE_TIME MEGABYTES
---------- ---------- ---------- ---------- ---------- ----------
0 0 0 0 0 52
7 rows selected.
SQL>
SQL>
SQL> set charwidth 48;
unknown SET option "charwidth"
SQL> set numwidth 10;
SQL> Rem I/O should be spread evenly accross drives. A big difference between
SQL> Rem phys_reads and phys_blks_rd implies table scans are going on.
SQL> select table_space, file_name,
2 phys_reads reads, phys_blks_rd blks_read, phys_rd_time read_time,
3 phys_writes writes, phys_blks_wr blks_wrt, phys_wrt_tim write_time,
4 megabytes_size megabytes
5 from stats$files order by table_space, file_name;
TABLE_SPACE
------------------------------
FILE_NAME
----------------------------------------------------------------------------------------------------
READS BLKS_READ READ_TIME WRITES BLKS_WRT WRITE_TIME MEGABYTES
---------- ---------- ---------- ---------- ---------- ---------- ----------
CFS
D:ORAWINORCLDATACFS01.DBF
0 0 0 6 6 236345808 105
INDX
D:ORAWINORCLDATAINDX01.DBF
0 0 0 0 0 0 52
NEWCFS
D:ORAWINORCLDATANEWCFS01.DBF
175915 1358333 150452 281 281 3950456470 105
SYSTEM
D:ORAWINORCLDATASYSTEM01.ORA
1 1 2 85 85 408149945 157
TEMP
TABLE_SPACE
------------------------------
FILE_NAME
----------------------------------------------------------------------------------------------------
READS BLKS_READ READ_TIME WRITES BLKS_WRT WRITE_TIME MEGABYTES
---------- ---------- ---------- ---------- ---------- ---------- ----------
D:ORAWINORCLDATATEMP01.DBF
1728 44859 2710 3089 47305 40 220
UNDOTBS
D:ORAWINORCLDATAUNDO01.DBF
0 0 0 149 149 157553508 52
USERS
D:ORAWINORCLDATAUSERS01.DBF
0 0 0 0 0 0 52
7 rows selected.
SQL>
SQL>
SQL> set charwidth 25
unknown SET option "charwidth"
SQL> Rem The times that bstat and estat were run.
SQL> select to_char(start_time, 'dd-mon-yy hh24:mi:ss') start_time,
2 to_char(end_time, 'dd-mon-yy hh24:mi:ss') end_time
3 from stats$dates;
START_TIME
---------------------------------------------------------------------------
END_TIME
---------------------------------------------------------------------------
09-jun-04 17:53:29
09-jun-04 19:03:34
SQL>
SQL> set charwidth 75
unknown SET option "charwidth"
SQL> Rem Versions
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle7 Workgroup Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
CORE Version 3.5.3.0.0 - Production
TNS for 32-bit Windows: Version 2.3.3.0.0 - Production
NLSRTL Version 3.2.3.0.0 - Production
SQL>
SQL>
SQL> spool off;
######################################################
REPORT_9JULY.TXT
######################################################
SQL>
SQL> set charwidth 12
unknown SET option "charwidth"
SQL> set numwidth 10
SQL> Rem Select Library cache statistics. The pin hit rate shoule be high.
SQL> select namespace library,
2 gets,
3 round(decode(gethits,0,1,gethits)/decode(gets,0,1,gets),3)
4 gethitratio,
5 pins,
6 round(decode(pinhits,0,1,pinhits)/decode(pins,0,1,pins),3)
7 pinhitratio,
8 reloads, invalidations
9 from stats$lib;
LIBRARY GETS GETHITRATIO PINS PINHITRATIO RELOADS INVALIDATIONS
--------------- ---------- ----------- ---------- ----------- ---------- -------------
BODY 20 .75 20 .75 0 0
CLUSTER 0 1 0 1 0 0
INDEX 0 1 0 1 0 0
OBJECT 0 1 0 1 0 0
PIPE 0 1 0 1 0 0
SQL AREA 32480 .925 90984 .939 692 1016
TABLE/PROCEDURE 6605 .926 19491 .971 17 0
TRIGGER 0 1 0 1 0 0
8 rows selected.
SQL>
SQL> set charwidth 27;
unknown SET option "charwidth"
SQL> set numwidth 12;
SQL> Rem The total is the total value of the statistic between the time
SQL> Rem bstat was run and the time estat was run. Note that the estat
SQL> Rem script logs on as "internal" so the per_logon statistics will
SQL> Rem always be based on at least one logon.
SQL> select n1.name "Statistic",
2 n1.change "Total",
3 round(n1.change/trans.change,2) "Per Transaction",
4 round(n1.change/logs.change,2) "Per Logon",
5 round(n1.change/(to_number(to_char(end_time, 'J'))*60*60*24 -
6 to_number(to_char(start_time, 'J'))*60*60*24 +
7 to_number(to_char(end_time, 'SSSSS')) -
8 to_number(to_char(start_time, 'SSSSS')))
9 , 2) "Per Second"
10 from stats$stats n1, stats$stats trans, stats$stats logs, stats$dates
11 where trans.name='user commits'
12 and logs.name='logons cumulative'
13 and n1.change != 0
14 order by n1.name;
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
CPU used by this session 113236 178.61
531.62 15.34
CPU used when call started 113208 178.56
531.49 15.33
CR blocks created 1321 2.08
6.2 .18
DBWR buffers scanned 35044 55.27
164.53 4.75
DBWR checkpoints 321 .51
1.51 .04
DBWR free buffers found 28389 44.78
133.28 3.84
DBWR lru scans 1257 1.98
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
5.9 .17
DBWR make free requests 1101 1.74
5.17 .15
DBWR summed scan depth 35056 55.29
164.58 4.75
DBWR timeouts 2398 3.78
11.26 .32
SQL*Net roundtrips to/from client 105539 166.47
495.49 14.29
background checkpoints completed 1 0
0 0
background checkpoints started 1 0
0 0
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
background timeouts 7520 11.86
35.31 1.02
bytes received via SQL*Net from client 7661524 12084.42
35969.6 1037.58
bytes sent via SQL*Net to client 84594120 133429.21
397155.49 11456.41
calls to get snapshot scn: kcmgss 29785 46.98
139.84 4.03
calls to kcmgas 1516 2.39
7.12 .21
calls to kcmgcs 230 .36
1.08 .03
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
calls to kcmgrs 37633 59.36
176.68 5.1
change write time 137 .22
.64 .02
cleanouts and rollbacks - consistent read gets 42 .07
.2 .01
cleanouts only - consistent read gets 158 .25
.74 .02
cluster key scan block gets 12676 19.99
59.51 1.72
cluster key scans 5425 8.56
25.47 .73
commit cleanout failures: callback failure 1 0
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
0 0
commit cleanout number successfully completed 3080 4.86
14.46 .42
consistent changes 1390 2.19
6.53 .19
consistent gets 9088990 14335.95
42671.31 1230.9
cursor authentications 7146 11.27
33.55 .97
data blocks consistent reads - undo records applied 1390 2.19
6.53 .19
db block changes 43173 68.1
202.69 5.85
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
db block gets 210792 332.48
989.63 28.55
deferred (CURRENT) block cleanout applications 2007 3.17
9.42 .27
dirty buffers inspected 20 .03
.09 0
enqueue releases 6537 10.31
30.69 .89
enqueue requests 6537 10.31
30.69 .89
enqueue timeouts 2 0
.01 0
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
execute count 30950 48.82
145.31 4.19
free buffer inspected 199 .31
.93 .03
free buffer requested 2588302 4082.5
12151.65 350.53
immediate (CR) block cleanout applications 200 .32
.94 .03
immediate (CURRENT) block cleanout applications 728 1.15
3.42 .1
logons cumulative 213 .34
1 .03
logons current 8 .01
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
.04 0
messages received 3065 4.83
14.39 .42
messages sent 3065 4.83
14.39 .42
no work - consistent read gets 8981326 14166.13
42165.85 1216.32
opened cursors cumulative 18596 29.33
87.31 2.52
opened cursors current 9 .01
.04 0
parse count 32328 50.99
151.77 4.38
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
parse time cpu 3010 4.75
14.13 .41
parse time elapsed 3648 5.75
17.13 .49
physical reads 2630985 4149.82
12352.04 356.31
physical writes 2095 3.3
9.84 .28
process last non-idle time 44399883333 70031361.72
208450156.49 6012985.28
recursive calls 333019 525.27
1563.47 45.1
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
recursive cpu usage 10679 16.84
50.14 1.45
redo blocks written 10502 16.56
49.31 1.42
redo entries 22373 35.29
105.04 3.03
redo size 4862935 7670.24
22830.68 658.58
redo small copies 22373 35.29
105.04 3.03
redo synch time 411 .65
1.93 .06
redo synch writes 898 1.42
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
4.22 .12
redo wastage 333353 525.79
1565.04 45.15
redo write time 973 1.53
4.57 .13
redo writes 1565 2.47
7.35 .21
rollback changes - undo records applied 18 .03
.08 0
rollbacks only - consistent read gets 1279 2.02
6 .17
session connect time 44399883333 70031361.72
208450156.49 6012985.28
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
session logical reads 9252868 14594.43
43440.69 1253.1
session pga memory 32362088 51044.3
151934.69 4382.73
session pga memory max 32565216 51364.69
152888.34 4410.24
session uga memory 629336 992.64
2954.63 85.23
session uga memory max 11660348 18391.72
54743.42 1579.14
sorts (disk) 45 .07
.21 .01
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
sorts (memory) 4192 6.61
19.68 .57
sorts (rows) 7752390 12227.74
36396.2 1049.89
summed dirty queue length 18 .03
.08 0
table fetch by rowid 38659 60.98
181.5 5.24
table fetch continued row 887 1.4
4.16 .12
table scan blocks gotten 8860471 13975.51
41598.46 1199.96
table scan rows gotten 132420255 208864.76
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
621691.34 17933.4
table scans (long tables) 3199 5.05
15.02 .43
table scans (short tables) 61982 97.76
291 8.39
total number commit cleanout calls 3252 5.13
15.27 .44
transaction rollbacks 12 .02
.06 0
user calls 105419 166.28
494.92 14.28
user commits 634 1
2.98 .09
Statistic Total Per Transaction
---------------------------------------------------------------- ------------ ---------------
Per Logon Per Second
------------ ------------
user rollbacks 80 .13
.38 .01
write requests 549 .87
2.58 .07
91 rows selected.
SQL>
SQL>
SQL> set numwidth 27
SQL> Rem Average length of the dirty buffer write queue. If this is larger
SQL> Rem than the value of:
SQL> Rem 1. (db_files * db_file_simultaneous_writes)/2
SQL> Rem or
SQL> Rem 2. 1/4 of db_block_buffers
SQL> Rem which ever is smaller and also there is a platform specific limit
SQL> Rem on the write batch size (normally 1024 or 2048 buffers). If the average
SQL> Rem length of the dirty buffer write queue is larger than the value
SQL> Rem calculated before, increase db_file_simultaneous_writes or db_files.
SQL> Rem Also check for disks that are doing many more IOs than other disks.
SQL> select queue.change/writes.change "Average Write Queue Length"
2 from stats$stats queue, stats$stats writes
3 where queue.name = 'summed dirty queue length'
4 and writes.name = 'write requests';
Average Write Queue Length
---------------------------
.0327868852459016393442623
SQL>
SQL>
SQL> set charwidth 32;
unknown SET option "charwidth"
SQL> set numwidth 13;
SQL> Rem System wide wait events for non-background processes (PMON,
SQL> Rem SMON, etc). Times are in hundreths of seconds. Each one of
SQL> Rem these is a context switch which costs CPU time. By looking at
SQL> Rem the Total Time you can often determine what is the bottleneck
SQL> Rem that processes are waiting for. This shows the total time spent
SQL> Rem waiting for a specific event and the average time per wait on
SQL> Rem that event.
SQL> select n1.event "Event Name",
2 n1.event_count "Count",
3 n1.time_waited "Total Time",
4 round(n1.time_waited/n1.event_count, 2) "Avg Time"
5 from stats$event n1
6 where n1.event_count > 0
7 order by n1.time_waited desc;
Event Name Count Total Time
---------------------------------------------------------------- ------------- -------------
Avg Time
-------------
SQL*Net message from client 105867 8821411
83.33
rdbms ipc message 122 737915
6048.48
db file scattered read 331110 305543
.92
db file sequential read 36938 22747
.62
direct access I/O 1308 11914
9.11
rdbms ipc reply 274 770
2.81
SQL*Net more data to client 28856 471
Event Name Count Total Time
---------------------------------------------------------------- ------------- -------------
Avg Time
-------------
.02
log file sync 840 401
.48
buffer busy waits 192 205
1.07
SQL*Net message to client 105873 47
0
latch free 21 43
2.05
SQL*Net break/reset to client 278 28
.1
SQL*Net more data from client 1179 4
0
Event Name Count Total Time
---------------------------------------------------------------- ------------- -------------
Avg Time
-------------
control file sequential read 24 3
.13
14 rows selected.
SQL>
SQL>
SQL> Rem System wide wait events for background processes (PMON, SMON, etc)
SQL> select n1.event "Event Name",
2 n1.event_count "Count",
3 n1.time_waited "Total Time",
4 round(n1.time_waited/n1.event_count, 2) "Avg Time"
5 from stats$bck_event n1
6 where n1.event_count > 0
7 order by n1.time_waited desc;
Event Name
----------------------------------------------------------------------------------------------------
Count Total Time Avg Time
------------- ------------- -------------
rdbms ipc message
9974 3861123 387.12
pmon timer
2457 738421 300.54
smon timer
26 737837 28378.35
db file parallel write
549 1708 3.11
log file parallel write
1566 976 .62
db file scattered read
19 33 1.74
db file sequential read
Event Name
----------------------------------------------------------------------------------------------------
Count Total Time Avg Time
------------- ------------- -------------
17 33 1.94
control file parallel write
12 16 1.33
control file sequential read
10 14 1.4
log file sync
1 2 2
buffer busy waits
1 1 1
db file single write
7 0 0
latch free
2 0 0
Event Name
----------------------------------------------------------------------------------------------------
Count Total Time Avg Time
------------- ------------- -------------
13 rows selected.
SQL>
SQL>
SQL> set charwidth 18;
unknown SET option "charwidth"
SQL> set numwidth 11;
SQL> Rem Latch statistics. Latch contention will show up as a large value for
SQL> Rem the 'latch free' event in the wait events above.
SQL> Rem Sleeps should be low. The hit_ratio should be high.
SQL> select name latch_name, gets, misses,
2 round((gets-misses)/decode(gets,0,1,gets),3)
3 hit_ratio,
4 sleeps,
5 round(sleeps/decode(misses,0,1,misses),3) "SLEEPS/MISS"
6 from stats$latches
7 where gets != 0
8 order by name;
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
cache buffer handles 288 0 1
0 0
cache buffers chains 23149754 4 1
4 1
cache buffers lru chain 2591237 6 1
6 1
dml lock allocation 6457 0 1
0 0
enqueue hash chains 13054 0 1
0 0
enqueues 17917 0 1
0 0
ktm global data 30 0 1
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
0 0
latch wait list 16 0 1
0 0
library cache 531121 7 1
8 1.143
library cache load lock 1110 0 1
0 0
list of block allocation 3029 0 1
0 0
loader state object freelist 92 0 1
0 0
messages 25659 0 1
0 0
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
modify parameter values 213 0 1
0 0
multiblock read objects 721648 1 1
1 1
process allocation 89 0 1
0 0
redo allocation 30178 2 1
2 1
row cache objects 229244 0 1
0 0
sequence cache 263 0 1
0 0
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
session allocation 286691 0 1
0 0
session idle bit 212567 0 1
0 0
session switching 117 0 1
0 0
shared pool 114471 1 1
1 1
sort extent pool 241 0 1
0 0
system commit number 44456 0 1
0 0
transaction allocation 5812 0 1
LATCH_NAME GETS MISSES HIT_RATIO
---------------------------------------------------------------- ----------- ----------- -----------
SLEEPS SLEEPS/MISS
----------- -----------
0 0
undo global data 6053 0 1
0 0
user lock 320 0 1
0 0
28 rows selected.
SQL>
SQL> set numwidth 16
SQL> Rem Statistics on no_wait gets of latches. A no_wait get does not
SQL> Rem wait for the latch to become free, it immediately times out.
SQL> select name latch_name,
2 immed_gets nowait_gets,
3 immed_miss nowait_misses,
4 round((immed_gets/immed_gets+immed_miss), 3)
5 nowait_hit_ratio
6 from stats$latches
7 where immed_gets + immed_miss != 0
8 order by name;
LATCH_NAME NOWAIT_GETS NOWAIT_MISSES
---------------------------------------------------------------- ---------------- ----------------
NOWAIT_HIT_RATIO
----------------
cache buffers chains 5051294 17
18
cache buffers lru chain 2571752 32
33
library cache 152 0
1
multiblock read objects 1 0
1
process allocation 89 0
1
row cache objects 164 0
1
6 rows selected.
SQL>
SQL> Rem Buffer busy wait statistics. If the value for 'buffer busy wait' in
SQL> Rem the wait event statistics is high, then this table will identify
SQL> Rem which class of blocks is having high contention. If there are high
SQL> Rem 'undo header' waits then add more rollback segments. If there are
SQL> Rem high 'segment header' waits then adding freelists might help. Check
SQL> Rem v$session_wait to get the addresses of the actual blocks having
SQL> Rem contention.
SQL> select * from stats$waitstat
2 where count != 0
3 order by count desc;
CLASS COUNT TIME
------------------ ---------------- ----------------
data block 192 205
undo header 1 1
SQL>
SQL>
SQL> set numwidth 19;
SQL> Rem Waits_for_trans_tbl high implies you should add rollback segments.
SQL> select * from stats$roll;
UNDO_SEGMENT TRANS_TBL_GETS TRANS_TBL_WAITS UNDO_BYTES_WRITTEN SEGMENT_SIZE_BYTES
------------------- ------------------- ------------------- ------------------- -------------------
XACTS SHRINKS WRAPS
------------------- ------------------- -------------------
0 27 0 0 714752
0 0 0
1 1094 0 439213 10545152
1 0 1
2 1116 0 476600 10545152
0 0 0
3 1131 1 470909 10545152
1 0 1
4 1124 0 474109 10545152
0 0 1
SQL>
SQL> set charwidth 39
unknown SET option "charwidth"
SQL> Rem The init.ora parameters currently in effect:
SQL> select name, value from v$parameter where isdefault = 'FALSE'
2 order by name;
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
always_anti_join
NESTED_LOOPS
audit_trail
NONE
background_dump_dest
d:orawinorclbdump
cache_size_threshold
2560
compatible
7.3.0.0.0
control_files
D:ORAWINorclcontrolcontrol01.ora, D:ORAWINorclcontrolcontrol02.ora
cpu_count
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
1
db_block_buffers
25600
db_block_lru_latches
1
db_block_size
2048
db_files
20
db_name
oracle
distributed_transactions
16
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
dml_locks
100
enqueue_resources
155
gc_freelist_groups
50
gc_releasable_locks
25600
log_archive_dest
d:orawinorclarchive
log_archive_start
TRUE
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
log_buffer
3145728
log_checkpoint_interval
10000
log_simultaneous_copies
0
max_dump_file_size
10240
mts_max_dispatchers
0
mts_max_servers
0
mts_servers
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
0
optimizer_mode
CHOOSE
processes
50
remote_login_passwordfile
SHARED
rollback_segments
rbs01, rbs02, rbs03, rbs04
sequence_cache_hash_buckets
10
sessions
60
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
shared_pool_size
31457280
snapshot_refresh_processes
1
sort_area_retained_size
262144
sort_area_size
524288
sort_direct_writes
TRUE
temporary_table_locks
60
NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
text_enable
TRUE
timed_statistics
TRUE
transactions
66
transactions_per_rollback_segment
16
unlimited_rollback_segments
TRUE
user_dump_dest
d:orawinorcludump
44 rows selected.
SQL>
SQL> set charwidth 15;
unknown SET option "charwidth"
SQL> set numwidth 8;
SQL> Rem get_miss and scan_miss should be very low compared to the requests.
SQL> Rem cur_usage is the number of entries in the cache that are being used.
SQL> select * from stats$dc
2 where get_reqs != 0 or scan_reqs != 0 or mod_reqs != 0;
NAME GET_REQS GET_MISS SCAN_REQS SCAN_MISS MOD_REQS COUNT CUR_USAGE
-------------------------------- -------- -------- --------- --------- -------- -------- ---------
dc_tablespaces 355 1 0 0 0 16 4
dc_free_extents 1443 475 246 0 1184 14 3
dc_segments 5386 225 0 0 268 302 287
dc_rollback_segments 262 0 0 0 0 18 6
dc_used_extents 475 246 0 0 475 50 39
dc_users 915 5 0 0 0 17 12
dc_user_grants 504 4 0 0 0 30 9
dc_objects 6065 392 0 0 0 572 567
dc_tables 11235 352 0 0 381 479 471
dc_columns 185427 3602 13335 352 4174 5279 5266
dc_table_grants 594 15 0 0 0 123 33
dc_indexes 929 149 5407 62 149 214 193
dc_constraint_defs 712 22 4512 82 0 88 76
dc_constraint_defs 12 2 124 19 0 99 4
dc_synonyms 86 15 0 0 0 25 18
dc_usernames 1068 2 0 0 0 20 6
dc_object_ids 229 6 0 0 0 45 36
dc_sequences 4 0 0 0 4 14 1
dc_tablespaces 246 0 0 0 246 9 2
dc_histogram_defs 13117 4174 0 0 4174 4176 4174
20 rows selected.
SQL>
SQL>
SQL> set charwidth 80;
unknown SET option "charwidth"
SQL> set numwidth 10;
SQL> Rem Sum IO operations over tablespaces.
SQL> select
2 table_space||' '
3 table_space,
4 sum(phys_reads) reads, sum(phys_blks_rd) blks_read,
5 sum(phys_rd_time) read_time, sum(phys_writes) writes,
6 sum(phys_blks_wr) blks_wrt, sum(phys_wrt_tim) write_time,
7 sum(megabytes_size) megabytes
8 from stats$files
9 group by table_space
10 order by table_space;
TABLE_SPACE READS
------------------------------------------------------------------------------- ----------
BLKS_READ READ_TIME WRITES BLKS_WRT WRITE_TIME MEGABYTES
---------- ---------- ---------- ---------- ---------- ----------
CFS 7741
46063 5723 92 92 1473212505 105
INDX 2516
2516 611 41 41 496653026 52
NEWCFS 355563
2537187 319777 172 172 2864724292 105
SYSTEM 1190
10977 1282 1299 10953 3437680538 157
TEMP 1311
36200 1670 2756 39494 29 220
UNDOTBS 0
0 0 1161 1161 1457398669 52
USERS 27
TABLE_SPACE READS
------------------------------------------------------------------------------- ----------
BLKS_READ READ_TIME WRITES BLKS_WRT WRITE_TIME MEGABYTES
---------- ---------- ---------- ---------- ---------- ----------
142 11 1 1 5152 52
7 rows selected.
SQL>
SQL>
SQL> set charwidth 48;
unknown SET option "charwidth"
SQL> set numwidth 10;
SQL> Rem I/O should be spread evenly accross drives. A big difference between
SQL> Rem phys_reads and phys_blks_rd implies table scans are going on.
SQL> select table_space, file_name,
2 phys_reads reads, phys_blks_rd blks_read, phys_rd_time read_time,
3 phys_writes writes, phys_blks_wr blks_wrt, phys_wrt_tim write_time,
4 megabytes_size megabytes
5 from stats$files order by table_space, file_name;
TABLE_SPACE
------------------------------
FILE_NAME
----------------------------------------------------------------------------------------------------
READS BLKS_READ READ_TIME WRITES BLKS_WRT WRITE_TIME MEGABYTES
---------- ---------- ---------- ---------- ---------- ---------- ----------
CFS
D:ORAWINORCLDATACFS01.DBF
7741 46063 5723 92 92 1473212505 105
INDX
D:ORAWINORCLDATAINDX01.DBF
2516 2516 611 41 41 496653026 52
NEWCFS
D:ORAWINORCLDATANEWCFS01.DBF
355563 2537187 319777 172 172 2864724292 105
SYSTEM
D:ORAWINORCLDATASYSTEM01.ORA
1190 10977 1282 1299 10953 3437680538 157
TEMP
TABLE_SPACE
------------------------------
FILE_NAME
----------------------------------------------------------------------------------------------------
READS BLKS_READ READ_TIME WRITES BLKS_WRT WRITE_TIME MEGABYTES
---------- ---------- ---------- ---------- ---------- ---------- ----------
D:ORAWINORCLDATATEMP01.DBF
1311 36200 1670 2756 39494 29 220
UNDOTBS
D:ORAWINORCLDATAUNDO01.DBF
0 0 0 1161 1161 1457398669 52
USERS
D:ORAWINORCLDATAUSERS01.DBF
27 142 11 1 1 5152 52
7 rows selected.
SQL>
SQL>
SQL> set charwidth 25
unknown SET option "charwidth"
SQL> Rem The times that bstat and estat were run.
SQL> select to_char(start_time, 'dd-mon-yy hh24:mi:ss') start_time,
2 to_char(end_time, 'dd-mon-yy hh24:mi:ss') end_time
3 from stats$dates;
START_TIME
---------------------------------------------------------------------------
END_TIME
---------------------------------------------------------------------------
11-jun-04 15:55:22
11-jun-04 17:58:26
SQL>
SQL> set charwidth 75
unknown SET option "charwidth"
SQL> Rem Versions
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle7 Workgroup Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
CORE Version 3.5.3.0.0 - Production
TNS for 32-bit Windows: Version 2.3.3.0.0 - Production
NLSRTL Version 3.2.3.0.0 - Production
SQL>
SQL>
SQL> spool off;
|
|
|
|
Goto Forum:
Current Time: Mon Jul 01 02:23:38 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
