Home » Other » General » Static and Dynamic Analysis (Windows, Oracle 10g)
Static and Dynamic Analysis [message #450810] Fri, 09 April 2010 06:27 Go to next message
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 #450814 is a reply to message #450810] Fri, 09 April 2010 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What are "Static and Dynamic analysis of database"?

Regards
Michel
Re: Static and Dynamic Analysis [message #450818 is a reply to message #450810] Fri, 09 April 2010 07:00 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is this a Forms related question?
Re: Static and Dynamic Analysis [message #451020 is a reply to message #450818] Mon, 12 April 2010 02:27 Go to previous messageGo to next message
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 #451026 is a reply to message #451020] Mon, 12 April 2010 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Seems very specific to your environment and so you have to create your own tools.

Regards
Michel
Re: Static and Dynamic Analysis [message #451311 is a reply to message #451026] Tue, 13 April 2010 22:50 Go to previous message
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
Previous Topic: AMM in ORACLE 11g
Next Topic: New Puzzle topic: Vigenere Cipher
Goto Forum:
  


Current Time: Thu Mar 28 18:11:47 CDT 2024