OraFAQ Forum: Performance Tuning » VW_NSO_1 !!

Home » RDBMS Server » Performance Tuning » VW_NSO_1 !!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

VW_NSO_1 !! [message #181200]

Fri, 07 July 2006 06:46

AlinaC
Messages: 45
Registered: November 2005
Location: India

Member

Execution plan of a query shows following-

SELECT STATEMENT |
HASH UNIQUE |
COUNT STOPKEY |
TABLE ACCESS BY INDEX ROWID | X
NESTED LOOPS |
VIEW | VW_NSO_1
SORT UNIQUE |
UNION-ALL |
INDEX RANGE SCAN | Y_IX2
TABLE ACCESS BY INDEX ROWID| Y
INDEX RANGE SCAN | Y_IX1
INDEX RANGE SCAN | X_IX2

Can you tell me what is the VW_NSO_1 view? Does it effect on performance? How to tune this query? I'm using Oracle10G Rel 2.

Regards,
Alina

Report message to a moderator

Re: VW_NSO_1 !! [message #181204 is a reply to message #181200]

Fri, 07 July 2006 07:14

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Check out this entry, from the Google cache.
There's also a mention of VW_NSO_1 here (ctrl+F to locate it on the page).
The Oracle documentation even has something to say about VW_NSO_1. Here, too.

Report message to a moderator

Previous Topic:	Why size log_buffer have no equal?
Next Topic:	Pro C report not working . Is the problem PC -related ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 06 15:21:21 CDT 2024