Interested to Buy Any Domain ? << Click Here >> for more details...
How many memory layers are in the shared pool?
- 3 Answers
- 7571 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / narmada kumari
1/3 of physical memory, can be 2/4k depending on bit of 32 or 64
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the recommended interval at which to run statspack snapshots, and why?
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.
how can you enable flashback feature?
What are the different sql server versions you have worked on? : sql server DBA
what do you understand by fine-grained auditing?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What are the different ways of moving data or databases between servers and databases in SQL Server?
How can we know the exact updation date of a particular database?
What the different components in replication and what is their use? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
what is the role of dip user in our database?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
