Home » RDBMS Server » Performance Tuning » Performance issues with dbms_job
Performance issues with dbms_job [message #242228] Fri, 01 June 2007 02:49 Go to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

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
Michel Cadot
Messages: 64111
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
Previous Topic: PARTITION HELP
Next Topic: WORK_AREA_SIZE_POLICY = manual
Goto Forum:
  


Current Time: Mon Dec 05 14:53:02 CST 2016

Total time taken to generate the page: 0.10103 seconds