Skip to content

Tag Archives: dba

Generating multiple Oracle TKPROF reports using Python

24-Nov-09

Recently, a customer told me that they felt a batch job was taking too long each night, I gave them a few commands to add to their nightly run. alter session set tracefile_identifier=’charging_batch’; exec dbms_monitor.session_trace_enable; These commands named the tracefile and enabled 10046 logging. Since I’m lazy(the good kind), I figured I’d use Python to [...]

Filed in Uncategorized | Also tagged , , | Comments (0) »

Manager: How big is my table? Me: What do you mean?

03-Nov-09

Recently, a data warehouse manager sent me a list of 49 tables; he wants the approximate size of each. For an end-user, this is no easy task. Sure, GUI interfaces such as Toad or OEM will give this information, but not all managers (or developers for that matter) know how to get this information. Furthermore, [...]

Filed in Uncategorized | Also tagged , , , , | Comments (0) »