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)

How to find the duplicate rows count from employees table in oracle?

0 Answers  

---

State any two functions of oracle?

0 Answers   Aricent,

---

is there a tool to trace queries, like profiler for sql server?

0 Answers  

---

Oracle

0 Answers   ABC, Genpact, HUI, Oracle,

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

0 Answers  

---

What is an Index Segment ?

2 Answers  

---

Which Department has MOST NUMBER of employees?

8 Answers   IBM, LeadSquared, Mastek,

---

How to export your connection information to a file?

0 Answers  

---

How to change program global area (pga) in oracle?

0 Answers  

---

What is a data segment ?

1 Answers  

---

candidate key is subset of super key but not vice-verse explain

0 Answers  

---

7. Repeat query (7) but also display all clients who have never ordered anything.

1 Answers   Wipro,

---