Overview of Data Files At the operating system level, Oracle Database stores database data in structures called data files. Every...
asrblogger
PARAMETER & PASSWORDFILE: * Create pfile from spfile to location '/home/oracle/init<sid.ora>' * Create password file with sys password as oracle1...
A system change number (SCN) is a logical, internal time stamp used by Oracle Database. SCNs order events that occur...
Below are the list of additional privileged user in 12c apart from the privileged user SYSOPER, SYSDBA, SYSASM. SYSBACKUP : It...
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...
In a typical use case, you manually shut down the database, making it unavailable for users while you perform maintenance...
Oracle ASH report introduced in Oracle 10g release 2. ASH collects samples of active sessions every second (waiting for non-idle...
The database buffer cache, also called the buffer cache, is the memory area that stores copies of data blocks read from data...
Oracle can store different kind of files under FRA: – backupset: for RMAN regular backups. – datafile: for RMAN image...
The pattern-matching conditions compare character data. LIKE Condition * The LIKE conditions specify a test involving pattern matching. Whereas the...
The database control file is a small binary file associated with only one database. Each database has one unique control...
This content is password protected. To view it please enter your password below: Password:
If you flush the shared pool, all the statements in cursor will be flushed. Sometimes it is required to flush...
A checkpoint is a crucial mechanism in consistent database shutdowns, instance recovery, and Oracle Database operation generally. The term has...
The dynamic performance views are special views that are continuously updated while a database is open and in use. Throughout...
A lock is a mechanism that prevents destructive interactions. Interactions are destructive when they incorrectly update data or incorrectly alter...
Problem:While patching 19.3 GRID_HOME with July2019 RU patch 19.4 I got this error: # export PATCH_LOCATION=/u01/oracle/RU_PATCHES/29708769 # $GRID_HOME/OPatch/opatchauto apply $PATCH_LOCATION...
Instance recovery is the process of applying records in the online redo log to data files to reconstruct changes made...
Typically, you manually start an instance, and then mount and open the database, making it available for users. You can...
The most crucial structure for recovery is the online redo log, which consists of two or more preallocated files that...
A deadlock is a situation in which two or more users are waiting for data locked by each other. Deadlocks...
A check constraint on a column or set of columns requires that a specified condition be true or unknown for...
The central set of read-only reference tables and views of each Oracle database is known collectively as the data dictionary....
NOT NULL Constraints The NOT NULL constraint ensures that the column contains no null values. Columns without the NOT NULL...
Purpose: Use a constraint to define an integrity constraint—a rule that restricts the values in a database. The Oracle server...