-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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
|
Received ORA-19571 error when running of archive log process, and found the the parameter control_file_record_keep_time was set to 0 so… READ MORE
One can use the following v$nls_parameters view to find the database LANGUAGE, TERRITORY, and CHARACTER SET. READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 