- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to monitor data manipulation in Oracle 9i
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-06-2003 04:11 AM
тАО03-06-2003 04:11 AM
How to monitor data manipulation in Oracle 9i
We want to monitor who and when had changed some data of our database.
Anyone knows any dba tables or views that could help us?
We use to work with several Oracle clients and want to know who had manipulated data stored in a central database.
Thanks in advanced.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-06-2003 04:17 AM
тАО03-06-2003 04:17 AM
Re: How to monitor data manipulation in Oracle 9i
look Through
http://web.singnet.com.sg/~petermag/oracle.html
http://www.orafaq.com/faq.htm
A question here will help you more
Steve Steel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-06-2003 04:53 AM
тАО03-06-2003 04:53 AM
Re: How to monitor data manipulation in Oracle 9i
you may wish to have a look at Workspace Manager which enables applications to version database rows, and isolate collections of row versions using workspaces. It requires no changes to application SQL (DML), and is easily managed from Oracle Enterprise Manager. Workspace Manager provides a rich concurrency and security model for long duration transactions. It has a complete set of workspace semantics and efficient storage of versioned data.
A summary of other benefits that it gives:
- See changes made in a workspace in the context of the entire database and as of any point in time or milestone.
- Allow multiple versions of the data to exist in the same table instead of copying and synchronizing multiple copies of the table.
- Free developers from writing custom code and DBAs from adding application specific metadata to track versions of table data.
- Manage access to row versions across all applications
hth
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-06-2003 05:10 AM
тАО03-06-2003 05:10 AM
Re: How to monitor data manipulation in Oracle 9i
That's why application developers should incorporate change control logs. Something we always did when I was a developer for a Banking Software firm. Of course another reason why users should NEVER have direct SQL update/insert capibilities at an SQL prompt and why they shouldn't have shell prompt access!
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-06-2003 03:53 PM
тАО03-06-2003 03:53 PM
Re: How to monitor data manipulation in Oracle 9i
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-06-2003 11:04 PM
тАО03-06-2003 11:04 PM
Re: How to monitor data manipulation in Oracle 9i
This will add overhead for your transaction processing, but if you feel it is necessary to monitor then it had to be done.
On the other hand if there are only few tables then you can write scripts to monitor the user sessions and e-mail to you when the table data is changed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-07-2003 06:21 AM
тАО03-07-2003 06:21 AM