Spotlight Monitoring of Oracle Database link creation

Recently when performing performance tests, the developer directly hung all the business tables into the Oracle database because of the space data to be mounted. Several recent tests have found that the response time and throughput are not ideal, after some analysis of the suspect may have problems in Oracle, so I looked for the relevant monitoring program on the net, eventually found spotlight, but no detailed description (also may be I did not find), Here are some of the lessons I've learned about how to connect to Oracle and how to monitor it, so please advise me if you have any flaws.

First of all, the installation and deployment of spotlight I will not say, I believe that everyone is very smart, install so easy.

Here I want to say is must install Spotlight.On.Oracle, Spotlight.On.Oracle, Spotlight.On.Oracle, emphasize 3 times OH.

The following launches the spotlight, as shown in the interface below:

Click the Small plug on the toolbar or "file", "Connections" to open "Spotlight connections Manager" as shown in:

Before connecting to the Oracle database, we need to create a monitoring user for the database to be monitored, and through this monitoring user to obtain the monitoring information, first open the "file", "Oracle User Wizard" interface, as shown in:

Click "Next" to enter the admin rights login screen, remember the administrator permissions of the user, because we want to create a new user, as shown in:

The Network service name can be obtained from the Oracle client here, or it can be set directly through the "Server ip/DB instance" mode, and click "Next" after the configuration is complete, as shown in:

Login successfully appear above interface, otherwise prompt failed reason interface, if the monitoring database has not been created before monitoring user select "Create a new user (recommended)", otherwise select "Set up an existing user" (select an existing users) , click on the "Next" button as shown in:

After entering the monitoring user name and password you want to create, click "Next" as shown in:

Select table space (usually by default) and click "Next" until the creation is complete, as shown in:

Click "Finish" to complete the configuration, then create a new Oracle monitoring connection in "Spotlight Connections Manager" as shown in:

Double-click New Connection, select the connection type in the pop-up window, and enter the newly created connection name as shown in:

Click "OK" to eject the connection Parameters Configuration window as shown in:

If you need to monitor Oracle ASM and OS also set the relevant connection parameters, otherwise the check box in front of it is unchecked, as shown in:

Click "OK" and after selecting the connection name in "Spotlight Connections Manager", click "Connect" to connect, as shown in:

After the connection is successful, the Correction Time Prompt window is displayed, setting the correction time (that is, the refresh time) as shown in:

Click "OK" when Setup is complete and start monitoring the connected Oracle database as shown in:

Note: The green area is normal for the relevant area, and a yellow area indicates that the area exceeds the standard value warning, and the red area indicates an exception in the region

Sessions: Represents the session area including (Response: Response Session, total Users: Overall user volume, active Users: Active user volume, active Sessions: Active session percentage)

Server Processes: Servers process
PGA (Program Global area): Is the memory reserved for each user process connected to the oracledatabase.
target:pga_aggregate_target-This parameter specifies that the maximum PGA memory can be used for all session totals.
The total amount of USED:PGA (the program Global Zone) is currently used by all active sessions.

Dedicated: Dedicated server process
Shared: Sharing Server
Dispatchers: Number of dispatchers for shared connections
Parallel query: Parallel query that uses multiple OS-level server process to complete an SQL query at the same time.
Job Queue: Work queues

Sga:systemglobal area is the basic component of oracleinstance, which is allocated when the instance starts; The system global domain SGA consists of three parts: the shared pool, the data buffer, and the log buffer.
Current Size: Actual sizes
Buffer Cache: Data Cache area
Recycle Pool: Recycling Pools
Keep pool: Reserved pools
Buffer Cache Hit Ratio: Cache Hits
Redo buffer: Redo Log Buffer
Shared pool: Sharing pools
Shared pool used: pooled usage
Java Pool:java Pool-provides services for parsing Java commands.
Large Pool: Large pools-an optional memory area in the SGA that is used only in a shared server environment.
Auto off

Background Processes: Background process
Database Writer: Data writer
Recovery Writer: Recovery area writer
Redo log Writer: Redo Journal writer
Archiver: Archive Process

Disk Storage: Storage of disks
Database files: Databases file
Flashback Recovery: Flash back Recovery area
Redo Logs: Redo Log
Archive LOG: Archive logs

This time is just a simple use of instructions, mainly for rookie-level introduction, but also a share of previous experience, if there are errors please master positive, about Oracle related content, we can Baidu "Oracle database Architecture detailed"

Spotlight Monitoring of Oracle Database link creation