Oracle Logbook

September 13, 2007

Small Rowid using bigfile tablespace

Filed under: Uncategorized — Helio Dias @ 4:42 pm

Since the bigfile comprise just one file , isn´t necessary to store relative file number on rowid, so Oracle cut it 3 bytes from rowid.

I´ll investigate, but i guess it will improve performance (less space=>less memory=>more performance)

Parse Calls

Filed under: Uncategorized — Helio Dias @ 4:21 pm

By Jonathan Lewis

Here’s an extract from a report of activity in an Oracle session that I’ve just been running. Spot the anomaly: Name Value —- —– session cursor cache hits 3 parse count (total) 5 parse count (hard) 31 execute count 35 There are no tricks involved with this output, though the database activity is a little unusual, and I haven’t faked any numbers. So how come I’ve got more “hard parses” than “parses” ?

see more at:

Blog at