| Static and Dynamic Analysis [message #450810] |
Fri, 09 April 2010 06:27  |
lokimisc
Messages: 101
Registered: February 2008
|
Senior Member |
|
|
Hi,
I have to do Static and Dynamic analysis of existing huge Database. So I would like to know
1. What and all involved in Static and Dynamic Analysis of Database?
2. Are there any tools that can be used to automate Static and Dynamic analysis ?
regards,
Lokesh
|
|
|
|
|
|
|
|
| Re: Static and Dynamic Analysis [message #451020 is a reply to message #450818] |
Mon, 12 April 2010 02:27  |
lokimisc
Messages: 101
Registered: February 2008
|
Senior Member |
|
|
I am Sorry this is not Oracle forms related query, its my mistake to post a query in this forum.
Static analysis: To detect and correct defects in Database code, DB design, naming Convention, Standard of coding and hence improve the performance of database.
Dynamic analysis: This is done by actually running the code / application
regards,
Lokesh
|
|
|
|
|
|
| Re: Static and Dynamic Analysis [message #451311 is a reply to message #451026] |
Tue, 13 April 2010 22:50 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Based on this definition, I would say that tools such as Quest's SQL Navigator perform Static analysis; they look for common bad practices in PL/SQL code and report them as warnings during a compile.
DBMS_MVIEW.EXLAIN_MVIEW could be also be defined as
Static.
Things like Oracle's SQL Tuning Adviser and StatsPack might fit the definition of Dynamic.
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
