Tagged Questions
2
votes
1answer
80 views
Oracle: How to gather stats in a logical standby database?
I have a Primary and a (logical) Standby Database. The Schema 'APP' gets synced.
Now a User has performance issues running a query against some tables in this 'APP' schema of the Standby Database. On ...
0
votes
1answer
164 views
Oracle not trusting statistics after an import?
We are seing some strange behavior in the way Oracle is handling statistics of an imported schema.
We build a schema on the dev system, analyze if and import into the production with the stats.
For ...
1
vote
1answer
298 views
Why is DBA_SEGMENTS presenting twice the amount of data than the DBA_TABLES?
I tried to compute the audit log table usage using the following steps:
Truncate all the audit log table data (i.e. AUD$)
Perform test case that inserts and update data, also delete statement but it ...
0
votes
1answer
79 views
Getting statistics of a table in Oracle
What is more efficient to gather table statistics:
Using dbms_stats.gather_table_stats?
Using analyze table?
