martes, 27 de abril de 2010

Oracle 1OG Performance and Tuning

http://husnusensoy.wordpress.com/2009/10/30/how-to-install-oracle-11g-release-2-on-oel-5-4-on-virtualbox-installing-grid-infrastructure/

alter system flush buffer_cache;

alter system flush shared_pool;

http://www.red-partner.com/pdf/UsoDeBitmapJoinIndexes.pdf

http://www.oracle-base.com/articles/10g/TablespaceManagement10g.php

v$session_wait

Tablas IOT
http://plsqlhowtos.blogspot.com/2008/10/notes-on-index-organized-tables.html
Vistas Materializadas
Vista Materializadas Log

ALTER SESSION ENABLE RESUMABLE

AFTER SUSPEND TRIGGER

http://jjmora.es/Rendimiento_Tuning_Solaris_Memoria_Swap/