oracle Database

Difference between delete and truncate in oracle database ?- SQL Interview question

In my previous blog , I have written about the future of oracle dbs jobs. If you are going for sql or oracle interview then most of the interviewer expect that you should know the difference between delete and truncate in oracle database. let’s see the difference between delete and truncate statement in oracle database. …

Difference between delete and truncate in oracle database ?- SQL Interview question Read More »

How to put database in Archive/No-Archive log mode?- Oracle Interview question

In this blog I will show you the importance of archive and no-archive log mode. Mode of Logging There are two types of logging modes in Oracle database :- 1. ARCHIVELOG :- In this type of logging whatever oracle writes in a redo log file related to transactions in database, saved to another location after …

How to put database in Archive/No-Archive log mode?- Oracle Interview question Read More »

How to Set ORACLE_HOME & ORACLE_SID on Windows Server

We will be finding out the way to set oracle environment path for windows server. What is ORACLE_HOME used for? The ORACLE_HOME is an environment variable which is used to set and define the path of Oracle Home (server) Directory. How to set ORACLE_HOME in Environment variable To set the ORACLE_HOME environment variable go to …

How to Set ORACLE_HOME & ORACLE_SID on Windows Server Read More »

How to check oracle database status – Interview question

let us find out the database health status by using following sql command. Check whether the Oracle Process run or not#> ps -ef | grep pmon If no pmon detected, your database might be down Check the instance status SQL>select instance_name, status from v$instance; Check whether the database can be read or write SQL>select name, …

How to check oracle database status – Interview question Read More »

How to change sys & System user password in Oracle 12C database

We cannot change the sys and system password in usual way as like till 11g. we have different method to do same. following blog describe the way to change user password in oracle 12c database. How to change SYS/SYSTEM password in 12C-Oracle 12C Administration =================================================== PDB1@ORCL= alter session set container=CDB$ROOT; Session altered. PDB1@ORCL=show con_id CON_ID …

How to change sys & System user password in Oracle 12C database Read More »

Alert log file in Oracle

As you know alert log file location determined by the background dump destination it’s specified by backupground_dump_dest parameter You can find location of alert log with following command. SQL> show parameter background NAME TYPE VALUE ——————————— ———– —————————— background_core_dump string partial background_dump_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCLDATA\BDUMP Also you can use following command SQL> select name, value from …

Alert log file in Oracle Read More »