Answer / mahesh

GV$ view is a global view of v$. GV$ view contains on extra
column called Inst_ID which indicates the instance ID of
ordered query. This ID is useful for session tracking.

Answer / shrinidhi

The INST_ID column which indicates the instance in a RAC environment the information came from.

Answer / krishna

GV$ view is a global view of v$. GV$ view contains on extra
column called Inst_ID which indicates the instance ID of
ordered query. This ID is useful for session tracking.

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

what is a user-defined lock?

1 Answers   Oracle,

---

Give two examples of referential integrity constraints.

2 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

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

1 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

Why does Oracle not permit the use of PCTUSED with indexes?

1 Answers  

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1 Answers   IBM,

---

How would you go about verifying the network name that the local_listener is currently using?

1 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---