Hi! Team,
Is there a way whereby we can get all rowids of a table without querying the table but some dba views or other stuffs? Actually we have a procedure which calculates cost of goods based on FIFO method. We have a table where all inventory related entries are get recorded. There can be more than 100 million records for a given financial year. We scan this table for a particular financial year and calculate cost. This takes huge time to complete the process. My idea is get rowids of this table and make smaller sets of data out of it and then submit jobs to process these sets. If a CPU is having 10 cores then we would submit 8 jobs assuming each job would be serviced by a particular core so that process can be finished much faster. Is it a good idea? Would it be the case that each job would be taken up by a different core?
Any other suggestion will be appreciated.
Thanks and regards.