Chirag >as we are giving in ORACLE select any dictionary, >OEM helps us to get that kind of view? What is provided by OEM is available under Setup -> Administrator. Go to this page and then give a look to the online documentation (link "Help"...). The available options are listed... (sorry, right now I just have a 10.2 beta GC available... and I don't remember which options are available in version 10.1...) HTH Chris New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com Italiano: Lugano (24-Nov) Français: Genève (17-Nov) Deutsch: Zürich (11-Oct), Hamburg (13-Oct), München (20-Oct), Basel (25-Oct), Frankfurt (27-Oct), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart (13-Dec) -- //www.freelists.org/webpage/oracle-l