Oracle Archives - Page 27 of 29

SYSTEM Tablespace is Growing Abnormally in 12c

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…

asrblogger March 18, 2022No Comments

ASM Oracle

ASM Disk Addition & Deletion

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…

asrblogger March 16, 2022No Comments

Oracle

Database Link

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…

asrblogger March 11, 2022No Comments

Oracle

Parameters which require DB bounce.

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…

asrblogger March 7, 2022No Comments

Oracle

Creating pluggable database from another pdb, when pdb$seed in in mount state

SQL> create pluggable database PDB1 from DEV1 create_file_dest='+DEV_DG_FLASH'; Pluggable database created. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 PDB1 MOUNTED 4…

asrblogger February 28, 2022No Comments

Oracle

Datafiles in Oracle (Physical Storage)

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…

asrblogger February 18, 2022No Comments

Oracle

Oracle Database 19c – Practical & Assignments

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…

asrblogger February 13, 2022No Comments

Oracle

System Change Numbers (SCNs)

A system change number (SCN) is a logical, internal time stamp used by Oracle Database. SCNs order events that occur within the database, which is necessary to satisfy the ACID…

asrblogger January 17, 2022No Comments

Oracle

Password File management in 12C/19C

Below are the list of additional privileged user in 12c apart from the privileged user SYSOPER, SYSDBA, SYSASM. SYSBACKUP : It will be used to perform all backup and recovery related operations either…

asrblogger December 30, 2021No Comments

Oracle Scripts

Determining the Size of Oracle database tables and indexes

Useful views to get index details: dba_indexes dba_segments dba_ind_columns dba_ind_partitions user_indexes user_segments user_ind_columns user_ind_partitions Query to check Index on a Table in Oracle. set lines 200 col index_name from a30…