Oracle : Oracle Server Architecture

Oracle Server Architecture   An Oracle server includes an Oracle Instance and an Oracle database. Oracle instance:  An Oracle Instance is a combination of two different sets of components. The first component includes the Memory components. That is nothing but SGA (shared global area or system global area)   The second… Read More

Oracle : SPFILE AND PFILE

                                SPFILE   SPFILE IS SERVER PARAMETER FILE SPFILE IS A SEMI BINARY FILE. WE CANNOT EDIT MANUALLY WE CAN EDIT AS DYNAMICALLY BY USING ALTER SYSTEM ITS SPECIALY MADE FOR RAC (REAL APPLICATION CLUSTER) WE CAN CREATE SPFILE AT ANY STAGE(nomount,mount,open) IF YOUR DATABASE… Read More