Configuration and use of performance monitoring tools five-point color platform Build-Spotlight on Oracle (Oracle)

Spotlight is a strong five-color platform to build "journey Source Forum zhengtuwl.com" Contact: qq:2747044651 Powerful Oracle Database real-time performance diagnostic tool, provides an intuitive, Visual database activity presentation. Spotlight Visualize Performance bottlenecks once an indicator exceeds acceptable thresholds. And, with drill down, DBAs can easily and quickly trace the underlying cause of performance bottlenecks "Journey Source Forum zhengtuwl.com" Contact: qq:2747044651

Spotlight do not need to take the five-color source download five-color source download five-point color Platform Builder Terminal Installation Agent, only need to create some management objects.

Spotlight on Oracle integrated Spotlight onunix/linux/windows and Spotlight on MySQL.

1.2. Fundamentals
Get Oracle's data dictionary and dynamic performance view, then show results

1.3. Tool Installation
Download the installation software (Toad_for_oracle_12_8_x86_full.exe, you can select only one, Spotlight on Oracle), follow the instructions step by step installation, pay attention to language selection when you can choose Chinese;

1.4. Establish Oracle Connection (required)
(1) Install Oracle client instantclient_11_2;

Configure the System environment variable path and tns_admin are the installation paths for instantclient_11_2;

To configure the Tnsnames.ora file, fill in the required database instance information as follows:

(2) establishing an Oracle connection

If you need to monitor the operating system synchronously, you need to enter the user name and password of the operating system; Select the database configured in the database client Tnsnames.ora;

Configuration and use of performance monitoring tools five-point color platform Build-Spotlight on Oracle (Oracle)