Application Tuning

Posted on

These questions are based on 1Z0-045 – Oracle Database 10g DBA New Features for Oracle8i OCPs.

 

Objective: Application Tuning
Sub-Objective: Use the SQL Tuning Advisor

 

Single Answer, Multiple Choice

 

You want to use SQL Profile APIs. Which system privilege is not required to use SQL profile APIs?

 

 

  1. CREATE SQL PROFILE
  2. DROP ANY SQL PROFILE
  3. ALTER ANY SQL PROFILE
  4. CREATE ANY SQL PROFILE

 

Answer:
A. CREATE SQL PROFILE

 

Tutorial:
The CREATE SQL PROFILE privilege is an invalid system privilege and is not required to use SQL Profile APIs. The correct privilege is CREATE ANY SQL PROFILE, which is used to create a SQL profile.

 

SQL profiles are managed through the DBMS_SQLTUNE package. To use SQL Profile APIs, you require the following system privileges:

 

 

  • DROP ANY SQL PROFILE is used to drop a SQL Profile.
  • ALTER ANY SQL PROFILE is used to alter the attributes of a SQL Profile.
  • CREATE ANY SQL PROFILE is used to create a SQL Profile.

 

Reference:
1. Oracle University – Oracle Database 10g: New Features for Administrators – Application Tuning
D17079GC10
Edition 1.0
February 2004
D39100

 

2. Oracle University – Oracle Database 10g: New Features for Administrators – Application Tuning
D17079GC21
Edition 2.1
October 2005
D22243

 

3. Oracle Database Performance Tuning Guide
10g Release 2 (10.2)
Part Number B14211-01
Chapter: 12 Automatic SQL Tuning
Topic: 12.4 SQL Profiles
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/sql_tune.htm#i36634

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: