Answer / chandra mohan

LIBRARY CACHE,DATA DICTIONARY CACHE

Answer / sweta

Hi,
in shared pool 2 memory layers are there,
they are,
library cache(to get the recentrly executed sql and pl/sql
statements) and data dictionary cache(to store the sql and
plsql statements and execution path of sql/plsql statemens
i.e explain paln of it) cursor sharing information etc.

Answer / narmada kumari

1/3 of physical memory, can be 2/4k depending on bit of 32 or 64

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

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

0 Answers  

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

What purpose does the model database server? : sql server DBA

0 Answers  

---