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)

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers  

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

0 Answers   Cisco,

---

when i run my query on yesterday it is fast but today it is slow why?

1 Answers  

---

How do I find the database name in oracle?

0 Answers  

---

What is E-R diagram ?

2 Answers   CGI, Keane India Ltd,

---

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

---

How to declare a local variable?

0 Answers  

---

what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,

---

How to get a list of all tables in the database?

1 Answers  

---

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

0 Answers  

---

What is a schema in oracle?

0 Answers  

---

How to convert characters to dates in oracle?

0 Answers  

---