How to get count of frequently accessed record?

[fastestindian]

Hi,

I am working on a task where i need to create the list from a table of frequently accessed records.

I am not sure where i should do that?
- In businees logic using C# or
- Is there any kind of functionality available for it in Oracle - which gives count of record accessed.

Thanks in advance.

[amitpatel66]

When you say frequently accessed records, are you looking for the records on which the DML operatins are frequently performed? Oracle Triggers will be an option for that.

[fastestindian]

Thanks..buddy..

[Oralloy]

Can you tell us what you are trying to accomplish?

Are you trying to profile general database use, or just the behaviour of a specific application or program?

What sorts of limits are you bound by? Are triggers, as amitpatel66 recommends, a viable option? Is there a table for you to save useage information in, or do you have to use an external file?

Cheers!

[fastestindian]

I wanted to keep the tract of the rows accessed maximum times and order them.

Later on came to know that these rows which are accessed are inserted into another table hence can tracked easily.

[Oralloy]

It sounds like you are profiling record access/use across all applications.

In this case, I agree with @amitpatel66 - you should use triggers. Why don't you take a stab at that and let us know, if you need more help.

Good luck!