Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Collaboration Suite Archived Forums
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 4, 2008 2:01 AM by
updating stats on all tables
Apr 2, 2008 8:41 PM
I'm needing to update statistics on all tables in a schema, is there a command to do this without writing a script to do so?
Also, I have 15 schemas in my database, would it be possible to do an update stats on all the tables in each schema, under 1 command without logging iinto each schema seperately.
This content has been marked as final.
Show 1 reply
Re: updating stats on all tables
Apr 4, 2008 2:01 AM
in response to
execute the procedure GATHER_DATABASE_STATS
PS : this is not the right forum, this one is dedicated to Oracle Collaboration Suite, not Database