Yes and if you have licensing issues, and if you use OEM, ding into OEM views ... all data you need is there. Raj You can if you're licensed to use AWR, ASH and ADDM; not all sites license > the Diagnostic Pack so you should check before you run such queries. > > David Fitzjarrell > -- //www.freelists.org/webpage/oracle-l