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 Invalid Objects collection collects data about invalid objects in each schema.
Oracle
Realtime Collection
20
Online
60
Offline
300
Invalid Functions
Number of invalid functions in the schema
Invalid Package Bodies
Number of invalid package bodies in the schema.
Invalid Packages
Number of invalid packages in the schema.
Invalid Procedures
Number of invalid procedures in the schema.
Invalid Types
Number of invalid types in the schema.
Invalid Views
Number of invalid views in the schema.
Invalid Materialized Views
Number of invalid materialized views in the schema.
New Invalid Functions
The number of invalid functions that are found to be present in the schema, and were not detected during the last run.
New Invalid Package Bodies
Number of invalid package bodies that were added to the schema during the last sampling period.
New Invalid Packages
Number of invalid packages that were added to the schema during the last sampling period.
New Invalid Procedures
Number of invalid procedures that were added to the schema during the last sampling period.
New Invalid Types
Number of invalid types that were added to the schema during the last sampling period.
New Invalid Views
Number of invalid views that were added to the schema during the last sampling period.
Others
Number of invalid objects of other object types in the schema.
PDB
In multitenant architectures, the name of the pluggable database.
Schema Name
The name of the schema that contains the invalid objects
Total Invalid Objects
Total number of invalid objects in the schema
The Invalid Objects List collection lists the invalid Object of the specific type currently detected in the database.
None (on-demand collection).
Object Name
The name of the invalid object
Object Type
The type of the invalid object
The IO Activity collection provides metrics, wait events, and performance ratios related to input/output activity.
Avg Read Time
The average time (ms) spent reading a data block from the disk into the database buffer cache.
Avg Write Time
The average time spent (ms) writing a data block from the database buffer to the disk.
Balance Average Read Time
The extent, in percents, to which average read time is balanced across RAC nodes
Balance Average Write Time
The extent, in percents, to which average write time is balanced across RAC nodes
Balance Cache Hit Ratio
The extent, in percents, to which cache hit ratio is balanced across RAC nodes
Balance Logical Reads
The extent, in percents, to which logical reads are balanced across RAC nodes
Balance Physical Reads
The extent, in percents, to which physical reads are balanced across RAC nodes
Balance Physical Writes
The extent, in percents, to which physical writes are balanced across RAC nodes
Block Changes per Call
This ratio measures the amount of data manipulation within existing database tables, which each transaction performs via DML commands, by computing the average number of blocks changed per single user call. Bea cu se creating or dropping indexes modifies index blocks, such operations increment the value of this metric.
Block Reads
This rate determines the block get rate, which is a basic measure of the rate at which the application system references the database. Change in metric size may indicate that the database workload has materially increased or that the referenced segment sizes increased.
Cache Hit Ratio
The effectiveness of the buffer cache, computed by comparing the number of block requests, which found the block in the buffer cache, with the entire block requests (including requests that required disk reads).
Chained Row Ratio
This ratio measures the percentage of chained or migrated rows encountered during a fetch as a percentage of the entire fetched rows.
Consistent Changes
The number of times a user process has applied rollback entries to perform a consistent read on the block.
Consistent Gets
The number of data block reads in CONSISTENT mode (that is, consistent reads). A CONSISTENT read retrieves the block version as of the time the query started.
Consistent Gets Direct
The number of times a consistent read was carried out directly for a block, bypassing the buffer cache.
Consistent Gets From Cache
The number of times a consistent read was carried out for a block from buffer cache.
DB Block Changes
The number of database blocks in memory (SGA) that were modified by the session as a result of DML activity. Such changes generate redo log entries, thereby becoming permanent changes to the database if the transaction is committed.
DB Block Gets
The number of data block reads in CURRENT mode (that is, current reads). A CURRENT read retrieves the latest version of the block as of the time of reading. Current mode reads are usually associated with DML activity.
DB Block Gets Direct
Number of times a CURRENT block was retrieved directly, bypassing the buffer cache.
DB Block Gets From Cache
Number of times a CURRENT block was retrieved from the buffer cache.
Disk Sorts Ratio
The number of sort operations that require creation of temporary segments on disk to store the intermediate sort results. This occurs if the data being sorted cannot be fit into memory block specified by the SORT_AREA_SIZE parameter in the init.ora file.
Full Scan Ratio
This ratio measures the percentage of the rows, which were retrieved as a result of full table scans, within the total number of retrieved rows.
Oracle Data I/O Operations
Total number of I/O operations (both physical and logical) performed by the Oracle session.
Oracle Physical Data Processed
the total size (in megabytes) of data processed via physical read and write operations during the specified time range.
Oracle Physical I/O Operations
Total number of physical I/O operations performed by the Oracle session.
Physical Read Bytes
The number of data blocks read by Oracle, which are not present in the buffer cache or in the PGA, thereby requiring I/O read operations, that is: the total number of data blocks read from disk.
Physical Read IO Requests
Number of read requests for application activity (mainly buffer cache and direct load operation) that read one or more database blocks per request.
Physical Read Total Bytes
Total size in bytes of disk reads by all database instance activity, including application reads, backup and recovery, and other utilities. The difference between this value and the value of the metric physical read bytes provides the total read size in bytes by non-application workload.
Physical Read Total IO Requests
Number of read requests that read one or more database blocks for all instance activity including application, backup and recovery, and other utilities. The difference between this value and the value of the metric physical read total multi block requests provides the total number of single block read requests.
Physical Read Total Multi Block Requests
Total number of read requests which read in two or more database blocks per request for all instance activity including application, backup and recovery, and other utilities.
Physical Reads
Physical Reads Cache
Total number of data blocks read from disk into the buffer cache.
Physical Reads Direct
Number of reads that were carried out directly from disk into the PGA, bypassing the buffer cache.
Physical Reads Refetch Warmup
Number of data blocks that were read from the disk during the automatic pre-warming of the buffer cache.
Physical Write Bytes
Total size, in bytes, of all disk writes from the database application activity (this metric does not include any other kind of instance activity).
Physical Write IO Requests
Number of write requests for application activity (mainly buffer cache and direct load operation) that wrote one or more database blocks per request.
Physical Write Total Bytes
Total size, in bytes, of all disk writes for the database instance, including application activity, backup and recovery, and other utilities. The difference between this value and the value of the metric physical write bytes provides the total write size, in bytes, resulting from non-application workload.
Physical Write Total IO Requests
Number of write requests which wrote one or more database blocks from all instance activity including application activity, backup and recovery, and other utilities. The difference between this metric value and the value of the metric physical write total multi block requests provides the number of single block write requests.
Physical Write Total Multi Block Requests
Total number of Oracle instance write requests that wrote two or more blocks per request to the disk for all instance activity, including application activity, recovery and backup, and other utilities.
Physical Writes
Total number of data blocks written to disk. This metric represents the rate at which Oracle generates system I/O calls.
Physical Writes Direct
Number of writes directly to disk, bypassing the buffer cache
Physical Writes From Cache
Total number of data blocks written to disk from the buffer cache
Physical Writes Non Checkpoint
Number of times a buffer is written for reasons other than checkpoint. This statistic measures the number of writes that would have occurred had no checkpoint operation taken place. Subtracting this value from the value of the metric physical writes provides the number of I/O operations carried out as a result of checkpoint operations.
Read Consistency Overhead
This ratio measures the extent to which applications must make use of the read consistency mechanism. The queries that processing parts of the UPDATE and/or DELETE operations are subject to read consistency.
Read Time
The total time spent on reading data from the data file.
Reads Per Second
Number of physical reads carried out per second
Redo Blocks Written
Total number of redo blocks written. Dividing this metric by the value of the metric redo writes provides the average number of blocks per write.
Redo Buffer Allocation Retries
Total number of retries necessary to allocate space in the redo buffer. Retries are needed either because the redo writer has fallen behind or because an event such as a log switch is occurring.
Redo Entries
The number of redo records created (copied into the redo log buffer).
Redo Log Space Requests
Number of times the active log file is full and the session must wait for a log switch to be performed. After the completion of the log switch, the redo log entries can be allocated, and the session can be resumed.
Redo Log Space Wait Ratio
Redo Size
Total size, in bytes, of the redo volume.
Redo Writes
Total number of write operations issued by LGWR to the redo log files.
Session Logical Reads
The number of data blocks read by Oracle, which are already present in the buffer cache, thereby requiring no I/O read operations. The value of this metric is a summary of the db block gets and consistent gets metrics.
Sorts (Disk)
Sorts (disk) are sorts that require creation of temporary segments on disk to store the intermediate sort results. Such sorts are carried out if the data being sorted cannot be fit into memory block specified by the SORT_AREA_SIZE parameter in the init.ora file.
Sorts (Memory)
Number of sort operations that were carried out entirely in memory, without requiring any disk writes. The sort operation can take place in memory if the sorted data can be fit into the memory block specified by the SORT_AREA_SIZE parameter in the init.ora file.
Sorts (Rows)
The total number of rows sorted.
Table Scan Blocks Gotten
The number of blocks encountered during the full table scans
Table Scan Short Tables
The number of times Oracle carried out a complete scan of a short table
Table Scans Cache Partitions
Number of range scans performed on tables that have the CACHE option enabled
Table Scans Direct Read
Number of table scans performed using direct read (bypassing the buffer cache)
Table Scans Fetch by ROWID
Number of rows that were fetched using a ROWID (usually recovered from an index)
Table Scans Long Tables
The number of times Oracle carried out a complete scan of a long table
Table Scans ROWID Ranges
The number of table scans conducted during parallel query by the query slaves, with the specified ROWID ranges
Table Scans Rows Gotten
The number of rows scanned during full table scans. High values may indicate use of non-optimal queries, absence of proper indexing, or both.
Tables Fetch Continued Row
Number of times a chained or migrated row is encountered during a fetch.
Total Physical Data I/O Operations
The total number of read and write operations carried out for the data file.
Total Sorts
Total number of sort operations, including both in-memory and disk sorts.
User Calls
Number of user calls such as login, parse, fetch, or execute. The value of this metric represents the rate at which the user application addresses Oracle.
User Commits
Number of transactions committed during the current interval. After a transaction is committed, the redo generated by that transaction reflects the changes made to database blocks, and the database blocks must be written to disk.
User Rollbacks
Number of transactions that were rolled back, either because of an error or as a result of a manually executed ROLLBACK command
Write Time
The total time spent on writing data to the datafile
Writes Per Second
The number of times DBWR was required to write per second.
The Jobs Queue collection provides jobs queue information and status.
Active Jobs
The number of currently running jobs
Jobs Idle
The number of scheduled jobs that are currently not running
Jobs Waiting
The number of jobs that are scheduled to be running now but waiting in queue for the resources
Total Jobs
The total number of scheduled jobs
계열사 지원 사이트에서 Quest *제품*에 대한 온라인 지원 도움말을 볼 수 있습니다. 올바른 *제품* 지원 콘텐츠 및 지원에 연결하려면 계속을 클릭하십시오.
The document was helpful.
평가 결과 선택
I easily found the information I needed.
© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center
Quest Software 포털은 더 이상 IE 8, 9, 10을 지원하지 않습니다. 브라우저를 최신 버전의 Internet Explorer나 Chrome으로 업그레이드하는 것이 좋습니다.
IE 11로 업그레이드 여기를 클릭
Chrome으로 업그레이드 여기를 클릭
IE 8, 9 또는 10을 계속 사용할 경우 당사가 제공하는 뛰어난 셀프서비스 기능 모두를 최대한으로 활용하실 수 없습니다.
