Oracle DBA Scripts
Oracle Production support DBA Tips
Friday, August 27, 2010
When we last gathered stats in Oracle 11G
›
select * from dba_optstat_operations; To see the current retention value, select dbms_stats.get_stats_history_retention from dual;
Monday, August 23, 2010
BIND VARIABLE PEEKING
›
There are 3 things that might put you at risk of unstable plans due to bind variable peeking. 1. Histograms: The histogram tells Oracle abou...
Friday, August 20, 2010
shrink the undo tablespace to free up some disk space after some unusual database activity
›
1. define a new temporary undo tablespace CREATE UNDO TABLESPACE "UNDOTBS2" DATAFILE '/u01/oradata/xxxx/undotbs201.dbf' SI...
1 comment:
Friday, July 16, 2010
shrink table in Oracle 10g/11g
›
In oracle 9i and below you need to export the table, drop the table and import the table to reclaim the unused space. In oracle 10g you need...
Thursday, July 15, 2010
Problem with "library cache pin' when deplyoing the package
›
Problem: Today i have been asked to deploy a package in the production. Same package has been deployed in staging and UAT successfully with ...
›
Home
View web version