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 …
ORA-00959 (tablespace does not exist) when creating an external table ...
Oct 9, 2014 · Hi, A colleague of mine has just pointed out to me a problem regarding the creation of an external table on a schema whose user's default tablespace does not exist.
BIGFILE datafile increase causes waits on 'enq: TT - contention'
Jun 30, 2023 · If the tablespace has more than one datafile, then Oracle may be able to allocate the extent in another datafile without having to wait. Since a bigfile tablespace has only one datafile, …
Tablespace's Utilization Report from OEM 12c/13c — oracle-mosc
Sep 7, 2022 · The below query does not provide accurate results for the Tablespace PCT_used. Need to correct this report to accurately reflect auto extensible tablespaces.
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
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 …
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 …
How to reclaim free space on SYSAUX and shrink tablespace?
Apr 1, 2022 · The SYSAUX tablespace needs to be defragmented due to plenty of free spaces(95%) Tried 1. shrink tablespace to smaller size and had ORA-03297 error. 2.
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 …
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."