How to Boot Up Your Oracle Performance

This is a good Oracle Performance Tuning video I have came across on youtube. This is a good video for both Developer and DBA. The presenter gave a very good and clear explanation. This is one of the Oracle tutorial series from the same presenter.

There were 2 different type of tuning that were discussed in this video System Tuning and SQL Tuning. Roughly, System Tuning involves the appropriate system parameters configuration and SQL Tuning involves the individual SQL statement tuning.

Here are what were introduced in this video:

System Tuning

• Tuning log (redo log) switches
• pga_aggregate target (9i)
• Tuning advisors (views hints)
• Pinning packages in memory
• Statspack

SQL Tuning

• Indexes
• Oracle Optimizer
• Explain Plan
• Hints
• Stored Outlines

Read More

Improve Performance, Reduce Data Growth Costs - Archiving ERP Applications

View this Webcast to find out from the experts how effective application archiving can help you effectively manage your production database, control data growth, and ultimately improve your bottom line. You'll learn to:

* Improve performance of the production environment
* Archive or purge inactive transactional data automatically to an online database or offline flat file
* Maintain complete application integrity
* Comply with data retention regulations
* Reduce application storage footprint
* Enable accessibility to archived data
* Further your bottom-line savings with application retirement
more on this...

Read More