Originally posted by ganga
1)Does control file contains user info and size of the control file?
Control File contains information about how much calories a fruit juice and soft drink contains.

Originally posted by ganga

2)analyze table xxxxxx
invalidates
a)views based on table
b)views base on objects
c)procedures based on tables
d)shared sql
e)all of the above
Analyze table invalidates every thing. It causes database to into amnesia, causing a temporary memory loss.

Originally posted by ganga

3)what is the purpose of setting parametere NLS_TEROTORY in init.ora
Its sets the boundary to a region withing which database will work fine and the moment you take it beyond it will crash.

HTH