title: Identify partitions having stale statistics in a list of schema
body: <p>I have 5 development schemas. And each of them have partitioned tables. We also have scripts to dynamically create partition tables (Monthly/Yearly). We have to go to DBA everytime for gathering the details over the parition tables. Our real problem is we do have a parition table with 9 partitions. Every day after a delta load operation (Updates/Deletes using a <code>PL/SQL</code>) also some <code>APPEND</code> load using <code>SQL*Loader</code>. This operation happens when database has the peak load.  We do have some performace issues over this table.(<code>SELECT</code> queries)</p>
  
  <p>When reported to DBA, they would say the table statistics are stale and after they do "gathering stats", magically the query works faster. I searched about this and identified some information about <code>dynamic performance</code> views.</p>
  
  <p>So, now , I have the following Questions.</p>
  
  <p>1) Can the developer generate a the list of all partitionon tables, partition name, no of records available without going to DBA? <br>
  2) Shall we identify the last analysed date of every parition <br>
  3) Also the status of the parition(index) if it usable or unusable.</p>