Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table stats in a standby database

Status
Not open for further replies.
VicMcD

VicMcD

Technical User
Jul 25, 2000
36
0
0
NZ
I am running a Oracle 9 standby database and applying logs using a script. Do I have to run a full table stats after activating thhe database or are they updated by the database logs?
 
Sort by date Sort by votes

They are updated when the logs are applied on the standby database -- when you execute "analyze" or "DBMS_STATS" all stats updated are recorded in the logs as any transaction update.

[noevil]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
170
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
141
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
162
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Copy a table from Test to Production
Replies
1
Views
63
carp
carp
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
202
carp
carp

Part and Inventory Search

Sponsor

Back
Top