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)

Explain do view contain data?

0 Answers  

---

Why does for update in oracle 8 cause an ora-01002 error?

0 Answers  

---

What happens if the update subquery returns multiple rows?

0 Answers  

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

0 Answers   Infosys,

---

which statement is running fastly ie insert or delete?

13 Answers   Oracle,

---

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

0 Answers   GTL,

---

WHT ARE THE AGGREATE FUNCTIONS?

7 Answers   GEITC, TCS,

---

What is a view and how is it different from a table?

0 Answers  

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

0 Answers   TCS,

---

How to create a table index?

0 Answers  

---

What is meant by redo log buffer ?

2 Answers  

---

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

---