Most of us probably do not know the exact differences the instance and the database. Many think that the database is the instance. For a more critical then to wonder, if so what is the use of Oracle database instance and use the term?
If we create a database with DBCA, by default instance name and database name that does the same. Is the name of the current database we maintain that the same as the instance name?
- To check the name of the instance, Oracle DBA must have all already know. Value of the ORACLE_SID is the name of the instance as well.
- To check the database name, use the command select VALUE from v$parameter where NAME = 'db_name'
More specifically, it helps us see the Oracle Database Architecture here
The instance is the processes structure and memory that run the database system (DBMS, database management system). While the database is a collection of files that store the data (which consists of datafile, controlfile, and redo log files).
Oracle Database terms that we often use it to refer to the database management system (DBMS) Oracle. said database management system may be too long. DBMS might say well why not. So easy-going, let's call it database.
reference : rohmad.net
Tidak ada komentar:
Posting Komentar