i am going for oracel9i DBA course. please mention some good links that will give thorough and easy to understand article on oracle database administration.
my query is
what is a segment? i do know that segment is a collection of extents.
can someone explain beyound this?
Go through the Oracle Documentation.
"Segment" is the generic name for a table, index, roll-back segment etc. It is used to cover the objects that are stored using the same space management techniques.
It's all here: http://tahiti.oracle.com/pls/db92/db92.homepage