WARNING FOR ORACLE STANDARD DATABASE USERS, 10G TUNING FEATURES RESTRICTIONS!!!!Hi,
If you are Oracle Standard Database user, you had heard about new tunning features like access and Sql Access advisors.
Now you must know you can't use them.
To use this packs you must have a separate license AND you MUST be using Oracle Enterprise Edition.
1) If you are using Database Control, the first time you connect using SYSMAN, you must disable that features.
2) You must be aware you can use these packages too from the Database
The usage of this features is registered in the database
For example:
ViewsV$ACTIVE_SESSION_HISTORY
DBA_HIST_*
DBA_ADVISOR_*
MGMT$*
packagesDBMS_SQLTUNE,DBMS_ADVISOR,DBMS_WORKLOAD_REPOSITORY
Scriptsawrrpt.sql, awrrpti.sql, addmrtp.sql, addmrpti.sql,
awrrpt.sql, awrrpti.sql, addmrpt.sql, addmrpti.sql, ashrpt.sql, ashrpti.sql,
awrddrpt.sql, awrddrpi.sql, awrsqrpi.sql, awrsqrpt.sql, sqltrpt.sql.
Other Database Control featuresOracle Configuration Management Pack
¦ Database and Host Configuration
¦ Deployments
¦ Search configuration
¦ Compare configuration
¦ Policies, including Security checks and scoring
The detailed information is in online documentation
http://www.oracle.com/pls/db102/portal.portal_db?selected=3
Oracle® Database Licensing Information
10g Release 2 (10.2)
B14199-03
http://www.oracle.com/pls/db102/to_pdf?pathname=license.102%2Fb14199.pdf&remark=portal+%28Books%29