Re: Help with a command

nujcharee_at_googlemail.com wrote in news:9c8fc657-2124-45fc-b755-6e0ce32e3ed8 @d50g2000hsf.googlegroups.com:

> I have this web based application which hosted on a oracle database.
> Being an old legacy system, I have no documentation about this
> application / database e.g data dictionary etc...
> My approach is that I want to add a new value via the web application
> and look to see where the entered value appear in which table on the
> database.
> Obviously in reality I will need to view all tables hoping to find the
> value I enter and it could take a life time to do this.
> Is there any command I can use to acheive this? Say a command that I
> can use that give me a list of tables with most updated?
>
> Many thanks

You can look in V$SQLAREA for the first 1000 bytes of any SQL in cache. This also has FIRST_LOAD_TIME time so you might be able to find the exact code fairly easily. UNLESS ...

Unless you are just a programmer and not the DBA. Only users with DBA priviliges usually have access to the SYS views.

Unless the application was written using bind variables in which case SQL statements are re-used and FIRST_LOAD_TIME might be sometime last week. Unless you are using Oracle10g which also has LAST_LOAD_TIME.

HTH Andy Young Received on Sun Nov 18 2007 - 23:39:27 CST