Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to enable statistics collection to specific schemas in 11g

kumarskJun 17 2012 — edited Jun 17 2012
Hi,

Oracle Version: 11.2.0.2

OS: AIX 5.3


I have the requirement to collect the statistics to certain oracle users only using dbms_auto_task_admin package.

I am looking this at http://www.bash-dba.com/2012/05/oracle-11g-automated-maintenance-tasks.html

But, with the above the link , we can enable stats collection to all the schema objects in the database.


I want to enable stats collection for specific schema objects and how can i do using the dbms_auto_task_admin package ?


Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2012
Added on Jun 17 2012
#general-database-discussions
5 comments
609 views