Impact of larger partition number on database performance

[Kamal Joshi]

Hi,

We have done partitioning of a big table:

Records = 57 millions
Number of Partitions = 1000
Partition type = hash

After the partition, we are facing high CUP usage problem even for the low load in database.
Is this because of the partitioning with large number (1000) of partitions?

If yes, then what should be the ideal number of partitions in this case for better performance?

Please help!

Thanks,
Kamal Joshi