Author Archives

Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variable

*+-I’ve updated some of my ASH scripts to use these 4 arguments in a standard way:

What ASH columns to display (and aggregate by)
Which ASH rows to use for the report (filter)
Time range start
Time range end

So this means whenever I run ashtop…

Oracle Exadata Performance: Latest Improvements and Less Known Features

*+-Here are the slides of a presentation I did at the IOUG Virtual Exadata conference in February. I’m explaining the basics of some new Oracle 12c things related to Exadata, plus current latest cellsrv improvements like Columnar Flash Cache and I…