OraFAQ Forum: Server Administration » PGA Aggregate Target File Location

Home » RDBMS Server » Server Administration » PGA Aggregate Target File Location (9.2.0.5 Sun O.S 5.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PGA Aggregate Target File Location [message #276313]

Wed, 24 October 2007 15:27

faiz_hyd
Messages: 294
Registered: February 2006

Senior Member

Hi,

This is the message from my trace file in my Alert log file,
and couple of times i have to restart the DB,it's a small Local Development Database, i asked other colleage he said to increased the PGA size and check TEMP tablespace, temp TS is ok, and where can i change the PGA aggregate parameter.
in a week 2 times this DB get's down and i have to restart,
[code]/u01/app/oracle/admin/neor1l1/bdump/neor1l1_dbw0_5038.trc
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME = /u01/app/oracle/product/9.2.0
System name: SunOS
Node name: loisd
Release: 5.7
Version: Generic_106541-16
Machine: sun4u
Instance name: neor1l1
Redo thread mounted by this instance: 1
Oracle process number: 3
Unix process pid: 5038, image: oracle@loisd (DBW0)

*** 2007-10-24 09:39:09.649
*** SESSION ID:(2.1) 2007-10-24 09:39:09.566
KCF: write/open error block=0x1d49 online=1
file=55 /u01/app/oracle/oradata/neor1l1/misc_data_01.dbf
error=27063 txt: 'SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192'
error 1242 detected in background process
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 55 (block # 7497)
ORA-01110: data file 55: '/u01/app/oracle/oradata/neor1l1/misc_data_01.dbf'
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
[code]
PGA currently is 24 MB.
Where can i change the PGA size on the box.
and what else you people think this problem could be.

Thanks

Report message to a moderator

Re: PGA Aggregate Target File Location [message #276314 is a reply to message #276313]

Wed, 24 October 2007 15:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

error=27063 txt: 'SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192'
error 1242 detected in background process
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
========================================================
you have a failing disk drive.
Confirm by looking the /var/log/messages file
or using
dmesg

Report message to a moderator

Re: PGA Aggregate Target File Location [message #276397 is a reply to message #276313]

Thu, 25 October 2007 01:47

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

he said to increased the PGA size and check TEMP tablespace, temp TS is ok, and where can i change the PGA aggregate parameter.

He said false. However you can see pga_aggregate_target in initialization parameter as well as

show parameter pga_aggregate;

Report message to a moderator

Re: PGA Aggregate Target File Location [message #276580 is a reply to message #276397]

Thu, 25 October 2007 09:45

faiz_hyd
Messages: 294
Registered: February 2006

Senior Member

Thanks For follow up,

Arju i was able to see the parameter value and said earlier it is 24 MB,do you mean to say that we shouldn't increase PGA or ?

Thanks

Report message to a moderator

Re: PGA Aggregate Target File Location [message #276587 is a reply to message #276580]

Thu, 25 October 2007 10:05

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

You are getting I/O errors

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 55 (block # 7497)

still why you want to play with PGA only. I think.. first.. you should work for resolving the corrupt files.

As for PGA... as Arju said.. & you confirmed.. set it in init.ora file or in spfile.

--Girish

Report message to a moderator

Previous Topic:	How to increase dba_free_space
Next Topic:	Checking Remote database is up or not

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 04:38:06 CST 2024