SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
some question about obout

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
some question about obout
Author Message
oracle



Joined: 30 Jan 2002
Posts: 2

Post some question about obout Reply with quote

hello, there are some question

1¡¢I have learned the DB Tools 4 for oracle , but I want to know how it read the oralce log file . usually, the format of log file is secret and not open.

2¡¢The audit for data change is implemented by what method, read log file or monitor the database activity ?

3¡¢Have some performance effects on database server when you install the DB tools to audit the data change ?

thanks



Wed Jan 30, 2002 4:50 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: some question about obout Reply with quote

: hello, there are some question

: 1¡¢I have learned the DB Tools 4 for oracle , but I want to know how it read
: the oralce log file . usually, the format of log file is secret and not
: open.

Which log file do you mean? If you mean Redo Logs, DB Tools doesn't read them directly, it reads data from the system tables. If you mean the alert logs and trace files, these files are plain text files

: 2¡¢The audit for data change is implemented by what method, read log file or
: monitor the database activity ?

Triggers on monitored tables

: 3¡¢Have some performance effects on database server when you install the DB
: tools to audit the data change ?

This depends on the transaction rate and volume (inserts/deletes/updates). It also depends on configuration/tuning state of your server. In general, the impact should be very minimal to unnoticed. As an advice, do not audit tables with high transaction rate, because any aduting method will cause some performance hit.

: thanks

Wed Jan 30, 2002 7:36 am View user's profile Send private message
oracle



Joined: 30 Jan 2002
Posts: 2

Post Re: some question about obout Reply with quote


thanks for your answers

of course ,I mean to the redo log and archive log . I think, Triggers on monitored tables must have effect on proformance of database server.

This is a sample , I wish that you can help me to decide what i can do, including which component of dbtools I can choose.

A securities company, at least 50 transactions in every second. we want to monitor the customers that their exchange volume exceed $10000 in one transaction. above all ,we can't reduce the proformance of db server. what can I do ?

thans very much

Sun Feb 03, 2002 10:37 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: some question about obout Reply with quote

There is no other way as to use triggers. You can alter these triggers after their are created and add $10000 condition so only large volume transactions are "audited", in other words logged. If there are not very many transactions exceeding that volume then the performance should not degrade significantly.

On other hand, if you have access to the code of your trading applications you can add logging of large transactions to the logic of these applications.

: thanks for your answers

: of course ,I mean to the redo log and archive log . I think, Triggers on
: monitored tables must have effect on proformance of database server.

: This is a sample , I wish that you can help me to decide what i can do,
: including which component of dbtools I can choose.

: A securities company, at least 50 transactions in every second. we want to
: monitor the customers that their exchange volume exceed $10000 in one
: transaction. above all ,we can't reduce the proformance of db server. what
: can I do ?

: thans very much

Sun Feb 03, 2002 11:10 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.