Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2012
    Posts
    4

    Question Unanswered: General Trace Query

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >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.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2012
    Posts
    4
    I mean seeing what SQL data change requets are being made by the Windows application when it's used, I think!

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >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?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2012
    Posts
    4
    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.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2012
    Posts
    4
    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!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •