Test tools

[cc]

Hi,
I´m working on one enterprise who work whith Oracle DB, they use lots
of versions. They wont mi to study metodologys to plan and execute
software tests, for example when they run a new script. I´m like to
now if someone could help mi, about that. I need information about
tools (if there some), about others enterprises who work wiht the same
tecnology, Cases Studys and metodology that can be used whith Oracle
to execute tests.

Tanks

[Rolf Unger]

ei99030@fe.up.pt (cc) wrote in message news:<d089995f.0403110243.7f0032b7@posting.google.com>... Hi, I´m working on one enterprise who work whith Oracle DB, they use lots of versions. They wont mi to study metodologys to plan and execute software tests, for example when they run a new script. I´m like to now if someone could help mi, about that. I need information about tools (if there some), about others enterprises who work wiht the same tecnology, Cases Studys and metodology that can be used whith Oracle to execute tests. Tanks

Hm, what do you mean if you mention "software tests" and "new scripts"?
Do you mean performance behaviour? Or do you want to test the logic of
a script?

For performance issue you can simply do a

SET TIMING ON

in sqlplus and you will get the execution time of your sql statements
in milliseconds (or some other units). The exact value probably won't
matter, as long as you see that it increases or decreases significantly
if you make changes in your statements.

Alternatively verify the execution plan of your queries.
Sorry, I'm not too deep into "execution plans", but if you google for
this topic in the oracle groups -- comp.database.oracle.server is
probably the best starting point -- you should find lots of hints.

If you want to cope with logic errors, the general rules of good
programming apply also to SQL:

* Use comments! You are forced to explicetly formulate what you
want to achieve.
* Do not cut'n'paste code!
"Cut'n'Paste is chewing gum for the mind!"
* Discuss your implementation with a fellow.
Usually you will learn to see the problem from a different point
of view.

Hth, Rolf.

[cc]

rolf.unger@ctilabs.de (Rolf Unger) wrote in message news:<32fe19ad.0403121304.743458f3@posting.google.com>... ei99030@fe.up.pt (cc) wrote in message news:<d089995f.0403110243.7f0032b7@posting.google.com>... Hi, I´m working on one enterprise who work whith Oracle DB, they use lots of versions. They wont mi to study metodologys to plan and execute software tests, for example when they run a new script. I´m like to now if someone could help mi, about that. I need information about tools (if there some), about others enterprises who work wiht the same tecnology, Cases Studys and metodology that can be used whith Oracle to execute tests. Tanks Hm, what do you mean if you mention "software tests" and "new scripts"? Do you mean performance behaviour? Or do you want to test the logic of a script? For performance issue you can simply do a SET TIMING ON in sqlplus and you will get the execution time of your sql statements in milliseconds (or some other units). The exact value probably won't matter, as long as you see that it increases or decreases significantly if you make changes in your statements. Alternatively verify the execution plan of your queries. Sorry, I'm not too deep into "execution plans", but if you google for this topic in the oracle groups -- comp.database.oracle.server is probably the best starting point -- you should find lots of hints. If you want to cope with logic errors, the general rules of good programming apply also to SQL: * Use comments! You are forced to explicetly formulate what you want to achieve. * Do not cut'n'paste code! "Cut'n'Paste is chewing gum for the mind!" * Discuss your implementation with a fellow. Usually you will learn to see the problem from a different point of view. Hth, Rolf.



Hi,
tanks for the response.
What I wont to test is the logic. Something like white-box test! But I
also like to check for the results os the new script, in this time is
something like Black-box tests. I dont now if existe tools for this
caind of thing whith SQL. I´m starting working with this now.

Tks again

Carlos