Oracle has created a site showing best practices for high availability.
Posts Tagged ‘Performance Tips’
Resources on Oracle’s Best Practices
Tuesday, March 31st, 2009Increase Performance Using Set_SQL_Constraint from a Large Table
Wednesday, February 27th, 2008Assuming you are using a SQL database and a Flex2SQL driver, the Flex2SQL driver has a feature, SQL_Set_Constraint, that automatically adds a constraint to find all operations.
Using ACTIVATE TIME STAMP
Wednesday, February 27th, 2008You must change the FD (field definition) files and insert the macro command.
Using StatsPack to monitor Oracle performance
Monday, February 25th, 2008StatsPack is an Oracle package for monitoring performance statistics.
Rollback Segment Size in Oracle
Monday, February 25th, 2008Rollback segment size refers to needing an accurate minimum number of bytes required by the rollback segment for any single given transaction or for the most important of these. There are differences between the kind of transactions (INSERTS,UPDATES and DELETES). For example the INSERTS generates less UNDO than deleting records because while rolling back an insert only requires deleting the row, rolling back a delete requires reinserting that row. It would take less bytes to store a rowid than to store information to reconstruct the actual row itself.