(Uwe Hesse) Say I have created a new tablespace recently and did not yet take a backup of the datafile. Now I lose that datafile. Dilemma? No, because I can do an ALTER DATABASE CREATE DATAFILE. Sounds complex? Well even if I wouldn’t be aware of that possibility, a simple RMAN restore will work – a

(Hemant K Chitale) So far, all my examples of Tracing have been ‘pure’ SQL. What does a Trace File show for SQL that is executed from within PL/SQL ?

(Mike Dietrich) Just had an observation about very large trace files on one of my customers I’m working with at the moment. When I write “very” I mean “VERY” as some grew over 10GB within a few hours.

(Jeff Smith) A question came up on the oracle-l…

Several clients and partners have asked for this checklist lately. Posting it for those who may find it useful:

(Hemant K Chitale) In the previous two posts, I demonstrated a single execution of an SQL query and interpreting the raw trace and the tkprof summary for it. The demonstration also showed the Hard Parsing for the first execution of the query.

(mwidlake) Where do oracle trace files go? I don’t know why this piece of info will not stick in my head, I seem to have to look it up 3 or 4 times a year.

(Richard Harrison) Ever run the create schema statement in Oracle? No – I thought not. It’s one of the least used commands available I would think – I’ve only seen it used once in all my years of doing this job.

(Flavio Casetta) In a perfect situation, when we need to display an inline image inside an Apex report, we might simply pick the BLOB column and apply the special formatting required in these cases, I mean that weird format mask containing a list of column attributes separated by colons where each m

(Hemant K Chitale) Picking up the same SQL Trace file from my previous post, I run (the well known) utility tkprof on it.