Select one of the available options.
| Field | Description |
|---|---|
| Create a new user |
This user does not have an Oracle account on the database. Create a new Oracle user that Spotlight can use to connect to the database. |
| Set up an existing user |
The user has an Oracle account on the database, but has not been configured to use Spotlight on Oracle. Use this option if there is an existing account on the target Oracle database that you want to use when connecting via Spotlight on Oracle. |
| Reconfigure "user" for use with Spotlight |
(Available when a new version of Spotlight on Oracle has been installed.) Use this option if you want to connect to an Oracle database as a user that was set up within a previous version of Spotlight on Oracle. Note: This option is available only if Spotlight detects that the current user has been configured using an earlier version of Spotlight on Oracle. |
Note: You should not use any system accounts as your Spotlight user account. We recommend creating a separate user for Spotlight or using a personal account.
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.
Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring... | End
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. |
Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring... | End
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. |
Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring... | End
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.
Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring... | End
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center
