Oracle Dba

ORACLE DBA

oracle impdp as sysdba and attach job

impdp allows Oracle DBA to exit out of the current process while the job continues to run in the background.  In the event you have to connect to the job and take some action, below is how that can be accomplished: In the following example job name is –...

Read More
Oracle

COMPANY NEWS

New Jersey Oracle User Group

Princeton IT Services is proud to be a key sponsor of the New Jersey Oracle User Group (NJOUG) in supporting organizers Nicholas Donatone, Rafael Orta, and Ravi Karamsetty to connect IT professionals working with Oracle Software Products every day. This unique user group, is dedicated to providing members with...

Read More
reports for RAC

TECHNOLOGY

Oracle – AWR, ASH and ADDM reports for RAC

Following are the scripts that can be executed as sysdba in order to get the AWR, ASH and ADDM reports on Oracle RAC: SQL script for getting AWR Report on RAC database: SQL>@$ORACLE_HOME/rdbms/admin/awrgrpt.sql SQL script for getting AWR Report for  single instance: SQL>@$ORACLE_HOME/rdbms/admin/awrrpt.sql SQL script for getting ASH Report on...

Read More