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 is oracle join syntax?

0 Answers  

---

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

What is a snapshot in oracle database?

0 Answers  

---

List out the components of logical database structure of oracle database.

0 Answers  

---

Is there a combination of "like" and "in" in sql?

0 Answers  

---

How to get the Installed Oracle Version Information ?

0 Answers   MCN Solutions,

---

what r routers?

1 Answers  

---

how to find count rows in table without count function?

3 Answers   Oracle,

---

How to best split csv strings in oracle 9i?

0 Answers  

---

Differnce between view and index

3 Answers  

---

How to use subqueries with the in operator using oracle?

0 Answers  

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

0 Answers  

---