Tag: trace

How do I get my trace files on a db-as-a-service

Yeah, sure it would be cool to crank up some big time powered VM’s in the cloud and let rip, but the reality is – if you’re starting out on a cloud exploration, you probably want to (initially at least) just dip your toes…

Where is my tracefile

As a developer, you might have have been reading about SQL trace. After all, we all want to be able to diagnose and improve the performance of the code we write. So if you’ve googled on Oracle performance, you will have no doubt stumbled…

A little quiz on tkprof

I found this in a trace file recently INSERT INTO T (X) VALUES(:B1) call count cpu elapsed disk query current rows ——- —— ——– ———- ———- ———- ———- ———- Parse 15 0.00 0.00 0 0 0 0 Execute 15 0.00 0.00 0 4 44…