Program Global Area (PGA) resides in the process private memory of the server process. PGA_AGGREGATE_TARGET is used to control the sizing of workareas. Often improper setup and incomplete understanding of the inner working of PGA and the interconnectivity with OS settings leads to ORA-4030 errors, which are raised when memory or resources are requested from…

All DBAs know a thing or two about partitions. We know the various types of partitions, when we think we should use partitions, etc. However, most DBAs don't know the events that occur in the background when the various types of partitions are used. How do indexes behave when partitions are introduced? This session takes…

This presentation is a high-level introduction to Oracle RAC. Many RAC beginner presentations are given by seasoned RAC experts and contain an overwhelming suite of technical discussions, covering a way too much information for the level of expertise of most attendees. This presentation is given by a beginner with the RACand will introduce attendees to…

Oracle Database 11gR2 has a number of unique features thataid in detecting and solving database and SQL related performance issues. AlthoughOracle 11g provide a plethora of tools and options to deal with databaseperformance, the question, however, is which of these are the most useful andpractical and how we can manage all the performance statistics that…

Come hear how CenturyLink (CTL) selected the Oracle Database Machine after evaluating multiple platforms to extend or re-platform its current multi-terabyte Oracle data warehouse. CTL is a telecommunications company created in 2009 when CenturyTel acquired EMBARQ. This merger exceeded the capacity of the current CTL data warehouse. To resolve this situation, CTL evaluated the HP…

There are many code debugging tools available to Oracle developers. Some require more effort than others. The author will walk the audience through a debugging session using SQL Developer 3.0.4 and how it's used with XML Documents. Examples will be shown using Oracle 11gR2

An important facet of securing an Oracle Database is the ability to audit. Auditing has now become extremely important as it is a requirement of an increasing set of regulations governing the use of database data. this talk will cover a range of auditing techniques that can be used on Oracle including the default System-based…

Many database management tasks become more difficult as you move from hundreds of millions of rows and hundreds of gigabytes to data to billions of rows and terabytes of data. Such tasks include ingesting data quickly while maintaining indexes, changing schemas without downtime, supporting many connections, replication, and backup. For some scaling problems (connections, and…

Beginners to MySQL often start monitoring and administering their systems manually but quickly realize the need to automate. When the new MySQL DBA is also new to shell scripting, the task of automating becomes even more daunting. This presentation introduces the Bash shell, shows how it can communicate with MySQL and with the outside world,…

This is a two-part session that will take place on Monday and Tuesday. You have to set up a MySQL instance for a test or even for production, and you're feverishly looking through the docs, trying to remember exactly what to do. You install the default MySQL version for your distribution, but is it the…