Very Computer

by **Anders Won** » Thu, 17 Oct 2002 11:04:32

Hi there,

Recently, our Database and OAS seems not as stable as usual. When
users access our OAS webpage, sometimes they got "REQUEST FAILED". However,
there has no problem with the PL/SQL in OAS, when they retried few click of
"refresh" through the browser. The page is working again. One of my senior
has check the loading through Oracle Enterprise Manager. The processes seems
ok. We couldn't find the problem (may be this is the bugs from Oracle 8.05
and OAS 3.0) at all.

Steps we have done in the parameter file

1. Increased the db_block_buffers = 550
2. Increased the processes = 100

Anything we can do...?

If anyone of you has encountered this problem, pls point me some hints.
Thank You in Advance.

Best Regards,
Anders

by **Sybrand Bakke** » Sat, 19 Oct 2002 02:00:09

On Wed, 16 Oct 2002 10:04:32 +0800, "Anders Wong"

>Hi there,

> Recently, our Database and OAS seems not as stable as usual. When
>users access our OAS webpage, sometimes they got "REQUEST FAILED". However,
>there has no problem with the PL/SQL in OAS, when they retried few click of
>"refresh" through the browser. The page is working again. One of my senior
>has check the loading through Oracle Enterprise Manager. The processes seems
>ok. We couldn't find the problem (may be this is the bugs from Oracle 8.05
>and OAS 3.0) at all.

>Steps we have done in the parameter file

>1. Increased the db_block_buffers = 550
>2. Increased the processes = 100

>Anything we can do...?

>If anyone of you has encountered this problem, pls point me some hints.
>Thank You in Advance.

>Best Regards,
>Anders

db_block_buffers= 550? Are you serious? Which block size?
My default buffer is at least 40M, so 40000/db_block_buffers would
make a factor 10 more.
Also: you are aware you are running fully on desupported software?

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

by **Svend Jense** » Sat, 19 Oct 2002 05:41:29

Isolate the problem, is it OAS or 805.
Check if there are *causualties* in 805 by query on v$system_event,
drill down to v$session_event and v$session_wait. If none - go for OAS error

/svend

> Hi there,

> Recently, our Database and OAS seems not as stable as usual. When
> users access our OAS webpage, sometimes they got "REQUEST FAILED". However,
> there has no problem with the PL/SQL in OAS, when they retried few click of
> "refresh" through the browser. The page is working again. One of my senior
> has check the loading through Oracle Enterprise Manager. The processes seems
> ok. We couldn't find the problem (may be this is the bugs from Oracle 8.05
> and OAS 3.0) at all.

> Steps we have done in the parameter file

> 1. Increased the db_block_buffers = 550
> 2. Increased the processes = 100

> Anything we can do...?

> If anyone of you has encountered this problem, pls point me some hints.
> Thank You in Advance.

> Best Regards,
> Anders

Very Computer

Need DBA help with Oracle 8.0.5 and OAS 3.0

Need DBA help with Oracle 8.0.5 and OAS 3.0

Need DBA help with Oracle 8.0.5 and OAS 3.0

Need DBA help with Oracle 8.0.5 and OAS 3.0