English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (422)
PLSQL (1)
PMI (4)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Oracle 8i: Performance Tuning 

АвторSubject: Q78
written 18 October 2007 15:13   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
The CURSOR_SPACE_FOR_TIME init.ora parameter influences library cache activity. When a user needs to parse and execute a SQL statement, Oracle may eliminate an existing SQL execution plan from the library cache to make room for the new one if CURSOR_SPACE_FOR_TIME is set to FALSE, the default. However, the problem here is that another process may need the execution plan to be eliminated to make room. If you set CURSOR_SPACE_FOR_TIME to TRUE, Oracle will not eliminate a parsed execution plan from the library cache until all open cursor user processes and applications using the execution plan have been closed. Library cache performance can be improved by setting CURSOR_SPACE_FOR_TIME to TRUE. However, you must be careful only to do so when your library-cache hit ratio is 100 %. If an execution miss occurs on your database when this parameter is set to TRUE and all execution plans in the library cache are associated with open cursors, your users will receive errors saying there is not enough shared memory in your database.
Incorrect Answers:

1: The TIMED_STATISTICS parameter does not relate with CURSOR_SPACE_FOR_TIME parameter.
2: The hit percentage in the library cache must be 100 %, it is not related with percentage in the buffer cache. C: There is no restriction on OPEN_CURSORS parameter for CURSOR_SPACE_FOR_TIME parameter value setting to TRUE.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 851. Chapter 18: Tuning Memory and Operating System Use

Current tread:
back to list

Q78 - Go to question 15:13 18.10.07

back to list
Up ^ gen. 0.061 Server date 07:13 08-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments