List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scripts
In the previous post I explained how to list Exadata disk layout and topology details with the exadisktopo scripts, in this post I’ll introduce one celldisk overview script, which I use to quickly...
List Exadata Disk Layout and Topology with the exadisktopo scripts
Here are two more Exadata scripts for listing the end-to-end ASM<->Exadata disk topology from V$ASM_ views and from V$CELL_CONFIG. These scripts see both the ASM level layout and the storage cell-level...
V$CELL_THREAD_HISTORY – “ASH” for Exadata Storage Cells
Did you know that there’s something like Active Session History also in the Exadata storage cells? ;-)
The V$CELL_THREAD_HISTORY view is somewhat like V$ACTIVE_SESSION_HISTORY, but it’s measuring...
Oracle Database 11.2 Upgrade and Migration slides
Check out the extensive slide deck (over 500 slides) about upgrading techniques to Oracle 11.2, by Oracle Corp (Roy Swonger and Mike Dietrich):
https://blogs.oracle.com/UPGRADE/entry/new_version_of_the_huge
It...
How to Compose New Gmail Messages in Full Screen (instead of the tiny compose box of new Gmail)
I’m writing this (unusual) post as I am a long time Gmail user and recently I’ve seen plenty of people & articles complain about the Gmail’s new compose window (the one that shows...
Public Appearances and Exadata Performance Training
I will be doing a lot of (Exadata) talking and teaching in the coming months. Here’s a list of events where you’ll see me speaking, teaching, hacking, learning and hopefully also drinking beer:
16...
Understanding what a hint affects using the V$SQL_FEATURE views
You may have used the Oracle 11g V$SQL_HINT view already – it displays all the valid hints (both documented and undocumented ones) available in your Oracle version, for example:
SQL> @hint merge
NAME...
Listing Exadata storage cells and their configuration info from V$CELL_CONFIG
If you attended my Exadata hacking session today, you saw me using the cellver.sql script which lists some basic configuration info about the currently connected storage cells:
SQL> @exadata/cellver
Show...
Alter session force parallel query doesn’t really force anything
Jonathan Lewis has already written about this behavior from the angle of PARALLEL hints.
I’m writing a similar article just because the word FORCE in the ALTER SESSION FORCE PARALLEL QUERY syntax....
asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time
I don’t have much time for a thorough blog post, so I’ll just paste in an example output of my asqlmon.sql script, which uses ASH sql_plan_line columns for displaying where inside your execution...
