Home » RDBMS Server » Server Administration » PGA Aggregate Target File Location (9.2.0.5 Sun O.S 5.7)
PGA Aggregate Target File Location [message #276313] Wed, 24 October 2007 15:27 Go to next message
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

Re: PGA Aggregate Target File Location [message #276314 is a reply to message #276313] Wed, 24 October 2007 15:36 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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
Re: PGA Aggregate Target File Location [message #276397 is a reply to message #276313] Thu, 25 October 2007 01:47 Go to previous messageGo to next message
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;
Re: PGA Aggregate Target File Location [message #276580 is a reply to message #276397] Thu, 25 October 2007 09:45 Go to previous messageGo to next message
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
Re: PGA Aggregate Target File Location [message #276587 is a reply to message #276580] Thu, 25 October 2007 10:05 Go to previous message
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
Previous Topic: How to increase dba_free_space
Next Topic: Checking Remote database is up or not
Goto Forum:
  


Current Time: Sat Dec 03 03:39:19 CST 2016

Total time taken to generate the page: 0.14233 seconds