当前位置:文档之家› 数据库检查报告模版

数据库检查报告模版

数据库系统远程性能监测报告模版文档控制修改记录审阅分发目录文档控制i概述1数据库配置1非缺省的数据库参数:1 Sga 占用情况3数据文件使用情况4表空间管理方式和碎片17 Tablespaces Free Space17排序区的使用情况:18回滚段:Rollback Segments19使用system 表空间的表和索引21表的数据行迁移情况21 Users错误!未定义书签。

日志切换检查21 Errors Check22系统空间使用情况:错误!未定义书签。

系统和数据库的性能22操作系统性能监视22数据库配置和监控(statspack报告摘录) 22运行优势26需改进的方面:26本次检查已经解决的问题:26建议27应立即解决的问题27将来应解决的问题27介绍在此次的ORACLE专家服务中我们完成了对呼和浩特计费系统(服务器位于:呼和浩特网通机房)的健康检查,在这次检查中我们发现了一些与数据库相关的的一些潜在的问题,同时我们对计费系统也有了更深入的了解,我们将根据所搜集的信息得出下面的报告。

在此,我们感谢呼和浩特网通及内蒙网通公司对此次系统检查所给予的积极的支持和配合!读者此系统健康检查报告供下列读者使用:概述此次数据库健康检查主….数据库,下几个方面:数据库配置,数据库可用性及性能,我们观察到该系统在数据库的参数以及存储方面的设置或配置尚好,同时也发现了一些潜在的问题,在下面的建议部分,我们将提出相关的改进措施。

数据库配置非缺省的数据库参数:使用的参数文件:pfile节点1:End valueParameter Name Begin value (if different)----------------------------- --------------------------------- --------------_lm_direct_sends lkmgr_sqlexec_progression_cost 0background_dump_dest /o8i/app/oracle/admin/hhlbas/bdumcompatible 8.1.0control_files /dev/vgora/rcontrol1, /dev/vgora/core_dump_dest /o8i/app/oracle/admin/hhlbas/cdumdb_block_buffers 25600db_block_lru_latches 2db_block_size 8192db_file_multiblock_read_count 4db_name hhlbasdb_writer_processes 2disk_asynch_io FALSEdml_locks 100000ifile /o8i/app/oracle/admin/hhlbas/pfil instance_name hhlbasjava_pool_size 32768job_queue_interval 30job_queue_processes 5large_pool_size 614400lm_locks 200000, 200000lm_ress 100000, 100000log_archive_dest /arch2/log_archive_format arch_%t_%s.arclog_archive_start TRUElog_buffer 67108864log_checkpoint_interval 100000log_checkpoint_timeout 0max_enabled_roles 30open_cursors 1500os_authent_prefixparallel_automatic_tuning TRUEparallel_server TRUEprocesses 300remote_login_passwordfile EXCLUSIVErollback_segments rbs2_1, rbs2_2, rbs2_3, rbs2_4, rservice_namessession_cached_cursors 50shared_pool_size 157286400sort_area_retained_size 655360sort_area_size 655360thread 2timed_statistics TRUEtransactions_per_rollback_seg 8user_dump_dest /o8i/app/oracle/admin/hhlbas/udum节点2同1建议:disk_asynch_io 改为truelog_buffer 改成3Mdb_file_multiblock_read_count 改成8gc_files_to_locks 设成1,8-25,27-30,32-79,81,83-141=2000each Sga 占用情况SQL> select * from v$sgastat;Total System Global Area 599955944 bytesFixed Size 104936 bytesVariable Size 323018752 bytesDatabase Buffers 209715200 bytesRedo Buffers 67117056 bytesPOOL NAME BYTES----------- -------------------------- ----------fixed_sga 104936db_block_buffers 209715200log_buffer 67108864shared pool free memory 33097768shared pool miscellaneous 4358952shared pool dlm shared memory 18941486shared pool processes 348000shared pool gc_* 3584000shared pool fixed allocation callback 2072shared pool view columns d 488shared pool PLS non-lib hp 2136POOL NAME BYTES----------- -------------------------- ----------shared pool KGK heap 13624shared pool trigger inform 12248shared pool dlm process array 274512shared pool KGFF heap 102576shared pool sessions 814720shared pool State objects 101752448shared pool db_block_buffers 6144000shared pool db_block_hash_buckets 1024048shared pool enqueue_resources 10422880shared pool log_buffer 1572864shared pool KQLS heap 4107280POOL NAME BYTES----------- -------------------------- ----------shared pool dictionary cache 5293096shared pool errors 6544shared pool PL/SQL DIANA 1529528shared pool table columns 30656shared pool library cache 55839696shared pool PX subheap 66032shared pool sql area 25481496shared pool table definiti 2584shared pool PL/SQL MPCODE 29000944shared pool transactions 559360shared pool DML locks 16800000POOL NAME BYTES----------- -------------------------- ----------shared pool event statistics per sess 1163120large pool free memory 299976large pool PX msg pool 314424java pool free memory 32768建议:数据文件使用情况column file_id format 99999column file_name format a25column bytes format 9999999999column status format a10column autoextensible format a10Select file_id,file_name,bytes,status,autoextensible from dba_data_files;TABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- -----------STATUS AUTOEXTENS---------- ----------SYSTEM 1 /dev/vgora/rsystem 1048576000AVAILABLE NOTOOLS 2 /dev/vgora/rtools208666624AVAILABLE NORBS 3 /dev/vgora/rrollback1 2095054848AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------TEMP 4 /dev/vgora/rtemp 1047527424AVAILABLE NOUSERS 5 /dev/vgora/rusers313524224AVAILABLE NORBS 6 /dev/vgora/rrollback2 2095054848AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------RBS 7 /dev/vgora/rrollback3 2095054848AVAILABLE NOBILLDATA2 8 /dev/vgora/rapp01 2095054848 AVAILABLE NOBILLDATA1 9 /dev/vgora/rapp11 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA2 10 /dev/vgora/rapp02 2095054848 AVAILABLE NOBILLDATA2 11 /dev/vgora/rapp03 2095054848 AVAILABLE NOBILLDATA2 12 /dev/vgora/rapp04 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS-------- ----------BILLDATA2 13 /dev/vgora/rapp05 2095054848 AVAILABLE NOBILLDATA2 14 /dev/vgora/rapp06 2095054848 AVAILABLE NOBILLDATA2 15 /dev/vgora/rapp07 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA2 16 /dev/vgora/rapp08 2095054848 AVAILABLE NOBILLDATA2 17 /dev/vgora/rapp09 2095054848 AVAILABLE NOBILLDATA2 18 /dev/vgora/rapp10 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA1 19 /dev/vgora/rapp12 2095054848 AVAILABLE NOBILLDATA1 20 /dev/vgora/rapp13 2095054848 AVAILABLE NOBILLDATA1 21 /dev/vgora/rapp14 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA1 22 /dev/vgora/rapp15 2095054848 AVAILABLE NOBILLDATA2 23 /dev/vgora/rapp16 2095054848 AVAILABLE NOBILLDATA2 24 /dev/vgora/rapp17 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA2 25 /dev/vgora/rapp18 2095054848 AVAILABLE NOBILLTEMP 26 /dev/vgora/rapp28 2095054848 AVAILABLE NOBILLDATA2 27 /dev/vgora/rapp19 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA2 28 /dev/vgora/rapp20 2095054848 AVAILABLE NOBILLINDEX1 29 /dev/vgora/rapp21 2095054848 AVAILABLE NOBILLINDEX1 30 /dev/vgora/rapp22 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLTEMP 31 /dev/vgora/rapp31 2095054848 AVAILABLE NOBILLINDEX1 32 /dev/vgora/rapp23 2095054848 AVAILABLE NOBILLINDEX1 33 /dev/vgora/rapp24 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX1 34 /dev/vgora/rapp25 2095054848 AVAILABLE NOBILLDATA1 35 /dev/vgora/rapp26 2095054848AVAILABLE NOBILLDATA1 36 /dev/vgora/rapp27 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX1 37 /dev/vgora/rapp29 2095054848 AVAILABLE NOBILLINDEX1 38 /dev/vgora/rapp30 2095054848 AVAILABLE NOBILLDATA0 39 /dev/vgora/rapp32 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA0 40 /dev/vgora/rapp33 2095054848 AVAILABLE NOBILLDATA0 41 /dev/vgora/rapp34 2095054848 AVAILABLE NOBILLDATA0 42 /dev/vgora/rapp35 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA0 43 /dev/vgora/rapp36 2095054848 AVAILABLE NOBILLDATA1 44 /dev/vgora/rapp37 2095054848 AVAILABLE NOBILLDATA1 45 /dev/vgora/rapp38 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX 46 /dev/vgora/rapp39 2095054848BILLINDEX 47 /dev/vgora/rapp40 2095054848 AVAILABLE NOBILLINDEX 48 /dev/vgora/rapp41 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA 49 /dev/vgora/rapp42 2095054848 AVAILABLE NOBILLDATA0 50 /dev/vgora/rapp43 2095054848 AVAILABLE NOBILLDATA0 51 /dev/vgora/rapp44 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA0 52 /dev/vgora/rapp45 2095054848 AVAILABLE NOBILLDATA0 53 /dev/vgora/rapp46 2095054848 AVAILABLE NOBILLDATA0 54 /dev/vgora/rapp47 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA0 55 /dev/vgora/rapp48 2095054848 AVAILABLE NOBILLDATA1 56 /dev/vgora/rapp49 2095054848 AVAILABLE NOBILLDATA0 57 /dev/vgora/rapp50 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA0 59 /dev/vgora/rapp52 2095054848 AVAILABLE NOBILLDATA3 60 /dev/vgora/rapp57 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA3 61 /dev/vgora/rapp53 2095054848 AVAILABLE NOBILLDATA3 62 /dev/vgora/rapp54 2095054848 AVAILABLE NOBILLTEMP 63 /dev/vgora/rapp56 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA3 64 /dev/vgora/rapp55 2095054848 AVAILABLE NOBILLDATA3 65 /dev/vgora/rapp58 2095054848 AVAILABLE NOBILLDATA3 66 /dev/vgora/rapp59 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA0 67 /dev/vgora/rapp60 2095054848 AVAILABLE NOBILLDATA3 68 /dev/vgora/rapp61 2095054848 AVAILABLE NOBILLDATA3 69 /dev/vgora/rapp62 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENSAVAILABLE NOBILLINDEX3 71 /dev/vgora/rapp64 2095054848 AVAILABLE NOBILLINDEX3 72 /dev/vgora/rapp65 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX 73 /dev/vgora/rapp66 2095054848 AVAILABLE NOBILLINDEX 74 /dev/vgora/rapp67 2095054848 AVAILABLE NOBILLDATA 75 /dev/vgora/rapp68 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX 76 /dev/vgora/rapp69 2095054848 AVAILABLE NOBILLDATA4 77 /dev/vgora/rapp70 2095054848 AVAILABLE NOBILLDATA4 78 /dev/vgora/rapp71 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA4 79 /dev/vgora/rapp72 2095054848 AVAILABLE NOBILLTEMP 80 /dev/vgora/rapp73 2095054848 AVAILABLE NOINTERFACE_KFXT 81 /dev/vgora/rapp76 2095054848AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES---------- ----------RBS 82 /dev/vgora/rapp75 2092957696AVAILABLE NOBILLINDEX1 83 /dev/vgora/rapp77 2095054848 AVAILABLE NOBILLINDEX 84 /dev/vgora/rapp78 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA1 85 /dev/vgora/rapp79 2095054848 AVAILABLE NOBILLINDEX1 86 /dev/vgora/rapp80 2095054848 AVAILABLE NOBILLINDEX1 87 /dev/vgora/rapp81 2095054848 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA 88 /dev/vgora/rapp82 2092957696 AVAILABLE NOBILLDATA1 89 /dev/vgora/rapp85 2092957696 AVAILABLE NOBILLINDEX 90 /dev/vgora/rapp83 2092957696 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX1 91 /dev/vgora/rapp84 2092957696 AVAILABLE NOBILLDATA 92 /dev/vgora/rapp86 2092957696 AVAILABLE NOBILLDATA1 93 /dev/vgora/rapp87 2092957696 AVAILABLE NO------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX1 94 /dev/vgora/rapp88 2092957696 AVAILABLE NOBILLDATA4 95 /dev/vgora/rapp89 2092957696 AVAILABLE NOBILLTEMP 96 /dev/vgora/rapp90 2092957696 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX1 97 /dev/vgora/rapp91 2092957696 AVAILABLE NOBILLDATA 98 /dev/vgora/rapp92 2092957696 AVAILABLE NOBILLDATA1 99 /dev/vgora/rapp93 2092957696 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA3 100 /dev/vgora/rapp94 2092957696 AVAILABLE NOBILLINDEX 101 /dev/vgora/rapp95 2092957696 AVAILABLE NOBILLINDEX1 102 /dev/vgora/rapp96 2092957696 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX1 103 /dev/vgora/rapp97 2092957696 AVAILABLE NOBILLDATA4 104 /dev/vgora/rapp98 2092957696 AVAILABLE NOBILLINDEX1 105 /dev/vgora/rapp99 2092957696 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX 106 /dev/vgora/rapp100 2092957696 AVAILABLE NOBILLDATA0 107 /dev/vgora/rapp101 2092957696 AVAILABLE NOBILLDATA1 108 /dev/vgora/rapp102 2092957696 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX 109 /dev/vgora/rapp103 2092957696 AVAILABLE NOBILLINDEX3 110 /dev/vgora/rapp104 2092957696 AVAILABLE NOBILLDATA3 111 /dev/vgora/rapp105 2092957696 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA3 112 /dev/vgora/rapp106 2092957696 AVAILABLE NOBILLDATA3 113 /dev/vgora/rapp107 2092957696 AVAILABLE NOBILLDATA3 114 /dev/vgora/rapp108 2092957696 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA3 115 /dev/vgora/rapp109 2092957696 AVAILABLE NOBILLDATA3 116 /dev/vgora/rapp110 2092957696 AVAILABLE NOBILLINDEX 117 /dev/vgora/rapp111 2092957696TABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA0 118 /dev/vgora/rapp112 2092957696 AVAILABLE NOBILLINDEX1 119 /dev/vgora/rapp113 2092957696 AVAILABLE NOBILLINDEX1 120 /dev/vgora/rapp114 2097152000 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX1 121 /dev/vgora/rapp115 2097152000 AVAILABLE NOBILLDATA1 122 /dev/vgora/rapp116 2097152000 AVAILABLE NOBILLDATA0 123 /dev/vgora/rapp117 2097152000 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA1 124 /dev/vgora/rapp118 2097152000 AVAILABLE NOBILLDATA2 125 /dev/vgora/rapp119 2097152000 AVAILABLE NOBILLDATA0 126 /dev/vgora/rapp120 2097152000 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA4 127 /dev/vgora/rapp121 2097152000 AVAILABLE NOBILLDATA 128 /dev/vgora/rapp122 2097152000 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA 130 /dev/vgora/rapp124 2097152000 AVAILABLE NOBILLDATA 131 /dev/vgora/rapp125 2097152000 AVAILABLE NOBILLDATA1 132 /dev/vgora/rapp126 2097152000 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLINDEX1 133 /dev/vgora/rapp127 2097152000 AVAILABLE NOBILLINDEX1 134 /dev/vgora/rapp128 2139095040 AVAILABLE NOBILLDATA4 135 /dev/vgora/rapp129 2139095040 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA 136 /dev/vgora/rapp130 2139095040 AVAILABLE NOBILLINDEX1 137 /dev/vgora/rapp131 2139095040 AVAILABLE NOBILLDATA4 138 /dev/vgora/rapp132 2139095040 AVAILABLE NOTABLESPACE_NAME FILE_ID FILE_NAME BYTES------------------------------ ------- ------------------------- ----------- STATUS AUTOEXTENS---------- ----------BILLDATA1 139 /dev/vgora/rapp133 2139095040 AVAILABLE NOBILLDATA4 140 /dev/vgora/rapp134 2139095040 AVAILABLE NOAVAILABLE NOselect tablespace_name,file_id,file_name,bytes,status,autoextensible fromdba_temp_files order by file_id;无建议:无表空间管理方式和碎片表空间管理方式:select tablespace_name,extent_management from dba_tablespaces;TABLESPACE_NAME EXTENT_MAN------------------------------ ----------SYSTEM DICTIONARYTOOLS DICTIONARYRBS DICTIONARYTEMP DICTIONARYUSERS DICTIONARYBILLDATA DICTIONARYBILLINDEX DICTIONARYBILLTEMP DICTIONARYBILLDATA1 LOCALINTERFACE_KFXT DICTIONARYBILLDATA4 LOCALTABLESPACE_NAME EXTENT_MAN------------------------------ ----------BILLDATA3 LOCALBILLDATA2 LOCALBILLINDEX1 LOCALBILLINDEX3 LOCALBILLDATA0 DICTIONARY建议除了system和RBS外都改成本地管理。

相关主题