面试问题，关于oracle 8i - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

面试问题，关于oracle 8i

面试问题，关于oracle 8i# Database - 数据库

s*e2004-11-08 08:11

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*d2004-11-08 08:11

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*e2004-11-08 08:11

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*c2004-11-08 08:11

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*e2004-11-08 08:11

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