s*******e
发帖数: 151 | 1 My friend had a DBA interivew question to ask me, but I do not know how to
help her.
An 8.0.6 database is being hit very hard with transactions that do not utilize
bind variables. The shared pool is set to 300MB. Intermittently, users are
unable to connect to the database. What specific actions would you take in
this situation?
Does sb know the answer? thanks a lot! |
c*****d
发帖数: 6045 | 2 不知道这道题目想考那方面的知识？
1. increase the shared_pool_size
2. modify cursor_sharing
3. query v$session and v$process
4. restart db
utilize
【在 s*******e 的大作中提到】
: My friend had a DBA interivew question to ask me, but I do not know how to
: help her.
: An 8.0.6 database is being hit very hard with transactions that do not utilize
: bind variables. The shared pool is set to 300MB. Intermittently, users are
: unable to connect to the database. What specific actions would you take in
: this situation?
: Does sb know the answer? thanks a lot!
|
s*******e
发帖数: 151 | 3 我也不知道。 应该是和bind variables有关吧。 我就没有用过oracle8, 所以 想问这里
高人的意见。
are
in
【在 c*****d 的大作中提到】
: 不知道这道题目想考那方面的知识？
: 1. increase the shared_pool_size
: 2. modify cursor_sharing
: 3. query v$session and v$process
: 4. restart db
:
: utilize
|
s*****c
发帖数: 24 | 4 Cursor sharing should be the key.
1st: verify the shared pool memory usage: most used by cursors
2nd: set cursor_sharing to force
3rd: restart the database or (alter system set and flush shared pool)
The purpose to use force is that the optimzer will the following cursors
SELECT * FROM user_names WHERE name='Jeff' AND county = 'Butler';
SELECT * FROM user_names WHERE name='Melody' AND county = 'Butler';
as one cursor with system generated bind variables:
SELECT * FROM user_names WHERE name=:SY
【在 s*******e 的大作中提到】
: 我也不知道。 应该是和bind variables有关吧。 我就没有用过oracle8, 所以 想问这里
: 高人的意见。
:
: are
: in
|
s*******e
发帖数: 151 | 5 yes, I am quite sure the database is 8.0.6. anyway, thanks a lot for your
answer.
这
how
users
take
【在 s*****c 的大作中提到】
: Cursor sharing should be the key.
: 1st: verify the shared pool memory usage: most used by cursors
: 2nd: set cursor_sharing to force
: 3rd: restart the database or (alter system set and flush shared pool)
: The purpose to use force is that the optimzer will the following cursors
: SELECT * FROM user_names WHERE name='Jeff' AND county = 'Butler';
: SELECT * FROM user_names WHERE name='Melody' AND county = 'Butler';
: as one cursor with system generated bind variables:
: SELECT * FROM user_names WHERE name=:SY
|
