Read this Oracle Tutorial Point article to know what is oracle database and what should we consider in oracle database. As per Oracle database management system, database is a collection of data in one or additional files. The database will contain physical and logical structure. The course of developing associate application consists of,
Within the oracle database, the basic structure may be a table. The various tables supported by oracle database are,
All the logical structures in the database should be stored in the database. Oracle maintains a data dictionary, which records METADATA about objects. The objects which require physical area that are allocated space within a TableSpace.
TableSpaces:
It consists of one or more data files. A data file can be a part of one and only one table space. As per Oracle minimum table space is made are,
Temporary TableSpaces:
The actual table space is permanent. However the segments saved within the table area are temporary. It is used to support sorting operations. That are index creation and joint processing. Table can be either Dictionary Managed / Logically Managed. Oracle maintenance a picture in every file of the table area to trace space availability.
Automated Storage Management (ASM):
It automates the layout of data files and other operating system level files, used by the database. It is done by distributing the files across all on the market disks. It supports multiplexing features, minimizing the possibility of data loss. As new disks are supplemental, the information files are mechanically decentralized access to all disks in the defined group for optimal performance.
Automatic UNDO Management:
The transactions are supported to dynamically create and manage undo segments. It helps in maintaining prior pictures of the modified blocks and rows. The UNDO segment is managed directly without the intervention of the DBA's. Flashback version queries are often executed to see different versions of a row as it changed during a given time interval.
Dropped Data:
The Recycle Bin concept was introduced in Oracle Database. This recycle bin concept impacts the space requirements for the tablespaces and datafiles. The recycle bin architecture greatly simplifies recoveries of accidentally dropped table's. This idea might significantly increase space used in the database. The PURGE command is used to get rid of previous entries from the recycle bin.
- Creating Structures (Table & Indexes).
- Creating Synonyms for the Object names.
- View objects in different databases.
- Restricting access to the objects.
- A memory area/space called System Global Area (SGA)
- Background process which interacts between the SGA and the database files on disk.
- The Oracle Read Application Cluster (RAC) can create more than one instance to use a similar database.
Within the oracle database, the basic structure may be a table. The various tables supported by oracle database are,
- Relational Table's
- Object Relational Table's
- External Table's
- Index Organized Table's
- Temporary Table's
- Partitioned Table's
- Clustered Table's
- Dropped Table's
- Materialized View's
- B+ Tree Indexe's
- Bitmap Indexe's
- Reverse Key Indexe's
- Function Based Indexe's
- Text Indexe's
- Partitioned Indexe's
All the logical structures in the database should be stored in the database. Oracle maintains a data dictionary, which records METADATA about objects. The objects which require physical area that are allocated space within a TableSpace.
TableSpaces:
It consists of one or more data files. A data file can be a part of one and only one table space. As per Oracle minimum table space is made are,
- SYSTEM and SYSAUX : Which are used to support its internal management needs.
Temporary TableSpaces:
The actual table space is permanent. However the segments saved within the table area are temporary. It is used to support sorting operations. That are index creation and joint processing. Table can be either Dictionary Managed / Logically Managed. Oracle maintenance a picture in every file of the table area to trace space availability.
Automated Storage Management (ASM):
It automates the layout of data files and other operating system level files, used by the database. It is done by distributing the files across all on the market disks. It supports multiplexing features, minimizing the possibility of data loss. As new disks are supplemental, the information files are mechanically decentralized access to all disks in the defined group for optimal performance.
Automatic UNDO Management:
The transactions are supported to dynamically create and manage undo segments. It helps in maintaining prior pictures of the modified blocks and rows. The UNDO segment is managed directly without the intervention of the DBA's. Flashback version queries are often executed to see different versions of a row as it changed during a given time interval.
Dropped Data:
The Recycle Bin concept was introduced in Oracle Database. This recycle bin concept impacts the space requirements for the tablespaces and datafiles. The recycle bin architecture greatly simplifies recoveries of accidentally dropped table's. This idea might significantly increase space used in the database. The PURGE command is used to get rid of previous entries from the recycle bin.
Comments
Post a Comment