Archive for the ‘scripts’ Category

Installing dbms_profiler

Friday 22 June 2007

This page has been moved to http://andrewfraserdba.com/?p=48

What SQL and sessions are running?

Friday 20 April 2007

This page has been moved to http://andrewfraserdba.com/?p=38

Bug? with wrong results from all_objects in stored plsql procedures

Friday 2 March 2007

This page has been moved to http://andrewfraserdba.com/?p=32

10046 tracing in another session

Wednesday 14 February 2007

This page has been moved to http://andrewfraserdba.com/?p=29

Clone a database

Friday 9 February 2007

This page has been moved to http://andrewfraserdba.com/?p=28

Slow SQL report

Wednesday 7 February 2007

This page has been moved to http://andrewfraserdba.com/?p=25

Using 10g datapump and scheduler to copy schemas

Thursday 1 February 2007

This page has been moved to http://andrewfraserdba.com/?p=19

Identify what auditing is on

Wednesday 17 January 2007

This page has been moved to http://www.andrewfraserdba.com/?p=14

Pre 9202/9014: Advanced queuing runs away with server memory.

Monday 15 January 2007

This page has been moved to http://www.andrewfraserdba.com/?p=12

Script run against every running database, listing total oracle memory (sga+pga)

Monday 15 January 2007

This page has been moved to http://www.andrewfraserdba.com/?p=11