Month: October 2017

October 20, 2017 How to rename a Datafile with Extension .dbf?

APPS DBAErrors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle APPS DBAOracle Database Material

How to rename a Datafile with Extension .dbf? For example we have added a datafile but we forgot to give…

October 11, 2017 How to Find Database Object and it’s Corresponding Datafiles

Database ScriptsScripts

How to Find Database Object and it’s Corresponding Datafiles SELECT DISTINCT t.ts#, t.name AS Tablespace_name, d.name AS DATAFILE, s.owner, s.segment_name, s.segment_type, s.bytes / 1024 / 1024 AS “MB” FROM v$tablespace t, v$datafile d, dba_segments s WHERE t.ts# = d.ts#…

October 11, 2017 How to Find CPU Usage for a Session

Database ScriptsScripts

How to Find CPU Usage for a Session SET linesize 145 SET pagesize 9999 COLUMN sid format 9999 heading ‘SID’ COLUMN serial_id format 999999 heading ‘Serial#’ COLUMN session_status format a9 heading ‘Status’ justify right

October 11, 2017 Oracle Real Application Cluster Intro

Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Oracle Real Application Cluster Intro RAC Defination Oracle RAC stands for Oracle Real Application cluster. It is a clustering solution…