Sunil Raja said:
> Ok, fine, I saw the oncon
>
> In general, if we do a particular transaction, in oracle, we would take
a
> snapshot before beginning of transaction and another snapshot after the
> transaction completes. now we generation the re****t ( using
statspack/AWR
> Re****t ), which tells the entire list of sql's, database parameters,....
> performance bottlenecks,....
It varies from version to version (in general, it gets more detailed with
each passing version.) It sounds a bit like you might be looking for
"onstat -g ses <session-id>". I'm not sure there's an exact match to what
you're looking for.
Can you describe the problem you're having?
> Is there anything a similar kind to check in INFORMIX, where a simple
> re****t
> can be generated to view all the details of a single transaction, so
that
> we
> can analyze the performance problem ?
>
> Please reply in detail, with example.
>
> With Regards,
> Sunil.
>
> On Fri, Jun 27, 2008 at 6:51 PM, Obnoxio The Clown
> <obnoxio@[EMAIL PROTECTED]
>
> wrote:
>
>>
>> Sunil Raja said:
>> > Its a very superb way of answering.
>> > Thanks for your immediate response.
>> >
>> > My Question : What are the list of tables, that related to DBA, to
>> tune
>> > the database ?
>> > Your Answer : $INFORMIXDIR/etc/onconfig
>>
>> Well, if you look at the file, you'll find a list of all the parameters
>> you can tune, by simply editing the file. However, it's very difficult
>> to
>> say HOW you should tune it. Are you experiencing a performance problem?
>>
>> (I've cc'ed the list back in, in case I get bored and bugger off to
>> drink
>> champagne.)
>>
>> > But still, I would like to have a detailed information on this. With
>> > Example, Please ...
>> >
>> > Thanks in Advance.
>> >
>> > With Regards,
>> > Sunil.
>> >
>> >
>> > On Fri, Jun 27, 2008 at 6:29 PM, Obnoxio The Clown
>> > <obnoxio@[EMAIL PROTECTED]
>
>> > wrote:
>> >
>> >>
>> >> raja said:
>> >> > Hi 2 All,
>> >> >
>> >> > I am new to INFORMIX database.
>> >> >
>> >> > I am using INFORMIX 9.4 database in HP-UX System.
>> >> >
>> >> > I have few questions, Please clarify those questions for me :
>> >> >
>> >> > 1. What is in INFORMIX, similar to sqlplus in ORACLE ( to view the
>> >> > schema details - tables, indexes,... ) ?
>> >>
>> >> See question 2.
>> >>
>> >> > 2. What is dbaccess in INFORMIX ?
>> >>
>> >> See question 1.
>> >>
>> >> > 3. How to execute a sql script file in INFORMIX ?
>> >>
>> >> See question 2.
>> >>
>> >> > 4. What are the list of tables, that related to DBA, to tune the
>> >> > database ?
>> >>
>> >> $INFORMIXDIR/etc/onconfig
>> >>
>> >> > 5. What are the tuning tools in INFORMIX ?
>> >>
>> >> See question 4.
>> >>
>> >> > 6. What is in INFORMIX, similar to statspack/AWR Re****t in ORACLE
?
>> >>
>> >> Pass. onstat, perhaps?
>> >>
>> >> > 7. What are the ways to tune a sql query in INFORMIX ?
>> >>
>> >> Optimiser directives.
>> >>
>> >> > 8. What are the ways to tune a procedure in INFORMIX ?
>> >>
>> >> Code it better.
>> >>
>> >> > I would be very much thankful, if you Please explain me these
>> >> > questions separately with Examples.
>> >> > If you have any do***ents or URL, Please send me them.
>> >>
>> >> http://www-306.ibm.com/software/data/informix/pubs/library/
>> >>
>> >> --
>> >> Bye now,
>> >> Obnoxio
>> >>
>> >> "There were a myriad of problems which conspired to corrupt your
>> reason
>> >> and rob you of your common sense. Fear got the best of you, and in
>> your
>> >> panic you turned to the Labour Party. They promised you order, they
>> >> promised you peace, and all they demanded in return was your silent,
>> >> obedient consent."
>> >>
>> >>
>> >>
>> >
>> >
>> >
>>
>>
>> --
>> Bye now,
>> Obnoxio
>>
>> "There were a myriad of problems which conspired to corrupt your reason
>> and rob you of your common sense. Fear got the best of you, and in your
>> panic you turned to the Labour Party. They promised you order, they
>> promised you peace, and all they demanded in return was your silent,
>> obedient consent."
>>
>>
>>
>
>
>
--
Bye now,
Obnoxio
"There were a myriad of problems which conspired to corrupt your reason
and rob you of your common sense. Fear got the best of you, and in your
panic you turned to the Labour Party. They promised you order, they
promised you peace, and all they demanded in return was your silent,
obedient consent."
|
