This Log Buffer Edition covers various valuable blog posts from the fields of Oracle, SQL Server and MySQL.
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:
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.
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:
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:
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:
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 188.8.131.52 BP 22 database on Exadata 184.108.40.206.1 and 220.127.116.11.2 database on Exadata 18.104.22.168.0. The test case evolves around the following table:
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