-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Suspend a running process SQL> oradebug setorapid 12 Unix process pid: 10932, image: oracle@localhost.localdomain (TNS V1-V3) SQL> oradebug suspend Statement… READ MORE
The following example shows how to set event on a oracle session To turn on event, needs to be run… READ MORE
1. Upgrades can happen right from 5 through 6.2 a) The last release from the primavera before being acquired by … READ MORE
The Project Portfolio Management (PPM) track at Oracle OpenWorld will present a full lineup of expert speakers, including PPM product… READ MORE
Oracle’s Primavera P6 Analytics, released this spring, uses prebuilt business intelligence and analytics to improve project portfolio management and forecasting… READ MORE
Hello, This year I am planning to attend most if not all sessions for Primavera at OpenWorld in San Francisco.… READ MORE
An increased level of scrutiny and accountability is driving enterprise decision-making. In industries including engineering and construction, aerospace and defense,… READ MORE
|
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
|
Using dbms_stats.get_stats_history_availability one can find date of oldest STATS information. STATS older than this timestamp cannot be restored. SQL> select… 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
“Control what I can control”
~ Alex Lima
Alex Lima 