The above is so cool. The graphic shows the latency heatmap of "log file sync". I was running a swingbench load and at the same time throttling I/O such that latencies started off good then got worse and then back to normal. All I did was type sqlplus / as sysdba @OraLatencyMap_event 3 "log file sync" This was created by Luca Canali , see http://externaltable.blogspot.com/2013/05/latency-heat-map-in-sqlplus-with.htm Now if we combine this monitoring, with the I/O throttling documeted by Frits Hoogland here https://fritshoogland.wordpress.com/2012/12/15/throttling-io-with-linux/ , we can really have some fun and even draw latency words: The above words in latency heat maps are from  http://dtrace.org/blogs/brendan/2009/03/17/heat-map-analytics/ where there is information on heat maps. In the graphic at ...

Kyle Hailey
Uncategorized

Oracle OTN is hosting a full day of  free*  hands on Oracle labs on May 22, 2013 in Pleasanton, Ca Re-engineering Your Database Using Oracle SQL Developer Data Modeler 3.1 Learn how to use SQL Developer Data Modeler to import your database schema, make changes and generate the modified DDL. Testing and Debugging Procedures using SQL Developer 3.1 Learn how to use Application Express to load data into your database, create an application with a variety of page types (including a interactive report, calendar and data load wizard). Building an Application using Oracle Application Express: Part 1 and part 2 Learn how to use Application Express ...

Kyle Hailey
Uncategorized

  Delphix has been selected as one of Gartner's Cool Vendors in Storage for 2013! Gartner uses the Cool Vendor awards to highlight innovative and disruptive new companies that are rapidly changing how enterprises do business. Delphix 2013 HIGHLIGHTS TO DATE Delphix recently engaged with Oracle guru Jonathan Lewis who spent a week putting Delphix through its paces and responding to community-driven requests / questions. A recording of the first webinar is available, informally answering the top community questions.   Many organizations have adopted agile development processes to accelerate their application projects. However, the database underlying these applications is often a major obstacle to success with agile development. ...

Kyle Hailey
Uncategorized

The healthcare sector has a clear opportunity to modernize care delivery by adopting new data interchange standards and EHR systems. But getting there will first require upgrading aging infrastructure, managing data explosion, and ensuring compliance with new regulations. This translates to more projects and greater costs for IT resources that are already stretched thin. There is a clear need for transformative technologies that will enable healthcare IT teams to tackle the unavoidable wave of big projects faster and with greater efficiency. Organizations like Presbyterian Healthcare Services, Health Dialog, Independence Blue Cross, European Bioformatics Institute and many others are leveraging Data Virtualization for databases ...

Kyle Hailey
Uncategorized

Had a machine running the default database from the Oracle 11.2.0.3 installer. This instance was called o1123. I then created a second database by hand (with crdb.sh for swingbench and slob tests) instead of dbca (maybe that was a mistake) and then I wanted to acccess OEM. The second instance was called SOE60G ( a 60GB swingbench dataset database) First tried to start up dbconsole: $ emctl start dbconsole OC4J Configuration issue. /home/oracle/oracle1123/product/oc4j/j2ee/OC4J_DBConsole_perf234-target1.delphix.com_SOE60G not found. OK, missing file. EM wasn't configured for this database, make sense. Let's configure it $ emca -config dbcontrol db -repos create ... SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM ...

Kyle Hailey
Uncategorized

previous segment at: part 1   Putting Virtual Databases To Use   Because the virtual database technology so drastically changes the way we think about cloning and provisioning new database environments, a myriad of use cases can also be envisioned that can take advantage of the saved storage and time. Additionally, these use cases fit perfectly into the model for accelerated development and management of a database environment. Development Environments This is the area where the biggest impact of data virtualization can be felt. Because the development environment is the first and most critical stage of application release, the benefits are widely felt and cascade into ...

Kyle Hailey
Uncategorized

followup at: part 2 It’s time that businesses took a good, hard look at the way they manage their cloned database environments. For years the words “we need a fresh copy of production in QA” were the universal sign of a horrible day. The amount of storage, server resources, and time required for provisioning a new database environment were often times unacceptable or at the least inconvenient. Thanks to Virtual Machines, the server resources have become far easier to provision. Within minutes a completely available virtual server could be ready to go, and often disk resources could be provisioned along with the ...

Kyle Hailey
Uncategorized

I'll be speaking on Mon, Wednesday and Thursday: Boosting performance on reporting and development databases April 8, 2:30-3:30pm (Mile High Ballroom 2B) Database virtualization: accelerating application development April 10,1:00-2:00pm (Mile High Ballroom 2B) NFS tuning for Oracle April 11, 8:30-9:30am (Mile High Ballroom 3A) Attend COLLABORATE online IOUG Forum for the Best in User-Driven Oracle Education and Networking Have you made your Oracle training plans for 2013? As an IOUG RUG leader, I’d like to extend a personal invitation to the conference that I continue to attend for truly valuable personal and professional growth- COLLABORATE 13 – IOUG Forum, April 7-11 at the Colorado Convention Center in Denver, ...

Kyle Hailey
Uncategorized

Delphix completely changes the way companies do business by removing critical bottlenecks in development productivity. Gone are the days when a simple database clone operation from production to development takes hours or even days. With Delphix database virtualization, cloning of Oracle databases becomes a fast and practically free operation. Additionally, infrastructure costs can be drastically reduced due to decreased disk utilization in your cloned environments; in fact, the more environments you deploy, the more cost savings you will realize. The old adage is that your options are Fast, Good, and Cheap; pick two of three. But as a recent performance study ...

Kyle Hailey
Uncategorized

NASDAQ: KLAC KLA-­-Tencor Corporation One Technology Drive Milpitas, CA 95035 United States Phone: 408.875.3000 Website: http://www.kla-­-tencor.com Industry: Semiconductors KEY RESULTS WITH DELPHIX 2.5x faster project rollout Consolidated 45 virtual databases across two Delphix Servers Reduced refresh time from 2 weeks to 20 minutes on average Performed 60 refreshes in 6 month Reduced storage needs by 94% Displaced need to purchase >$400K in Tier 1 storage   Business-Critical SAP Projects Today’s businesses depend on critical applications like SAP to drive sales, finance, and marketing operations.  Application projects that deliver new or improved functionality can have an immediate and significant impact on top line revenues and bottom line earnings.  Most IT organizations can only manage a small ...

Kyle Hailey
Uncategorized