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)

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 Answers  

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

---

What are the components of logical database structure in oracle database?

0 Answers  

---

how to get second highest sal of emp table

6 Answers  

---

Explain rename?

0 Answers  

---

What are the uses of a database trigger?

0 Answers  

---

What is the purpose of save points in oracle database?

0 Answers  

---

What is difference between cartesian join and cross join?

0 Answers  

---

What are the differences between lov and list item?

0 Answers  

---

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

0 Answers   EDC,

---

Explain the features of oracle?

0 Answers  

---