-
Subscribe
Subscribed
Have a WordPress.com account? Log in now.
This parameter controls the format of the archive log file name. This parameter can’t be changed on the fly therefore… READ MORE
Using the following steps one can clone a database manually. In the following example PRD represents the source and DEV… 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
|
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
|
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
