巡检人:小麦苗　QQ:646634621　微信公众号：DB宝　提供OCP、OCM、高可用（rac+dg）、PostgreSQL和MySQL培训和考证服务　BLOG地址: https://www.dbaup.com 若需要脚本可私聊我
崖山数据库yashandb巡检报告
Copyright (c) 2015-2100 (https://www.dbaup.com) dbaup. All rights reserved.

巡 检 人：小麦苗([QQ：646634621] [微信公众号：DB宝] [提供OCP、OCM、高可用、MySQL和PostgreSQL最实用的培训和考证服务])
版 本 号：v7.0.0
修改日期：2023-11-21
巡检日期：2023-11-21 14:10:01

[转到页底]

目录
总体概况 崖山版本信息 崖山实例信息 数据库服务器信息 其它信息
表空间情况 数据文件情况 控制文件 Redo日志文件 临时文件
对象统计 所有用户 所有参数 行数最多的表top10 最大的表top10 用户、索引和表TOP
Undo统计 Undo段信息 近一周归档日志切换情况
备份情况
SQL部分 数据库最慢的20条SQL 数据库高内存的20条SQL 数据库高MTAB的20条SQL 数据库排序页最多的SQL 数据库HASH连接最多的SQL
JOB部分 JOB运行情况 所有JOB
磁盘部分
会话情况 状态汇总 等待事件
内存统计 DB_CACHE BUFFERPOOL MEM_POOL
其它 DBA_DB_LINKS 错误信息 AWR信息
高可用


总体概况

● 崖山版本信息
BANNERVERSION_NUMBER
Personal Edition Release 23.1.1.100 x86_6423.1.1.100

● 实例信息
STATUSVERSIONSTARTUP_TIMEHOST_NAMEDATA_HOMEINSTANCE_NUMBERINSTANCE_NAMEPARALLELINSTANCE_ROLEIN_REFORM
OPENPersonal Edition Release 23.1.1.100 x86_642023-11-13 15:49:24.545909lhryashandb/yashandb/data/db-1-11yasdbfalseMASTER_ROLENO

● 数据库基本信息
DATABASE_IDDATABASE_NAMECREATE_TIMELOG_MODEOPEN_MODEPROTECTION_MODEPROTECTION_LEVELDATABASE_ROLEBLOCK_SIZECURRENT_SCNSTATUSRCY_POINTFLUSH_POINTRESET_POINTPLATFORM_NAMEHOST_NAMERESTORE_TIMESWITCHOVER_STATUS
4145226049yashandb2023-11-13ARCHIVELOGREAD_WRITEMAXIMUM PERFORMANCEMAXIMUM PERFORMANCEPRIMARY8192502617538149957632NORMAL0-20-20049-2081720-20-20049-2081720-0-0-0Linux x86_64lhryashandbNOT ALLOWED

● 数据库其它信息
项目值
字符集UTF8
数据库大小586.5625 MB

[回到目录]

表空间情况

● 表空间情况
IDTABLESPACE_NAMEMAX_SIZE_MBTOTAL_SIZE_MBTS_USED_SIZE_MBSTATUSCONTENTSLOGGINGALLOCATION_TYPEBLOCK_SIZESEGMENT_SPACE_MANAGEMENTENCRYPTED
0SYSTEM5242886427.1875ONLINEPERMANENTLOGGINGAUTO8192BITMAPN
1SYSAUX5242886432.375ONLINEPERMANENTLOGGINGAUTO8192BITMAPN
2TEMP52428864ONLINETEMPORARYNOLOGGINGUNIFORM8192BITMAPN
3SWAP524288192ONLINESWAPNOLOGGINGUNIFORM8192BITMAPN
4USERS524288576527ONLINEPERMANENTLOGGINGAUTO8192BITMAPN
5UNDO65536448ONLINEUNDOLOGGINGUNIFORM8192BITMAPN
6TS_YASHAN100100ONLINEPERMANENTLOGGINGAUTO8192BITMAPN

[回到目录]

● 数据文件情况
FILE_NAMEFILE_IDTABLESPACE_NAMEBYTESBLOCKSSTATUSMAXBYTESMAXBLOCKSAUTO_EXTENDNEXT_SIZEUSER_BYTESUSER_BLOCKS
/yashandb/data/db-1-1/dbfiles/system0SYSTEM671088648192ONLINE54975581388867108864ON67108864375521284584
/yashandb/data/db-1-1/dbfiles/sysaux1SYSAUX671088648192ONLINE54975581388867108864ON67108864321126403920
/yashandb/data/db-1-1/dbfiles/temp2TEMP671088648192ONLINE54975581388867108864ON67108864618659847552
/yashandb/data/db-1-1/dbfiles/swap3SWAP20132659224576ONLINE54975581388867108864ON67108864534118406520
/yashandb/data/db-1-1/dbfiles/users4USERS60397977673728ONLINE54975581388867108864ON67108864503316486144
/yashandb/data/db-1-1/dbfiles/undo5UNDO46976204857344ONLINE687194767368388608ON6710886441056665650118
/yashandb/data/db-1-1/dbfiles/ts_yashan016TS_YASHAN10485760012800ONLINE10485760012800OFF010380902412672

[回到目录]

● 控制文件情况
IDNAMEBLOCK_SIZEFILE_SIZE_BLKSBYTES
0/yashandb/data/db-1-1/dbfiles/ctrl18192309725370624
1/yashandb/data/db-1-1/dbfiles/ctrl28192309725370624
2/yashandb/data/db-1-1/dbfiles/ctrl38192309725370624

[回到目录]

● Redo日志文件情况
THREAD#IDNAMEBLOCK_SIZEBLOCK_COUNTUSED_BLOCKSSEQUENCE#STATUS
10/yashandb/data/db-1-1/dbfiles/redo14096327683275317INACTIVE
11/yashandb/data/db-1-1/dbfiles/redo24096327683261918INACTIVE
12/yashandb/data/db-1-1/dbfiles/redo34096327683265019INACTIVE
13/yashandb/data/db-1-1/dbfiles/redo44096327682004920CURRENT

[回到目录]

● 临时文件信息
FILE_IDFILE_NAMESTATUSSIZE_MBAUTOEXTENSIBLETABLESPACE_NAMEMAXSIZE_MBINCREMENT_BY
2/yashandb/data/db-1-1/dbfiles/tempONLINE64ONTEMP5242888192
3/yashandb/data/db-1-1/dbfiles/swapONLINE192ONSWAP5242888192

[回到目录]

● 所有用户
USERNAMEUSER_IDPASSWORDACCOUNT_STATUSLOCK_DATEEXPIRY_DATEDEFAULT_TABLESPACECREATEDAUTHENTICATION_TYPELAST_LOGINPASSWORD_CHANGE_DATEDATABASE_MAINTAINEDPROFILE
SYS0S:79FF0062818A09584FBFE645CB4A14B029EEC9BE77467D185AB69EAC3BAF34F74F369689811829FC32DFOPENSYSTEM2023-11-13PASSWORD2023-11-13YDEFAULT
MDSYS10240LOCKEDUSERS2023-11-13PASSWORD2023-11-13YDEFAULT
LHR3S:D6D37E0E1C1FE6961ECC730E0D3439D8AED5D7D1E97FC561BB3F8E7AD0D453B58024343E2DA1BD1DDD88OPENUSERS2023-11-13PASSWORD2023-11-13NDEFAULT

[回到目录]

● 所有用户角色
GRANTEEPRIVILEGEPRIVILEGE_TYPEADMIN_OPTION
LHRDBAROLE_PRIVSNO
MDSYSSELECT ON SYS.DBA_CONSTRAINTSTABLE_PRIVSN
MDSYSSELECT ON SYS.DBA_TABLESTABLE_PRIVSN
MDSYSSELECT ON SYS.DBA_TAB_COLSTABLE_PRIVSN
MDSYSSELECT ON SYS.DBA_TYPESTABLE_PRIVSN
MDSYSSELECT ON SYS.V_$DATABASETABLE_PRIVSN

[回到目录]

● 所有参数[下一项]
NAMEVALUEDEFAULT_VALUE
MAX_SESSIONS10241024
MAX_WORKERS00
MAX_PARALLEL_WORKERS3232
MAX_REACTOR_CHANNELS00
WORK_AREA_STACK_SIZE1024K1024K
RUN_LOG_LEVELINFOINFO
RUN_LOG_FILE_COUNT1010
RUN_LOG_FILE_SIZE20M20M
RUN_LOG_FILE_PATH/yashandb/install/log/yashandb/db-1-1/run''
USE_LARGE_PAGESFALSEFALSE
CONTROL_FILES('/yashandb/data/db-1-1/dbfiles/ctrl1', '/yashandb/data/db-1-1/dbfiles/ctrl2', '/yashandb/data/db-1-1/dbfiles/ctrl3')('?/dbfiles/ctrl1', '?/dbfiles/ctrl2', '?/dbfiles/ctrl3')
DB_BLOCK_SIZE81928192
DATA_BUFFER_SIZE64M64M
WORK_AREA_HEAP_SIZE512K512K
WORK_AREA_POOL_SIZE16M16M
HA_HEARTBEAT_INTERVAL33
HA_ELECTION_TIMEOUT99
HA_ELECTION_ENABLEDFALSEFALSE
HA_ELECTION_LEADER_LEASE_ENABLEDFALSEFALSE
REDO_BUFFER_SIZE8M8M
REDO_BUFFER_PARTS44
LARGE_POOL_SIZE16M16M
MAX_PRIVATE_TEMP_TABLES1616
VM_BUFFER_SIZE32M32M
DBWR_BUFFER_SIZE4M4M
UNDO_RETENTION300300
UNDO_SHRINK_ENABLEDTRUETRUE
UNDO_SHRINK_INTERVAL36003600
TRANSACTION_LOCK_TIMEOUT00
DDL_LOCK_TIMEOUT00
STARTUP_ROLLBACK_PARALLELISM22
ISOLATION_LEVELREAD_COMMITTEDREAD_COMMITTED
COMMIT_WAITWAITWAIT
COMMIT_LOGGINGIMMEDIATEIMMEDIATE
RECOVERY_PARALLELISM1616
CHECKPOINT_INTERVAL100000100000
CHECKPOINT_TIMEOUT300300
LISTEN_ADDR192.92.0.24:16880.0.0.0:1688
REPLICATION_ADDR192.92.0.24:1689
CHARACTER_SETUTF8UTF8
NATIONAL_CHARACTER_SETUTF16UTF16
DBWR_COUNT22
DB_FILE_NAME_CONVERT
REDO_FILE_NAME_CONVERT
DB_BUCKET_NAME_CONVERT
ARCHIVE_LOCAL_DEST?/archive?/archive
ARCHIVE_DEST_1
ARCHIVE_DEST_2
ARCHIVE_DEST_3
ARCHIVE_DEST_4
ARCHIVE_DEST_5
ARCHIVE_DEST_6
ARCHIVE_DEST_7
ARCHIVE_DEST_8
ARCHIVE_DEST_9
ARCHIVE_DEST_10
ARCHIVE_DEST_11
ARCHIVE_DEST_12
ARCHIVE_DEST_13
ARCHIVE_DEST_14
ARCHIVE_DEST_15
ARCHIVE_DEST_16
ARCHIVE_DEST_17
ARCHIVE_DEST_18
ARCHIVE_DEST_19
ARCHIVE_DEST_20
ARCHIVE_DEST_21
ARCHIVE_DEST_22
ARCHIVE_DEST_23
ARCHIVE_DEST_24
ARCHIVE_DEST_25
ARCHIVE_DEST_26
ARCHIVE_DEST_27
ARCHIVE_DEST_28
ARCHIVE_DEST_29
ARCHIVE_DEST_30
ARCHIVE_DEST_31
ARCHIVE_DEST_32
QUORUM_SYNC_STANDBYSMAJORITYMAJORITY
REQUIRED_SYNC_STANDBYS
DATAFILE_IO_MODEDEFAULTDEFAULT
REDOFILE_IO_MODEDSYNCDSYNC
DOUBLE_WRITE_ENABLEDTRUETRUE
DEFAULT_TABLE_TYPEHEAPHEAP
MMS_USE_LARGE_PAGESFALSEFALSE
MMS_DATA_LOADERS44
ARCH_CLEAN_UPPER_THRESHOLD16G16G
ARCH_CLEAN_LOWER_THRESHOLD12G12G
ARCH_CLEAN_IGNORE_MODENONENONE
DATE_FORMATyyyy-mm-ddyyyy-mm-dd
TIME_FORMAThh24:mi:ss.ffhh24:mi:ss.ff
TIMESTAMP_FORMATyyyy-mm-dd hh24:mi:ss.ffyyyy-mm-dd hh24:mi:ss.ff
YMINTERVAL_FORMATyy-mmyy-mm
DSINTERVAL_FORMATdd hh24:mi:ss.ffdd hh24:mi:ss.ff
PASSWORD_FILE?/instance/yasdb.pwd?/instance/yasdb.pwd
SQL_PLUGINNONENONE
SCOL_DATA_BUFFER_SIZE128M128M
SCOL_CACHEABLE_SCAN_ROWS1844674407370955161518446744073709551615
SCOL_DISK_CACHEABLE_SCAN_ROWS1844674407370955161518446744073709551615
SCOL_DATA_PRELOADERS22
RECYCLEBIN_ENABLEDOFFOFF
COLUMNAR_VM_BUFFER_SIZE2G2G
COLUMNAR_MATERIAL_PERCENT8080
COLUMNAR_WORK_AREA_HEAP_SIZE64M64M
DB_BLOCK_CHECKSUMTYPICALTYPICAL
BLOCK_REPAIR_ENABLEDTRUETRUE
BLOCK_REPAIR_TIMEOUT6060
COMPRESSIONUNCOMPRESSEDUNCOMPRESSED
COMPRESSION_LEVELLOWLOW
OPTIMIZER_DYNAMIC_SAMPLING00
LSC_DICTIONARY_CACHE_AUTOEXTENDFALSEFALSE
BUCKET_RESERVED_SPACE1G1G
DIAGNOSTIC_DEST?/diag?/diag
DIAG_ADR_ENABLEDTRUETRUE
COLUMNAR_BULK_SIZE10241024
DEGREE_OF_PARALLEL11
QUERY_REWRITE_ENABLEDFALSEFALSE
NODE_ID1-1:11-1:1
CM_ADDR1-1:1/127.0.0.1:16791-1:1/127.0.0.1:1679
DIN_ADDR127.0.0.1:1690127.0.0.1:1690
DIN_RECONNECT_TIME50005000
DEFAULT_MCOL_TTL36003600
SCOL_WRITE_CACHE_POLICYWRITE_BACKWRITE_BACK
DS_SCALE_OUT_FACTOR77
STATISTICS_LEVELTYPICALTYPICAL
UNIFIED_AUDITINGFALSEFALSE
SHARE_POOL_SIZE256M256M
CGROUP_FLAG00
CGROUP_ROOT_DIR/sys/fs/cgroup/sys/fs/cgroup
RESOURCE_MANAGER_PLAN
JOB_QUEUE_PROCESSES1616
OPEN_CURSORS310310
LSNR_LOGONON
JVM_XMS512M512M
JVM_XMX512M512M
CLUSTER_DATABASEFALSEFALSE
INSTANCE_NAMEyasdbyasdb
CLUSTER_INTERCONNECT127.0.0.1:1700127.0.0.1:1700
INTERCONNECT_LINKS22
INTERCONNECT_MESSAGE_POOL1024:64;512:8800;128:16800;64:328001024:64;512:8800;128:16800;64:32800
INTERCONNECT_RECEIVE_TIMEOUT55
GRC_TASK_COUNT22
GCS_TASK_COUNT33
GLS_TASK_COUNT22
CLUSTER_SERVICE
CLUSTER_RECONNECT_TIME50005000
YASFS_DATA_DIR+DG0+DG0
SESSION_MAX_OPEN_FILES5050
AC_MAX_SOURCE_SLICE_COUNT2020
AC_SLICE_THRESHOLD_SIZE64M64M
SSL_CERT_FILE
SSL_KEY_FILE
SSL_DH_PARAM_FILE
SSL_ENABLEOFFOFF
ENABLE_SEPARATE_DUTYFALSEFALSE
BLOOM_FILTER_FACTOR.3.3
ENABLE_SLOW_LOGFALSEFALSE
SLOW_LOG_TIME_THRESHOLD10001000
SLOW_LOG_FILE_NAMEslow.logslow.log
SLOW_LOG_FILE_PATH/yashandb/install/log/yashandb/db-1-1/slow?/log/slow
SLOW_LOG_OUTPUTFILEFILE
SLOW_LOG_SQL_MAX_LEN20002000
AUDIT_QUEUE_WRITETRUETRUE
AUDIT_QUEUE_SIZE16M16M
AUDIT_FLUSH_INTERVAL100100
TAB_QUEUE_WINDOW_SIZE44
DATA_RETENTION36003600
DATA_TRANSFORMER_ENABLEDTRUETRUE
SCOL_SLICE_ROWS8M8M
COLUMNAR_VM_SWAP_SIZE200G200G
BROADCAST_GTS_TIME55
HA_SSL_ENABLEOFFOFF
EXTSERVER_CONNS6464
DBWR_FLUSH_NEIGHBORS_COUNT1616
ENABLE_DISKCACHEFALSEFALSE
ENABLE_ARCH_DATA_IGNORE_BACKUPFALSEFALSE
SQL_MAPFALSEFALSE

[回到目录]

推荐参数[上一项]

RECOMMEND_SETTINGS
[回到目录]

对象统计[上一项]

OWNEROBJECT_TYPECNT
LHRVIEW2
LHRTABLE3
MDSYSVIEW1
MDSYSTABLE1
MDSYSINDEX1
MDSYSTYPE1
PUBLICSYNONYM537
[回到目录]

● 最大的表top10
OWNERSEGMENT_NAMETABLESPACE_NAMESIZE_MBNUM_ROWS
LHRT1USERS287
LHRT_YH_20230705_LHRUSERS237
SYSWRH$_SQLTEXTSYSAUX1026028
MDSYSSPATIAL_REF_SYSSYSTEM88500
SYSWRH$_SQLSTATSYSAUX626029
SYSWRH$_SQLSTAT_PKSYSAUX4
SYSI_HISTGRM1SYSTEM4
SYSHISTGRM$SYSTEM445700
SYSWRH$_SQLTEXT_PKSYSAUX3
LHRT_YH_20170705_LHRUSERS3

[回到目录]

● 行数最多的表top10
OWNERTABLE_NAMETABLESPACE_NAMESTATUSNUM_ROWSSIZE_MB
MDSYSSPATIAL_REF_SYSSYSTEMVALID85008

[回到目录]

● Undo统计
IDBLK_REUSEBALANCE_TIMEBALANCEBALANCE_BLKRECYCLE_TIMERECYCLE_LISTRECYCLE_LIST_BLK
0192023-11-21191476612023-11-2000
1222023-11-21191510592023-11-2000
2142023-11-21191544422023-11-2000
3182023-11-21191578802023-11-2000
4142023-11-21191612552023-11-1800
5152023-11-21191646612023-11-1800
6242023-11-21191682722023-11-1800
7202023-11-21191716912023-11-1800
8202023-11-21191750992023-11-2000
9162023-11-21191784882023-11-1800
10202023-11-21191818702023-11-2000
11182023-11-21191853252023-11-1800
12212023-11-21191887352023-11-1800
13172023-11-21191921332023-11-1800
14172023-11-21191955062023-11-2000
15172023-11-21191989212023-11-1800
16162023-11-211911023312023-11-1800
17152023-11-211911057762023-11-2000
18152023-11-211911091902023-11-1800
19142023-11-211911125872023-11-1800
20162023-11-211911159762023-11-1800
21252023-11-211911193742023-11-1800
22192023-11-2119112284100
23162023-11-2119112620000
24212023-11-2119112957800
25172023-11-2119113292900
26372023-11-211911362972023-11-1800
27192023-11-2119113971500
28182023-11-2119114309900
29232023-11-2119114646400
30282023-11-211911498822023-11-1800
31212023-11-2119115329400
32202023-11-2119115667300
33162023-11-2119116006200
34182023-11-211911634612023-11-1800
35172023-11-2119116682600
36332023-11-2119117020600
37192023-11-211911735672023-11-2100
38182023-11-2119117694900
39212023-11-2119118032600
40182023-11-2119118374900
41182023-11-2119118732200
42202023-11-2119119073300
43192023-11-2119119412600
44212023-11-2119119751000
45162023-11-211912009412023-11-1800
46212023-11-2119120430200
47152023-11-2119120767200
48282023-11-211912110152023-11-1800
49182023-11-2119121441400
50182023-11-211912177712023-11-1800
51182023-11-2119122117300
52202023-11-2119122459400
53152023-11-2119122794700
54212023-11-2119123128900
55172023-11-2119123465400
56182023-11-2119123804200
57152023-11-2119124143500
58252023-11-2119124493600
59192023-11-2119124849600
60192023-11-2119125216800
61172023-11-2119125622600
62172023-11-2119126016300
63182023-11-2119126357400

[回到目录]

● Undo段信息
IDUSED_TIMEFIRST_UBAFILFIRST_UBABLKLAST_UBAFILLAST_UBABLKUFB_COUNTFIRST_UFBFILFIRST_UFBBLK
02023-11-2106871068711406872
12023-11-2106887068871406888
22023-11-2106999069991407000
32023-11-2107079070791407080
42023-11-2107106071061407107
52023-11-2107122071221407123
62023-11-210742207422207423
72023-11-2107154071541407155
82023-11-2107202072021407203
92023-11-2107218072181407219
102023-11-2105304405304411053045
112023-11-2107250072501407251
122023-11-2107266072661407267
132023-11-2106389063891106390
142023-11-2107330073301407331
152023-11-2107345073451507346
162023-11-2106453064531106454
172023-11-2106485064851106486
182023-11-2106502065021106503
192023-11-2106520065201006521
202023-11-210654807191907192
212023-11-2106563065661106567
222023-11-2106582065861006587
232023-11-2106598066011106602
242023-11-2106614066171106618
252023-11-21042217063731406374
262023-11-21042170064181406419
272023-11-2106631066341006635
282023-11-2106660066641106665
292023-11-2106448071381407139
302023-11-21042186071701407171
312023-11-21042123072341407235
322023-11-21041693072821407283
332023-11-21041900072981407299
342023-11-21042547073141407315
352023-11-210668106684706685
362023-11-2106693066931406694
372023-11-2106708067081506709
382023-11-210421390421390042144
392023-11-210637106371006384
402023-11-210648006480006496
412023-11-210704407044107045
422023-11-2106402064021406403
432023-11-2106741067411406742
442023-11-2106789067891406790
452023-11-2106807068071406808
462023-11-2106839068391406840
472023-11-2106855068551406856
482023-11-2106903069031406904
492023-11-2106919069191406920
502023-11-2106935069351406936
512023-11-2106951069511406952
522023-11-2106967069671406968
532023-11-2106983069831406984
542023-11-2107015070151407016
552023-11-2107047070471407048
562023-11-2107063070631407064
572023-11-210635106351006352
582023-11-2106353063531406354
592023-11-2106532065321406533
602023-11-2106725067251406726
612023-11-2106757067571406758
622023-11-2106773067731406774
632023-11-2106823068231406824

[回到目录]

● 近一周归档日志切换情况
DAYH00H01H02H03H04H05H06H07H08H09H10H11H12H13H14H15H16H17H18H19H20H21H22H23TOTAL
2023-11-2100000000000000000000000011
2023-11-200000000000000000000000001
2023-11-190000000000000000000000001
2023-11-180000000000000000000000001
2023-11-170000000000000000000000001
2023-11-160000000000000000000000001
2023-11-140000000000000000000000001

[回到目录]

会话情况

● 状态汇总
STATUSCNT
ACTIVE24
INACTIVE6

● 客户端汇总
STATUSUSERNAMECLI_OSUSERCLI_HOSTNAMECLI_PROGRAMIP_ADDRESSCNT
INACTIVELHRlhrLHRXXTYashanDB JDBC Driver192.168.26.1905
ACTIVERESERVE3
ACTIVE2
ACTIVEDBWR2
ACTIVECKPT1
ACTIVEARCH1
ACTIVERCY1
ACTIVEGBPG1
ACTIVEBCR1
INACTIVESYSyashanlhryashandb/yashandb/install/bin/yasql1
ACTIVESYSyashanlhryashandb/yashandb/install/bin/yasql1
ACTIVEARCH DATA1
ACTIVEXFMR RUNTIME1
ACTIVEAC PRODUCE1
ACTIVEHM1
ACTIVEMMS1
ACTIVEFAL1
ACTIVEXRB1
ACTIVEBPRA1
ACTIVESMON1
ACTIVELOGW1
ACTIVEBOOT1

[回到目录]

● 等待事件
EVENTTOTAL_WAITSTOTAL_TIMEOUTSTIME_WAITEDAVERAGE_WAITTIME_WAITED_MICROTOTAL_WAITS_FGTOTAL_TIMEOUTS_FGTIME_WAITED_FGAVERAGE_WAIT_FGTIME_WAITED_MICRO_FGEVENT_IDWAIT_CLASS
free buffer wait66549904190419818392728032803281818Configuration
db file scattered read532071023020230239026421601526.0115261219User I/O
redo remote sync complete249857010301037700000037Commit
log file parallel write2081710106163.511061632072026450100355.510035587331System I/O
log file sync2053630101103.49101103515201681097558.489755849732Commit
SQL*Net message from client8485012221324514403.451222132453938485012221324514403.4512221324539348Idle
SQL*Net message to client84510365.0436502284510365.0436502249Network
db file sequential read83310498.0649811064470477.0747768410User I/O
db file parallel write661907593211.47759324930000011System I/O
log buffer space1082039943.6939949021037038443.71384478428Configuration
log file single write50023.462382918011.611127630System I/O
undo segment extending60878146.3387873850739147.873974518Configuration
log file switch completion104446780000035Configuration
xslot busy wait00000000002Configuration
heap segment extending000000000012Concurrency
index block split000000000014Other
checkpoint completed000000000016Configuration
space extent000000000020Concurrency
role create000000000022Concurrency
interval part extend000000000024Concurrency

[回到目录]

其它

● DBA_DB_LINKS
OWNERDB_LINKUSERNAMEPASSWORDCREDENTIAL_NAMECREDENTIAL_OWNERHOSTCREATEDHIDDENSHARD_INTERNALVALIDINTRA_CDB

[回到目录]

AWR

● AWR配置信息
DBIDSNAP_INTERVALRETENTIONMOST_RECENT_SNAP_IDMOST_RECENT_SNAP_TIMESTATUS_FLAG
4145226049+00 01:00:00.000000+08 00:00:00.0000001912023-11-21 13:55:59.8998161

[回到目录]

● 近10条AWR快照
SNAP_IDDBIDINSTANCE_NUMBERSTARTUP_TIMEBEGIN_INTERVAL_TIMEEND_INTERVAL_TIMEFLUSH_ELAPSEDSNAP_LEVELSTATUSERROR_COUNT
191414522604912023-11-13 15:49:30.1548772023-11-21 12:55:57.9846962023-11-21 13:55:59.899816+00 00:00:00.100000100
190414522604912023-11-13 15:49:30.1548772023-11-21 11:55:56.0276832023-11-21 12:55:57.984696+00 00:00:00.100000100
189414522604912023-11-13 15:49:30.1548772023-11-21 10:55:54.0365482023-11-21 11:55:56.027683+00 00:00:00.100000100
188414522604912023-11-13 15:49:30.1548772023-11-21 09:55:51.9765892023-11-21 10:55:54.036548+00 00:00:00.100000100
187414522604912023-11-13 15:49:30.1548772023-11-21 08:55:49.9061442023-11-21 09:55:51.976589+00 00:00:00.100000100
186414522604912023-11-13 15:49:30.1548772023-11-21 07:55:47.9012552023-11-21 08:55:49.906144+00 00:00:00.100000100
185414522604912023-11-13 15:49:30.1548772023-11-21 06:55:45.9422912023-11-21 07:55:47.901255+00 00:00:00.100000100
184414522604912023-11-13 15:49:30.1548772023-11-21 05:55:43.9982962023-11-21 06:55:45.942291+00 00:00:00.100000100
183414522604912023-11-13 15:49:30.1548772023-11-21 04:55:41.8182072023-11-21 05:55:43.998296+00 00:00:00.100000100
182414522604912023-11-13 15:49:30.1548772023-11-21 03:55:39.6237132023-11-21 04:55:41.818207+00 00:00:00.100000100
181414522604912023-11-13 15:49:30.1548772023-11-21 02:55:37.5040662023-11-21 03:55:39.623713+00 00:00:00.100000100
180414522604912023-11-13 15:49:30.1548772023-11-21 01:55:35.3152842023-11-21 02:55:37.504066+00 00:00:00.100000100
179414522604912023-11-13 15:49:30.1548772023-11-21 00:55:33.0814612023-11-21 01:55:35.315284+00 00:00:00.100000100
178414522604912023-11-13 15:49:30.1548772023-11-20 23:55:31.1403652023-11-21 00:55:33.081461+00 00:00:00.100000100
177414522604912023-11-13 15:49:30.1548772023-11-20 22:55:29.1978682023-11-20 23:55:31.140365+00 00:00:00.100000100
176414522604912023-11-13 15:49:30.1548772023-11-20 21:55:27.2165502023-11-20 22:55:29.197868+00 00:00:00.100000100
175414522604912023-11-13 15:49:30.1548772023-11-20 20:55:25.2271822023-11-20 21:55:27.216550+00 00:00:00.100000100
174414522604912023-11-13 15:49:30.1548772023-11-20 19:55:23.2866132023-11-20 20:55:25.227182+00 00:00:00.100000100
173414522604912023-11-13 15:49:30.1548772023-11-20 18:55:21.2601472023-11-20 19:55:23.286613+00 00:00:00.100000100
172414522604912023-11-13 15:49:30.1548772023-11-20 17:55:19.3357422023-11-20 18:55:21.260147+00 00:00:00.100000100
171414522604912023-11-13 15:49:30.1548772023-11-20 16:55:17.3999932023-11-20 17:55:19.335742+00 00:00:00.100000100
170414522604912023-11-13 15:49:30.1548772023-11-20 15:55:15.4573782023-11-20 16:55:17.399993+00 00:00:00.100000100
169414522604912023-11-13 15:49:30.1548772023-11-20 14:55:13.4476472023-11-20 15:55:15.457378+00 00:00:00.100000100
168414522604912023-11-13 15:49:30.1548772023-11-20 13:55:11.5281672023-11-20 14:55:13.447647+00 00:00:00.100000100
167414522604912023-11-13 15:49:30.1548772023-11-20 12:55:09.5877582023-11-20 13:55:11.528167+00 00:00:00.100000100
166414522604912023-11-13 15:49:30.1548772023-11-20 11:55:07.5975042023-11-20 12:55:09.587758+00 00:00:00.100000100
165414522604912023-11-13 15:49:30.1548772023-11-20 10:55:05.5564942023-11-20 11:55:07.597504+00 00:00:00.100000100
164414522604912023-11-13 15:49:30.1548772023-11-20 09:55:03.5422922023-11-20 10:55:05.556494+00 00:00:00.100000100
163414522604912023-11-13 15:49:30.1548772023-11-20 08:55:01.5345992023-11-20 09:55:03.542292+00 00:00:00.100000100
162414522604912023-11-13 15:49:30.1548772023-11-20 07:54:59.5636642023-11-20 08:55:01.534599+00 00:00:00.100000100
161414522604912023-11-13 15:49:30.1548772023-11-20 06:54:57.5785442023-11-20 07:54:59.563664+00 00:00:00.100000100
160414522604912023-11-13 15:49:30.1548772023-11-20 05:54:55.6121292023-11-20 06:54:57.578544+00 00:00:00.100000100
159414522604912023-11-13 15:49:30.1548772023-11-20 04:54:53.4691432023-11-20 05:54:55.612129+00 00:00:00.100000100
158414522604912023-11-13 15:49:30.1548772023-11-20 03:54:51.3157422023-11-20 04:54:53.469143+00 00:00:00.100000100
157414522604912023-11-13 15:49:30.1548772023-11-20 02:54:49.1489432023-11-20 03:54:51.315742+00 00:00:00.100000100
156414522604912023-11-13 15:49:30.1548772023-11-20 01:54:46.9880082023-11-20 02:54:49.148943+00 00:00:00.100000100
155414522604912023-11-13 15:49:30.1548772023-11-20 00:54:44.7758682023-11-20 01:54:46.988008+00 00:00:00.100000100
154414522604912023-11-13 15:49:30.1548772023-11-19 23:54:42.8421252023-11-20 00:54:44.775868+00 00:00:00.100000100
153414522604912023-11-13 15:49:30.1548772023-11-19 22:54:40.8206962023-11-19 23:54:42.842125+00 00:00:00.100000100
152414522604912023-11-13 15:49:30.1548772023-11-19 21:54:38.9223762023-11-19 22:54:40.820696+00 00:00:00.100000100
151414522604912023-11-13 15:49:30.1548772023-11-19 20:54:36.9767332023-11-19 21:54:38.922376+00 00:00:00.100000100
150414522604912023-11-13 15:49:30.1548772023-11-19 19:54:34.9787392023-11-19 20:54:36.976733+00 00:00:00.100000100
149414522604912023-11-13 15:49:30.1548772023-11-19 18:54:33.0009852023-11-19 19:54:34.978739+00 00:00:00.100000100
148414522604912023-11-13 15:49:30.1548772023-11-19 17:54:31.0871372023-11-19 18:54:33.000985+00 00:00:00.100000100
147414522604912023-11-13 15:49:30.1548772023-11-19 16:54:29.1274832023-11-19 17:54:31.087137+00 00:00:00.100000100
146414522604912023-11-13 15:49:30.1548772023-11-19 15:54:27.2120852023-11-19 16:54:29.127483+00 00:00:00.100000100
145414522604912023-11-13 15:49:30.1548772023-11-19 14:54:25.2404182023-11-19 15:54:27.212085+00 00:00:00.100000100
144414522604912023-11-13 15:49:30.1548772023-11-19 13:54:23.3473122023-11-19 14:54:25.240418+00 00:00:00.100000100
143414522604912023-11-13 15:49:30.1548772023-11-19 12:54:21.4747962023-11-19 13:54:23.347312+00 00:00:00.100000100
142414522604912023-11-13 15:49:30.1548772023-11-19 11:54:19.5062292023-11-19 12:54:21.474796+00 00:00:00.100000100

[回到目录]

● YashanDB数据库的所有故障信息
TYPECODEDESCRIPTION
YASF101cannot allocate memory
YASF102too many open files
YASF103no space left on device
YASF104failed to open file
YASF105failed to create file
YASF106failed to write file
YASF107file metadata changed, for example, permissions, timestamps, extended attributes, and user/group ID, etc
YASF108file is missing
YASF109file is moved
YASF110file system is unmounted
YASF111failed to read file
YASF112failed to extend file
YASF201the data file is corrupted
YASF202the redo log file is corrupted
YASF203the ctrl files are corrupted
YASF204data block versions are mismatching
YASF205the database is aborted
YASF206the database needs to be repaired
YASF207deadlock detected
YASF208inconsistent database startup
YASF209watcher has an exception
YASF210the user limit on the total number of watches was reached
YASF211synchronization standby database destinations have failed

[回到目录]

● 错误记录
INCIDENT_IDSESSION_IDERROR_NUMBERERROR_ARGUMENTERROR_COMMENTS

[回到目录]