Home / Oracle Database Material

Oracle Database Material

Temporary Tablespace and Datafile Management in Oracle database

Temporary Tablespace and Datafile Management in Oracle database   1.  For Finding temp file and temp tablespace with size SELECT file#,         status,         bytes / 1024 / 1024 “Size_MB”,         name  FROM   v$tempfile;  SELECT file_name,         tablespace_name,         bytes / 1024 / 1024 / 1024,         status  FROM   dba_temp_files;    …

Read More »

Change Date and Time Formats In Oracle Database?

Change Date and Time Formats In Oracle Database? Option 1. If We want to change this format to DD/MONTH/YYYY format. SQL> alter session set nls_date_format=’DD/MONTH/YYYY’; Session altered. SQL> select sysdate …

Read More »

Comparison Between Oracle GoldenGate and DataGuard

Comparison Between Oracle GoldenGate and DataGuard   Technical Points Oracle Dataguard / Active Dataguard Oracle Golden Gate Operating System Primary Database and Standby Database Should be same. (But 11g Onwards …

Read More »