- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to view the Oracle sql history
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
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
тАО06-30-2009 09:03 AM
тАО06-30-2009 09:03 AM
select * from v$sqlarea;
but how about to see the history command run filtered by user ?
many thanks!!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2009 09:15 AM
тАО06-30-2009 09:15 AM
SolutionIts been a while
desc v$sqlarea
If there is a user field.
select * from v$sqlarea where user = 'username';
Example:
SELECT *
FROM suppliers
WHERE city = 'Newark';
http://www.techonthenet.com/sql/select.php
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2009 09:47 AM
тАО06-30-2009 09:47 AM
Re: How to view the Oracle sql history
does it something like show history for UNIX ?
some sort of sabotage happen lately, and i want to see what certain user has been doing with the DB...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2009 09:49 AM
тАО06-30-2009 09:49 AM
Re: How to view the Oracle sql history
You need to merely construct the proper sql statement to call up the data and find our whom is doing what.
Oracle collects this data to conduct self tuning based on actual database use.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-01-2009 01:21 AM
тАО07-01-2009 01:21 AM
Re: How to view the Oracle sql history
In v$sql you just get the sql history since the last startup.
In the futures, to get more history (before the last startup) you must activate the audit functionality of your database (check your Database Administrator├в s Guide).
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-01-2009 12:48 PM
тАО07-01-2009 12:48 PM
Re: How to view the Oracle sql history
V$SQL contains what the database need to
keep track for current operation, not
for archiving yesterdays executed statements.
If your shared pool is small, statements might be flushed from that area, so if it
is not in there, it does NOT mean, it has
not been executed! (clear ? :-)
If you need relyable information, you'll need
to dig into auditing or use logminer.
Volker