Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: resize datafile contention

Re: resize datafile contention

From: Matthias Hoys <anti_at_spam.com>
Date: Fri, 19 Oct 2007 20:30:00 +0200
Message-ID: <4718f7a5$0$22307$ba620e4c@news.skynet.be>

"Ben" <balvey_at_comcast.net> wrote in message news:1192804055.551914.8650_at_v23g2000prn.googlegroups.com...

> On Oct 17, 11:32 am, "Matthias Hoys" <a..._at_spam.com> wrote:

>> "Ben" <bal..._at_comcast.net> wrote in message
>>
>> news:1192626226.070101.126320_at_i13g2000prf.googlegroups.com...
>>
>>
>>
>>
>>
>> > On Oct 16, 8:59 am, "Matthias Hoys" <a..._at_spam.com> wrote:
>> >> "Ben" <bal..._at_comcast.net> wrote in message
>>
>> >>news:1192533656.222392.21310_at_y27g2000pre.googlegroups.com...
>>
>> >> > On Oct 16, 4:06 am, csn..._at_gmail.com wrote:
>> >> >> To the OP, yes it does sound like fet$/uet$ contention, and there
>> >> >> is
>> >> >> nothing you can do except be patient and wait, in the knowledge
>> >> >> that
>> >> >> you are getting rid of the problem, slowly but surely as you move
>> >> >> to
>> >> >> LMT.
>>
>> >> > well, it only took about 2.5 hours to drop the tablespace. Then
>> >> > guess
>> >> > what, the OS still doesn't see the space. great.
>>
>> >> I think you have the stop the database instance and unmount/mount the
>> >> filesystem ... What's the filesystem type ? Jfs or jfs2 ?
>>
>> >> Matthias
>>
>> > It is jfs.
>>
>> I had the same problem with jfs, but not with jfs2 ... Anyway it's not a
>> good idea to use the "older" jfs filesystem type on AIX 5L, jfs2 has so
>> many
>> advantages ... Blame the sysadmin :-)- Hide quoted text -
>>
>> - Show quoted text -
>
> So the sysadmin is talking about creating some new filesystems with
> jfs2. I'm not so sure it is a good idea to mix jfs and jfs2
> filesystems on the same database though. I'm now trying to do some
> research on mixing the two to see if it will even work.
>

I wouldn't do it. You could keep jfs for non-Oracle stuff like /home etc. But I would put all the Oracle related files (datafiles, redo logs, controlfiles) on jfs2. Maybe you can directly upgrade a jfs filesystem to jfs2, I don't know that much about AIX administration.

Matthias Received on Fri Oct 19 2007 - 13:30:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US