Re: very slow query on dba_jobs

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Tue, 2 Dec 2003 23:29:32 +0200
Message-ID: <3fcd043d_1@news.estpak.ee>

> > 1) select /*+ RULE */ * from dba_jobs_running;
> Works great. That's what I'm going to use.

Awesome ;)
This "hack" can be used with several other DD views as well, like DBA_FREE_SPACE in LMT database.

> > 3) set your optimizer_dynamic_sampling greater than 1.
> Didn't make a difference with any setting between 0 and 10.

It seems that DD tables aren't sampled dynamically. I created another table under SYS and for that it worked...

>
> Lots of Greetings and thanks!

You're welcome,
Tanel. Received on Tue Dec 02 2003 - 15:29:32 CST

Re: very slow query on dba_jobs_running...