-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Using the following steps one can clone a database manually. In the following example PRD represents the source and DEV… READ MORE
—– Connect.java —- —- To compile c:> javac Connect.java —- Note: Make sure the CLASSPATH env is set. MySQL Connnector/J… READ MORE
|
If you use SSH to login using your own user account and su to oracle or su directly to oracle… READ MORE
Tom Kyte, Oracle DBA and founder of the Ask Tom blog, gave the Oracle Database Insider his resolutions for 2009… READ MORE
|
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
“Control what I can control”
~ Alex Lima
Alex Lima 