Sunil Raja said:
> Actually, The problem here is :
>
> An *INFORMIX *database is given to me, I have to do *performance
tuning*,
> by
> checking the performance bottlenecks in sql or procedure or ....
> So, I am looking for steps to proceed and find something for performance
> tuning of the INFORMIX Database.
My approach has always been: if the users ain't moaning, there isn't a
performance problem.
So, let's start with: are your users moaning? If so, what are they moaning
about?
> In *ORACLE*, for performance tuning, *STATSPACK/AWR* re****ts will be
used
> to
> generate re****ts between the 2 *snapshot id's*, so that the re****t
> explains
> all the database parameter settings, which sql is taking more buffer,
cpu
> time, .... the entire list will come in a single re****t.
> For particular *sql,* we can use *EXPLAIN PLAN*, to see the response
> time,...
> For particular plsql ( *procedure* ), we can use *DBMS_PROFILE* package,
> to
> see the response time...
> To *gather statistics*, we can use *DBMS_STATS* package
>
> Now, I am looking for *similar kind of the above stuffs in INFORMIX*.
> I want such kind of *tools or utilities or scripts*, that could give me
> the
The problem is that you wouldn't approach tuning IDS in the same way.
> information of the with examples :
> 1. Entire Schema. ?
dbschema --
> 2. Way to tune a particular SQL Query ?
Tune it how? Generally, you'd be more likely to look at indexing it. I
don't know how you would tune it, really.
> 3. Way to tune a particular Procedure ?
See above.
> 4. View the Database Parameters ( to tune them ) ?
vi $INFORMIXDIR/etc/onconfig
> 5. List of indexes, ..... in each tables or columns ?
dbschema will tell you, or you can look it up in dbaccess interactively.
> 6. Take snapshot for a particular transaction and find the re****t (
> similar
> to statspack/awr in oracle ) ?
onstat -g ses <session-id>
> 7. How to gather schema statistics, how to check whether the statistics
> are
> collected ?
Use the "UPDATE STATISTICS" SQL command.
> 8. How to run the scripts ?
> .
> .
>
>
> So that it would be helpful to find the performance bottlenecks and
hence
> tune the INFORMIX database...
>
> Please guide me to proceed further.
Tell me whether you are even having a problem. There are so many ways to
find performance bottlenecks that I wouldn't know where to start.
Let's try something simple: run the command "onstat -p" and post the
output here.
--
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."
|
