Home » SQL & PL/SQL » SQL & PL/SQL » v$sort_usage
v$sort_usage [message #255635] Wed, 01 August 2007 06:42 Go to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Hi all,

In an attempt to figure out what happens in the temp tablespace I came across v$sort_usage. After playing around with it, I wanted to see some documentation. Then I noticed that there is documentation in the Oracle 8 docu. In documentation for 9 or 10 databases I can't found an entry for v$sort_usage.
However in oracle 9 or 10 I can still query against v$sort_usage.

My question(s): Do I look in the wrong place for documentation? or is this view deprecated?

If deprecated : Which view could I use to get information regarding temporary space usage.
Re: v$sort_usage [message #255639 is a reply to message #255635] Wed, 01 August 2007 06:45 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
This view is deprecated. It is replaced by GV$TEMPSEG_USAGE.
Link.

MHE
Re: v$sort_usage [message #255641 is a reply to message #255635] Wed, 01 August 2007 06:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The view still exists, maybe a miss in the documentation.

Regards
Michel
Re: v$sort_usage [message #255644 is a reply to message #255639] Wed, 01 August 2007 06:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hm... Maybe maybe... but V$TEMPSEG_USAGE is just a synonym for... V_$SORT_USAGE

Regards
Michel
Re: v$sort_usage [message #255645 is a reply to message #255639] Wed, 01 August 2007 06:51 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
that's quick Smile
I guess that v$sort_usage isn't filled at all in ORA 9/10. It's only there for some backward-compatability

anyway... thanks.
Re: v$sort_usage [message #255646 is a reply to message #255641] Wed, 01 August 2007 06:55 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Oracle could have made an documentation entry only to tell us that the view is deprecated and will be replaced by v$tempseg_usage.

On the other hand.....it's not overly importand Smile

thanks for replying.
Re: v$sort_usage [message #255648 is a reply to message #255646] Wed, 01 August 2007 06:58 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
martijn wrote on Wed, 01 August 2007 13:55
Oracle could have made an documentation entry only to tell us that the view is deprecated and will be replaced by v$tempseg_usage.

On the other hand.....it's not overly importand Smile

thanks for replying.


Didn't Oracle just do that? Did you check my link Wink

MHE
Re: v$sort_usage [message #255655 is a reply to message #255648] Wed, 01 August 2007 07:12 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
yeahyeah I did check your link.
But I'm quite lazy (as every good admin should be Smile )
I need documentation where I look for it Very Happy

I need a function in the oracle documentation like my wife has: She spots that I'm searching something. Then she tells me where I left the thingie WHITOUT asking me what I'm looking for. She just knows. This is almost always very, very handy. But sometimes ....aargh
Re: v$sort_usage [message #255656 is a reply to message #255655] Wed, 01 August 2007 07:18 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Perhaps in the next version. Very Happy

Along with the CIP (Counter Idiot Protection)

MHE
Re: v$sort_usage [message #255658 is a reply to message #255656] Wed, 01 August 2007 07:27 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
mwhuhahahaha

Embarassed I must admit that when I started with sql about 2 years back, I had about the same question. But never dared to ask Embarassed
Previous Topic: EMP Table
Next Topic: trigger vs procedure
Goto Forum:
  


Current Time: Sun Dec 04 04:41:34 CST 2016

Total time taken to generate the page: 0.04540 seconds