| help me--> dynamic view [message #63497] |
Mon, 11 October 2004 01:46  |
Puneet sachar
Messages: 62
Registered: October 2003
|
Member |
|
|
Hi I was solving few question on fundamental -1 and come across one question
Question) Which of following about dynamic performance view are correct
and it has few options
and i have clicked on the optionwhich says DML are not allowed on these views which i think is correct but instead of this it says
these view obtain the information from memory n control files...
Tell me... am I wrong if i select above option.
Cheers
Puneet
|
|
|
|
| Re: help me--> dynamic view [message #63498 is a reply to message #63497] |
Mon, 11 October 2004 02:09  |
Sujit Sarkar
Messages: 40
Registered: September 2003
|
Member |
|
|
Dear Puneet,
These dynamic views are owned by SYS so anyway no DMLs are allowed.
To the context of the nature of the views the Given option is correct.
These views are called dynamic view, bcos changes in the memory and the control file is reflected with these views (As soon as something is changed in Memory and Controlfile these views would reflect them).
And these views retain the data as long as instance is running . Once the Instance is brought down the Informations are gone from these views.
the Other type of views are Fixed View (e.g DBA_TABLES,DBA_USERS,DBA_SEGMENTS .....).
Both type of views are owned by SYS user.
So that is why the given answer is more relevant.
best of luck
Sujit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
