ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
Read More »unable to spawn jobq slave process, slot 0, error 1089
ERROR kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
Read More »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; 2. Add …
Read More »How To Find Oracle Database 32 bit or 64 bit
How To Find Oracle Database 32 bit or 64 bit Finding Oracle Database Version on your system through Operating System $ cd $ORACLE_HOME $ cd bin $ file oracle oracle: …
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 »Difference between P-File and SP-File?
Difference between P-File and SP-File? P-FILE SP-FILE It is called as parameter file. It is called as server parameter file. P-File is ASCII file and it can be edited Manually spfile is binary file and it …
Read More »How to rename a Datafile with Extension .dbf?
How to rename a Datafile with Extension .dbf? For example we have added a datafile but we forgot to give the extension .dbf Step 1. Shut down the Database SQL> …
Read More »Oracle Real Application Cluster Intro
Oracle Real Application Cluster Intro RAC Defination Oracle RAC stands for Oracle Real Application cluster. It is a clustering solution that ensures high availability of databases by providing instance failover …
Read More »Data Guard Vs SAN To SAN Replication
Data Guard Vs SAN to SAN Replication Oracle Data Guard SAN-to-SAN Implementation Cost Low High Database Aware Yes No Granularity of Replication Transaction level Disk Block Level Distance Limitations …
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 it …
Read More »