Re: Long Select freezes Instance

Ralf,

If your system is OK there are a couple of things that can be done:

[1] tune the query: use EXPLAIN PLAN etc. to see if additional search criteria or indexes will help
[2] try to find out what Oracle is doing when it 'freezes': e.g. v$session_wait for the session that is performing the query.

Peter

"Ralf Bender" <ralf.bender_at_arcor.de> schreef in bericht news:20020925.5521025_at_mis.configured.host... Hi Peter,

the Rest of the system is ok.
Asking too much? My User using for select always LIKE for asking. The table has 2 Mio. columns. That's a little bit. Teaching them to use '=' is a worst think :-(

I can't understand why such a select of one session all other sessions freezes while running the bad one?

Ralf

>>>>>>>>>>>>>>>>>> Ursprüngliche Nachricht <<<<<<<<<<<<<<<<<<

Am 25.09.2002, 07:18:23, schrieb "Peter van Rijn" <p.vanrijnREMOVE_at_THISzhew.nl> zum Thema Re: Long Select freezes Instance:

> Ralf,

> Did you monitor how the rest of the system is working? CPU idle time,
memory
> consumption etc. Perhaps you're just asking too much?

> Peter

> "Ralf Bender" <ralf.bender_at_arcor.de> schreef in bericht
> news:20020924.8273770_at_mis.configured.host...
> Hello,

> I'm running a Oracle 8i database on linux. Some select statements runs
> very long. That's ok, but if such statement runs, nobody else can work on
> the database. All sessions are freeze. What happens here? How can I
> change it?

> Thanks
> Ralf
Received on Wed Sep 25 2002 - 01:04:21 CDT