Tag: Database

SELECT Star
Premium

How to Save on Oracle Software

A SELECT Few
Premium

SELECT’s Associate Editor, Dr. Paul Dorsey, asked Matt Warman, one of the “Java Rock Stars” about the impact of Oracle’s purchase of Sun and the integration of the JavaOne conference with Oracle OpenWorld.

A SELECT Few
Premium

SELECT’s Associate Editor, Dr. Paul Dorsey, asked Matt Warman, one of the “Java Rock Stars” about the impact of Oracle’s purchase of Sun and the integration of the JavaOne conference with Oracle OpenWorld.

For nearly 20 years, the IOUG has brought together a group of individuals,who working together as a team, drive great value to the Oracle community. As volunteers, they don’t get paid, but they do get access to Oracle, the ability to work with a dynamic group of leaders and a chance to try out their…

For nearly 20 years, the IOUG has brought together a group of individuals,who working together as a team, drive great value to the Oracle community. As volunteers, they don’t get paid, but they do get access to Oracle, the ability to work with a dynamic group of leaders and a chance to try out their…

From the Editor
Premium

Welcome to the Q2 2011 issue of SELECT Journal! Once in a while, it is a good idea to go back to the basics. I had to go back into the SQL Reference manual to refer the details of an option that helped me solve a SQL tuning issue. During this exercise, I realized that…

From the Editor
Premium

Welcome to the Q2 2011 issue of SELECT Journal! Once in a while, it is a good idea to go back to the basics. I had to go back into the SQL Reference manual to refer the details of an option that helped me solve a SQL tuning issue. During this exercise, I realized that…

By Chris Lawson Some aspects of the Real Application Clusters technology are not well-documented, and as such, they are not well-understood. Lawson explains the Resource Master, how you can find it and the role it plays in Oracle RAC.

By Chris Lawson Some aspects of the Real Application Clusters technology are not well-documented, and as such, they are not well-understood. Lawson explains the Resource Master, how you can find it and the role it plays in Oracle RAC.

Selvaganesan and Zeng discuss the how they use data from AWR and ASH to find out SQL statements that suffer as a result of CPU spikes on a database server. Through real-life case studies, they illustrate a systematic approach on how to find the root cause of the spikes.