Today, I had to identify all rows on a given block. I used DBMS_ROWID, but initially I wasn’t using it correctly. I figured out what I should have been doing (below)… select work_id from xwc.frbr_holding_display partition(FRBR_HOLDING_DISPLAY_P12) where dbms_rowid.ROWID_BLOCK_NUMBER(rowid,’BIGFILE’) > =…
Category: Python
Parsing a 10046 trace with python
This needs work (I am just learning python), but try the following… #!/usr/bin/python #————————————————————————————————– #Author: Steve Howard #Date: March 23, 2009 #Organization: AppCrawler #Purpose: Simple script to print statements in executed order from 10046 trace file. It also # prints…