oracle impdp as sysdba and attach job

By Ravi Karamsetty | July 22, 2016 |

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 – “my_job”   impdp \”/as sysdba\” attach=my_job … Continue reading “oracle impdp as sysdba and attach job”

Read More

Enabling and Disabling – auto optimizer stats collection

By Ravi Karamsetty | May 20, 2016 |

Here is how you can query if the Auto Optimizer Stats Collection job is running in Oracle Database 11g: Login to database as SYSDBA: [sql] SELECT CLIENT_NAME, STATUS FROM DBA_AUTOTASK_CLIENT WHERE CLIENT_NAME = ‘auto optimizer stats collection’; [/sql] Below is how the job can be disabled: [sql htmlscript=”false”] EXEC DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => ‘auto optimizer stats collection’, … Continue reading “Enabling and Disabling – auto optimizer stats collection”

Read More

New Jersey Oracle User Group

By dwaprince | October 29, 2015 |

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 real-life Oracle strategies & best practices … Continue reading “New Jersey Oracle User Group”

Read More

Oracle – AWR, ASH and ADDM reports for RAC

By Ravi Karamsetty | August 19, 2015 |

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 RAC database: SQL>@$ORACLE_HOME/rdbms/admin/ashrpti.sql SQL script for … Continue reading “Oracle – AWR, ASH and ADDM reports for RAC”

Read More

Setting Oracle Database User Password Not to Expire

By Ravi Karamsetty | April 16, 2015 |

Here are the steps to set the password not to expire for the  Oracle database user. Here we are assuming that the user has been assigned with the default profile: SQL> alter profile default limit password_life_time unlimited; Profile altered.

Read More

Generating User Script from Oracle Database

By Ravi Karamsetty | November 24, 2014 |

generating the create user script from the data dictionary.

Read More