Oracle Logbook

September 13, 2007

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:

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: