Database Administration (MOSC)

MOSC Banner

Table with hash partition contains partition with 0 rows

We have a hash-partitioned table with 256 partitions. I was expecting that these partition will contain around even number of rows. but some of them have 0 rows.

A. Is this expected/normal?

B. If not, what could've caused this and how can we fix this?

We are facing performance issue on query that is accessing this table so we need to check if this might be one of the causes.

Attached below is a spreadsheet of row distribution on each partitions.

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center