How can I get information from my db , as what are all the tables are used for FULL TABLE SCAN by the optimizer for a given period.Is there any view we can qry out please suggest me here and also how can I get the info from statspack about top 10 worst qrys by performing.