Control Files Has 8 Cntrl Files
Data file contain original dataRedo file contain transaction filesControl files contains database files,log files, details about about, crucial information.if the data is lost then database is lostOrcle database and instance database(memory area)(original files physical files) Parameter file contains about the path info,size etcControl files has 8 cntrl filesSystem contain crucial files ,meta data of every obtainSysaux contain Performance related , statics of dataTemp files contain order by idUndo files back up of my dataUsers files keep some data in that.To reduce the load on the data system fles[pic 1]Control RedoData [pic 2]Client end one process is instated  client sideserver end one process is instated  server sideboth communicate and query moved Syntaxly and synimaticallyfwd parsing’and/  database buffer cache is contain of database fileserver processhow does a select statement  work??Softparsing?previous query Is already usedHard parsing?and new query is executionUpdate works?Syntaxly and synimaticallySlect query and chage in dbbc and datafiles
Database writer is used to wire the databaseCheckpoint other back end process it will update control files Updating the number SCN-system change numberLogwriter Archived log files is used as a back files or redo files are ful in that case it is saved in archivedRecover is nothing but the recover the databaseSystem monitor (temp tablespace)SMONWhen sorting for an information.Sharedpool        Library cache-shared SQL areaDbbc data blocks are retrived in data filesBackground processCheckpointPmonSmonLogwriterArchiverRecoverLarge pool when used for parallel query or backup filesJava pools used for java applicaionPGA-it is specifically design for end usersShared poolBuffer cacheRedo log buffer are usesKeep poolRecycle pool these are used for temporary processStarting up a database can by one user SYSSql>startupNomount→pfile(detail of data base)Mount→control file( data base is consisted or not)Open →Startup nomount pfile=Ănt test.org’→after database mount→after database openShutdown  normal/immediate/transactional/abort