
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 […]

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 […]

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 […]

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 […]

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: […]

generating the create user script from the data dictionary.