3 min read
Why there is a need to upgrade Oracle 12c Database? The most important reason to upgrade 12c is to enjoy...
asrblogger
3 min read
2 min read
What is use of INDEXFILE option in imp? Will write DDLs of the objects in the dumpfile into the specified...
9 min read
What is use of CONSISTENT option in exp? When you export a table, you are guaranteed that the contents of...
2 min read
Below is the error while I was upgrading my test environment. SQL> alter pluggable database application CODDY begin upgrade '1.3'...
2 min read
Each instance has it's own personal set of redo and each redo thread is made up of at least two...
3 min read
Scenario 1: If the jobs are running too frequently, it is possible the queries are not releasing the lock and...
2 min read
A full table scan reads all rows from a table, and then filters out those rows that do not meet...
1 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
Computer memory is managed in blocks of storage known as pages, which have a predetermined size that depends on the...
3 min read
On 12c, Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and if Oracle...
3 min read
On : 19.18.0.0.0 version, Patching After applying a RU Patch , CATALOG / CATPROC Component goes Invalid with lot of...
1 min read
SELECT to_char(begin_interval_time,’YY-MM-DD HH24′) snap_time, dhso.object_name, sum(db_block_changes_delta) BLOCK_CHANGED FROM dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhso, dba_hist_snapshot dhs WHERE dhs.snap_id = dhss.snap_id AND dhs.instance_number...
1 min read
ORACLE_HOME disk (filesystem) became full and caused an ASM error... Got the following errors in the alert log file: ORA-01148:...
4 min read
SAR is used to collect, report or save system activity. SAR stands for System Activity Report. SAR is used to...
4 min read
The top utility is a commonly used tool for displaying system-performance information. It dynamically shows administrators which processes are consuming processor and...
3 min read
Traditional startup/shutdown command prior to 12c. Shutdown Command SHUTDOWN NORMAL SHUTDOWN IMMEDIATE SHUTDOWN ABORT Startup Command STARTUP STARTUP NOMOUNT STARTUP...
2 min read
After performing database upgrade from 12.1.0.2.171017 to 12.2.0.1.171017, PDB is shown in RESTRICTED mode. SQL> show pdbs; CON_ID CON_NAME OPEN...
1 min read
Archivelog gap set pagesize 320 set linesize 200 set wrap off select thread#, sequence#, applied,to_char(first_time,’mm/dd/yy hh24:mi:ss’) first,to_char(next_time, ‘mm/dd/yy hh24:mi:ss’) next,to_char(completion_time,...
4 min read
Private SQL area holds information about a parsed SQL statement and other session specific information for processing. When a server...
1 min read
Overview Benefits What can be done Different Instances Users (Interview Question) User Power User Admin Mode (Interview Question) Fast Smart...
5 min read
Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name...
3 min read
Materialized views are query results that have been stored or "materialized" in advance as schema objects. The FROM clause of...
2 min read
What is the shared pool ? Oracle keeps SQL statements, packages, object information and many other items in an area...
3 min read
When you are taking backups regularly to a specified disk then after some period of time the backup disk will...
1 min read
While trying to rollback the conflicting patch 18893947 applying patch 21967332 $ opatch rollback -id 18893947 Oracle Interim Patch Installer...
