Skip to Main Content

Oracle Database Index Creation Problem For Big Table On OCI

User_Y7UC4Oct 22 2022

On RDS:
I have a table "stats". It is ~400GB
I try to create an index for it: CREATE INDEX IDX_...
Index creations starts successfully.
It takes 10 hours long.
On OCI:
I have a table "stats". It is ~400GB
I try to create an index for it: CREATE INDEX IDX_...
Index creations starts successfully and continue for a while.
After 20 minutes, process disappeared(Except ssh(ServerAliveInterval 240)).
For ssh(ServerAliveInterval 240), it takes 10 hours to complete.
I tried it with 4 different client:
sql-developer -> didn’t work
java -> didn’t work
ssh -> didn't work
ssh(ServerAliveInterval 240) -> worked (when we keep alive the session, it worked.)
So my question is so clear. Why does it work with only ssh(ServerAliveInterval 240)? and is there a way to handle it on Java with some configuration? It should have a configuration because RDS solves it.
Any suggestion?

This post has been answered by asahide on Oct 23 2022
Jump to Answer
Comments
Post Details
Added on Oct 22 2022
3 comments
43 views