Tuesday Apr 28, 2015

Understanding the Shared Pool for Tuning

Written by Ira Singer, Oracle DBA

Understanding the Shared Pool for Tuning, a recent webinar, I talked about parsing the library cache of the shared pool, how to cut down on hard parses, and AWR (Automatic Workload Repository) findings to help tune the library cache.

The main purpose of the shared pool is to share your SQL statements -- your execution plans, especially for online transaction processing. There are other areas in the shared pool that can be used, but there are some important areas of the shared pool that are helpful to understand.

The major components of the shared pool are:

The library cache, which stores shared SQL and PL/SQL code and object metadata in areas distinguished by namespaces. You're aiming to have most of your code, in an OLTP operation, in the library cache. But, if it isn't in the library cache, you then have to do a hard parse.

The data dictionary cache, which holds row images from the data dictionary tables -- also called the row cache.

The results cache holds query result sets and query fragments, so subsequent queries can retrieve the result directly from the cache. If you have large SQL statements that are going to give you a smaller set of results, that will go into the results cache.

If we do the hard parse, we tend to slow down the overall performance. Instead, we’ll want to tune the library cache.

SQL Statement Processing Phases

SQL statements are in four phases: a parse, a bind, an execute, and a fetch.


The aspects that deal particularly with the shared pool are parse and bind:

  • Parse phase is one of the stages in the processing of a SQL statement. When an application issues a SQL statement, the application makes a parse call to the Oracle Database. During the parse call, the Oracle Database checks the statement for syntactic and semantic validity, determines whether the process issuing the statement has privileges to run it, searches for an sharable match of the statement in the shared pool, and allocates a private SQL area for the statement.

  • Bind phase checks the statements for the bind variable and assigns/reassigns a value to the bind variable. When bind variables are used properly, more soft parses are possible, thereby reducing hard parses and keeping parsed statements in the library cache for a longer period.

Now it’s good to look at the Automatic Workload Repository, or the Statspack indicators that you might be having problems with in your shared pool.

Please watch my webinar, because in it I show you these AWR reports in detail and how to use them for hints of problems. Specifically, we look at a load profile, instance efficiencies, top wait events, and the time model. I also provide several examples for how shared pools work. I hope you can join me for the full session.

Check out other webinars available through Oracle Learning Streams.

Friday Apr 04, 2014

2014 Looks Bright for Oracle DBAs, Developers and Analysts

We know it.  You know it.  The IT landscape is going through a lot of change. As a result, hiring managers are on the hunt for new talent who can support this transformation.

According to a recent survey by Robert Half International, CIOs are more optimistic about hiring in 2014 than they were in 2013.


Source: Robert Half International

This is good news, especially for individuals who have the skills that hiring managers are seeking.  

The Bureau of Labor Statistics projects employment for DBAs to grow 15 percent between 2012 and 2022; Oracle DBAs in particular appear to be well positioned. 

John Reed of Robert Half International observed that “the market for Oracle DBAs is strong right now and I would anticipate it would at least maintain that level if not increase in values over the next 12 to 18 months.”

Research from Foote Partners also supports the growth for DBAs as well as developers and analysts. David Foote stated that in 2014 “the winners will be database developers, architects, analysts and technical specialists, especially if they know Apache HBase, NoSQL or prescriptive tools and analytics.”

Cloud Architects, Solution Architects, Administrators & Integrators in High Demand

No surprise that demand continues to rise for cloud architects, solution architects, administrators and integrators.  And the growth of mobile devices continues to generate demand for experienced and certified mobile developers.

Salary trends in the US also support good growth for these hot jobs:


Take a closer look at what’s hot in some of these recent industry reports:

•    2014 Salary Guide from Robert Half International
•    8 hot IT skills for 2014
•    Which Tech Jobs Will Win, Which Will Lose in 2014
•    Increasing Demand for Oracle DBAs
•    8 Hot IT Jobs for 2014
•    Dice.com December 2013: Special Edition, Hiring Survey

•    Hot IT Job Skills in 2014: Mobile, Web Development and Big Data 

Oracle University Offers Flexible Training & Certification Options

If you're thinking about making a career change, now may be the time. Brush up your skills with Oracle training.

Short on time? Take advantage of the flexibility of Training On Demand or Self-Study Courses. To gain an edge in the job market, validate your expertise by studying to earn an Oracle Certification in Oracle Database, PL/SQL, SQL or Java.

Tuesday Jul 02, 2013

Oracle Database 12c Training and Certification: What’s in it for Me?


Oracle Database 12c has officially launched!

Through Oracle University, our expert instructors can introduce you to the features and functions of this new Oracle Database 12c product. Through training courses and certification exam prep seminars, you can build up your database knowledge and apply this knowledge to advance your career.

Already an Oracle Database Expert? Why Oracle Database 12c Training is still a Good Idea

Oracle is the industry leader for database technology and takes the release of new products very seriously. We continue to listen to customer needs and add features and functionality to address those needs. Oracle Database 12c is no exception.

The following areas have been greatly enhanced and should be considered for your additional training or certification:

• Database for Cloud Computing

• Compression and Information Lifecycle Management (ILM)

• Improved Performance & Scalability

• Extreme Availability

• Security Defense in Depth

• Manageability

Oracle Certified Database Administrators Reap Career Rewards

Becoming an expert user of database technology through Oracle University's certification program widens your skill set to demonstrate your expertise implementing the most advanced database technology available. By doing so, you'll make yourself a more marketable employee and candidate in the job market. 

Reasons to Become an Oracle Certified Database Administrator of Oracle Database 12c:

• The new Oracle Database 12c certifications emphasize more advanced skills that align with industry standards, resulting in an even more valuable credential for customers and partners.

• The Oracle Certified Associate (OCA) for Oracle Database 12c centers upon certification objectives that measure IT professionals' day-to-day skills, along with your ability to manage challenges.

• Building upon all of the competencies incorporated into Oracle's Database 12c OCA certification, the Oracle Certified Professional (OCP) for Oracle Database 12c certification includes advanced knowledge and skills required of top-performing database administrators.

• The Oracle Certified Master (OCM) for Oracle Database 12c - a very challenging and elite top-level certification - certifies the most highly skilled and experienced database experts.

• Oracle offers 12c upgrade paths for existing Oracle Certified Professionals (OCP) and Oracle Certified Masters (OCM).

Database 12c Training and Certification: Built with Your Input

When creating Oracle Database 12c training courses and certifications, we wanted to know which tasks are most important in a DBA's day-to-day work. Instead of assuming what those tasks might be, we decided to develop a job task analysis survey for DBAs.

The response rate from DBAs from around the world was overwhelming! The survey focused on the following key database areas:

• DBA Core Essentials

• Database Storage

• High Availability

• Scalability

• Networking

• Security

• Very Large Database Administration

• Distributed Databases

After conducting this survey, we took this specific feedback and used it to help mold the new Oracle Database 12c training and certification curriculum. The benefit to you? You now have access to Oracle Database 12c courses and certification exams that were created with your specific on-the-job tasks in mind.

Explore Oracle Database 12c Training & Certification Today

Investing in Oracle Database 12c training courses and certifications will help you develop a great deal of knowledge, experience and expertise. Explore our portfolio of offerings to determine which skills you need as a DBA to get up-to-speed on Oracle Database 12c technology.

Questions or comments about the new Oracle Database 12c offerings? Let us know in the comments below.

- Diana Gray, Principle Curriculum Product Manager and Raza Siddiqui, Senior Principle Curriculum Product Manager

About

Oracle University is THE trusted provider of quality, expert Oracle training & certification. All training is delivered by our Elite global team of Oracle experts and made available in multiple learning formats for anytime, anywhere training. Delivery methods include:
- Traditional classroom,
- Live Virtual Class,
- Oracle Learning Streams,
- Oracle Learning Cloud and
- Training On Demand.
For buying confidence all our training is backed by the unique 100% student satisfaction guarantee.

Subscribe to the Latest OU Blog Posts by Email

OU Website

Subscribe to OU Training Newsletters

Oracle Certification Blog

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today