Re: ADDM advices Oracle's application logic
Date: Wed, 16 Jan 2008 08:30:33 -0800 (PST)
Message-ID: <6df476e0-6515-4755-b59c-46011afed2dc@x69g2000hsx.googlegroups.com>
On Jan 16, 9:37 am, Helma <helma.vi..._at_hotmail.com> wrote:
> Hello *,
>
> I'm new to performance tuning and linux , so any pointers to speed up
> my investigation is much appreciated.
>
> I've just installed a 10.2.0.3 on a 64bit Linux AS. I created a few
> TBS, with datafiles of 16GB each. The first file took about 3 minutes,
> the last file took about 1 hour to create. My experience on other
> machines is just a few minutes.
> I'm looking at the ADDM advice:
>
> "Individual database segments responsible for significant user I/O
> wait were found."
>
> Investigate application logic involving I/O on database object with id
> 440.
> Database ObjectSYS.I_RLS2
>
> where I_RLS2 is:
>
> Name I_RLS2
> Schema SYS
> Tablespace SYSTEM
> Index Type Normal
> Status VALID
>
> Has anyone an idea what happened or where to look? What other elements
> are needed for a proper diagnoses? Again, i am alone on the machine,
> not other processes, users etc. Physical writing was the paramount i/o
> activity, as expected.
>
> Thanks!
Hello,
Two questions:
- What commands did you issue when creating the tablespace(s) and associated datafile(s)?
- Do the datafiles need to be 16G in size due to given requirements?
Regards,
Arun
Received on Wed Jan 16 2008 - 10:30:33 CST