mculp.wordpress.com
start trace in session « OracLog
https://mculp.wordpress.com/2012/05/30/start-trace-in-session
Another day in the OraSphere. Laquo; Start Trace. Start trace in session. Posted by Mike Culp on May 30, 2012. SQL*Plus script to start the SQL Trace for another session. This. Script displays the trace file name and location. This script will. Display the user sessions and prompt for information it needs. Column in db namet new value out db namet noprint. Column in spidt new value out spidt noprint. Column in usert new value out usert noprint. Column in patht new value out patht noprint. This entry was ...
mculp.wordpress.com
Find Locked Sessions « OracLog
https://mculp.wordpress.com/2012/05/30/find-locked-sessions
Another day in the OraSphere. Laquo; Shows waiting sessions and the events they await. Display database locks and latches (with tables names, etc). Posted by Mike Culp on May 30, 2012. Set lines 100 pages 999. Col username format a20. Col sess id format a10. Col object format a25. Col mode held format a10. Select oracle username ‘ (‘ s.osuser ‘)’ username. Ssid ‘,’ s.serial# sess id. Owner ‘.’ object name object. 0, ‘Not Blocking’. 1, ‘Blocking’. 2, ‘Global’) status. 0, ‘None’. 1, ‘Null’. Create a free w...
mculp.wordpress.com
APEX Development Notes « OracLog
https://mculp.wordpress.com/2010/03/12/apex-development-notes
Another day in the OraSphere. Laquo; CentOS 5.6, Oracle11gR2, and VMware Player 3.0. Oracle Licensing for Standby and Data Guard. Posted by Mike Culp on March 12, 2010. Over the years I have been very involved in the development of various APEX applications. This area of my blog is to talk about the type of things that I am doing that might be interesting general features and techniques of APEX. Feel free to send me anything you feel is relevant to what I am talking about in here. From your own site.
mculp.wordpress.com
CentOS 5.6, Oracle11gR2, and VMware Player 3.0 « OracLog
https://mculp.wordpress.com/2010/03/12/centos-and-oracle11gr2
Another day in the OraSphere. Laquo; Sun Solaris Downloads. CentOS 5.6, Oracle11gR2, and VMware Player 3.0. Posted by Mike Culp on March 12, 2010. I have recently done an install of CentOS 5.4 and Oracle11gR2, here are some of my notes. First of all since I wanted to be mobile I decided to install this on my laptop and use VMware Player 3.0 to make my virtuals. Then I went to www.centos.org. In order to install the uncompress that doesn’t get installed with CentOS 5.4. Feed You can leave a response.
mculp.wordpress.com
Shows waiting sessions and the events they await « OracLog
https://mculp.wordpress.com/2012/05/30/shows-waiting-sessions-and-the-events-they-await
Another day in the OraSphere. Shows waiting sessions and the events they await. Posted by Mike Culp on May 30, 2012. Select sw.sid sid, p.spid spid, s.username username, s.osuser osuser, sw.event event, s.machine machine. Sprogram program, decode(sw.event,’db file sequential read’, sw.p3, ‘db file scattered read’, sw.p3, null) blocks. From v$session wait sw,v$session s, v$process p. Where s.paddr = p.addr. And event not in (‘pipe get’,’client message’). And sw.sid = s.sid. Feed You can leave a response.
mculp.wordpress.com
Sun Solaris Downloads « OracLog
https://mculp.wordpress.com/2010/03/12/sun-solaris-downloads
Another day in the OraSphere. CentOS 5.6, Oracle11gR2, and VMware Player 3.0. Posted by Mike Culp on March 12, 2010. Http:/ www.sun.com/download/index.jsp? This entry was posted on March 12, 2010 at 3:17 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0. Feed You can leave a response. From your own site. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public).
mculp.wordpress.com
Oracle Licensing for Standby and Data Guard « OracLog
https://mculp.wordpress.com/2010/03/16/oracle-licensing-for-standby-and-data-guard
Another day in the OraSphere. Laquo; APEX Development Notes. Oracle Licensing for Standby and Data Guard. Posted by Mike Culp on March 16, 2010. Licensing for Standby and Data Guard is a very misunderstood and sketchy subject. I’ve worked for companies that were charged for the standby server, and sometimes obtained. Huge discounts. It depends on how close to May 31st you are. If the software is running on the. Server you must license it. BTW here is a link to a couple of Oracle’s licensing docs:.
mculp.wordpress.com
OracLog
https://mculp.wordpress.com/page/2
Another day in the OraSphere. Posted by Mike Culp on April 16, 2009. Here is the low down on the OCFS2. Http:/ www.oracle.com/technologies/linux/ocfs2.html. Http:/ oss.oracle.com/projects/ocfs2/. Oracle Enterprise Linux Notes. Posted by Mike Culp on July 22, 2008. I will be detailing some of the installation notes as it relates to Linux and Oracle over the coming weeks. Installation notes concerning 11g and Oracle Enterprise Linux OEL (Red Hat 5.6). Oracle 11g New Features. Next Entries ».
mculp.wordpress.com
Start Trace « OracLog
https://mculp.wordpress.com/2012/05/30/start-trace
Another day in the OraSphere. Laquo; Display database locks and latches (with tables names, etc). Start trace in session. Posted by Mike Culp on May 30, 2012. SQL*Plus script to start the SQL Trace facility for the current session. This script also displays the trace file name being created and its. Column in db name new value out db name noprint. Column in spid new value out spid noprint. Column in user new value out user noprint. Column in path new value out path noprint. Select value in path. You are ...
