Performance issue with AUD$ table
RDBMS: 11.2.0.1
I migrated AUD$ table and corresponding indexes to a different tablespace long time ago. The ADDM reports consistently pointed to a query that is taking close to 2mins to run. The same query when run in a similar version of database with default AUDIT settings return results within 3seconds. I have been searching for metalink documents related to performance improvement of AUD$ table. One of the document suggested that i should adjust storage parameters. Here is a comparison of stats for AUD$ table in two different databases:
CUSTOM DEFAULT
Size 2.39G 695M
Extents 22,402 158
pctfree 10 10
pctused -- 40
nextextent 64K 1M
I migrated AUD$ table and corresponding indexes to a different tablespace long time ago. The ADDM reports consistently pointed to a query that is taking close to 2mins to run. The same query when run in a similar version of database with default AUDIT settings return results within 3seconds. I have been searching for metalink documents related to performance improvement of AUD$ table. One of the document suggested that i should adjust storage parameters. Here is a comparison of stats for AUD$ table in two different databases:
CUSTOM DEFAULT
Size 2.39G 695M
Extents 22,402 158
pctfree 10 10
pctused -- 40
nextextent 64K 1M
0