Realistically, unless you have some sort of change/ query tracking
mechanism in place (Workspace Manager, Fine-Grained Auditing, auditing
triggers, etc. depending on the precise requirements) you are probably
out of luck if the goal is to identify something at the row level.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Sharad Kumar
[mailto:oracledba-ezmlmshield-x50363353.[Email address protected]
Sent: Friday, June 03, 2005 5:25 PM
To: LazyDBA Discussion
Subject: RE: Query help
I want to pull out that row to reach some result how I can? What sql
statements should I used.
Please suggest.
Regards,
Sharad.
-----Original Message-----
From: Justin Cave (DDBC)
[mailto:oracledba-ezmlmshield-x43699868.[Email address protected]
Sent: Saturday, June 04, 2005 2:51 AM
To: LazyDBA Discussion
Subject: RE: Query help
Highly accessed as in frequently selected? You could probably track
that with Fine-Grained Auditing.
Otherwise, you'd be stuck with the LogMiner/ segment-level statistics
approaches, with all their limitations.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Sharad Kumar
[mailto:oracledba-ezmlmshield-x46616620.[Email address protected]
Sent: Friday, June 03, 2005 5:11 PM
To: LazyDBA Discussion
Subject: RE: Query help
Can we find highly access row in a table?
Regards,
Sharad.
-----Original Message-----
From: Justin Cave (DDBC)
[mailto:oracledba-ezmlmshield-x40638067.[Email address protected]
Sent: Saturday, June 04, 2005 2:43 AM
To: LazyDBA Discussion
Subject: RE: Query help
Define "most updated row". Do you mean the particular row that has been
affected by the largest number of UPDATE statements? Unless you are
tracking changes to the rows via triggers, Workspace Manager, or
something else, Oracle will not track this sort of information.
If you are looking at a particular timeframe that you have archived log
files for, you may be able to extract the information via LogMiner, but
that would be pretty arduous. If you are looking for hot blocks, 9i
collects segment-level I/O statistics (v$segstat). That's going to be a
large number of rows, and you can't differentiate UPDATE activity from
other types of activity, though.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Sharad Kumar
[mailto:oracledba-ezmlmshield-x74976821.[Email address protected]
Sent: Friday, June 03, 2005 4:58 PM
To: LazyDBA Discussion
Subject: Query help
How do we find most updated row in a table? Please provide me the query.
Regards,
Sharad.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page