Blog Detail
Oracle Experiences
http://bigbosswithoracle.wordpress.com/
All about my experiences with Oracle Data Base
- Author: Anupam Thakur
- Listed in: Education Blogging
- Tags: oracle oracle dba oca bigboss oracle experiences experiences with oracle
Recent Posts
Changing the Size of the Tablespace
Alter the STORAGE settings of a Tablespace ALTER TABLESPACE tablespacename [MINIMUM EXTENT integer [K|M] [DEFAULT storage clause] Resizing a Tablespace ALTER TABLESPACE mydb1data ADD DATAFILE ‘\mydatabases\mydb1\mydb1data02.dbf’ SIZE 100M...
Space Management in Tablespaces
Locally Managed Tablespaces Free Extent Information is NOT stored in Data Dictionary Bitmap Segments are used to keep track of the free space usage Within the tablespace, there are bitmap segments Each bit in the Bitmap corresponds to a Data Block o...
Dropping Tablespaces
The following list provides all the possible parameters to the DROP TABLESPACE command: DROP TABLESPACE tablespacename INCLUDING CONTENTS [AND DATAFILES | INCLUDING DATAFILES] CASCADE CONSTRAINTS; INCLUDING CONTENTS - Causes all the segments in th...
Creating Tablespaces
The following is the generic form of the command with an explanation of the different components: CREATE TABLESPACE tablespace_name [DATAFILE clause] [MINIMUM EXTENT integer [K]] [BLOCKSIZE integer [K]] [LOGGING | NOLOGGING] [DEFAULT storage_clause] ...
Types of Tablespaces
There are two types of tablespaces in an Oracle database: SYSTEM and Non-System The SYSTEM tablespace is created during Database creation Its purpose is to hold the data dictionary tables, views, and stored program units. It also holds the SYSTEM u...
Redo Logs Information in Data Dictionary
V$LOG – Contains information about the redo logs from the control file V$LOGFILES – This view provides the current status of all the redo logs V$LOG_HISTORY – Contains information concerning archived redo logs from the control file....
