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)

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  

---

What is a select query statement in oracle?

1 Answers  

---

How to define an anonymous block?

1 Answers  

---

What is the dynamic sql in oracle?

1 Answers  

---

what is cartesian product?

2 Answers  

---

What is a SNAPSHOT ?

1 Answers  

---

How to define a data field as not null?

1 Answers  

---

What would you do if a database crashes in production?

1 Answers  

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

what is a Nested Loop join?

1 Answers  

---

What is a cluster Key ?

2 Answers  

---

What is an oracle user account?

1 Answers  

---