bstat-estat-rpt.txt 05-28-2001 Bikle -------------------- This file contains the output of a bstat-estat report which was started on 27-may-01 15:29:24 and ended on 29-may-01 04:50:06. During this time, I ran a resource intensive Accipiter report and a SQL query which kept the machine busy over a 26 hour period. The report is displayed below: SVRMGR> SVRMGR> set charwidth 12 Charwidth 12 SVRMGR> set numwidth 10 Numwidth 10 SVRMGR> Rem Select Library cache statistics. The pin hit rate should 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 ------------ ---------- ---------- ---------- ---------- ---------- ---------- SQL AREA 1629208 .531 11048132 .807 526566 45551 TABLE/PROCED 2188756 .999 4271575 .999 1867 0 BODY 144 .951 144 .882 10 0 TRIGGER 0 1 0 1 0 0 INDEX 681 .667 681 .667 0 0 CLUSTER 1779 .991 1967 .985 1 0 OBJECT 0 1 0 1 0 0 PIPE 0 1 0 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 --------------------------- ------------ ------------ ------------ ------------ CR blocks created 2934 .01 12.87 .02 Current blocks converted fo 11273 .04 49.44 .08 DBWR Flush object call foun 4 0 .02 0 DBWR Flush object cross ins 14 0 .06 0 DBWR buffers scanned 12750867 47.78 55924.86 94.84 DBWR checkpoint buffers wri 50585 .19 221.86 .38 DBWR checkpoint write reque 2326 .01 10.2 .02 DBWR checkpoints 46 0 .2 0 DBWR free buffers found 7127069 26.7 31259.07 53.01 DBWR lru scans 5368 .02 23.54 .04 DBWR make free requests 3040 .01 13.33 .02 DBWR revisited being-writte 192 0 .84 0 DBWR skip hot writes 212 0 .93 0 DBWR summed scan depth 12751354 47.78 55926.99 94.85 DBWR transaction table writ 1827 .01 8.01 .01 DBWR undo block writes 41252 .15 180.93 .31 SQL*Net roundtrips to/from 7493338 28.08 32865.52 55.74 background checkpoints comp 36 0 .16 0 background checkpoints star 36 0 .16 0 background timeouts 175708 .66 770.65 1.31 buffer is not pinned count 13996811 52.45 61389.52 104.11 buffer is pinned count 13250121 49.65 58114.57 98.56 bytes received via SQL*Net 1202832818 4506.93 5275582.54 8946.85 bytes sent via SQL*Net to c 5024769344 18827.47 22038462.04 37375 calls to get snapshot scn: 6997848 26.22 30692.32 52.05 calls to kcmgas 268997 1.01 1179.81 2 calls to kcmgcs 1241 0 5.44 .01 cleanouts and rollbacks - c 3 0 .01 0 cleanouts only - consistent 1303 0 5.71 .01 cluster key scan block gets 139796 .52 613.14 1.04 cluster key scans 55146 .21 241.87 .41 commit cleanout failures: b 41 0 .18 0 commit cleanout failures: b 62 0 .27 0 commit cleanout failures: c 14 0 .06 0 commit cleanouts 2421634 9.07 10621.2 18.01 commit cleanouts successful 2421517 9.07 10620.69 18.01 consistent changes 192451 .72 844.08 1.43 consistent gets 225260294 844.04 987983.75 1675.52 cursor authentications 380049 1.42 1666.88 2.83 data blocks consistent read 192451 .72 844.08 1.43 db block changes 12212310 45.76 53562.76 90.84 db block gets 7974165 29.88 34974.41 59.31 deferred (CURRENT) block cl 2028742 7.6 8897.99 15.09 dirty buffers inspected 487 0 2.14 0 enqueue conversions 32 0 .14 0 enqueue releases 951989 3.57 4175.39 7.08 enqueue requests 952004 3.57 4175.46 7.08 enqueue timeouts 21 0 .09 0 enqueue waits 5 0 .02 0 execute count 6867002 25.73 30118.43 51.08 free buffer inspected 2266 .01 9.94 .02 free buffer requested 2205234 8.26 9672.08 16.4 immediate (CR) block cleano 1306 0 5.73 .01 immediate (CURRENT) block c 367368 1.38 1611.26 2.73 logons cumulative 228 0 1 0 messages received 195578 .73 857.8 1.45 messages sent 195578 .73 857.8 1.45 no work - consistent read g 197735252 740.9 867259.88 1470.78 opened cursors cumulative 1625199 6.09 7128.07 12.09 parse count (hard) 1290496 4.84 5660.07 9.6 parse count (total) 1629187 6.1 7145.56 12.12 physical reads 2388121 8.95 10474.21 17.76 physical writes 317531 1.19 1392.68 2.36 recursive calls 1915540 7.18 8401.49 14.25 redo blocks written 3586067 13.44 15728.36 26.67 redo buffer allocation retr 86 0 .38 0 redo entries 6275805 23.52 27525.46 46.68 redo log space requests 104 0 .46 0 redo size 1720561516 6446.83 7546322.44 12797.8 redo small copies 641178 2.4 2812.18 4.77 redo synch writes 267449 1 1173.02 1.99 redo wastage 57701756 216.2 253077.88 429.19 redo writes 232761 .87 1020.88 1.73 rollback changes - undo rec 3 0 .01 0 rollbacks only - consistent 21164 .08 92.82 .16 session logical reads 232813720 872.34 1021112.81 1731.7 session pga memory 267641872 1002.84 1173867.86 1990.76 session pga memory max 279215024 1046.2 1224627.3 2076.84 session uga memory 904832 3.39 3968.56 6.73 session uga memory max 29453604 110.36 129182.47 219.08 sorts (disk) 8 0 .04 0 sorts (memory) 12133 .05 53.21 .09 sorts (rows) 46211007 173.15 202679.86 343.72 summed dirty queue length 341 0 1.5 0 table fetch by rowid 13185329 49.4 57830.39 98.07 table fetch continued row 90 0 .39 0 table scan blocks gotten 966285 3.62 4238.09 7.19 table scan rows gotten 232884111 872.6 1021421.54 1732.23 table scans (long tables) 20 0 .09 0 table scans (short tables) 16936 .06 74.28 .13 total file opens 1529 .01 6.71 .01 transaction rollbacks 3 0 .01 0 user calls 9094052 34.07 39886.19 67.64 user commits 266885 1 1170.55 1.99 user rollbacks 35 0 .15 0 write requests 3643 .01 15.98 .03 96 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 --------------------------- .09360417238539665111172111 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 -------------------------------- ------------- ------------- ------------- latch free 210771 0 0 rdbms ipc reply 178 0 0 enqueue 71 0 0 control file sequential read 128514 0 0 control file single write 22 0 0 control file parallel write 247 0 0 refresh controlfile command 4936 0 0 write complete waits 1733 0 0 buffer busy waits 53955 0 0 log file sequential read 797 0 0 switch logfile command 2 0 0 log file switch completion 104 0 0 log file sync 267652 0 0 db file sequential read 1435863 0 0 db file scattered read 204138 0 0 db file single write 48 0 0 direct path write 70 0 0 file identify 299 0 0 file open 1414 0 0 SQL*Net message to client 7494015 0 0 SQL*Net more data to client 6266554 0 0 SQL*Net message from client 7494013 0 0 SQL*Net more data from client 48 0 0 SQL*Net break/reset to client 60 0 0 24 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 -------------------------------- ------------- ------------- ------------- buffer busy waits 3 0 0 control file parallel write 43520 0 0 control file sequential read 16284 0 0 db file parallel write 3643 0 0 db file scattered read 257 0 0 db file sequential read 1804 0 0 db file single write 864 0 0 enqueue 5 0 0 file identify 174 0 0 file open 140 0 0 latch free 903 0 0 log file parallel write 232761 0 0 log file sequential read 27270 0 0 log file single write 72 0 0 log file sync 50 0 0 pmon timer 44694 0 0 rdbms ipc message 360649 0 0 smon timer 448 0 0 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 ------------------ ----------- ----------- ----------- ----------- ----------- Active checkpoint 92183 22 1 0 0 Checkpoint queue l 5215487 200 1 10 .05 Token Manager 2938 0 1 0 0 archive control 72 0 1 0 0 begin backup scn a 52 0 1 0 0 cache buffer handl 26436 0 1 0 0 cache buffers chai 463653257 5338 1 126 .024 cache buffers lru 40459 132 .997 29 .22 dml lock allocatio 538517 110 1 25 .227 enqueue hash chain 1904101 676 1 171 .253 enqueues 4207459 1021 1 124 .121 file number transl 14 0 1 0 0 ktm global data 448 0 1 0 0 latch wait list 206091 187 .999 24 .128 library cache 55043455 128723 .998 28354 .22 library cache load 10670 0 1 0 0 list of block allo 537951 69 1 12 .174 loader state objec 24 0 1 0 0 messages 1279453 1948 .998 12 .006 modify parameter v 2378 5 .998 15 3 multiblock read ob 410660 0 1 0 0 ncodef allocation 2150 0 1 0 0 process allocation 215 0 1 0 0 redo allocation 6779898 12004 .998 2255 .188 redo copy 1125 1096 .026 724 .661 redo writing 1172463 1019 .999 187 .184 row cache objects 25573463 3868 1 108 .028 sequence cache 702 0 1 0 0 session allocation 2973058 468 1 56 .12 session idle bit 19672179 1149 1 215 .187 session switching 2150 0 1 0 0 shared pool 34633543 258844 .993 179073 .692 sort extent pool 829 0 1 0 0 transaction alloca 812646 393 1 75 .191 transaction branch 2150 0 1 0 0 undo global data 935725 809 .999 76 .094 user lock 727576 3 1 1 .333 37 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 ------------------ ---------------- ---------------- ---------------- Token Manager 239025 0 1 cache buffers chai 3097556 99 1 cache buffers lru 69672969 40527 .999 i/o slave adaptor 239025 0 1 latch wait list 206177 444 .998 library cache 2686902 8834 .997 multiblock read ob 2 0 1 process allocation 215 0 1 redo copy 6564533 3408 .999 row cache objects 238938 128 .999 vecio buf des 239025 0 1 11 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 53950 0 undo block 5 0 undo header 3 0 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 458 0 0 835584 0 0 0 1 62230 0 67788314 104841216 0 0 7 2 62330 0 67963842 104841216 0 0 6 3 62296 0 67964924 104841216 0 0 7 4 15505 0 16843778 104841216 0 0 1 5 62241 0 67759772 104841216 1 0 7 6 62256 0 67646582 104841216 0 0 6 7 62272 0 67727292 104841216 -1 0 6 8 62207 1 67530600 104841216 0 0 7 9 62189 0 67693238 104841216 0 0 6 10 62208 0 67626188 104841216 0 0 7 11 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 --------------------------------------- --------------------------------------- background_dump_dest /opt/bikle/oracle/admin/ZCCP/bdump commit_point_strength 20 compatible 8.0.5.1.0 control_file_record_keep_time 0 control_files /oradata/u001/ZCCP/ZCCP_control_01.dbf, core_dump_dest /opt/bikle/oracle/admin/ZCCP/cdump db_block_buffers 19200 db_block_lru_latches 2 db_block_size 16384 db_domain bikle.co.jp db_file_multiblock_read_count 4 db_files 1000 db_name ZCCP db_writer_processes 2 disk_asynch_io FALSE dml_locks 3000 enqueue_resources 5000 global_names TRUE log_archive_buffer_size 127 log_archive_buffers 4 log_archive_dest /oradata/u008/ZCCP log_archive_format ZCCP_redolog_%S.arc log_archive_start TRUE log_buffer 10485760 log_simultaneous_copies 4 max_dump_file_size 10240 max_enabled_roles 48 open_cursors 300 open_links 5 optimizer_mode CHOOSE parallel_max_servers 4 parallel_min_percent 0 parallel_min_servers 0 parallel_server_idle_time 5 processes 700 recovery_parallelism 4 remote_os_authent FALSE rollback_segments r01, r02, r03, r04, r05, r06, r07, r08, sequence_cache_entries 30 sequence_cache_hash_buckets 23 sessions 700 shared_pool_reserved_size 15000000 shared_pool_size 150000000 sort_area_size 1056768 timed_statistics FALSE transactions 550 transactions_per_rollback_segment 55 user_dump_dest /opt/bikle/oracle/admin/ZCCP/udump 48 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_free_extents 11207 21 12 0 34 38 36 dc_used_extents 1286066 10 0 0 16 53 52 dc_segments 2583664 198 0 0 33 362 361 dc_tablespaces 51 1 0 0 0 6 5 dc_tablespace_q 10 0 0 0 7 23 5 dc_users 371167 4 0 0 0 17 16 dc_rollback_seg 9892 0 0 0 0 13 12 dc_objects 1295564 591 0 0 117 347 343 dc_object_ids 1298562 301 0 0 7 290 286 dc_synonyms 176 29 0 0 32 36 32 dc_sequences 61 0 0 0 30 9 4 dc_usernames 4369 1 0 0 0 21 14 dc_histogram_de 1779566 1726 7 0 1955 235 234 dc_profiles 199 0 0 0 0 12 1 dc_user_grants 4504 6 0 0 0 12 11 15 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 ------------------------------------------------------------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- DATA01 131493 155599 0 6056 6056 0 525 DATA02 3 3 0 0 0 0 314 DATA03 645414 1230731 0 64934 64970 0 6136 INDEX01 66139 66139 0 2085 2084 0 210 INDEX02 36 36 0 0 0 0 1573 INDEX03 669084 669084 0 49329 49357 0 7342 RBS 30549 30549 0 42916 42957 0 2097 SYSTEM 5471 7403 0 327 327 0 315 TEMP 92583 228379 0 75827 151529 0 2097 TOOLS 83 197 0 5 5 0 105 USERS 0 0 0 0 0 0 10 11 rows selected. SVRMGR> SVRMGR> SVRMGR> set charwidth 48; Charwidth 48 SVRMGR> set numwidth 10; Numwidth 10 SVRMGR> Rem I/O should be spread evenly accross drives. A big difference between SVRMGR> Rem phys_reads and phys_blks_rd implies table scans are going on. SVRMGR> 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 ------------------------------ ------------------------------------------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- DATA01 /oradata/u005/ZCCP/ZCCP_data01_01.dbf 131306 155101 0 5938 5938 0 315 DATA01 /oradata/u005/ZCCP/ZCCP_data01_02.dbf 187 498 0 118 118 0 210 DATA02 /oradata/u005/ZCCP/ZCCP_data02_01.dbf 3 3 0 0 0 0 157 DATA02 /oradata/u005/ZCCP/ZCCP_data02_02.dbf 0 0 0 0 0 0 157 DATA03 /oradata/u006/ZCCP/ZCCP_data03_01.dbf 77053 298292 0 3738 3739 0 1940 DATA03 /oradata/u006/ZCCP/ZCCP_data03_02.dbf 45688 182734 0 0 0 0 1049 DATA03 /oradata/u006/ZCCP/ZCCP_data03_03.dbf 447002 581216 0 360 360 0 1049 DATA03 /oradata/u006/ZCCP/ZCCP_data03_05.dbf 22070 86884 0 1634 1652 0 1049 DATA03 /oradata/u006/ZCCP/ZCCP_data03_06.dbf 53601 81605 0 59202 59219 0 1049 INDEX01 /oradata/u007/ZCCP/ZCCP_index01_01.dbf 58403 58403 0 1813 1812 0 105 INDEX01 /oradata/u007/ZCCP/ZCCP_index01_02.dbf 7736 7736 0 272 272 0 105 INDEX02 /oradata/u007/ZCCP/ZCCP_index02_01.dbf 36 36 0 0 0 0 1049 INDEX02 /oradata/u007/ZCCP/ZCCP_index02_02.dbf 0 0 0 0 0 0 524 INDEX03 /oradata/u006/ZCCP/ZCCP_data03_04.dbf 91251 91252 0 95 95 0 1049 INDEX03 /oradata/u008/ZCCP/ZCCP_index03_01.dbf 122835 122835 0 185 185 0 2097 INDEX03 /oradata/u008/ZCCP/ZCCP_index03_02.dbf 46236 46236 0 0 0 0 1049 INDEX03 /oradata/u008/ZCCP/ZCCP_index03_03.dbf 330252 330251 0 855 855 0 1049 INDEX03 /oradata/u008/ZCCP/ZCCP_index03_05.dbf 78510 78510 0 48194 48222 0 1049 INDEX03 /oradata/u008/ZCCP/ZCCP_index03_06.dbf 0 0 0 0 0 0 1049 RBS /oradata/u003/ZCCP/ZCCP_rbs_01.dbf 30549 30549 0 42916 42957 0 2097 SYSTEM /oradata/u004/ZCCP/ZCCP_system_01.dbf 5471 7403 0 327 327 0 315 TEMP /oradata/u002/ZCCP/ZCCP_temp_01.dbf 92583 228379 0 75827 151529 0 2097 TOOLS /oradata/u004/ZCCP/ZCCP_tools_01.dbf 83 197 0 5 5 0 105 USERS /oradata/u004/ZCCP/ZCCP_users_01.dbf 0 0 0 0 0 0 10 24 rows selected. SVRMGR> SVRMGR> SVRMGR> set charwidth 25 Charwidth 25 SVRMGR> Rem The times that bstat and estat were run. SVRMGR> 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 ------------------ ------------------ 27-may-01 15:29:24 29-may-01 04:50:06 1 row selected. SVRMGR> SVRMGR> set charwidth 75 Charwidth 75 SVRMGR> Rem Versions SVRMGR> select * from v$version; BANNER ---------------------------------------------------------------- Oracle8 Enterprise Edition Release 8.0.5.2.0 - Production PL/SQL Release 8.0.5.2.0 - Production CORE Version 4.0.5.0.0 - Production TNS for Solaris: Version 8.0.5.0.0 - Production NLSRTL Version 3.3.2.0.0 - Production 5 rows selected. SVRMGR> SVRMGR> SVRMGR> spool off; xy-bikle1.bikle.co.jp-csh-12 %