(Presented at Oracle Open World 11) "Throw more hardware at the project to keep up the speed" is a phrase heard all too often among IT professionals. Sometimes, additional hardware doesn't solve performance problems. When dealing with computer systems, XML documents are an effective method to communicate real time information between two or more computers.…

This talk will provide tips for using SQL against an Oracle Database. It will discuss how to exploit a selection of lesser known features and also how to avoid traps and pitfalls. Examples of redundant and undocumented functions, such as OVERLAPS, REVERSE and the range of SYS_OP functions will be covered and some of the…

You want to engage the mobile market, but what's the best approach? A native application in the iTunes store, or a mobile version of your web site? With the latest ADF Mobile tools, you get the best of both worlds, because you can make native applications with nothing more than standard HTML5, CSS, and JavaScript!

This paper re-introduces Perl as a language of choice for many solutions for DBA's and developers. Discover what makes Perl so successful and why it is so versatile. Perl can automate all those manual daily tasks and is truly platform independent so that your scripts can now run on Linux, Unix and Windows. Perl may…

This session is recommended for users who are interested in Oracle Products for Linux on the System Z Platform. This Special Interest Group session will be the final meeting for the 2012 z/Series Oracle SIG at COLLABORATE 2012. Committee members of the SIG, Oracle and IBM representatives will also participate in a question and answer…

Most Organizations setup their disaster recovery environment and hardly able to utilize their disaster recover infrastructure to full capaciity. In this presentation, you will learn how to setup an active data guard environment and best practices to setup active data guard environment, which can be utilized as a reporting infrastructure which supports MIS reporting, Also…

Do I have enough memory? Why is my free memory so low? Am I swapping to disk? Can I increase my SGA (db cache) size? Can I add another instance to this server? Are my system resources used optimally? These are all questions that often haunt DBAs. This presentation is The Answer. It covers in…

This session will describe user experiences with tuning the set up for an Oracle Database running on Linux on IBM System z. It will cover the options in z/VM, Linux, Storage, and init.ora that can improve the throughtput achieved.

Oracle GoldenGate has been widely used as a data replication and integration technology. At PayPal, Inc., there are many large scale Oracle GoldenGate systems implemented to support data replication/integration needs. This session will overview Oracle GoldenGate architecture and common use cases, new features offered by the latest GoldenGate v11 release, best practice in managing/scaling the…

Oracle on VMware??? Most of our customers have virtualized their application tier, but now are either virtualizing databases or planning to do so soon. Some companies have attempted to virtualize databases on VMware already but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading information. Understand which metrics are important and how to get the data.