Answer / manish rathore

I got it from net.
Hope it will serve.

select *
from sys.dm_db_index_usage_stats
where object_id = object_id( '<Table_Name>' )

Answer / aseem k

select b.name, a.analyzetime from tab$ a, obj$ b
where a.obj#=b.obj#
and b.name ='EMP'

Answer / ajit nayak

SELECT TO_CHAR(LAST_ANALYZED,'DD-MON-YYYY HH12:MI:SS'),COLUMN_NAME
FROM COLS
WHERE TABLE_NAME = 'EMP';

Answer / manoj

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  

---

What is partitioned table in Oracle?

0 Answers   MCN Solutions,

---

Explain about achiever in sql?

0 Answers  

---

Give the Types of modules in a form?

1 Answers  

---

how to retrieve daily sal from emp table in oracle 10g

2 Answers   Infosys,

---

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

Explain coalesce function?

0 Answers  

---

What is proxy method?

0 Answers  

---

How to find the date and time of last updated table?

4 Answers  

---

please explain.. DB architecture ...

0 Answers  

---

What is a oracle database?

0 Answers  

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---