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
Messages: 56
Registered: July 2005
Location: Indore

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

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: 63917
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.

Previous Topic: PARTITION HELP
Next Topic: WORK_AREA_SIZE_POLICY = manual
Goto Forum:

Current Time: Mon Oct 24 19:31:36 CDT 2016

Total time taken to generate the page: 0.09032 seconds