Month: July 2004

nnnnn Make the tablespace Read-Only = alter tablespace xxxx read only; Export it connecting as sys as sysdba = exp file=tt.dmp log=tt.log tablespaces=xxxx transportable_tablespaces=y Copy the .dmp file and the data_files to the destination Put the tablespace back in write mode = alter tablespace xxxx read write; In the destination offline and drop the tablespace…

nnnnnschedule a job which uses the undocumented call xp_fixeddrives Or you can try with master..xp_cmdsh

nnnnn Datafile I/O DATAFILE I/O NOTES: File Name – Datafile name Physical Reads – Number of physical reads Reads % – Percentage of physical reads Physical Writes – Number of physical writes Writes % – Percentage of physical writes Total Block I/O’s – Number of I/O blocks Use this report to identify any “hot spots”…