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

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

Which Mobile Platform Should I Support? - dwaprince - can you give suggestion to list out all files which are replication factor is 3 through a command line

Guide for Installation of WordPress with LAMP on CentOS 7 server - dwaprince - Excellent

Guide for Installation of WordPress with LAMP on CentOS 7 server - dwaprince - Good

TNS SQL .NET Connectivity Issues – Troubleshooting and Diagnosing Tips - dwaprince - Good