The specific methods for creating a database are: With Database Configuration Assistant (DBCA), a graphical tool. With the CREATE DATABASE SQL statement. 1. Specify an Instance Identifier (SID) The ORACLE_SID environment variable is used to distinguish this instance from other Oracle Database instances on the same host computer. 2. Ensure That the Required Environment Variables Are Set 3. Choose a Database … Read more
Normally if you are trying to shrink a compressed table lets say you get below error, and the trick to solve it is below :- For partition tables and for normal tables There are two possibilities:1: The SHRINK clause is not valid on a compressed table and you will get ORA-10635 . (b) Autosegment space … Read more
Space allocation in the UNDO tablespace is unique and does not follow the same rules as normal tablespaces. Data within the tablespace frequently grows and shrinks throughout the life of the instance. There are three categories of blocks in the UNDO tablespace: Active, unexpired and expired Active: Blocks that contain active UNDO data for active … Read more
SYSTEM Tablespace is Growing Abnormally in 12c My SYSTEM tablespace was growing rapidly. This was happening in my test environment. We observe that we were not doing much on this database. Only few users were working to test the application and doing approx 40-50 transaction per day. That’s it.There was no much load as well, … Read more
Adding Disks to a Disk Group is done with the “alter diskgroup” command.Oracle provides the alter diskgroup command to adding or removing physical disks within SQL*Plus: First we identify the ASM diskgroup where we want to add the disk: Next, we identify the disks to see which disk should be added to the diskgroup: IF … Read more
A database link (DBlink) is a definition of how to establish a connection from one Oracle database to another. Type of Database Links: Private database link – belongs to a specific schema of a database. Only the owner of a private database link can use it. Public database link – all users in the database … Read more
In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases: 1) Immediate 2) Deferred 3) False 1. Immediate : We can change the parameter in fly database ie Dynamic.(only need to change the value no need to bounce) 2. DEFERRED : We can change the parameter in fly database but this … Read more
→ Here we can see that new pluggable database PDB1 created from another pluggable database DEV even if the PDB$SEED is in mount state. Here we can see from where the PDB is created Drop undo tablespace in PDB
Overview of Data Files At the operating system level, Oracle Database stores database data in structures called data files. Every Oracle database must have at least one data file. Use of Data Files Oracle Database physically stores tablespace data in data files. Each nonpartitioned schema object and each partition of an object is stored in … Read more
PARAMETER & PASSWORDFILE: * Create pfile from spfile to location ‘/home/oracle/init<sid.ora>’ * Create password file with sys password as oracle1 * Create parameterfile in different location /u01 & start the DB to up and running condition. * How to check all parameters associated with database? * How to change specific parameters with Scope=both/spfile/memory? * How … Read more