select t1.col1,t1.col2....t1.coln 
from t1,t2 
where <condition having joins between the 2 tables>
union all
select t1.col1,t1.col2....t1.coln 
from t1,t2,t3
where <condition having joins between the 3 tables>.

      select    last_analyzed
      from      user_tables
      where     table-name in ('abc','def','ghi');

    

        SELECT    'Buffer Cache' NAME,
		  ROUND ( (congets.VALUE + dbgets.VALUE - physreads.VALUE)* 100/ (congets.VALUE + dbgets.VALUE),2) VALUE
        FROM      v$sysstat congets
                 ,v$sysstat dbgets
                 ,v$sysstat physreads
        WHERE     congets.NAME = 'consistent gets'
        AND       dbgets.NAME = 'db block gets'
        AND       physreads.NAME = 'physical reads'
   UNION ALL
        SELECT   'Execute/NoParse',
                  DECODE (SIGN (ROUND ( (ec.VALUE - pc.VALUE)* 100/ DECODE (ec.VALUE, 0, 1, ec.VALUE),2)),-1, 0,ROUND ( (ec.VALUE - pc.VALUE)* 100/ DECODE (ec.VALUE, 0, 1, ec.VALUE),2))
        FROM      v$sysstat ec
                 ,v$sysstat pc
        WHERE     ec.NAME = 'execute count'
        AND       pc.NAME IN ('parse count', 'parse count (total)')
   UNION ALL
        SELECT   'Memory Sort',
                  ROUND ( ms.VALUE/ DECODE ((ds.VALUE + ms.VALUE), 0, 1, (ds.VALUE + ms.VALUE))* 100,2)
        FROM      v$sysstat ds
                 ,v$sysstat ms
        WHERE     ms.NAME = 'sorts (memory)' AND ds.NAME = 'sorts (disk)'
   UNION ALL
        SELECT   'SQL Area get hitrate'
                 ,ROUND (gethitratio * 100, 2)
        FROM      v$librarycache
        WHERE     namespace = 'SQL AREA'
   UNION ALL 
        SELECT   'Avg Latch Hit (No Miss)'
                 ,ROUND ((SUM (gets) - SUM (misses)) * 100 / SUM (gets), 2)
        FROM      v$latch
   UNION ALL
        SELECT   'Avg Latch Hit (No Sleep)',ROUND ((SUM (gets) - SUM (sleeps)) * 100 / SUM (gets), 2)
        FROM     v$latch;