Month: February 2019

Oracle Certification Highlights – February

Oracle Certification highlights provides insight on new exams, exam preparation, exams that are retiring, program announcements, and all the great things that are happening in the certification program. 

February went by fast! Here is what’s currently featured!

 

Valuable Insight from a True Java Insider – Simon Roberts

Each new release of Java brings new features and enhancements, and certification is a great way to keep current. It’s more than a piece of paper, it’s keeping up with the knowledge and having advanced skills. Read more of Simon’s interview on the blog.
 

Preparing for an Exam Soon? 

Find out how Kaplan IT Training’s exam preparation product fits into your study schedule. The Kaplan Way is a comprehensive learning strategy that combines scientific, evidence-based design philosophy with a straightforward educational approach to learning. Experience an innovative new Learning Management System before you buy. Try a Free 5-Day Demo!

Featured Exam

Java SE 8 Programmer II | 1Z0-809

A professional Java Developer with advanced expertise requires the skills covered in both Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP) exams. The Java SE 8 certification was designed to be a two-exam process. If you’re a Java SE 8 OCA, now is the time to get prepared for the next level. We’re here to help.

Prepare for this exam with:

 

New Learning Subscription

Integrated online learning and certification. You can train and test – anywhere and anytime.

Oracle Data Integration Learning Subscription 

Note: Learning subscriptions with a certification exam provide one attempt at any of the exam(s) in the subscription with no additional fee during the subscription period.

 

Get Oracle Certified at Collaborate 19, April 8 and 9, 2019

Take one exam for free at Collaborate 19.

Choose from a selection of Oracle Technology, Applications, and Oracle Cloud Solutions exams. Select from 4 available test sessions. Seating is based on first-come first-served basis, and testing is available to all conference registered attendees.

Registration will open soon! Check back on the blog or the Collaborate 19 website. 

 

Oracle Certification Continues to Drive Success

Thank you for sharing your pathways to success through Oracle Certification Success Stories. These stories inspire and inform with tales of long hours spent studying and preparing for exams and your commitment to lifelong learning. Learn how you can submit your story

Explore All Certifications

PREEMPTIVE_OS_FLUSHFILEBUFFERS waits on Linux

Last week I blogged about Using the Wait Statistics Report in Azure Data Studio, using a Linux VM in Azure as an example host. As that was my first time running wait stats analysis on a Linux host, I found that the PREEMPTIVE_OS_FLUSHFILEBUFFERS waits on Linux will show up as the top wait on SQL […]

The post PREEMPTIVE_OS_FLUSHFILEBUFFERS waits on Linux appeared first on Paul S. Randal.

What’s New in the Oracle Optimizer for Oracle Database 19c?

For those of you that want to keep up-to-speed with the latest changes, this post includes a quick summary of the headline new features in Oracle Database 19c with links to the documentation. In addition, most of the new optimizer white papers have been published. You will find links to them in the new Oracle Query Optimization page (and there will be further updates to this page soon).

Automatic Indexing

This is a complex and sophisticated piece of functionality but, ironically, it requires only a tiny API because it has been designed to be very easy to use and require virtually zero manual intervention. I’m sure that you can expect a lot to be written about this feature, but you can find material in the SQL Tuning Guide and the DBMS_AUTO_INDEX API.

Real-Time Statistics

Statistics can now be collected ‘on-the-fly’ during conventional DML operations. This feature requires no manual intervention, but you can find details in the SQL Tuning Guide’s Optimizer Statistics Concepts chapter.

High-Frequency Statistics Gathering

Real-time statistics are a complement to conventional gathered statistics, so there is still a need for both. To help keep gathered statistics up-to-date, we added a new task to do it more frequently. It is again documented in the SQL Tuning Guide.

Automatic SQL Plan Management

There is a lot to say about this feature, so my intention is to post a blog in the next few of weeks. We have included more automation in the SQL evolve advisor task, so see the new features guide and the section on managing SQL plan baselines.

I noticed that there are a couple of documentation bugs in the DBMS_SPM API documentation. I’m getting that fixed, but in the meantime note that the following SQL plan management task parameters have new default values in Oracle Database 19c: 

PARAMETER_NAME DEFAULT
——————————– ———-
ALTERNATE_PLAN_BASELINE AUTO
ALTERNATE_PLAN_LIMIT UNLIMITED
ALTERNATE_PLAN_SOURCE AUTO

If you currently use SQL plan management, especially if you use it to micro-manage individual SQL execution plans, then you need to be aware of the new default behavior when upgrading to Oracle Database 19c. You do have a choice: you can use the new defaults immediately or, if you prefer, you can set these parameters back to the pre-19c defaults very easily.

An additional piece of SQL plan management functionality was added late-in-the-day, so that will make its way through soon. I will post an update here when it’s documented.

Hint Usage Reporting

Diagnosing SQL statement hint issues can be difficult. More information on how we have made is easier can be found in the documentation and in this blog post. Using this feature to diagnose issues with SQL plan baselines is presented in this blog post.

SQL Plan Comparison

We’ve made it much easier to compare a ‘reference’ SQL execution plan with multiple plans from a variety of different sources using a single API call. It’s a great tool for diagnosis and you can find details in the section on comparing execution plans in the documentation. The API is DBMS_XPLAN.COMPARE_PLANS.

SQL Quarantine

This feature allows you to prevent runaway SQL statements from consuming all your system resource. It is covered in detail in the Database Administrator’s Guide chapter on Diagnosing and Resolving Problems.

Automatic Diagnosis and Repair

The process of diagnosing and repairing problems has been enhanced to make it easier to treat issues with the DBMS_SQLDIAG API and the addition of the V$SQL_TESTCASES view.

There’s more in in the Database Administrator’s Guide.

Licensing

Not all of these features will be available on all database platforms. Consult the Database Licensing Information User Manual for details

 

数据泵导致表部分列

看到群里有人提出一个需求,一张表数据量很大,只想导出其中一部分列。 无论是老版本exp还是数据泵expdp,Oracle都提供了QUERY的功能,这使得查询表中部分记录的功能可以实现,但是QUERY只能过滤行,而不能过滤列,Oracle数据泵会读取表中全部列的。 在12c中,Oracle为数据泵提供了VIEW功能,使得导出的时候可以根据视图的定义来导出表中的数据: SQL> select banner from v$version; BANNER ——————————————————————————– Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production SQL> CREATE TABLE T_TABLES AS SELECT * FROM ALL_TABLES; 表已创建。 SQL> create view v_tables as select owner, table_name, tablespace_name from t_tables … Continue reading

10 Leaders Share Their Infrastructure Transformation Stories

The detailed use cases in this paper are of the 2018 Winners of the Oracle Excellence Awards “Leadership In Infrastructure Transformation” category.

In these 10 individual stories, you’ll learn how IT leaders accelerated innovation and drove business transformation.  Each of these leaders ultimately delivered value to their organizations through the use of multiple Oracle technologies which have resulted in reduced cost of IT operations, improved time to deployment, and performance and end user productivity gains.

Each story includes the use of at least one, if not a combination of several, of the below:
 
•    Oracle Linux
•    Oracle Virtualization (VM, VirtualBox)
•    Oracle Private Cloud Appliance
•    Oracle SuperCluster
•    Oracle SPARC
•    Oracle Solaris
•    Oracle Storage, Tape/Disk

The stories feature Michael Polepchuk, Deputy Chief Information Officer, BCS Global Markets; Brian Young, Vice President, Cerner, Brian Bream, CTO, Collier IT; Rudolf Rotheneder, CEO, cons4u GmbH; Heidi Ratini, Senior Director of Engineering, IT Convergence; Philip Adams, Chief Technology Officer, Lawrence Livermore National Labs; JK Pareek, Vice President, Global IT and CIO, Nidec Americas Holding Corporation; Baris Findik, CIO, Pegasus Airlines; Michael Myhrén, Senior DBA Senior Systems Engineer and Charles Mongeon, Vice President Data Center Solutions and Services (TELUS Corporation).

Learn more here

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569