![]() ![]() For a local connection, you identify the instance by setting operating system environment variables ORACLE_SID and ORACLE_HOME. ![]() Because there can be multiple Oracle databases on a host computer, each with its own set of data files, you must identify the instance to which you want to connect. Metadata, or "data about the data," consists of structural, configuration, and control information about the database.Īn Oracle instance (also known as a database instance) contains the set of Oracle Database background processes that operate on the stored data and the shared allocated memory that those processes use to do their work.Įach instance has an instance ID, also known as a system ID (SID). Overview of the Oracle Instance and Instance ManagementĪn Oracle database system consists of an Oracle database and an Oracle instance.Ī database consists of a set of disk files that store user data and metadata. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |