OraFAQ Forum: Performance Tuning » meaning of 'VW_NSO

Home » RDBMS Server » Performance Tuning » meaning of 'VW_NSO_1'

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

meaning of 'VW_NSO_1' [message #64678]

Fri, 19 December 2003 20:05

Vinod Nair
Messages: 6
Registered: December 2003

Junior Member

I have the following query explain plan
I don't know the meaning of 'VW_NSO_1'
in the plan

Execution Plan
-------------------------------------------------------

0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3 Card=14 Bytes=224)

1 0 HASH JOIN (ANTI) (Cost=3 Card=14 Bytes=224)

2 1 INDEX (FULL SCAN) OF 'SYS_C005773' (UNIQUE) (Cost=1 Card
=15 Bytes=45)

3 1 VIEW OF 'VW_NSO_1' (Cost=1 Card=15Bytes=195)
4 3 SORT (GROUP BY) (Cost=1 Card=15 Bytes=45)
5 4 INDEX (FULL SCAN) OF 'SYS_C005773' (UNIQUE) (Cost=1
Card=15 Bytes=45)

Please explain me.

2. What are filters? In which case FILTERS are used?
Please explain with examples

Report message to a moderator

Re: meaning of 'VW_NSO_1' [message #64683 is a reply to message #64678]

Mon, 22 December 2003 22:39

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

VW_NSO_1 should be the name of a view on your database. To verify:

SQL> SELECT * FROM DBA_VIEWS WHERE VIEW_NAME = 'VW_NSO_1';

Best regards.

Frank

Report message to a moderator

Previous Topic:	buffer cache holds objects not listed in dba_objects
Next Topic:	statistics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 04:47:37 CDT 2024