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 Buffer Pools metrics that are collected, and a description for each.
DBPARTITIONNUM
The database partition from which the data was retrieved for this row.
INSTANCE_NAME
The name of the monitored instance.
DB_NAME
The name of the monitored database.
BP_NAME
The name of the monitored buffer pool.
TABLESPACES
The number of the tablespaces using this buffer pool.
TOTAL_LOGICAL_READS
The total number of logical reads (index, XDA, and data) in the buffer pool.
TOTAL_LOGICAL_READS_S
The total number of logical reads per second (index, XDA, and data) in the buffer pool.
TOTAL_PHYSICAL_READS
The total number of physical reads (index, XDA, and data) in the buffer pool.
TOTAL_PHYSICAL_READS_S
Total number of physical reads per second (index, XDA, and data) in the buffer pool.
TOTAL_HIT_RATIO_PERCENT
The total hit ratio (index, XDA, and data reads).
DATA_LOGICAL_READS
The data logical reads, which includes access to data that is:
DATA_LOGICAL_READS_S
The data logical reads per second.
DATA_PHYSICAL_READS
The number of data pages read in from the tablespace containers (physical) for regular and large tablespaces.
DATA_PHYSICAL_READS_S
The number of data pages read in per second from the tablespace containers (physical) for regular and large tablespaces.
DATA_HIT_RATIO_PERCENT
The data hit ratio.
INDEX_LOGICAL_READS
The index logical reads, which includes access to index pages that are:
INDEX_LOGICAL_READS_S
The index logical reads per second.
INDEX_PHYSICAL_READS
The number of index pages read in from the tablespace containers (physical) for regular and large tablespaces.
INDEX_PHYSICAL_READS_S
The number of index pages read in per second from the tablespace containers (physical) for regular and large tablespaces.
INDEX_HIT_RATIO_PERCENT
The index hit ratio.
XDA_LOGICAL_READS
The number of data pages for XML storage objects (XDAs) that have been requested from the buffer pool (logical) for regular and large tablespaces.
XDA_LOGICAL_READS_S
The number of data pages per second for XML storage objects (XDAs) that have been requested from the buffer pool (logical) for regular and large tablespaces.
XDA_PHYSICAL_READS
The number of data pages for XML storage objects (XDAs) read in from the tablespace containers (physical) for regular and large tablespaces.
XDA_PHYSICAL_READS_S
The number of data pages per second for XML storage objects (XDAs) read in from the tablespace containers (physical) for regular and large tablespaces.
XDA_HIT_RATIO_PERCENT
The auxiliary storage objects hit ratio.
POOL_READ_TIME_S
The total amount of time spent reading in data and index pages from the tablespace containers (physical) for all types of tablespaces.
POOL_WRITE_TIME_S
The total amount of time spent physically writing data or index pages from the buffer pool to disk.
DIRECT_READS
The number of read operations that do not use the buffer pool. Direct reads are used when:
Reading LONG VARCHAR columns
Reading LOB (large object) columns
Performing a backup
DIRECT_READS_S
The number of read operations that do not use the buffer pool, per second.
DIRECT_WRITES
The number of write operations that do not use the buffer pool. Direct writes are used when:
DIRECT_WRITES_S
The number of write operations that do not use the buffer pool, per second.
DIRECT_READ_TIME_S
The elapsed time (in seconds) required to perform the direct reads.
DIRECT_WRITE_TIME_S
The elapsed time (in seconds) required to perform the direct writes.
FILES_CLOSED
The total number of database files closed.
You can use this element to assist in determining the best value for the maxfilop configuration parameter.
UNREAD_PREFETCH_PAGES
The number of pages that the prefetcher read in that were never used.
If this number is high, prefetchers are causing unnecessary I/O by reading pages into the buffer pool that will not be used.
GBP_LOGICAL_READS
The number of times an attempt was made to read a group buffer pool (GBP) dependent page from the group buffer pool, because the page was either invalid or not present in the local buffer pool (LBP). This is for pureScale instances only, which are not yet supported.
GBP_PHYSICAL_READS
The number of times a GBP dependent page was read into the LBP from disk, because it was not found in the GBP. This is for pureScale instances only, which are not yet supported.
GBP_HIT_RATIO
The percentage of time a requested page was found in the GBP out of all of the times it was requested. If a page is found in the GBP, that saves the database time, because the database does not have to look for it in the LBP. This is for pureScale instances only, which are not yet supported.
The following table provides a list of the Database Tables metrics that are collected, and a description for each.
The database partition from which the data was retrieved.
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.
계열사 지원 사이트에서 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을 계속 사용할 경우 당사가 제공하는 뛰어난 셀프서비스 기능 모두를 최대한으로 활용하실 수 없습니다.
