-
Automated stats gathering
10g has our auto stats collection. But how do you know if it running. Is there a table to check apart from last_analyzed from user/dba_tables?
thanks
Looking for the greatest evil in the world? Look in the mirror.
-
Em Statistics Management
Enterprise Manager-> Administration-> Statistics Management-> Manage Optimizer Statistics
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally Posted by LKBrwn_DBA
Enterprise Manager-> Administration-> Statistics Management-> Manage Optimizer Statistics
Thanks...but this is assuming you have EM. Is there any table/feature to check right off the database/sqlplus?
Looking for the greatest evil in the world? Look in the mirror.
-
you already said it yourself, user/dba_tables
-
Check dba_scheduler_jobs
Regards
-
But you do have EM
Originally Posted by Tuma
Thanks...but this is assuming you have EM. Is there any table/feature to check right off the database/sqlplus?
EM is included in all 10g+ databases, just install it:
Code:
$ emca -config dbcontrol db -repos create
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
[QUOTE=LKBrwn_DBA;260701]EM is included in all 10g+ databases, just install it:
Code:
$ emca -config dbcontrol db -repos create
QUOTE]
Does this need to be licensed?
Looking for the greatest evil in the world? Look in the mirror.
-
Originally Posted by Tuma
Does this need to be licensed?
Did you check Oracle Licensing? -guess not, here http://www.oracle.com/corporate/pricing/pricelists.html
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|