Re: Help!!!!

From: Paul Drake <paled_at_home.com>
Date: Thu, 23 Aug 2001 16:12:24 GMT
Message-ID: <3B852B76.276B3BF5@home.com>

Al wrote:

> Hi,
> We have a SunUltra5 workstation with solaris2.6. It has 256MB of RAM and
> 1GB of swap has been allocated to the system.
> Recently we loaded oracle server version 7.3.4.
> With all the cost cutting around although we are using a licensed version,
> we cannot go for support. I'd be glad to have any of you help to let me know
> a few answers.
>
> The oracle seems to have occupied more memory. Cuz with no process running ,
> top command shows only 10MB free. Is there a way to tune it and make it
> perform better.
> The system is dead slow. Any ideas why?
> Please let me know of useful URLs which provide some info, if any.
>
> regards
> -Al

You can alter the memory setting (cycle the instance to take effect) by editing the init.ora file. (located in $oracle_base/admin/$db_name/pfile or %ORACLE_BASE%\admin\pfile\init.ora

from sqlplus, run the following query:

1 select rpad(name,30),rpad(value,40),trunc(to_number(value)/1024) KB 2 from v$parameter
3 where name like '%pool%'

  4      or name like '%buffer%'
  5     and name in

('shared_pool_size','large_pool_size','java_pool_size','log_buffer')   6 union
  7 select
rpad(vp1.name,30),rpad(vp1.value,40),trunc(to_number(vp1.value)*vp2.value/1024) KB
  8 from v$parameter vp1, v$parameter vp2   9 where vp1.name='db_block_buffers'
10* and vp2.name='db_block_size'
12:11:13 dev:drake> /

RPAD(NAME,30)                  RPAD(VALUE,40)

------------------------------ ----------------------------------------

buffer_pool_keep
buffer_pool_recycle
db_block_buffers 49152
393216

java_pool_size                 8388608
8192
large_pool_size                4194304
4096
log_buffer                     1048576
1024
shared_pool_reserved_size      5033164
4915
shared_pool_size               100663296

98304

8 rows selected.

hth,

Paul Received on Thu Aug 23 2001 - 11:12:24 CDT