You can use what is below to print out each session that is currently executing (or has pinned) a given stored procedure 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 COLUMN owner format a20 COLUMN name format a30 COLUMN type format a15... »
Archive for May, 2011
How much can I shrink my datafile?
Monday, May 2nd, 2011
Periodically, we will need to shrink a datafile. In Oracle, you can only shrink a file to the point occupied by the “highest” block in the file. The SQL below will provide you with the SQL to execute for each datafile after calculating the size to which it can be shrunk. SET LINES 1000... »