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 export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

How can you enable a trace for a session?

1 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

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

0 Answers  

---

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  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

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

2 Answers  

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---