SQL Performance (MOSC)

MOSC Banner

coexistence of global and partitioned indexes

edited Jul 11, 2019 5:03AM in SQL Performance (MOSC) 2 commentsAnswered ✓

Hello!

in my case there are global and partitioned indexes on some table,  full version number of oracle database is 11.2.0.4.0

Could you explain please,

in what chronological sequence

- did blockings occur (and released) and take place actions during  removing (synchronous removing and adding) of the partition ;

- did removing partition and entries of global index ;

- what of this processes can prevent dml-activity ?

in othwer words how this ddl-operations (and  deleting entries from global index ) affects dml-activity ?

what occurs earlier - deleting entries from global index or deleting of partition ?

if deleting entries from global index is the last step in the chain  then subsequent dml-activity is possible directly after ddl ?

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