ORACLE INSTANCE
- Whenever we want to work with the database then we need an instance. The instance can be defined as memory + background processes
- The instance is used constantly by oracle to process all the requests that the database is recieving from its users.
- When we start an oracle database then an exclusive memory area is allocated for that database in the ram of the server. This memory area is known as the system global area (SGA). All user requests for reading, writing and modifying data in the database are performed in the SGA.
No comments:
Post a Comment