how to specify undo tablespace for a PDB (instance) in RAC?
Oct 9, 2018 · Our CDB using local undo tablespace for each PDB. I've create a new undo tablespace (in PDB1 session) and add it to an PDB instance, but when shutdown/startup PDB, all two instances …
efficient way to reclaim free space in tablespace for 19c
May 26, 2021 · Database Administration (MOSC) efficient way to reclaim free space in tablespace for 19c May 26, 2021 10:12PM 4 comments Answered
How to migrate data from small file tablespace to bigfile tablespace ...
Nov 8, 2017 · Hi All, How to migrate data from small file tablespace to bigfile tablespace. Actual requirement is to migrate the data from small file tablespace to bigfile tablespace with in the …
Query to check tablespace usage — oracle-mosc
May 27, 2022 · (select tablespace_name, round (sum (bytes)/1024/1024,2) free_mb from dba_free_space group by tablespace_name) f where t.tablespace_name=f.tablespace_name order …
2 undo tablespaces for Oracle rac 2 nodes pluggable database
Mar 7, 2021 · I have oracle 19c rac on linux with 2 nodes and database 19c pluggable database; ive noticed the belowl some times when I issue show parameter undo i see that the default undo …
How to reclaim free space on SYSAUX and shrink tablespace?
Apr 1, 2022 · 2. created new tablespace, moved the objects on the end of segment to new tablespace, then moved them back to SYSAUX. The shrink still can't work. Could you suggest convenient way to …
how to shrink MGMT_TABLESPACE ? — oracle-mosc
Nov 4, 2025 · EM Cloud Control is writing its data into mgmt_tablespace, which is getting bigger and bigger. I no longer have space on the filesystem to extend the datafile.
About Encryption of SYSTEM, SYSAUX, UNDO and TEMP tablespaces in …
Jan 9, 2024 · Optionally, encrypt the USERS tablespace in the root container. While technically possible, you should not encrypt the SYSTEM, SYSAUX, TEMP, and UNDO tablespaces of the root container."
Tablespace Available Used VS Allocated Used — oracle-mosc
Aug 30, 2022 · Finally I checked the tablespace in Enterprise Manager and realized that the "Avalialbe Sapce Used %) is 84,10 but the "Allocated Space Used %" is 97,55. So I think the problem is that …
ORA-1688: unable to extend table AUDSYS.AUD$UNIFIED partition SYS ...
Jul 10, 2023 · ORA-1688: unable to extend table AUDSYS.AUD$UNIFIED partition SYS_P00000 by 8192 in tablespace SYSAUX > Unified Audit record write to audit trail table failed due to ORA-1688.