Category: Blog

SELECT TO_CHAR(FIRST_TIME,’YYYY-MM-DD’) DAY, TO_CHAR(FIRST_TIME,’HH24′) HOUR, COUNT(*) TOTAL FROM V$LOG_HISTORY GROUP BY TO_CHAR(FIRST_TIME,’YYYY-MM-DD’),TO_CHAR(FIRST_TIME,’HH24′) ORDER BY TO_CHAR(FIRST_TIME,’YYYY-MM-DD’),TO_CHAR(FIRST_TIME,’HH24′) ASC /

Trick and Tips List: 1. How to know total archive generated each houers 2. Find log history per hours 3. How to Change DBID and DBNAME? 4. How…

Section: A (Create first Virtual Machine) 1. Create the windows folders to house the first virtual machines and the shared storage. F:>mkdir RAC1 F:>mkdir SHARED-STORAGE…

Query 1 To determine which databases are currently registered in the recovery catalog: SQL> SELECT * FROM RC_DATABASE; Query 2 To determine which tablespaces are…

When we applying patches in Interactive Mode by using ADPATCH utility, this utility ask basic question like Default APPL_TOP, Log File Name, ORACLE_HOME, apps password,…

How to find patch is applied or not (Except Localization) select A.APPLIED_PATCH_ID, A.PATCH_NAME, A.PATCH_TYPE, B.PATCH_DRIVER_ID, B.DRIVER_FILE_NAME, B.ORIG_PATCH_NAME, B.CREATION_DATE, B.PLATFORM, B.SOURCE_CODE, B.CREATION_DATE, B.FILE_SIZE, B.MERGED_DRIVER_FLAG, B.MERGE_DATE from…

How to Find Oracle Applications version Version of a Oracle Applications Form (fmx) or report strings -a | grep Header alternatively you can also use…

1. Troubleshooting Logical Standby ID: 215020.1 2. ARCHIVE LOGS GETTING DISAPPEARED ON 10.2 LOGICAL STANDBY ID 353748.1

Indian DBA design job-oriented courses meant for people who like to specialize in a definite IT stream. The training programmers include Linux, SUN Solaris, Oracle…