-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Depending on the platform different command may be available, below are the commands for AIX and SUN to find the… READ MORE
On 10R2 if the Oracle binaries are installed with the RAC, one can’t use those binaries to start Oracle Instance… READ MORE
|
Using one of the following commands one can tell the uptime on windows i.e. the time since the last reboot… READ MORE
|
One can’t grant direct access V$session as v$session is a synonym. SQL> GRANT SELECT ON v$session TO scott; grant select… READ MORE
shutdown (or shutdown normal) – In this method the database shuts down cleanly and oracle will wait for all users… READ MORE
Using the utility rlwrap one can perform command line scrolling on SQL*Plus similar to that is available on windows version… READ MORE
As part of the RMAN script during backup to disk for example you may have a statement to delete the… READ MORE
|
Using block tracking one can improve performance of the backup time of incremental backup from hours to minutes depending on… READ MORE
|
One can check syntax for RMAN commands without running the RMAN. Example: Checking syntax of commands on the command line.… READ MORE
— compile public synonym that are invalid Select ‘alter public synonym ‘||object_name||’ compile;’ From dba_objects Where status <> ‘VALID’ And… READ MORE
Using the package DBMS_SCHEDULER one can enable/disable jobs. To disable job: This disables the job from running SQL> exec dbms_scheduler.disable(‘GATHER_STATS_JOB’);… READ MORE
In 10g one can find the jobs that are currently running by querying the following view SELECT job_name, session_id, running_instance,… READ MORE
|
— One can use the following query to find the name of the trace filename — To find the name… READ MORE
|
Using one of the following you can find your session id (SID). SQL> SELECT sid FROM v$mystat WHERE rownum =… READ MORE
— Set default tablespace for all users, so when users are created without specifying default tablespace it will be user’s… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 