Re: prepare phase hangs

Posted by satish on May 15, 2023; 2:06am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/prepare-phase-hangs-tp11865p11876.html

Dear Erman,

We have provided the backend session details in previous updates.

Query run immediately in CDB but from PDB,it hangs even from application servers or from database servers. Please guide.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

SQL> SELECT     df.tablespace_name   , round((df.total_space/(1024*1024*1024)
),2) total_space   , round(((df.total_space -
  2    3  fs.free_space)/(1024*1024*1024)),2) used_space   ,
round((fs.free_space/(1024*1024*1024)),2) free_space   ,
round(((df.total_space-fs.free_space) / df.total_space)*100, 2)
PCT_USED FROM     ( SELECT tablespace_name, SUM(bytes) TOTAL_SPACE
 FROM dba_data_files       GROUP BY tablespace_name) df   , ( SELECT
tablespace_name, SUM(bytes) FREE_SPACE       FROM dba_free_space
GROUP BY tablespace_name) fs WHERE       df.tablespace_name =
fs.tablespace_name(+)   and df.tablespace_name in         ('SYSTEM',
'APPS_TS_SEED', 'APPS_TS_TX_DATA', 'APPS_TS_TX_IDX') ORDER BY
fs.tablespace_name  4    5    6    7    8    9   10   11   12
 13  ;




What might be wrong?

Thanks,
Satish