[Recommended] use of Quest. Central. For. Databases -- Spotlight

Spotlight helps you quickly identify performance problems and, to some extent, helps you solve basic problems that are directly related to these symptoms. For complex problems, especially when the backend layer encounters bottlenecks, Spotlight can help you identify problems and use more in-depth analysis tools to solve the problems. In the Spotlight warning window, you can see the problem at a glance. Notify the Administrator when the critical resource usage reaches the critical level. Issue a color alert to the Administrator and highlight the server or application component with performance issues. After locating a problem, Spotlight can provide expert suggestions and solutions for the problem.
The following uses Spotlight On Oracle as an example to describe how to use Spotlight (similar to Spotlight on Windows and Spotlight on SQL Server)

　　I,First, establish an Oracle connection

The first step is to create a connection so that spotlight can be used to connect to the database to be monitored.

II,System Main Interface

The main interface of the system reflects the overall running status of the system. If any problem occurs in the system, a corresponding warning will be reported. Different colors will be displayed at different levels, and the most serious warning will be red. Based on this warning, drill down to the corresponding subwindow to view the corresponding situation. The following sections describe the subwindows.

1. Session Panel:

(1) Response <10, system Response time

(2) Total Users: Total number of user sessions

(3) Active Users: number of user sessions being executed

　　2. Host panel:

(1) CPU utilization

(2) memory usage

　　3. Server Processes panel: displays the Server process information

(1) PGA Target/Used: displays the total number of PGA targets and current usage.

(2) dedicated displays the number of dedicated server processes

(3) Shared display the number of Shared server processes.

(4) Dispatchers displays the number of dispathers.

(5) JobQueue displays the number of job Processes

　　4. SGA panel: displays the memory usage of each component in SGA.

(1) CurrentSize: displays the number of M used by sga.

(2) BufferCache, KeepPool, and RecyclePool display the data buffer memory.

(3) SharedPool: usage of the Shared Pool

(4) RedoLog: usage of duplicate logs

(5) LargePool: usage of large pools

(6) JavaPool: java pool usage

　　5. Background process Panel-Background process Panel: displays Background processes related to disk I/O.

(1) DBWR Data Writing Process

(2) LGWR log process

(3) ARCH pattern

　　6. Disk Storage panel: displays major database files (excluding control files)

(1) DatabaseFiles: displays the usage of data files.

(2) Online log files. Including the number and size of groups.

(3) Archiving logs.

　　III,TopSessions

You can use the topSession panel to check which session currently occupies a large amount of resources to locate database problems. Click the upper list to display all the details of the session in session Information.

The following are some notes:

Most recent SQL: used to determine the SQL statement that currently occupies the largest resource

Session waits: identifies the wait events related to the session.

Session locks: displays the related lock information.

IV,Top SQL: view the corresponding SQL in libraryCache according to the conditions.

The main option is sorting.

You can find the SQL statements that have a big impact.

Click the Fetch SQL button to view the corresponding SQL statements.

V,Activity:This window mainly provides wait events, lock wait, unlock lock wait, and current transaction.

Vi. Configuration and memory: main displaySGAUsage and parameter configuration

VII. Disk Storage:Displays the table space utilization and usage of online logs.

Quest. Central. For. Databases:
Http: // 58.251.57.206/down? Cid = 1669258673 & t = 14 & fmt = & usrinput = Quest. Central & dt = 0 & ps = 0_0 & rt = 0kbs & plt = 0 & spd = 9
 
Note: The trial period of this software is only 7 days. I have a registration machine. If you need it, please leave an Email and send it in a unified manner!

Quest. Central. For. Databases:
[Recommended] [SQL optimization tool] Quest. Central. For. Databases -- SQL Tuning for SQL Server
[Recommended] use of Quest. Central. For. Databases -- Spotlight