Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> v$tempfile.file#+200 = $sort_usage.segfile# in 8i, +1000 in 9i ?

v$tempfile.file#+200 = $sort_usage.segfile# in 8i, +1000 in 9i ?

From: Spendius <spendius_at_muchomail.com>
Date: 13 Apr 2006 01:35:25 -0700
Message-ID: <1144917325.187235.268240@e56g2000cwe.googlegroups.com> 





I've noticed that in order to join V$SORT_USAGE and V$TEMPFILE
I have to add 200 or 1000 to the value of the file number in the
latter (depending on the version).


In Metalink note


https://metalink.oracle.com/metalink/plsql/f?p=130:14:4053916170257422556::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,67534.1,1,1,1,helvetica



they say that SQLADDR and SQLHASH can appear wrong, I'm afraid
they forgot to add that other columns of this view may be erroneous too
!



I'm going to check it in 10g.



Spendius
Received on Thu Apr 13 2006 - 03:35:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US