-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Using dbms_monitor.client_id_trace_enable to turn trace on for all sessions that have client identifier set to 'debug' and using dbms_session.set_identifier which… READ MORE
At times you may have a scenario where you may want to monitor temp space usage in a running session.… READ MORE
|
Find SQL currently executing in a session: https://oraclespin.wordpress.com/2010/05/09/how-to-find-sql-running-for-a-usersid/ Session running waiting on SYS@TESTDB> SELECT event, state, p1, p2, p3, seconds_in_wait… READ MORE
|
— Buffer hit ratioselect (1-(sum(decode(name, ‘physical reads’, value, 0))/(sum(decode(name, ‘db block gets’, value, 0)) +(sum(decode(name, ‘consistent gets’, value, 0))))))*100 “Buffer… READ MORE
Way of changing retention SQL> select dbms_stats.get_stats_history_retention from dual; GET_STATS_HISTORY_RETENTION ————————— 31 — value passed is in days — If… READ MORE
|
Space used by AWR SQL> select occupant_desc, space_usage_kbytes from v$sysaux_occupants where occupant_name like ‘%AWR%’; OCCUPANT_DESC SPACE_USAGE_KBYTES —————————————————————- —————— Server Manageability… READ MORE
|
Using the SQL below in which joining with V$session and V$sqlarea one can find the SQL currently running. In this… READ MORE
Using DBA_SCHEDULER_RUNNING_JOBS one can see jobs currently running. In the example below it shows the oracle session id and corresponding… READ MORE
In 10g oracle has introduced the concept of recycle bin one can recover tables that were dropped. When a table… READ MORE
Depending on tool one can grant access to users if they need access to look at code for store procedure,… READ MORE
When a user name has a profile that has a password verify function set and the user tries to change… READ MORE
— shows what options are enabled SQL> select parameter FROM v$option where value = 'TRUE'; PARAMETER —————————————————————- Partitioning Objects Advanced… READ MORE
control_file_record_keep_time – the value indicates number of days before reusable record is overwritten, if set to 0 reusable record is… READ MORE
— backup control file in binary format to a file named /tmp/x.ctl, it will preserve the backup information of the… READ MORE
LogMiner can be used to recover data and audit database, it has 2 packages one of them named “DBMS_LOGMNR_D” to… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 