Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

long run preupgrade due to check tablespace usage

Hi,

When I run preupgrade tool it stacks on tablespace usage SQL:

select ds.tablespace_name,

row_number() over (partition by tablespace_name order by 1) rn,

          round(nvl(sum(ds.bytes) over (partition by ds.tablespace_name),0),2) as inuse

      from sys.dba_segments ds) where rn =1;

It runs hours.

I purged dba_recyclebin before but it doesn't help.

current Oracle version: 12.2.0.1.190115


BR.

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