Titlebook: Secrets of the Oracle Database; Norbert Debes Book 2009 Norbert Debes 2009 DBMS.Interface.Oracle.SQL.business intelligence.database.databa

Endoscope

Psychogenic

基因组

IND$, V$OBJECT_USAGE, and Index MonitoringThe view V$OBJECT_USAGE is partially documented in the . manual and in the .. The purpose of this view is to classify indexes as used or unused. Since SELECT statements don’t benefit from unused indexes, and modifications through INSERT, UPDATE, and DELETE statements must maintain indexes, it may be worthwhile to drop unused indexes.

canvass

Event 10079 and Oracle Net Packet ContentsThe undocumented event 10079 may be used to dump Oracle Net traffic to a trace file. It is useful for quickly determining which SQL statements, PL/SQL calls, or SQL*Plus commands send sensitive data such as passwords unencrypted.

Bridle

Introduction to X$ Fixed TablesA few X$ tables are mentioned in the documentation, but the vast majority are undocumented. For example X$BH is mentioned in the .. The . contains a procedure for resolving locking issues pertaining to the library cache by accessing X$KGLLK.

Inoperable

X$BH and Latch ContentionThe X$ fixed table X$BH is partially documented in .. This chapter provides additional information on X$BH. Contrary to what you might expect, I will show that scrutinizing undocumented X$ tables such as X$BH is not necessarily the royal road to optimum system performance.

抗原

Norbert DebesExclusive – Gives readers the ability to "join the club" of those having knowledge that traditionally has only been available to those with the "right" insider contacts..Authoritative – written by an

ENNUI

FRAX-tool

https://doi.org/10.1007/978-1-4302-1953-8DBMS; Interface; Oracle; SQL; business intelligence; database; database administration; performance

dissolution

Event 10053 and the Cost Based Optimizerwith the undocumented event 10053. Oracle Support will usually request such a trace file if you intend to file a technical assistance request against the optimizer in situations where it fails to find an execution plan that yields an acceptable response time.