Thursday, March 25, 2010

Solaris 10 administrator cheat

http://blogs.sun.com/lyon/entry/solaris_certified_administrator_cheat_sheet

Add swap file on Solaris 10

mkfile 1024m /swapfile
swap -a /swapfile

You then need to add the following line to /etc/vfstab...

/swapfile - - swap - no -

To determine the size of the configured swap space, enter the following command:

# /usr/sbin/swap -s

To determine the physical RAM size, enter the following command:

# /usr/sbin/prtconf | grep "Memory size"



Wednesday, March 24, 2010

Oracle Client / Server Interoperability Support

http://orcl.tistory.com/entry/Oracle-Client-Server-Interoperability-Support

Tuesday, March 23, 2010

SSIS - Connect to Oracle on a 64-bit machine

http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx

Choosing a Recovery Model for Index Operations

http://msdn.microsoft.com/en-us/library/ms191484.aspx


ALTER INDEX ... REORGANIZE is Equivalent to DBCC INDEXDEFRAG

ALTER INDEX ... REBUILD is Equivalent to DBCC DBREINDEX