RE: Extent allocation time -- process check
From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Thu, 11 Feb 2010 07:34:11 -0500
Message-ID: <SNT130-ds1DB5FA830409C157867A6A64E0_at_phx.gbl>
Why all the work in trying to figure out the extent allocation. Can't you just go into awr and look at what was running during that time. It's going to be an insert or a create table. You say you're suspecting LGC as being wrong, did a message get posted to the alert log, or was it just that a threshold got crossed? Did users get the "cannot allocate" etc error?
Date: Thu, 11 Feb 2010 07:34:11 -0500
Message-ID: <SNT130-ds1DB5FA830409C157867A6A64E0_at_phx.gbl>
Why all the work in trying to figure out the extent allocation. Can't you just go into awr and look at what was running during that time. It's going to be an insert or a create table. You say you're suspecting LGC as being wrong, did a message get posted to the alert log, or was it just that a threshold got crossed? Did users get the "cannot allocate" etc error?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Rich Jesse
Sent: Tuesday, February 09, 2010 3:21 PM
To: oracle-l_at_freelists.org
Subject: Extent allocation time -- process check
[bump] Any takers on this?
My apologies for the repost...
Rich
--
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 11 2010 - 06:34:11 CST