Performance issues with dbms_job [message #242228] |
Fri, 01 June 2007 02:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hi All,
I have implemented a job which runs every minute. That job written for a table which is important for the security purpose which deletes records of user who have more then 15 minutes of login. This means that the table is requested for the validity of the user.
So the number of rows in that table will not be on high count.
Will this job effect perforamnce of retrival of data from that table?
Database used Oracle 10g R2
regards
Amit Nanote
[Updated on: Fri, 01 June 2007 02:54] Report message to a moderator
|
|
|
Re: Performance issues with dbms_job [message #242234 is a reply to message #242228] |
Fri, 01 June 2007 03:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
This job will have no effect on performances neither benefit nor loss.
If to retrieve the rows you use an index, the total number of rows is meaningless.
If to retrieve the rows you use a full scan, it will not change after delete.
Regards
Michel
|
|
|