I am working as an Oracle developer. I have an "Insert-Heavy" table which is accessed by several sessions concurrently. It is essentially an audit table which stores changes made to all other tables in the database.
I am trying to tune performance of insert statements into this table.
Note that I can use only schema level and session level parameters to tune this.
In other words - the following are ruled out:
- database level parameters
- operating system level parameters
- Partitioning / Bit-Map Indexes
- Dropping and Re-Creating Indexes
Based upon my research, the following are some of the things which are on the table:
- configuring FREELISTS
- configuring PCTUSED / PCTFREE
Are there any other options available?
The database version is Oracle 11.2.0.4.
Thanks & Regards
Camillelola
