Oracle Database - Database

Card Puncher Data Processing

About

A database in the context of Oracle is a collection of files (physical structures):

  • data files,
  • control files,
  • redo log files

A database may be mounted and opened by many instances.

This physical structures contain logical structures:

  • tablespaces,
  • schema objects,
  • data blocks,
  • extents,
  • and segments.

Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.

Data Dictionary

select   
   db_unique_name,
   database_role,
   open_mode
from      
   v$database

Status / Open

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;

Database altered.

apps/search/search.jsp





Discover More
Card Puncher Data Processing
Oracle Database - (initialization|server) parameter file (init.ora | spfile.ora)

How to manage the initialization parameters when the database start. By default, the preconfigured database uses a parameter file (spfile) named spfilesid.ora, which is stored in the $ORACLE_HOME/dbs...
Card Puncher Data Processing
Oracle Database - Control Files

Every Oracle database has a control file. Every time an instance of an Oracle database is started, its control file identifies the physical structure: the datafiles, the tempfiles, and redo...
Data Pump Sqldeveloper
Oracle Database - Data Pump - (Export|Import) Utilities

Oracle Data Pump works with the file system of the database whereas Export and Import utilities works with the client file system. Since Oracle Database 10g, Oracle Data Pump enables movement of data...
Oracle Database One Instance By Database
Oracle Database - Instance (Database Start-up)

When you start a database, an instance is created. An instance is comprised of: a memory area called the System Global Area (SGA) and Oracle background processes. The memory and processes of an...
Card Puncher Data Processing
Oracle Database - Internal Locks

Internal locks are higher-level, more complex mechanisms than latches and mutexes and serve various purposes. The database uses the following types of internal locks: These locks are of very short...



Share this page:
Follow us:
Task Runner