What is datapump in oracle
What is datapump in oracle Data Pump: Data pump is a utility provided by Oracle to export data and/or structure from a database into a binary file called as dump… Read more »
Author Archives: Pankaj Yadav
How to check tablespace size in oracle database
How to check tablespace size in oracle database set linesize 150 set pagesize 5000 col owner for a15 col segment_name for a30 col segment_type for a20 col TABLESPACE_NAME for a30… Read more »
Check user status in oracle database
Check user status in oracle database Here with the use of below scripts you can check the status of particular user whether is open/locked or expired , you can check… Read more »
check sql session detail in oracle database
Check sql session detail in oracle database SET LINESIZE 190 COLUMN spid FORMAT A10 COLUMN username FORMAT A15 COLUMN program FORMAT A65 SELECT s.inst_id, s.sid,s.serial#, p.spid, s.username, s.program FROM… Read more »
How to check datapump job status
How to check Export/Import data pump job status Monitor export/Import with the data pump views – The main view to monitor Export/Import jobs are dba_datapump_jobs and dba_datapump_sessions. set line 190… Read more »
How To Resolve Database Blocking In Oracle
How To Resolve Database Blocking In Oracle Database blocking is a situation where the statement run by one user locks a record or set of records and another statement run… Read more »
How to change RAC database NoarchiveLog Mod to Archivelog mode
How to change RAC database NoarchiveLog Mod to Archivelog mode Login to one of the nodes (i.e. linux Node1) and disable the cluster instance parameter by setting cluster_database to FALSE… Read more »
Oracle DBA interview questions and answers
Oracle DBA interview questions and answers: What is the difference between Oracle DBA role and an Oracle Developer role in an organization? Are there any similarities between both? An Oracle… Read more »
Check free space in UNDO Tablespace
How to check free space in UNDO tablespace select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select sum(bytes) / 1024 / 1024 SIZEMB, b.tablespace_name from dba_data_files a, dba_tablespaces b where… Read more »
Oracle Database session and user details
Script for Oracle Database session,user,process and sid details. col OS_USER for a25 col SID for a10 col USERNAME for a20 col PID for a20 select substr(a.spid,1,9) pid, substr(b.sid,1,5)… Read more »