Answer Posted / rajesh naidu

SELECT TABLESPACE_NAME,SUM(BYTES/1024/1024) FROM
DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;

AND THE VIEW IS DESC DBA_FREE_SPACE;

what is asm?

1116

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1962

---

how can a session indicate its interest in receiving alerts?

1095

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1369

---

what do you understand by flashback feature of oracle?

1046

---

What are statistics, under what circumstances they go out of date, how do you update them?

2312

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2094

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1184

---

What happens on checkpoint? : sql server DBA

1143

---

Query processing is slow(eg select query)how will u solve that

8047

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2494

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2499

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1036

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2610

---

Why would you use sql agent? : sql server DBA

1132

---