Oracle - Transportable Tablespaces

• 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 if exists
• Import = imp file=tt.dmp log=tt.log tablespaces=test transportable_tablespace=y datafiles=(......., ........)

Sqlserver database maintenance--Free disk space.

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

Oracle :: Disk I/O, Events, Waits

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" or I/O contention

select  NAME,
PHYRDS "Physical Reads",
round((PHYRDS / PD.PHYS_READS)*100,2) "Read %",
PHYWRTS "Physical Writes",
round(PHYWRTS * 100 / PD.PHYS_WRTS,2) "Write %",
fs.PHYBLKRD+FS.PHYBLKWRT "Total Block I/O's"
from (
select  sum(PHYRDS) PHYS_READS,
sum(PHYWRTS) PHYS_WRTS
from   v$filestat
) pd,
v$datafile df,
v$filestat fs
where  df.FILE# = fs.FILE#
order  by fs.PHYBLKRD+fs.PHYBLKWRT desc