Oracle VM Site Review - Oracle VM Health Check
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Log Buffer #424: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers various valuable blog posts from the fields of Oracle, SQL Server and MySQL.

Oracle:

Web Publishing for All! Introducing Community Translator Tools

Publishing tools for everyone

Roughly half of the content and traffic on the internet is in English1, yet English is the mother tongue of only about a quarter of internet users2, and less than 5% of the world’s population.3 We believe that WordPress.com should be for

The Fundamental theorem of arithmetic – SQL version

Every positive integer (except the number 1) can be represented in exactly one way apart from rearrangement as a product of one or more primes, see for example Wolfram MathWorld or Wikipedia.
Here is the SQL-Version, we compute this for all integers up to 100

Lab Report: Oracle Database on EMC XtremIO. A Compression Technology Case Study.

If you are interested in array-level data reduction services and how such technology mixes with Oracle Database application-level compression (such as Advanced Compression Option), I offer the link below to an EMC Lab Report on this very topic.

To read the entire Lab Report please click the following link:   Click Here.

The following is an excerpt from the Lab Report:

High Performance Oracle Database with the Dell Acceleration Appliances for Databases

The performance of many business critical applications like Oracle database is often limited by bottlenecks in the infrastructure components—CPU, memory, network, and storage. Although CPU, memory, and network performance has improved dramatically over time, storage performance improvements have lagged due to the limitations of latency and throughput.

OCM 11g Preparation – Implement Grid Control and Database Control

Grid Control and Database Control can and must run in the same time in your simulation environment. Why? Because they may be used in different times during the exam, and EM can help you a lot saving time!
If you only know how to configure the Grid Control and you are asked to do that only in the last exam topic, can you imagine how much time you would lose doing everything using CLI and GUI until there? Time is the most important thing during the exam!
So, in this topic, practice the following:

OCM 11g Preparation – Create notifications

This topic is a complement for the last one. There is no reason of creating alert without notifications. Nobody keep looking the EM Panel fulltime. So, if you create an alert but does not notify anyone, it will be probably too late when you realise the problem is there.
For this topic, you must know how to:

OCM 11g Preparation – Create and monitor alerts

In this chapter you must know how to configure Metric Thresholds. Each target has a screen to configure all of them in one place.
It’s a menu item called “Metric and Policy Settings“. However, you can also define in metrics in other places.
E.g: If you need to define the Used% for tablespace USERS, you can go directly in the tablespace menu item, edit the USERS one and define the metrics there.
The best way to practice this topic is creating random questions to yourself and check if you are able to apply them in less than 1 minute:

Smart Scan enhancements in Oracle Exadata 12c-inline LOBs

As part of the 12c release of the database and cellos Oracle introduced the ability to perform Smart Scans on inline LOBs. The enhancement is certainly for Secure Files only. And as always, if you would like to read up about Secure Files you can head over to Tim Hall’s website for the details.

To demonstrate the new behaviour I have used an 11.2.0.3 BP 22 database on Exadata 11.2.3.3.1 and 12.1.0.2.2 database on Exadata 12.1.2.1.0. The test case evolves around the following table:

Temp Table Transformation Cardinality Estimates - 1

Having published recently two notes about the Temp Table Transformation highlighting the heuristics based decision and other weaknesses, for example regarding the projection of columns, it's time to publish some more notes about it.The transformation can also have significant impact on cardinality estimates, both join and single table cardinality.Looking at the difference

view counter