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)

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,

---

How to run create database statement?

0 Answers  

---

How to create a new table in your schema?

0 Answers  

---

What is merge in oracle?

0 Answers  

---

What happens to the current transaction if the session is killed?

0 Answers  

---

Explain what are the type of synonyms?

0 Answers  

---

How does oracle handle read consistency?

0 Answers  

---

What is STATSPACK tool?

3 Answers   Wipro,

---

wirte the syntax of update query?

3 Answers   IBM,

---

How to find out what oracle odbc drivers are installed?

0 Answers  

---

What is Database Buffers ?

1 Answers  

---

How to do clean up if create database failed?

0 Answers  

---