-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
From the following KB article it list couple of store procedures which can be used to send email through SQLServer.… READ MORE
|
Using “oradebug dump errorstack <dump level>” one can dump the call stack of the process after attaching to a running… READ MORE
There can be a scenario where the datatype of the column is VARCHAR or CHAR but values that are suppose… READ MORE
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
“Control what I can control”
~ Alex Lima
Alex Lima 