Database Administration (MOSC) - Oracle Community
Oct 13, 2021 · Database Administration (MOSC) Errors ora-39127 ora-01422 on expdp domain index of Arcgis geodatabase - Oracle 19.11 Oct 13, 2021 7:53PM 22 comments Answered
Why use CASCADE=>'TRUE' for …
May 9, 2023 · hi, Why use CASCADE=>'TRUE' when using exec DBMS_STATS.GATHER_SCHEMA_STATS ('HR') the above will gather the statistics of all …
DBMS_SNAPSHOT.REFRESH vs dbms_mview.refresh — oracle-mosc
Jan 22, 2013 · Database DataWarehousing (MOSC) DBMS_SNAPSHOT.REFRESH vs dbms_mview.refresh Jan 22, 2013 10:39AM edited Apr 16, 2013 1:09AM 10 comments …
how to check DBMS_JOB historical run details prior to 19C — …
Feb 18, 2021 · Hello Oracle Enthusiasts, We have lot of dbs which are still on 11g and 12c and jobs scheduled using DBMS_JOBS.
GRANULARITY AUTO for Partitions and Subpartitions - Oracle …
Nov 11, 2013 · The documentations says: "determines the granularity based on the partitioning type. This is the default value." What does "AUTO" mean, does oracle the stats collection for …
What is DBMS_AQADM_SYS.REGISTER_DRIVER — oracle-mosc
Nov 9, 2020 · Hi All Kindly, recently I can see many active sessions in my oracle database (11.2.0.4) running from DBMS_SCHEDULER module with action …
Database Administration (MOSC) - Oracle Community
Jun 11, 2021 · Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production I have a container db with a single pluggable database. I've created a service in the pluggable …
Schedule gather stats job in scheduler — oracle-mosc
Dec 6, 2018 · Hello All, I am trying to gather schema stats(all tables in specifc schemas) by scheduing a job in scheduler.
how to reset next_run_date of a Scheduler job — oracle-mosc
Jan 19, 2012 · 3. In the body, insert detailed information, including Oracle product and version. Please abide by the Oracle Community guidelines and refrain from posting any customer or …
Steps to resolve "PL/SQL package SYS.DBMS_RCVMAN ... - Oracle …
Feb 11, 2025 · That all worked great but the alert log has these messages PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not current PL/SQL package …