Chat now with support

Live-Hilfe anfordern
Registrierung abschließen

Anmelden

Preisinformationen anfragen

Vertrieb kontaktieren

Spotlight on Oracle 11.0 - Getting Started Guide

Inhaltsnavigation

Welcome to Spotlight Install Spotlight

Multiple Concurrent Installations MSI Installers for Spotlight on Oracle Uninstall Spotlight

Start Spotlight

Authorize Spotlight

Spotlight on Oracle

Connect to an Oracle Database

Oracle Connection Details

Oracle User Wizard

DBA Connection Credentials User Account New Oracle User Select Tablespace Predictive Diagnostics Ready To Configure Oracle User End

Configuring Oracle User for Spotlight Dialog Toad DBA Suite for Oracle Oracle Architecture Overview Spotlight on Oracle Home Page Spotlight on Oracle Alarms Spotlight on Oracle Drilldowns Install And Configure DTrace Scripts Tune Your Oracle Database Predictive Diagnostics Spotlight on Oracle Tools: Explain Plan, SQL Optimizer, Space Manager

Spotlight on Oracle Data Guard

Standby Connections Dialog Spotlight on Oracle Data Guard Home Page Spotlight on Oracle Data Guard Alarms

Spotlight on Oracle RAC

Connect to Spotlight on Oracle RAC

Oracle RAC Connection Details Verify Cluster Connection Details Dialog Connect to an Exadata Storage Server (Cells)

Spotlight on Oracle RAC Home Page Spotlight on Oracle RAC Alarms Spotlight on Oracle RAC Drilldowns

Spotlight on Unix

Configure the Unix System Connect to Unix Systems

Unix Connection Details

Spotlight on Unix Home Page Spotlight on Unix Alarms Spotlight on Unix Drilldowns

Spotlight on Windows

Connect to Windows Systems

Windows Connection Details

Spotlight on Windows Home Page Spotlight on Windows Alarms Spotlight on Windows Drilldowns

Troubleshooting: Connection Problems

Troubleshooting Spotlight on Windows

The Registry ... is not accessible. Connecting As The Logged-in User WMI Connection Problems

Spotlight on Oracle

Shared Pool Latch Wait Alarm

Shared pool latches control access to the shared pool memory map.

The primary cause of contention is excessive hard parsing. This can indicate the need to use bind variables or adjust the CURSOR_SHARING parameter.

To combat shared pool fragmentation:

Flush the shared pool periodically using the ALTER SYSTEM FLUSH SHARED POOL command.
Set a minimum value for the shared pool if you are using automatic SGA memory management. Alternatively, revert to manual memory management.
Use DBMS_SHARED_POOL to prevent large objects from moving in and out of memory.

Related Topics

Parse Activity Page

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center