jarneil.wordpress.com
jarneil | The thoughts of Jason Arneil | Page 2
https://jarneil.wordpress.com/page/2
The thoughts of Jason Arneil. I’ve just come back from my 5th trip to Oracle OpenWorld. While there is something very special about your first trip to OpenWorld, this has been my favourite trip of the lot. In previous years I’ve blogged about what’s been going on every day, but for me, twitter and @jarneil. Is where I tend to be more active these days, but I thought I’d give a general overview of my OpenWorld experiences this year. And it was a real privelege to be able to attend this. To ensure offloadi...
externaltable.blogspot.com
External Table: Listener.ora and Oraagent in RAC 11gR2
http://externaltable.blogspot.com/2012/07/listenerora-and-oraagent-in-rac-11gr2.html
Luca's blog on databases, data platforms, performance. Wednesday, July 11, 2012. Listener.ora and Oraagent in RAC 11gR2. An investigation of a few details of the implementation of listeners in 11gR2, including the configuration of listener.ora in RAC and the role of the cluster process 'oraagent'. 11gR2 comes with several important changes and improvements to the clusterware in general and in particular the way listeners are managed. While the listener process is still the 'good old' process tnslsnr.
externaltable.blogspot.com
External Table: Event Histogram Metric and Oracle 12c
http://externaltable.blogspot.com/2015/06/event-histogram-metric-and-oracle-12c.html
Luca's blog on databases, data platforms, performance. Monday, June 15, 2015. Event Histogram Metric and Oracle 12c. Event histogram metric, a script and some related discussions on collecting and displaying wait event latency histograms for Oracle performance troubleshooting. Also discussed is the new 12c feature of event histrograms with microsecond buckets. Latency histograms (and by extension wait event histograms) provide very useful information when troubleshooting performanc. Where histogram bucke...
externaltable.blogspot.com
External Table: Talks at UKOUG TECH 2014 with CERN Speakers
http://externaltable.blogspot.com/2014/12/talks-at-ukoug-tech-2014-with-cern.html
Luca's blog on databases, data platforms, performance. Wednesday, December 3, 2014. Talks at UKOUG TECH 2014 with CERN Speakers. This is a short blog post with a list of the talks at the UKOUG TECH 2014 conference in Liverpool with CERN speakers. Come and say hi, we hope to see many of you there! Modern Linux Tools for Oracle Troubleshooting. A Closer Look at CALIBRATE IO. The Importance of Having an Appropriate Data Segmentation (Partitioning) (link is external). Subscribe to: Post Comments (Atom).
externaltable.blogspot.com
External Table: Getting Started with PyLatencyMap: Latency Heat Maps for Oracle, DTrace and More Sources
http://externaltable.blogspot.com/2013/09/getting-started-with-pylatencymap.html
Luca's blog on databases, data platforms, performance. Tuesday, September 10, 2013. Getting Started with PyLatencyMap: Latency Heat Maps for Oracle, DTrace and More Sources. This is a getting-started article for PyLatencyMap. A performance tool for real-time investigation and troubleshooting of latency data. Contains examples relevant for the Oracle RDBMS and for DTrace. Download the latest version of PyLatencyMap. Also available on GitHub. Getting Started with PyLatencyMap for. The wrapper script is Exa...
externaltable.blogspot.com
External Table: PyLatencyMap, a Performance Tool for Latency Data Visualization
http://externaltable.blogspot.com/2013/08/pylatencymap-performance-tool-to-drill.html
Luca's blog on databases, data platforms, performance. Tuesday, August 27, 2013. PyLatencyMap, a Performance Tool for Latency Data Visualization. This post is about PyLatencyMap, a performance-oriented tool I have written for command-line drill down of latency data, integrating various data sources (Oracle, DTrace, trace files) into a basic visualization engine. Studying the latency of single block read calls can provide very useful information: how many reads are from cache? More data sources are availa...
externaltable.blogspot.com
External Table: A Closer Look at CALIBRATE_IO
http://externaltable.blogspot.com/2014/04/a-closer-look-at-calibrateio.html
Luca's blog on databases, data platforms, performance. Friday, April 25, 2014. A Closer Look at CALIBRATE IO. This blog entry is about investigating Oracle's DBMS RESOURCE MANAGER.CALIBRATE IO. Is an excellent tool that I have happily used in several occasions for this purpose (see also this example. Kyle Hailey has also written on the topic of storage testing, see for example this. Brendan Gregg has written on the advantages of using the active benchmarking. From the Oracle performance tuning manual.
externaltable.blogspot.com
External Table: Wait Event History Sampling, an Experiment in Oracle Performance Analysis
http://externaltable.blogspot.com/2014/02/wait-event-history-sampling-experiment.html
Luca's blog on databases, data platforms, performance. Tuesday, February 25, 2014. Wait Event History Sampling, an Experiment in Oracle Performance Analysis. This post is about a performance analysis technique based on high frequency sampling of wait event history data in Oracle. Two scripts are provided for performing this type of analysis and two example cases are discussed applied to the study random read latency and read workload characterization. Sampling of wait event history data. Provides details...
externaltable.blogspot.com
External Table: How to Turn Off Adaptive Cursor Sharing, Cardinality Feedback and Serial Direct Read
http://externaltable.blogspot.com/2012/08/how-to-turn-off-adaptive-cursor-sharing.html
Luca's blog on databases, data platforms, performance. Thursday, August 16, 2012. How to Turn Off Adaptive Cursor Sharing, Cardinality Feedback and Serial Direct Read. When this is relevant:. Three 11g features of cost-based optimization and SQL execution to consider when upgrading from 10g:. OPTIMIZER USE FEEDBACK"=FALSE;. This can also be done with a hint, therefore at statement level, using the opt param syntax:. Opt param(' OPTIMIZER USE FEEDBACK','FALSE') */. This was introduced in 11gR1 to address ...
fatdba.com
linux « Tales From A Lazy Fat Oracle DBA
https://fatdba.com/tag/linux
Tales From A Lazy Fat Oracle DBA. Prashant Dixit is the FatDBA. Follow Tales From A Lazy Fat Oracle DBA on WordPress.com. Delhi To recap: dengue, chikungunya, bird flu worries, poisonous air, embassy warnings of ISIL's desire to attack target. 1 day ago. Delhi and NCR is in Agonizing Pain! Smog even inside the houses. #DelhiIsDying. Jayant Yadav meant to put the name of the lady who raised her on his shirt, but by mistake they put the name of his biolo. 1 week ago. 79 All Out, Kiwi Butchered by the Tiger!
