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?