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.

Thursday Apr 23, 2015

Oracle Commerce: Guide to Selecting the Right Training

With the recent availability of Oracle Commerce Release 11.1, Oracle continues to unify and enhance the leading commerce, content and experience technologies on the market.

Given that Oracle Commerce combines ATG Web Commerce and Oracle Endeca Commerce technologies, select courses from the existing ATG and Endeca Commerce curriculum also apply to Oracle Commerce Rel 11.1 customers. For those looking for training, your training needs will vary depending upon your particular situation. 

At Oracle University, we recognize this can be confusing to you. Therefore, we created a Guide to Help You Select the Right Oracle Commerce Training.


This guide addresses multiple customer scenarios, including:
  • New Oracle Commerce customers
  • Customers upgrading from and earlier release of ATG or Endeca Commerce
  • Customers only implementing 'Guided Search' within an existing ATG, Oracle Commerce or other commerce platform environment
  • Customers in need of training to support an existing ATG or Endeca Commerce implementation

View the Oracle Commerce Training Selection Guide now.

Monday Apr 20, 2015

Training On Demand - Using Oracle Database Vault with Oracle Database 12c

Written by Maria Billings, Senior Principal Curriculum Developer

Do you want to advance your career, but never know beforehand when you might have time for training?

Try Oracle University’s Training On Demand or TOD curriculum. You can watch recorded classroom and hands-on sessions in smaller or larger increments as it fits into your schedule.

For Database Vault

  • Do you sometimes need to prove that you couldn't possibly have seen confidential information, although you are a highly privileged DBA?
  • Did you know that the Oracle Database 12c has a Database Vault option already installed, ready to be enabled, if your organization decides to use it?
  • What is Database Vault?

Database Vault TOD Training is composed of several components, including realms, rule sets, command rules, secure application roles and factors that can be highly customized or simply used out-of-the box.

A realm, for example, is a zone of protection for tables, roles, and packages. A realm protects the objects in it from users exercising system privileges, such as SELECT ANY TABLE. So, any such privileged user must be defined as a realm participant (or have a realm-participating role that is granted to him or her) to access the protected objects.

If you are not a realm participant or owner, you can show that a query of a realm-protected table will result in the "ORA-01031: insufficient privileges" error. In short, you can prove you couldn't have possibly seen the confidential content.

The course "Using Oracle Database Vault with Oracle Database 12c" TOD training goes into all the necessary details to show you:

  1. How to reduce the attack surface for potential security breaches through limiting privileges.
  2. How to perform security analysis and report security vulnerabilities.
  3. How to configure and maintain Database Vault elements.
  4. How to implement best practices, which begins by identifying YOUR security requirements.

You can then see samples of building and documenting security implementations, and you view or discuss sample use cases, such as the workflow of an application DBA, dual key security, dynamic auditing, and so on.

Tuesday Apr 14, 2015

Join Us! Oracle University Expert Summit in Cancun Mexico - May 4-6

The Oracle Expert Summit is being held in Cancun, Mexico and provides the ideal opportunity to learn directly from top Oracle Database experts – including Tom Kyte, Pete Finnigan and Arup Nanda – and to interact with like-minded Oracle professionals.

Attend three days of training, choosing from six expert-led sessions.

Here are a few of the sessions you will not want to miss:

Optimizer Master Class with Tom Kyte

This workshop begins with an in-depth look at statistics and statistics maintenance, a challenge all DBAs must face  to prevent sub-optimal execution plan. This presentation includes information about the features introduced in Oracle Database 11g to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments. These strategies include how to use dynamic sampling, as well as when and how to manually set statistics directly versus collecting them.

The workshop continues with a detailed walk-through of how to interpret an execution plan. Each aspect of an execution plan is examined, from cardinality estimates to parallel execution. You will learn which information you should be gleaning from the plan and how it affects the execution. 

Oracle Database Security Audit with Pete Finnigan

Learn from the renowned security assessment expert for Oracle Database. This seminar teaches you how to confidently perform a security audit of the Oracle Database. Pete will explain how to avoid the security risk of an improperly configured Oracle Database. He will show you how a security audit is planned, teaching you how to prepare yourself, your staff and your environment.

Explore the fundamentals of how to review a database, along with an explanation about why it's necessary. This will help you understand why something is an issue, how to verify that it's an issue and understand the implications on your own databases and applications before using pre-built or commercial tools. The seminar uses supported versions of Oracle from 9iR2 through Oracle 11g.

Performance Tuning in RAC with Arup Nanda

The foundation of any tuning depends heavily on the proper diagnosis -  therefore this seminar will start with building your knowledge about the RAC system with respect to performance. All concepts will be shown with live examples and real-life stories from Arup Nanda's experience.

You will learn how to assess the performance using various tools and techniques available in Oracle and how to use the output to develop a strategy to handle performance issues. The focal point is on the word "strategy", as the seminar helps you master the art of the strategy building based on evidence collected; not just a blind shot at the problem using various ad-hoc approaches.

Learn More and Register Now

 For registration inquiries and questions regarding this event, please contact the local regional office

via ou-direct-lad_co@oracle.com


Wednesday Apr 08, 2015

User Adoption: the Key to Successful Change Management

Oracle University offers comprehensive training services to help executives, managers, and end users make the most of new Oracle technology. With Oracle User Adoption Services, you can experience an easier transition, a quicker return on your technology investment, and a more successful Oracle product implementation.

[Read More]

Monday Apr 06, 2015

Just Released - New “Training On Demand” Courses for April 2015

Written by Diana.H.Gray

What is Training on Demand?

Training On Demand offers expert training from Oracle's top instructors in a sophisticated streaming video recording available for 90 days, 24 hours a day, 7 days a week.

Watch this demo to see how Training On Demand works.

What is included?

  • Online access to a comprehensive student eKit
  • White boarding and training labs for hands-on experience
  • Oracle University instructor Q&A
  • No travel required
  • A full-text search leads to the right video fragment in a matter of seconds.
  • Counts as a hands-on requirement for Oracle Certification

The Benefits of Training On Demand

  • Accessible for 90 days, 24x7. The ideal training solution to bridge the summer season
  • Access to Training On Demand is available within 24 hours from your booking
  • Start, stop, pause, jump or rewind sections of the course as needed
  • Save valuable time and money by taking advantage of unscheduled free time to develop your staff's skills at their own pace

Just Released - New Training on Demand Courses      

PREVIEW THE FOLLOWING COURSES NOW:

1. MySQL for Developers

2. Using Oracle Key Vault

3. Oracle Database 12c: Security

4. Oracle Database 12c: Performance Management and Tuning

5. Oracle SOA Suite 12c: Build Composite Applications

6. Oracle Data Integrator 12c: Integration and Administration

7. Oracle Hyperion Financial Management 11.1.2 for Interactive Users (11.1.2.3)

8. PeopleSoft Inventory Rel 9.2

9. PeopleSoft Purchasing Rel 9.2

10. Siebel 8.1.x BI Publisher Reports

11. R12.2 Oracle Subledger Accounting Fundamentals

For additional "Training On Demand" courses, go here.

Wednesday Mar 18, 2015

Just Released in March - New Oracle University Courses

Here's a list of some newly released courses that we believe will be popular with customers like you.

Courses are typically available in a classroom at an Oracle Learning center, as a Live Virtual Class that is delivered online or as a private training event for your organization.

  1. PeopleSoft Lifecycle Management/Update Manager Accelerated Rel 8.54
  2. R12.x Oracle Production Scheduling
  3. Oracle CPQ Cloud Yellow Belt for the Business Users
  4. Oracle Communications ECB Configuration and Administration
  5. Oracle Identity Governance 11g R2: Develop Identity Provisioning
  6. Oracle Identity Governance 11g R2: Essentials
  7. Perl Programming
  8. Virtual Compute Appliance: Overview
  9. Oracle Linux 7: System Administration

Monday Mar 16, 2015

Taleo Enterprise Edition: Continuing Education

Written by Jim Vonick and Kristine Kukich

System Administrators have a continuous need to understand the new tools and functionality released within Taleo Recruiting, Taleo Onboarding (Transitions) and Taleo Performance, as well as the need to report on these activities.

Oracle University provides many ways for your team to keep their skills current, check their knowledge and become the system advocate within your organization.


Learn More About the Tools and Functions

Oracle University provides over 150 instructional videos in the new Oracle HCM Cloud Learning Stream. Topics covered go beyond those covered in our traditional courses. With new videos added continuously, this subscription-based learning service is designed to help you regularly broaden and deepen your knowledge.

Watch for some of the more complex topics, including Taleo Connect Client (TCC) and Dynamic Approval Routing (DAR). Upcoming topics include integration techniques and best practices.

In addition, each subscription lets you request specific videos that interest you. You will also have access to a Taleo product expert to help answer your questions.

Preview the Oracle HCM Cloud Learning Stream.


Learn and Test Your Skills through the Taleo ACE Program

Meet with one of our experts and test your knowledge be enrolling in the courses list below.

Designed for business users and system administrators, these courses are packed full of items you may already know, combined with topics with which you may be less familiar. At the end of your session, test your abilities via practical examples and quiz questions to see if you're a Taleo ACE.

  • Taleo (TEE): Taleo ACE Recruiter (TAR) - helps you develop additional knowledge and skills around business user recruiting functionality. Check in using real world examples and expand your knowledge in this 3-day session.
  • Taleo (TEE): Taleo ACE System Administrator - recruiting expands your skill set to include DAR, eOffers and evaluations, in addition to exploring more details around best practices optimizing your environment. This course is 5 days of intensive activities built around real world scenarios taken from our experiences with various global clients.

Training Courses Beyond the Fundamentals

So you know the fundamentals and you're ready to either tackle advanced topics. Or possibly you're upgrading from legacy Onboarding to Onboarding (Transitions). Here are a few courses to consider.

See all available Taleo Enterprise Edition Training Courses.

Tuesday Mar 03, 2015

FREE Webinar: Software in Silicon - Register Now

Join us on March 18, 2015 for a FREE Webinar on "Software In Silicon" hosted by Oracle experts, Angelo Rajadurai and Mike Mulkey.

Oracle ISV Engineering is offering an exciting opportunity to learn about the NEW offering for developers who want early access to the revolutionary Software in Silicon technology in the forthcoming Oracle SPARC M7 processor running Oracle Solaris 11.

What Will You Learn? 

By listening to this webinar, you'll learn how to:

  • Use the NEW Software in Silicon Cloud to dramatically improve reliability and security.
  • Accelerate application performance in today’s market. 
  • Software in Silicon implements accelerators directly into the processor to deliver a rich feature-set that enables quick development of more secure, robust, reliable, and faster databases and applications.

With the Oracle Software in Silicon Cloud, developers can have a secure environment in which to test and improve their software, as well as exploit the unique advantages of Oracle's Software in Silicon technology.

Angelo Rajadurai, Software Engineer with ISV Engineering, will provide an explanation of the technical details of the Software In Silicon features. He will also conduct a demonstration illustrating how developers can use the Software in Silicon Cloud to test these features on their applications today.

JOIN US ON MARCH 18, 2015

Register Now >

Thursday Feb 26, 2015

Spotlight On: Oracle Systems Learning Stream

Online Training to Support Your Infrastructure Professional Development

Systems Learning Stream

Oracle University has released the

New Oracle Systems Learning Stream

 Ask yourself:

  • Are you up to speed on "Software in Silicon"?
  • Are you familiar with the Virtual Compute Appliance?
  • Are you using SPARC M6-32 or FS1 software?
  • What's new with the Exadata  X5 release?
  • Do you know what the experts are saying about Linux?
  • Do you know how to build an Oracle Key Manager Cluster setup?
  • Have you heard of the new Engineer System, Zero Data Loss Recovery Appliance?
  • How do you scale SAM-QFS?
  • Which systems provide optimization for the cloud?
  • What is the latest information available on ZFS Storage Appliance?
  • Would an overview of the Oracle Enterprise Manager help you?
  • Which Oracle products can increase performance in your Data Center?

Learn the answers to these questions by accessing our recently released training option: Oracle Learning Streams

The Oracle Systems Learning Stream covers multiple products, including: Engineered Systems, Servers, Storage, Operating Systems, Virtualization and more.

Plus, the content is coming straight from Oracle experts.

Learn More: The Oracle Systems Learning Stream

Friday Feb 20, 2015

Exadata X5 & Related Product Knowledge - Just a Click Away with Oracle Streams

With so many new Oracle products being introduced, how can you get a quick overview of these new products to learn how they fit into the big picture?

Did you know that Oracle unveiled the sixth generation of its high-performing, low-cost platform for running Oracle Database, the Oracle Exadata Database Machine X5?

Oracle Exadata's architecture features:

  • Scale-out database servers
  • Scale-out intelligent storage servers
  • High-speed InfiniBand networking
  • 50 percent faster processors
  • 50 percent larger maximum memory capacity
  • Faster and larger flash increase overall performance

Oracle also introduced an all-flash storage server that uses ultra-fast PCIe flash drives, the latest Non-Volatile Memory Express flash protocol, and InfiniBand scale-out to achieve breakthrough performance and price per I/O.

Oracle Exadata X5-2,Oracle SuperCluster T5-8 and Oracle SuperCluster M6-32 engineered systems can be configured with extreme flash storage servers.

To find out more about these products, explore Oracle Systems Learning Stream online videos to develop the knowledge you need just-in-time.

Gain access to over 280 online videos that will increase over time as more exciting knowledge about Oracle’s latest developments becomes available.

Learn about the Exadata Database Machine, Oracle ZFS Storage Appliance, Oracle SuperCluster and so much more by viewing the new Oracle Systems Learning Stream.

Access additional Oracle Streams by visiting education.oracle.com/streams today.

Monday Feb 16, 2015

Now Available - Oracle Systems and PeopleSoft Learning Streams

More Videos. More Choices. More Experts.

Two new Oracle Learning Streams are now available:

Oracle Learning Streams are innovative, subscription-based learning solutions that are changing how professionals stay up-to-date on Oracle products and technologies.

This is done through ready access to hundreds of instructional videos and live webinars delivered by Oracle experts, along with access to top instructors that can answers your questions.  New videos are added regularly to each Learning Stream. You can  also request videos on topics that interest you.

Oracle Systems Learning Stream

The Oracle Systems Learning Stream includes over 280 instructional videos on several layers of the Oracle stack, including Oracle Servers, Storage, Operating Systems (i.e., Linux and Oracle Solaris), Virtualization products and related technologies. 

Oracle subject-matter experts advise on product direction, performance, optimization, and troubleshooting on core Oracle products.

This learning solution is for system administrators, architects, support engineers and developers who need to learn about Oracle Infrastructure products, how they work together, what new features are available, and what they are capable of.

Preview the Oracle Systems Learning Stream.


Oracle PeopleSoft Learning Stream

The PeopleSoft Learning Stream is ideal for both technical and business professionals, who need to stay current on the technical and functional aspect of your PeopleSoft solutions.

It includes over 150 instructional videos on critical and advanced topics for PeopleTools, Financials, Human Capital Management, Supply Chain Management and Customer Relationship Management.

Preview the Oracle PeopleSoft Learning Stream

Find Out More

Learn more about all of the available Oracle Learning Streams.


Thursday Feb 12, 2015

Just Released - New Oracle University Courses for February 2015

Each month Oracle University releases numerous new courses to make sure our training portfolio is current. 

Courses are typically available both in the classroom and online.  Here's a quick summary of some of the courses that we anticipate will be popular with customers.

Top New Courses for February

  1. Using Oracle Database Vault with Oracle Database 12c
  2. Oracle Audit Vault and Database Firewall: Install & Configure
  3. Oracle Commerce: Implementing Guided Search Rel 11.1
  4. PeopleSoft Fluid User Interface Rel 8.54
  5. PeopleSoft Pivot Grids Rel 8.54
  6. PeopleSoft Update Manager Rel 8.54
  7. JavaScript and HTML5: Develop Web Applications
  8. Oracle Data Integrator 12c: Advanced Integration and Development

Explore all of Oracle's training and certifications at education.oracle.com.

Wednesday Feb 04, 2015

Oracle E-Business 12.2 Training - Support Your Deployment


As enterprises continue to migrate and adopt Oracle E-Business Suite 12.2, we continue to see strong demand for training. Courses are available in both traditional classroom and our popular online Live Virtual Class formats.

Here are some key training opportunities you may want to consider.

Online Patching

One of the most significant new features of Oracle E-Business Suite Rel 12.2 is 'Online Patching'. This allows you to apply patches while the system is still running, which reduces the patching and maintenance downtime.

Such a significant transition does, however, require an understanding of the new patching model, the terminology, and the tools that underpin the online patching operation. The following course will help you meet this objective.

Application Administration

System administrators need to understand the concepts and functions  critical to their job role as it pertains to your applications. The following course covers implementing and managing the Oracle E-Business Suite.

Oracle Workflow

Oracle Workflow Manager allows system administrators to define and manage business processes. You can route relevant information to decision makers, automate processes, deliver electronic notifications to users in a given workflow, and monitor your processes as they are implemented.  The following course will teach you how to design, administer, and manage workflow processes.

Oracle Financials

Training for the Oracle E-Business Suite Financial Management is designed to help implementers and end users set up, use, and manage their financial applications.  The following course provides a deep dive into implementation considerations for setting up and using Oracle Subledger Accounting. You'll walk away with the knowledge to create and translate journal entries to the General Ledger.

The next course is for those who need to know how to set up and use Oracle Receivables to manage receivables processing.

Order Management

If you're looking to learn how to perform the steps to setup Oracle Inventory in support of Oracle Order Management, including how to create subinventories, units of measure and items, then you should take the following course.

Inventory Management

Effective inventory management is critical to any successful manufacturing operation. The following course will show you how to setup, define, and perform inventory transactions, while reflecting the logical flow of the processes involved in inventory management.

Learn More

Learn more about all of the available training for the Oracle E-Business Suite.

About

Official home blog of Oracle University. 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 inc. our NEW "Training on Demand" options. For buying confidence our training is backed by the unique 100% student satisfaction guarantee...

Search

Archives
« July 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