OraFAQ Forum: Server Administration » How to see what happened on past 10days in DB

Home » RDBMS Server » Server Administration » How to see what happened on past 10days in DB (Oracle 10g,R2,WindowsServer2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to see what happened on past 10days in DB [message #466371]

Mon, 19 July 2010 05:30

senthil22
Messages: 2
Registered: July 2010
Location: CHENNAI

Junior Member

I am working in development environment which has only 150 gb db size but suddenly it is raised to 250gb within 10 days i want to see which user did what in my database.How we can see what task made what in past 10 days.

Report message to a moderator

Re: How to see what happened on past 10days in DB [message #466373 is a reply to message #466371]

Mon, 19 July 2010 05:42

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Hi,
The best option to use is LOGMINER. Google it.

Report message to a moderator

Re: How to see what happened on past 10days in DB [message #466374 is a reply to message #466371]

Mon, 19 July 2010 05:42

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Using Log Miner.
And for the futur you may activate audit and then you can get this information just querying the audit trail.

Regards
Michel

Report message to a moderator

Re: How to see what happened on past 10days in DB [message #466403 is a reply to message #466374]

Mon, 19 July 2010 08:10

senthil22
Messages: 2
Registered: July 2010
Location: CHENNAI

Junior Member

Thank for everyone response

Report message to a moderator

Previous Topic:	Create new service for database
Next Topic:	Tracking DBMS JOB timing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 13:20:51 CST 2024