OraChat – Oracle DBAs

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE ‘DBA_%’ ORDER BY TABLE_NAME; TABLE_NAME COMMENTS —————————— —————————————————————————————————- DBA_2PC_NEIGHBORS – information about incoming and outgoing connections for pending transactions DBA_2PC_PENDING – info about distributed transactions awaiting recovery DBA_ADVISOR_ACTIONS – DBA_ADVISOR_COMMANDS – DBA_ADVISOR_DEFINITIONS – DBA_ADVISOR_DEF_PARAMETERS – DBA_ADVISOR_DIRECTIVES – DBA_ADVISOR_FINDINGS – DBA_ADVISOR_JOURNAL – DBA_ADVISOR_LOG – DBA_ADVISOR_OBJECTS – DBA_ADVISOR_OBJECT_TYPES – [...]

After running Gather Schema Statistics concurrent request with (LASTRUN) option to save only the history for last run, then run the concurrent request again for 2 times after that found that (FND_STATS_HIST) tables contains the history for all the 3 requests and it is not cleaned up to keep only last run. Sample steps to [...]

If you conducted an import or export of an Oracle10g Release 2 or 11g Release 1 database prior to September 11, 2009, you should follow the instructions in My Oracle Support Knowledge Document 1055539.1 to verify the privileges in your database. This is because a missing step in several OracleMetaLink notes published before 11 September [...]