Re: ADDM advices Oracle's application logic

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:

1. What commands did you issue when creating the tablespace(s) and associated datafile(s)?
2. 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