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 Once […]
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’, […]
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 […]
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 […]
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.
generating the create user script from the data dictionary.