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 …
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
ORA-01652: unable to extend temp segment by 128 in tablespace …
Aug 29, 2024 · Summary: we have one custom report keeps failing with error ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP in saas application.
ORA-1688: unable to extend table AUDSYS.AUD$UNIFIED partition …
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 …
Tablespace SYSTEM&SYSAUX components size too large
Apr 25, 2023 · My oracle version is 19.16 EE which is primary db using Data guard, recently first receive SYSAUX tablespace usage more than 90% and i checked and cleared Optimizer …
SYSTEM Tablespace ENCRYPTION — oracle-mosc
Jan 29, 2020 · Hi, I want encrypt system tablespace . Below statement is working fine and system tablespace be encrypted with default encryption algoritm AES128
Is it possible to relocate UnifiedAuditing audsys.aud$unified table …
Jun 19, 2018 · On HPUX I64, upgraded to 12.1.0.2, activated UnifiedAuditing, set audit trail location to a user tablespace, worked great.
ora-28426: must FINISH a tablespace encrypt, decrypt or rekey …
Dec 4, 2017 · I have a tablespace test with 4 datafiles, test1, test2, test3 and test4.
Script to get tablespace free space including MAXSIZE for datafiles
Mar 11, 2012 · Hi, gurus.I have scripts that query a 9i database for datafile free space and send emails listing available space per tablespace.
apps_ts_media tablespace is growing very fast. — oracle-mosc
Sep 8, 2012 · the apps_ts_media tablespace is growing very fast. Is there a way to reduce the space utilised in this tablespace. I mean to store the data in a compressed form or store the …