Handling Heuristic Decisions with Oracle

Greenhorn

Posts: 5

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi All,

I am using Oracle as the database.
I want to know to handle heuristic exceptions/decisions from Oracle.
I am not getting any heuristic exceptions right now, but just acting proactively.

Thnks
Sam

Nicholas Cheung

Ranch Hand

Posts: 4982

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

You could configure the DB to start the statistic collection. Then, you could try to execute the most commonly used SQL statements many many times currently. By then, you could get your TIMED_STATISTICS data, as well as the execution plan from the dynamic views, or from the Oracle10g's Data Center.

Nick

SCJP 1.2, OCP 9i DBA, SCWCD 1.3, SCJP 1.4 (SAI), SCJD 1.4, SCWCD 1.4 (Beta), ICED (IBM 287, IBM 484, IBM 486), SCMAD 1.0 (Beta), SCBCD 1.3, ICSD (IBM 288), ICDBA (IBM 700, IBM 701), SCDJWS, ICSD (IBM 348), OCP 10g DBA (Beta), SCJP 5.0 (Beta), SCJA 1.0 (Beta), MCP(70-270), SCBCD 5.0 (Beta), SCJP 6.0, SCEA for JEE5 (in progress)

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.