weidongzhou.wordpress.com
Scripts | My Big Data World
https://weidongzhou.wordpress.com/scripts
My Big Data World. Set lines 180 SELECT * FROM table(dbms xplan.display awr(nvl('&sql id','a96b61z6vp3un'),nvl('&plan hash value',null),null,'typical peeked binds') /. Select owner, table name, status, last analyzed, num rows, blocks, degree from dba tables where owner like nvl('&owner',owner) and table name like nvl('&table name',table name) /. Awr plan change.sql. Sql text info.sql. 3 thoughts on “ Scripts. July 29, 2013 at 9:11 am. July 29, 2013 at 11:41 am. Anyway, still a good suggestion. Thanks.
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...
karenmorton.blogspot.com
Karen Morton: Find it. Fix it. Real-World SQL Tuning Cases - Jan. 13 Webinar Followup
http://karenmorton.blogspot.com/2015/01/find-it-fix-it-real-world-sql-tuning.html
Meanderings of one who is lucky enough to have her avocation be her vocation. Monday, January 26, 2015. Find it. Fix it. Real-World SQL Tuning Cases - Jan. 13 Webinar Followup. If you missed my January 13th webinar entitled "Find it. Fix it. Real-World SQL Tuning Cases" you can now access the recording and download the presentation file using the following links. 1 Review ways to identify poorly performing SQL. 2 Learn a simple method for evaluating a problem SQL statement. 2015 - Webinar Recordings.
karenmorton.blogspot.com
Karen Morton: July 2013
http://karenmorton.blogspot.com/2013_07_01_archive.html
Meanderings of one who is lucky enough to have her avocation be her vocation. Wednesday, July 24, 2013. My day with the Ohio Oracle Users Group. Thanks so much to everyone who attended the Ohio Oracle User's Group. Event with me on July 18. I really enjoyed the opportunity to be there. The group appears to be vibrant and growing and everyone involved made it a top-notch experience (for me at least! Links to this post. Tuesday, July 23, 2013. Follow-up: Visual SQL Tuning Webinar. I want to thank:. I hope ...
ruepprich.wordpress.com
APEX 5: Packaged Application Icons | Christoph's 2 Oracle Cents
https://ruepprich.wordpress.com/2015/06/03/apex-5-packaged-application-icons
Christoph's 2 Oracle Cents. APEX 5: Packaged Application Icons. June 3, 2015 at 8:30 am Posted in Oracle Developement. To use some of the packaged application icons for your own applications, include the packaged apps css file in your application, and reference the appropriate css class for the icon you want. Navigate to Edit Application Definition - User Interface. And edit the interface for your application. Under Cascading Style Sheets. Here are the available packaged application icons:. Thanks Christ...
ruepprich.wordpress.com
ORDS 3 – Enabling RESTful service for database tables | Christoph's 2 Oracle Cents
https://ruepprich.wordpress.com/2015/06/18/ords-3-enabling-restful-service-for-database-tables
Christoph's 2 Oracle Cents. ORDS 3 – Enabling RESTful service for database tables. June 18, 2015 at 2:26 pm Posted in Oracle Developement. We’ll take a look at how to enable a RESTful service in ORDS 3.0 via PL/SQL, and how to retrieve some data and metadata from this service. ORDS 3.0 is installed and configured with RESTful services. A schema named ORDSTEST with the EMP and DEPT tables is installed. DBA privileges are needed to execute the PL/SQL. Schema with the URI path ot. To disable a schema use:.
minersoracleblog.wordpress.com
GoldenGate 12 – Classic, Coordinated and Integrated Replicat | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/03/07/goldengate-12-classic-coordinated-and-integrated-replicat
Rick Miners' Oracle Blog. GoldenGate 12 – Classic, Coordinated and Integrated Replicat. This entry was posted on March 7, 2014, in GoldenGate. I New Replicat Modes Availalble in GolgenGate 12.1. The new Coordinated and Integrated Replicats can help you achieve transactions being applied in parallel on the target database without having to manually split out tables into multiple replicats. Let’s take a look at the difference in the replicat modes. Constructs logical change records (LCR) that represent sou...
minersoracleblog.wordpress.com
Using dstat for monitoring CPU, Memory, Disk, etc | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/10/15/using-dstat-for-monitoring-cpu-memory-disk-etc
Rick Miners' Oracle Blog. Using dstat for monitoring CPU, Memory, Disk, etc. This entry was posted on October 15, 2014, in Linux. Dstat is a good tool for replacing vmstat, netstat, iostat, and ifstat. It it a very lightweight tool that can consolidate and correlate data that you would normally have to capture in different terminals. I’ve used dstat before in the past to monitor backup throughput over interfaces. Of course, this is possible if the backups are going to disk. CPU, Load, Disk I/O and Memory.
minersoracleblog.wordpress.com
GoldenGate Initial-Load Direct Load | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2013/05/24/goldengate-initial-load-direct-load
Rick Miners' Oracle Blog. GoldenGate Initial-Load Direct Load. This entry was posted on May 24, 2013, in GoldenGate. And tagged OGG Initial Load. This article will demostrate how to perform a OGG Initial Load using the Direct Load technique. Other Initial Load techniques and their advantages and disadvantages can be found here. OGG is installed on source and target systems. OGG : 11.2.1.0.1. Database : 11.2.0.3. Linux : OEL 6 ( 64 bit ). 1 Configure the initial-load processes. GGSCI start extract csoea.
SOCIAL ENGAGEMENT