RE: Statspack recomendations.

[M Rafiq]

Robert,

It works in HP-UX 11 Oracle version Oracle9i Enterprise Edition Release 9.0.1.0.0 - 64bit Production

SQL> select a.file_name
2 from dba_temp_files a, v$tempstat b
3 where b.file#=a.file_id;


FILE_NAME
------------------------------------------------------------------------------------------------------------------------
/a1/app/oracle/product/9.0.1/oradata/OEM/temp01.dbf

Regards
Rafiq








Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 23 Jan 2003 12:14:11 -0800

Anyone know a work around to joining v$tempfile and dba_temp_files by file#?
I'm using 9.2.0.1.0 on XP and I'm issuing the statement:

select a.file_name
from dba_temp_files a, v$tempstat b
where b.file#=a.file_id;

I get an ora-0600 on this with a [ktfthcf-1] [202]

Argument. I looked this up on Metalink and this appears to have been a bug
discovered in 8i and fixed in 9i but alas, it's still here. I tried to
implement the work around, issuing the RULE hint, which removes the error
message but gives me no results.

Anyone experience this?

RF



_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).