Re: Report.Txt - Suggestions Welcome

From: <spam_at_no.thanks.com>
Date: Tue, 28 Aug 2001 07:53:14 GMT
Message-ID: <998985194.1@thunderstar.net>

From: "andrew_webby at hotmail" <spam_at_no.thanks.com>

Mick

Any chance of posting this as a .txt attachment as the formatting is  all to
pot. Also, when doing this, stick "CRIT: whatever" in the subject  line to
help those who aren't interested to skip it...

"Mick Rice" <mickrice_at_techie.com> wrote in message news:645b6e08.0107120047.6a2141ed_at_posting.google.com...
> A few posters have provided a sample of their utlbstat/utlestat
 output
> for review and observations. I've done the same below and would
> welcome comments. I've been trying to tune this database for a
 while
> and it seems to run fairly well but would welcome any suggestions
 as
> to where I copuld improve performance,
>
> Thanks In Advance,
>
> Mick.
>
> SVRMGR> set charwidth 12
> Charwidth 12
> SVRMGR> set numwidth 10
> Numwidth 10
> SVRMGR>
> SVRMGR> select (1 - (sum(decode(name, 'physical reads', value, 0))
 /
> 2> (sum(decode(name, 'db block gets', value, 0)) +
> 3> sum(decode(name, 'consistent gets', value, 0))))) *
> 100 "Data Hit Ratio"
> 4> from v$sysstat;
> Data Hit R
> ----------
> 97.1780017
> 1 row selected.
> SVRMGR>
> SVRMGR> Rem Select Library cache statistics. The pin hit rate
 shoule
> be high.
> SVRMGR> 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 GETHITRATI PINS PINHITRATI RELOADS
> INVALIDATI
> ------------ ---------- ---------- ---------- ---------- ----------
> ----------
> BODY 535 1 535 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 798585 .897 2578962 .935 2126
> 299
> TABLE/PROCED 603441 .961 1763784 .994 3199
> 0
> TRIGGER 28016 1 28016 1 0
> 0
> 8 rows selected.
> SVRMGR>
> SVRMGR> set charwidth 27;
> Charwidth 27
> SVRMGR> set numwidth 12;
> Numwidth 12
> SVRMGR> Rem The total is the total value of the statistic between
 the
> time
> SVRMGR> Rem bstat was run and the time estat was run. Note that
 the
> estat
> SVRMGR> Rem script logs on as "internal" so the per_logon
 statistics
> will
> SVRMGR> Rem always be based on at least one logon.
> SVRMGR> 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 Transact Per Logon
 Per
> Second
> --------------------------- ------------ ------------ ------------
> ------------
> CPU used by this session 1732569 37.36 1522.47
> 43.76
> CPU used when call started 1732584 37.37 1522.48
> 43.76
> CR blocks created 1439 .03 1.26
> .04
> DBWR buffers scanned 3284166 70.83 2885.91
> 82.94
> DBWR checkpoints 85533 1.84 75.16
> 2.16
> DBWR free buffers found 1173778 25.31 1031.44
> 29.64
> DBWR lru scans 14573 .31 12.81
> .37
> DBWR make free requests 8157 .18 7.17
> .21
> DBWR summed scan depth 4463549 96.26 3922.28
> 112.72
> DBWR timeouts 9444 .2 8.3
> .24
> SQL*Net roundtrips to/from 866177 18.68 761.14
> 21.87
> background checkpoints comp 48 0 .04
> 0
> background checkpoints star 48 0 .04
> 0
> background timeouts 38545 .83 33.87
> .97
> bytes received via SQL*Net 400852814 8644.84 352243.25
> 10123.31
> bytes sent via SQL*Net to c 272527521 5877.36 239479.37
> 6882.53
> calls to get snapshot scn: 883001 19.04 775.92
> 22.3
> calls to kcmgas 49958 1.08 43.9
> 1.26
> calls to kcmgcs 3762 .08 3.31
> .1
> calls to kcmgrs 1166153 25.15 1024.74
> 29.45
> change write time 1053 .02 .93
> .03
> cleanouts and rollbacks - c 313 .01 .28
> .01
> cleanouts only - consistent 700 .02 .62
> .02
> cluster key scan block gets 92950 2 81.68
> 2.35
> cluster key scans 42819 .92 37.63
> 1.08
> commit cleanout failures: b 4 0 0
> 0
> commit cleanout number succ 413446 8.92 363.31
> 10.44
> consistent changes 1619 .03 1.42
> .04
> consistent gets 235448312 5077.71 206896.58
> 5946.11
> cursor authentications 781404 16.85 686.65
> 19.73
> data blocks consistent read 1617 .03 1.42
> .04
> db block changes 1145794 24.71 1006.85
> 28.94
> db block gets 8201187 176.87 7206.67
> 207.12
> deferred (CURRENT) block cl 71569 1.54 62.89
> 1.81
> enqueue releases 375389 8.1 329.87
> 9.48
> enqueue requests 375554 8.1 330.01
> 9.48
> enqueue timeouts 171 0 .15
> 0
> enqueue waits 20415 .44 17.94
> .52
> execute count 873493 18.84 767.57
> 22.06
> free buffer inspected 262884 5.67 231.01
> 6.64
> free buffer requested 8807008 189.93 7739.02
> 222.42
> immediate (CR) block cleano 1013 .02 .89
> .03
> immediate (CURRENT) block c 137639 2.97 120.95
> 3.48
> logons cumulative 1138 .02 1
> .03
> logons current -9 0 -.01
> 0
> messages received 148202 3.2 130.23
> 3.74
> messages sent 148202 3.2 130.23
> 3.74
> no work - consistent read g 230489653 4970.77 202539.24
> 5820.89
> opened cursors cumulative 133274 2.87 117.11
> 3.37
> opened cursors current -27 0 -.02
> 0
> parse count 869429 18.75 764
> 21.96
> parse time cpu 65116 1.4 57.22
> 1.64
> parse time elapsed 69990 1.51 61.5
> 1.77
> physical reads 6237461 134.52 5481.07
> 157.52
> physical writes 468462 10.1 411.65
> 11.83
> process last non-idle time 409586845227 8833204.19 359918141.68
> 10343885.78
> recursive calls 1289703 27.81 1133.31
> 32.57
> recursive cpu usage 28555 .62 25.09
> .72
> redo blocks written 311853 6.73 274.04
> 7.88
> redo buffer allocation retr 8 0 .01
> 0
> redo entries 641061 13.83 563.32
> 16.19
> redo log space requests 12 0 .01
> 0
> redo log space wait time 354 .01 .31
> .01
> redo size 140429465 3028.52 123400.23
> 3546.47
> redo small copies 193391 4.17 169.94
> 4.88
> redo synch time 109026 2.35 95.8
> 2.75
> redo synch writes 48787 1.05 42.87
> 1.23
> redo wastage 13784697 297.28 12113.09
> 348.12
> redo write time 92147 1.99 80.97
> 2.33
> redo writer latching time 40 0 .04
> 0
> redo writes 49190 1.06 43.22
> 1.24
> rollback changes - undo rec 258 .01 .23
> .01
> rollbacks only - consistent 1123 .02 .99
> .03
> session connect time 409586845227 8833204.19 359918141.68
> 10343885.78
> session logical reads 241889847 5216.63 212556.98
> 6108.79
> session pga memory 420348336 9065.29 369374.64
> 10615.66
> session pga memory max 543493572 11721.05 477586.62
> 13725.62
> session uga memory 3689620 79.57 3242.2
> 93.18
> session uga memory max 141370108 3048.81 124226.81
> 3570.22
> sorts (disk) 1709 .04 1.5
> .04
> sorts (memory) 40083 .86 35.22
> 1.01
> sorts (rows) 535322217 11544.83 470406.17
> 13519.26
> summed dirty queue length 312200 6.73 274.34
> 7.88
> table fetch by rowid 214148680 4618.36 188179.86
> 5408.2
> table fetch continued row 107114 2.31 94.12
> 2.71
> table scan blocks gotten 14595982 314.78 12825.99
> 368.61
> table scan rows gotten 1027277337 22154.4 902704.16
> 25943.31
> table scans (long tables) 2736 .06 2.4
> .07
> table scans (short tables) 162619 3.51 142.9
> 4.11
> total number commit cleanou 414298 8.93 364.06
> 10.46
> transaction rollbacks 14 0 .01
> 0
> user calls 843465 18.19 741.18
> 21.3
> user commits 46369 1 40.75
> 1.17
> user rollbacks 20 0 .02
> 0
> write requests 19655 .42 17.27
> .5
> 95 rows selected.
> SVRMGR>
> SVRMGR>
> SVRMGR> set numwidth 27
> Numwidth 27
> SVRMGR> Rem Average length of the dirty buffer write queue. If
 this
> is larger
> SVRMGR> Rem than the value of:
> SVRMGR> Rem 1. (db_files * db_file_simultaneous_writes)/2
> SVRMGR> Rem or
> SVRMGR> Rem 2. 1/4 of db_block_buffers
> SVRMGR> Rem which ever is smaller and also there is a platform
> specific limit
> SVRMGR> Rem on the write batch size (normally 1024 or 2048
 buffers).
> If the average
> SVRMGR> Rem length of the dirty buffer write queue is larger than
 the
> value
> SVRMGR> Rem calculated before, increase db_file_simultaneous_writes
 or
> db_files.
> SVRMGR> Rem Also check for disks that are doing many more IOs than
> other disks.
> SVRMGR> 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
> ---------------------------
> 15.883998982447214449249555
> 1 row selected.
> SVRMGR>
> SVRMGR>
> SVRMGR> set charwidth 32;
> Charwidth 32
> SVRMGR> set numwidth 13;
> Numwidth 13
> SVRMGR> Rem System wide wait events for non-background processes
> (PMON,
> SVRMGR> Rem SMON, etc). Times are in hundreths of seconds. Each
 one
> of
> SVRMGR> Rem these is a context switch which costs CPU time. By
> looking at
> SVRMGR> Rem the Total Time you can often determine what is the
> bottleneck
> SVRMGR> Rem that processes are waiting for. This shows the total
 time
> spent
> SVRMGR> Rem waiting for a specific event and the average time per
 wait
> on
> SVRMGR> Rem that event.
> SVRMGR> 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 869550 625909468
> 719.81
> rdbms ipc reply 85490 599101
> 7.01
> enqueue 20423 240059
> 11.75
> free buffer waits 21546 190568
> 8.84
> log file sync 49065 108988
> 2.22
> db file sequential read 908831 43825
> .05
> SQL*Net more data from client 21351 40465
> 1.9
> db file scattered read 1216719 28796
> .02
> latch free 16444 5525
> .34
> write complete waits 57 644
> 11.3
> SQL*Net more data to client 58096 546
> .01
> SQL*Net message to client 869541 473
> 0
> log file switch completion 12 353
> 29.42
> buffer busy waits 42 318
> 7.57
> direct access I/O 22 44
> 2
> SQL*Net break/reset to client 40 15
> .38
> control file sequential read 975 8
> .01
> 17 rows selected.
> SVRMGR>
> SVRMGR>
> SVRMGR> Rem System wide wait events for background processes (PMON,
> SMON, etc)
> SVRMGR> 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 166568 14889820
> 89.39
> smon timer 243 3962153
> 16305.16
> pmon timer 13161 3959843
> 300.88
> db file parallel write 19655 366604
> 18.65
> log file parallel write 49190 92124
> 1.87
> timer in sksawat 2135 4282
> 2.01
> control file parallel write 1579 1647
> 1.04
> db file single write 1056 1009
> .96
> latch free 223 511
> 2.29
> db file sequential read 1135 402
> .35
> log file sync 39 219
> 5.62
> free buffer waits 7 145
> 20.71
> control file sequential read 1094 79
> .07
> log file single write 24 39
> 1.63
> rdbms ipc reply 6 33
> 5.5
> db file scattered read 66 27
> .41
> buffer busy waits 16 18
> 1.13
> log file sequential read 12 10
> .83
> 18 rows selected.
> SVRMGR>
> SVRMGR>
> SVRMGR> set charwidth 18;
> Charwidth 18
> SVRMGR> set numwidth 11;
> Numwidth 11
> SVRMGR> Rem Latch statistics. Latch contention will show up as a
 large
> value for
> SVRMGR> Rem the 'latch free' event in the wait events above.
> SVRMGR> Rem Sleeps should be low. The hit_ratio should be high.
> SVRMGR> 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
> ------------------ ----------- ----------- ----------- -----------
> -----------
> archive control 6 0 1 0
> 0
> cache buffer handl 974 0 1 0
> 0
> cache buffers chai 1882904849 8118 1 177
> .022
> cache buffers lru 2278790 2679 .999 154
> .057
> dml lock allocatio 252975 1 1 0
> 0
> enqueue hash chain 771404 646 .999 6
> .009
> enqueues 988110 28 1 0
> 0
> ktm global data 585 0 1 0
> 0
> latch wait list 28270 10 1 0
> 0
> library cache 22496393 16349 .999 1360
> .083
> library cache load 19398 0 1 0
> 0
> list of block allo 111387 0 1 0
> 0
> messages 833327 6739 .992 17
> .003
> modify parameter v 1138 0 1 0
> 0
> multiblock read ob 4014630 401 1 2
> .005
> process allocation 1057 0 1 0
> 0
> redo allocation 863642 390 1 7
> .018
> redo copy 2 2 0 1
> .5
> row cache objects 20894740 14959 .999 2156
> .144
> sequence cache 145247 4 1 0
> 0
> session allocation 108129 3 1 0
> 0
> session idle bit 1738615 5 1 0
> 0
> session switching 632 0 1 0
> 0
> shared pool 3194243 14049 .996 12787
> .91
> sort extent pool 92568 0 1 0
> 0
> system commit numb 2695683 150 1 0
> 0
> transaction alloca 150388 1 1 0
> 0
> undo global data 166721 5 1 0
> 0
> user lock 4242 0 1 0
> 0
> 29 rows selected.
> SVRMGR>
> SVRMGR> set numwidth 16
> Numwidth 16
> SVRMGR> Rem Statistics on no_wait gets of latches. A no_wait get
 does
> not
> SVRMGR> Rem wait for the latch to become free, it immediately times
> out.
> SVRMGR> 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 chai 16775674 125
 126
> cache buffers lru 21945298 22616
 22617
> library cache 337110 364
 365
> process allocation 1057 0
 1
> redo copy 644418 24
 25
> row cache objects 15886 47
 48
> 6 rows selected.
> SVRMGR>
> SVRMGR> Rem Buffer busy wait statistics. If the value for 'buffer
> busy wait' in
> SVRMGR> Rem the wait event statistics is high, then this table will
> identify
> SVRMGR> Rem which class of blocks is having high contention. If
 there
> are high
> SVRMGR> Rem 'undo header' waits then add more rollback segments.
 If
> there are
> SVRMGR> Rem high 'segment header' waits then adding freelists might
> help. Check
> SVRMGR> Rem v$session_wait to get the addresses of the actual
 blocks
> having
> SVRMGR> Rem contention.
> SVRMGR> select * from stats$waitstat
> 2> where count != 0
> 3> order by count desc;
> CLASS COUNT TIME
> ------------------ ---------------- ----------------
> data block 26 275
> undo header 25 25
> undo block 7 36
> 3 rows selected.
> SVRMGR>
> SVRMGR>
> SVRMGR> set numwidth 19;
> Numwidth 19
> SVRMGR> Rem Waits_for_trans_tbl high implies you should add
 rollback
> segments.
> SVRMGR> select * from stats$roll;
> UNDO_SEGMENT TRANS_TBL_GETS TRANS_TBL_WAITS
> UNDO_BYTES_WRITTEN SEGMENT_SIZE_BYTES XACTS SHRINKS
> WRAPS
> ------------------- ------------------- -------------------
> ------------------- ------------------- -------------------
> ------------
> ------- -------------------
> 0 244 0
> 0 892928 0
> 0 0
> 1 4300 0
> 2307729 20963328 0
> 0 1
> 2 4326 3
> 2225682 1138688 0
> 0 9
> 3 4316 1
> 2162012 1138688 0
> 0 9
> 4 4284 2
> 2091334 1138688 0
> 0 9
> 5 4381 1
> 2397055 1138688 0
> 0 10
> 6 4357 3
> 2273394 1138688 0
> 0 9
> 7 4336 1
> 2223538 2285568 0
> 0 9
> 8 4335 0
> 2254586 1138688 0
> 0 8
> 9 4354 0
> 2298591 1138688 0
> 0 9
> 10 4307 0
> 2210287 1138688 0
> 0 9
> 11 4376 0
> 2327139 1138688 1
> 0 9
> 12 4347 0
> 2257750 1138688 0
> 0 9
> 13 4289 1
> 2085959 1138688 0
> 0 8
> 14 4329 0
> 2205735 1138688 0
> 0 9
> 15 4306 1
> 2145751 1138688 0
> 0 8
> 16 4339 0
> 2245605 1425408 0
> 0 9
> 17 4364 1
> 2269226 1712128 -1
> 0 9
> 18 4322 0
> 2283698 2285568 0
> 0 9
> 19 4368 4
> 2281241 1138688 0
> 0 9
> 20 4337 0
> 2231631 1138688 0
> 0 9
> 21 4330 1
> 2271366 1138688 0
> 0 8
> 22 4342 1
> 2247156 2285568 0
> 0 9
> 23 4414 0
> 2399869 2285568 0
> 0 10
> 24 4370 1
> 2373355 1138688 0
> 0 9
> 25 4328 0
> 2236722 1138688 0
> 0 9
> 26 4389 0
> 2373402 1138688 0
> 0 10
> 27 rows selected.
> SVRMGR>
> SVRMGR> set charwidth 39
> Charwidth 39
> SVRMGR> Rem The init.ora parameters currently in effect:
> SVRMGR> select name, value from v$parameter where isdefault =
 'FALSE'
> 2> order by name;
> NAME VALUE
> ---------------------------------------
> ---------------------------------------
> always_anti_join HASH
> audit_trail DB
> background_dump_dest
> /oracle/app/oracle/admin/XXXXXXXX/bdump
> cache_size_threshold 6500
> checkpoint_process TRUE
> compatible 7.3.4.0.1
> control_files
> /XXXXXXXX/data01/oradata/XXXXXXXX/contr
> core_dump_dest
> /oracle/app/oracle/admin/XXXXXXXX/cdump
> cpu_count 4
> db_block_buffers 65000
> db_block_lru_latches 2
> db_block_size 8192
> db_files 40
> db_name XXXXXXXX
> distributed_transactions 152
> dml_locks 500
> enqueue_resources 1000
> gc_freelist_groups 50
> gc_releasable_locks 65000
> ifile
> /oracle/app/oracle/admin/XXXXXXXX/pfile
> log_archive_dest
 /XXXXXXXX/archive01/XXXXXXXX
> log_archive_format XXXXXXXX_arch%s.log
> log_archive_start TRUE
> log_block_checksum TRUE
> log_buffer 10240000
> log_checkpoint_interval 6400
> log_simultaneous_copies 4
> max_dump_file_size 102400
> mts_max_dispatchers 0
> mts_max_servers 0
> mts_servers 0
> mts_service XXXXXXXX
> open_cursors 64
> optimizer_mode CHOOSE
> parallel_max_servers 0
> processes 500
> remote_login_passwordfile NONE
> rollback_segments r01, r02, r03, r04, r05,
 r06,
> r07, r08,
> sequence_cache_entries 100
> sequence_cache_hash_buckets 89
> sessions 555
> shared_pool_size 200000000
> sort_area_retained_size 65536
> sort_direct_writes AUTO
> temporary_table_locks 555
> timed_statistics TRUE
> transactions 610
> transactions_per_rollback_segment 71
> user_dump_dest
> /oracle/app/oracle/admin/XXXXXXXX/udump
> 49 rows selected.
> SVRMGR>
> SVRMGR> set charwidth 15;
> Charwidth 15
> SVRMGR> set numwidth 8;
> Numwidth 8
> SVRMGR> Rem get_miss and scan_miss should be very low compared to
 the
> requests.
> SVRMGR> Rem cur_usage is the number of entries in the cache that
 are
> being used.
> SVRMGR> select * from stats$dc
> 2> where get_reqs != 0 or scan_reqs != 0 or mod_reqs != 0;
> NAME GET_REQS GET_MISS SCAN_REQ SCAN_MIS MOD_REQS COUNT
> CUR_USAG
> --------------- -------- -------- -------- -------- --------

---

> --------
> dc_tablespaces 1983 0 0 0 0
 7
> 6
> dc_free_extents 378 6 6 0 18
 1292
> 371
> dc_segments 540635 0 0 0 6
 1339
> 1329
> dc_rollback_seg 13293 0 0 0 0
 35
> 28
> dc_used_extents 6 6 0 0 6
 1125
> 1124
> dc_users 66212 4 0 0 8
 262
> 259
> dc_users 2196 3 0 0 0
 260
> 250
> dc_user_grants 8252 5 0 0 0
 256
> 255
> dc_objects 292051 698 0 0 0
 25547
> 25544
> dc_tables 1026146 0 0 0 0
 667
> 654
> dc_columns 6867055 0 197097 0 0
 6965
> 6913
> dc_table_grants 921317 6 0 0 0
 818
> 781
> dc_indexes 507222 0 76879 0 0
 1192
> 1191
> dc_constraint_d 128887 0 147288 0 0
 178
> 160
> dc_constraint_d 0 0 70650 0 0
 1
> 0
> dc_synonyms 76670 0 0 0 0
 214
> 212
> dc_usernames 88730 5 0 0 1
 269
> 261
> dc_object_ids 10329896 0 0 0 0
 513
> 511
> dc_sequences 83157 0 0 0 529
 35
> 34
> dc_sequence_gra 123979 0 0 0 0
 134
> 63
> dc_tablespaces 6 0 0 0 6
 7
> 6
> dc_histogram_de 85486 0 0 0 0
 5226
> 5201
> 22 rows selected.
> SVRMGR>
> SVRMGR>
> SVRMGR> set charwidth 80;
> Charwidth 80
> SVRMGR> set numwidth 10;
> Numwidth 10
> SVRMGR> Rem Sum IO operations over tablespaces.
> SVRMGR> 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
>

---

---

---

> ---------- ---------- ---------- ---------- --------
> -- ---------- ----------
> CLAR_INDEX
> 33071 33071 27491 43643 436
> 43 188765 3144
> RBS
> 0 0 0
Received on Tue Aug 28 2001 - 02:53:14 CDT