Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
라이브 도움말 보기
등록 완료
로그인
가격 산정 요청
영업 담당자에게 문의
제품 번들을 선택했습니다. 귀하의 요청에 더 적합한 서비스를 제공해 드릴 수 있도록 개별 제품을 선택해 주십시오. *
지금은 채팅에 회신할 수 있는 기술 지원 엔지니어가 없습니다. 즉각적인 서비스를 받으려면 당사의 서비스 요청 양식을 사용하여 요청을 제출하십시오.
다음 문서의 설명에 따라 문제를 해결할 수 있습니다.
The following table provides a list of the Database Tables metrics that are collected, and a description for each.
DBPARTITIONNUM
The database partition from which the data was retrieved.
INSTANCE_NAME
The name of the monitored instance.
DB_NAME
The name of the monitored database.
TABSCHEMA
The schema of the table.
Along with TABNAME this element can assist in determining the source of the contention for resources.
TABNAME
The name of the table.
TAB_TYPE
The type of table for which information is returned.
Types:
TBSP_ID
An integer that uniquely represents a tablespace used by the current database.
DATA_OBJECT_PAGES
The number of disk pages consumed by a table. This represents the base table size only. Space consumed by index objects, LOB data, and long data are reported by INDEX_OBJECT_PAGES, LOB_OBJECT_PAGES, and LONG_OBJECT_PAGES, respectively.
INDEX_OBJECT_PAGES
The number of disk pages consumed by all indices defined in a table.
LOB_OBJECT_PAGES
The number of disk pages consumed by LOB data.
LONG_OBJECT_PAGES
The number of disk pages consumed by long data in a table.
XDA_OBJECT_PAGES
The number of disk pages consumed by XML storage object (XDA) data.
ROWS_READ
The number of rows read from the table.
ROWS_WRITTEN
The number of rows changed (inserted, deleted, or updated) in the table.
OVERFLOW_ACCESSES
The number of reads and writes from/to overflowed rows of this table.
PAGE_REORGS
The number of page reorganizations executed for a table.
The following table provides a list of the Database Partition Backup Collection metrics that are collected, and a description for each.
The database partition number from which the data was retrieved for this row.
LAST_SUCCESSFUL_BACKUP_START
The start time of the last successful backup.
LAST_SUCCESSFUL_BACKUP_END
The end time of the last successful backup.
LAST_SUCCESSFUL_BACKUP_TYPE
The type of the last successful backup.
Values:
DAYS_SINCE_LAST_SUCCESSFUL
The number of days that have passed since the last successful backup.
LAST_BACKUP_START
The start time of the last backup.
LAST_BACKUP_END
The end time of the last backup.
LAST_BACKUP_TYPE
The type of the last backup.
LAST_BACKUP_STATUS
The sqlcode value returned for the most recent running backup.
For more detail, query dbadmin db_history.
The following table provides a list of the Database Tables Global metrics that are collected, and a description for each.
Along with TABNAME, this element can assist in determining the source of the contention for resources.
The number of read and write operations from/to overflowed rows of this table.
The following table provides a list of the Database Applications metrics that are collected, and a description for each.
The database partition from which the data was retrieved for this row.
APPL_NAME
The name of the application running on the client.
ACTIVE_TIME
The elapsed time (in seconds) spent processing an SQL request on a host database server.
FOREGROUND_BACKGROUND_TYPE
The foreground or background status of the application.
APPL_IDLE_TIME
The number of seconds since an application issued any requests to the server. This includes applications that have not terminated a transaction (for example, not issued a commit or rollback).
TOTAL_CPU
The total CPU time (in seconds) used by the application.
AGENT_USR_CPU_TIME_S
The user CPU time (in seconds) used by the application.
AGENT_SYS_CPU_TIME_S
The system CPU time (in seconds) used by the application.
DIRECT_READS
The number of direct reads by the application.
DIRECT_WRITES
The number of direct writes by the application.
DIRECT_READ_TIME
The direct read time by the application.
DIRECT_WRITE_TIME
The direct write time by the application.
LOCKS_HELD
The locks held by the application.
LOCK_WAITS
The number of lock waits related to the application.
LOCK_WAIT_TIME
The lock wait time of the application.
LOCK_ESCALS
The number of lock escalations.
X_LOCK_ESCALS
The number of exclusive lock escalations.
TOTAL_SORTS
The total sorts related to the application.
TOTAL_SORT_TIME
The total sort time.
SORT_OVERFLOWS
The sort overflows of the application.
COMMIT_SQL_STMTS
The commit SQL statements related to the application.
ROLLBACK_SQL_STMTS
The rollback SQL statements related to the application.
PERCENT_SORT_OVERFLOWS
The percentage of sort operations, out of the total sort operations, that ran out of sort heap and may have required disk space for temporary storage.
FAILED_SQL_STMTS
The number of failed SQL statements.
DYNAMIC_SQL_STMTS
The number of dynamic SQL statements.
STATIC_SQL_STMTS
The number of static SQL statements.
SELECT_SQL_STMTS
The number of select SQL statements.
DDL_SQL_STMTS
The number of DDL SQL statements.
UID_SQL_STMTS
The number of DML SQL statements (UID).
ROWS_DELETED
The rows deleted by the application.
ROWS_INSERTED
The rows inserted by the application.
ROWS_UPDATED
The rows updated by the application.
ROWS_SELECTED
The rows selected by the application.
HASH_JOIN_OVERFLOWS
The hash join overflows of the application.
LOCKS_WAITING
The locks waiting related to the application.
계열사 지원 사이트에서 Quest *제품*에 대한 온라인 지원 도움말을 볼 수 있습니다. 올바른 *제품* 지원 콘텐츠 및 지원에 연결하려면 계속을 클릭하십시오.
The document was helpful.
평가 결과 선택
I easily found the information I needed.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center
Quest Software 포털은 더 이상 IE 8, 9, 10을 지원하지 않습니다. 브라우저를 최신 버전의 Internet Explorer나 Chrome으로 업그레이드하는 것이 좋습니다.
IE 11로 업그레이드 여기를 클릭
Chrome으로 업그레이드 여기를 클릭
IE 8, 9 또는 10을 계속 사용할 경우 당사가 제공하는 뛰어난 셀프서비스 기능 모두를 최대한으로 활용하실 수 없습니다.
