Re: temporary space issue

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Tue, 8 Feb 2011 06:43:41 -0800 (PST)
Message-ID: <0355c4ab-ca75-4595-baec-24b8293ad28b_at_x18g2000yqe.googlegroups.com>



On Feb 8, 9:16 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> Oracle 10.2.0.4 enterprise windows 2003 standard
>
> temp space is 3 * 64gig v$tempfiles in ts LOCALTEMP
>
> Got the following errors yesterday
>
> Mon Feb 07 14:00:26 2011
> ORA-1652: unable to extend temp segment by 64 in
> tablespace                 LOCALTEMP
> Mon Feb 07 14:00:53 2011
> Errors in file d:\oracle\product\10.2.0\admin\lvyesmi\bdump
> \lvyesmi_j000_568.trc:
> ORA-00600: internal error code, arguments: [kglhdgn_1],
> [0x7FF84871250], [18446744071639766840], [4], [], [], [], []
>
> What I know
>
> temp resource filling up caused database to be unavailable
>
> Known unknowns
>
> Is there a way I can get details of users/query/temp useage at time of
> crash so that I can say eg Mr x  ran a select from tab which used
> 1.5gig & was trying to grab more space
>
> I am hoping AWR may hold key to who was using temp at time of the
> crash..thus giving a more meaningful explanation to the customer of
> the cause and potential solutions
>
> regards
> Chris B

Do you have OEM available? You should be able to find pretty easily the bad query ( probably missing join conditions ) that chewed up your temp space. Received on Tue Feb 08 2011 - 08:43:41 CST

Original text of this message