Database ( 14 Sep. 2012 )
Today’s main topics · Data Base Files · Memory · Logical / Physical Structure · Processes v Solaries O.S. is the best O.S. to run a database v Windows is the worse O.S. to run a database v CMMI is an IT standard on which all software houses are ranked v ETL Technology ( Link ) Data Base Administrator Responsibilities Ø Installation Ø Standards / guide lines & operational policies Ø Storage media Ø Network area storage Ø SQL performance & tuning Ø Backup & recovery Ø Database performance issue Ø Memory usage issue Ø Security Ø Test database Ø Upgrade database …………… Some major File types in database Ø Control files having “ .ctl “ extension Ø Data files having “ .dbf “ extension Ø All data stored in data files Ø Online redolog Ø Archive logfile (Archives are things which people use so rarely ) Ø Password files Ø Parameter file