Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how can you create a user-defined lock?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the different types of indexes available in sql server? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
what are the benefits of flashback feature?
What is fill factor? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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.
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is the diffrence between core dba and apps dba?
how can you communicate with operating system files from oracle?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
