Re: Is OEM complete?

Hello Karen!

I think that the configuration of the PCTFREE, PCTUSED and other parameters are very interesting for
a DBA! These paremeters are very important for a good performace of a Oracle database!. However, I am not able to know the exact space which is used by a Oracle block. This information can?t be got in dictionary tables. Therefore, I am thinking of making a graphical tool which shows the average of Oracle block space. I mean,
I would make a graphical tool which shows average space block used in any segment.
My question is: This tool will be useful? This information is not showed by OEM and I think
that it ?s very important to choice the PCTFREE and PCTUSED parameters!

I forgot your question.....I ?d make this tool in Java language!

What is your opinion?

"Karen Abgarian" <abvk_at_ureach.com> escribio en el mensaje news:3D59FF86.88D8C9CA_at_ureach.com...
>
> There is plenty of tools in the market. I do not believe though that any
of
> them shows usage in oracle blocks. I doubt that in DBA practice they look
> at specific blocks often. Say, a block is not complete, so what?
However,
> imagining such a tool, it could probably look nice, so why not go ahead
and
> implement it, given that this is an education project?
>
> But, just out of curiosity, how are you going to implement a such a tool?
>
>
>
> Alberto Garzas wrote:
>
> > Hi group !
> >
> > Could I ask you some questions?
> >
> > I have to do my final proyect to my computer science degree and it
must be
> > focused on Oracle 9i , OEM and
> > physical structures storage (blocks, segments, tablespaces....)
> >
> > I think that OEM is not complete. I need to make a graphical usefull
tool
> > which can help to complete OEM tool.
> >
> > I think that I should make a tool which shows the
> > Oracle block states(parameters) of all segment in my database. For
example,
> > PCTUSED,PCTFREE, space used in any block......
> >
> > Could you tell me your opinion about the graphical tool which I am
going to
> > make? Do you think that tool
> > will be useful?
> >
> > Could you tell me other graphical tool which I could make which will be
more
> > useful ?
> >
> > Thank you very much!
>
Received on Thu Aug 15 2002 - 12:27:47 CDT