Hi,

I wondered if anyone guide offer me any guidance regarding a idea I have.

Within my job I support a proprietary Records Management system and I want to learn more about its database procedures and mechanisms than the user guidance offers.

I have access to the backend database and all its schemas, I have a copy of TOAD and also SQL Developer, I can see the various tables within it's many schemas etc but don't know the most efficient method for monitoring each change in data.

The Records Management system interface is a Windows application that is created in Visual Basic 6 I think, I also wondered if this could be monitored in terms of the transactions it's making.

Any help and guidance would be greatly appreciated and if there's any information needed to do so then please let me know

>don't know the most efficient method for monitoring each change in data.
solution may depend upon exactly what is meant by "monitoring".

One possible solution is to AUDIT some or all of the tables.

I mean seeing what SQL data change requets are being made by the Windows application when it's used, I think!

>I mean seeing what SQL data change requets are being made by the Windows application when it's used, I think!

who is doing the seeing?
See what changes exactly where?
seeing in real time or logging the changes for later viewing?
I hope no idea what would satisfy your vague description for what you think you want.
Who will implement the needed changes to satisfy your requirements?
Can you program in both SQL & PL/SQL languages?

Sorry for being vague as I really don't know where to start, this is why I'm asking.

To answer your questions:

I would be the one who needs to see what data changes are made.
The changes in the database tables.
Logging the changes would be useful so that I could see the steps/stages of the database changes.
I hoped there would be tools that might do this for me, such as db traces or a process monitor? What kind of changes would be required?
Unfortunately I am no expert in either PL/SQL or SQL, this is why I'm keen to learn.

Please excuse my ignorance and thanks for your patience and time.

data in any DB is changed by DML (INSERT, UPDATE & DELETE).
For me, watching data change would be like watching paint dry.
I don't understand what exactly you hope to accomplish.
Do you have access to the application source code that contains the DML?

Thanks,

My limited knowledge of SQL does extend to being able to use INSERT, UPDATE & DELETE statements, my goal is to establish

what statements are used
which tables the statements amend
the order in which these statements occur

I guess I'm jumping the gun as my knowledge of database architecture and concepts are no where near the level of database used by the application, which is why I sound clueless and vague.

I do not have access to the source code of the application and it's difficult to fully explain the aim and reasons etc.

Thanks anyway!