Chatta subito con l'assistenza
Chat con il supporto

Spotlight on Oracle 10.5 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

New Oracle User

When you create a new Oracle account for use with Spotlight on Oracle, you need to supply a user name and password for that account.

The additional options specified on this page give the Spotlight user greater access to the database. If you want to grant the additional privileges, select the Select any table and Alter system options.

Field Description
User name

Enter a name for the new user. You can type up to 30 characters. The first character of the user name must be a letter.

Note: (Oracle 12c) As per Oracle guidelines, the Spotlight Oracle user needs to be of the form “c##<username>” when connecting to an Oracle 12c Container database.

Password Enter a password for the new user. You can type up to 30 characters.
Confirm password Confirm the password. The password exactly as you typed it in the Password field.
Select any table Select to allow the user to generate explain plans for SQL statements created by other users.
Alter system Select to allow the user to trace and terminate sessions.

 

Related Topics

Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring...End

Select Tablespace

Spotlight stores data in the Oracle database while it diagnoses the performance of the system. Define where the data should be stored.

Control Description

Tablespace Table

This table is informative. Clicking on it has not effect. It lists the available tablespaces with the amount of free space in each.

Tablespace to use for Spotlight tables

Select the tablespace to store Spotlight tables.

The default is USERS, if available.

Tip: Use the Tablespace Table to identify the tablespaces with enough free space to host the tables.

Tablespace to use for temporary segments

Select the tablespace to store Spotlight temporary segments.

The default is TEMP, if available.

Tip: Use the Tablespace Table to identify the tablespaces with enough free space to host the segments.

 

Related Topics

Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring...End

Predictive Diagnostics

Select Create/Upgrade Predictive Diagnostics schema to use Predictive Diagnostics to collect and analyze performance metrics for this Oracle database in order to predict its future behavior.

 

Related Topics

Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring...End

Ready To Configure Oracle User

Spotlight is ready to change the Oracle database.

Option Description
Next Click to create / update the Oracle User based on the settings entered in the Oracle User Wizard.
Back Click to return to previous pages in the Oracle User Wizard, to edit the settings.
Cancel Click to close the Oracle User Wizard. No changes will be made.

 

Related Topics

Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring...End

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione