To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Database
Discussion List
-
Metrics in DB system for CDB instance - OCI consoleHi Team, Current Logons,Parse count (total),Block Changes,Execute Count shown in DB system for CDB instance ---> Are these aggregated across the entire instance, which i… -
Enable Diagnostics & ManagementHi Team, We are using oci base database service 19c version. We are trying to set basic database management for our base DB, Enable Diagnostics & Management. We are usin…
-
Database Management for OCI Base Database ServiceHi Team, Could you please confirm whether Database Management for OCI Base Database Service is a free feature? Specifically, we are planning to use Database Monitoring M…
-
Availability of 19.30 Database RU in OCI (DBCS/ExaCS)Summary: Hello Team, The JAN 2026 RU is released on MOS, however it is not yet visible in the OCI Console for our DB system or EXACS . Could you please confirm when it w… -
Oracle Base Database Service on VM(DBCS VM)Dear Team, The environment is Oracle Base Database Service on VM(DBCS VM,) and we want to upload and retrieve files from application hosted in DB. We will have around 60…
-
How can I determine my total database size?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Best database option in oracle cloud i.e. optimal in cost? Executed via Oracle Integration CloudSummary: I would like to know what is best database option we have in oracle cloud that is optimal in cost? Content (please ensure you mask any confidential information)…
-
backup destination of DBCS system from object storage to autonomous recovery serviceHi Team, We have changed backup destination of DBCS system from object storage to autonomous recovery service yesterday. After the change, in oci screen, it showed a mes…
-
storage quota exceededHi Team, We are placing file from onpremise server to oci server using oci cli, but we are getting "StorageQuotaExceeded". We have 1 TB procured initially for object sto…
-
Backup size in DBCS object storageDear Team, We are using oracle dbcs with automatic configured backups to object storage. We are trying to find the size of the backups in object storage. But looks like …
-
Where can I download Oracle Application Express 24 patch?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Below bug fix patch 38896696: SHUTDOWN TAKES LONG TIME INTERM included in 19.31(APR Release Patch)Below bug fix patch included in 19.31(APR Release Patch)? 38896696;SHUTDOWN TAKES LONG TIME INTERMITTENTLY AT SHUTTING DOWN ARCHIVE PROCESSES
-
Index - Performance queryHi Team, We are using Oracle Database 19.28 version. We need your support in fixing the below SQL query appeared in SQL ordered by Elapsed Time in AWR report. CPU consum…
-
ETA for 19.30 CPU Update on Base DB SystemsThe January CPUs for the Base DB Systems seem to be delayed a lot more than usual this quarter. Is there any ETA for when they will be released? Is the delay related to …
-
DBMS_CLOUD_AI_AGENTSummary: we are at 23.26 DB version OCI DBaaS Content (please ensure you mask any confidential information): How do we install DBMS_CLOUD_AI_AGENT? We have tried: 274836…
-
DBMS_CLOUD.COPY_DATA performance IssueSummary: I am loading the data from CSV file on OIC object storage to ATP using DBMS_CLOUD.COPY_DATA The execution time of this approach is not Consistent. For some run …
-
How to calculate cpu utilization for single pdb database alone.Summary: Any Query to analyze cpu utilization for single pdb database alone. Content (required): Database running on Exacs Version (include the version you are using, if… -
How can I find the total image/document size in my Oracle Fusion databaseSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
I want to understand how OTM database (GLOGOWNER) is aligned with OAC database (HDOWNER)Summary: HOW OTM data is mapped in OAC, I want to understand this, because data in OTM database have different tables and in HDOWNER have diff hierarchy, wanted to under…
-
I want to understand how OTM database (GLOGOWNER) is aligned with OAC database (HDOWNER)Summary: HOW OTM data is mapped in OAC, I want to understand this, because data in OTM database have different tables and in HDOWNER have diff hierarchy, wanted to under…
-
ORDS standalone port running on tcp6 port unable to connectSummary: ORDS standalone port running on tcp6 port unable to connect. ORDS version is 25.3 and how to make standalone port to run on tcp(IPV4) port. Content (please ensu…
-
sizing from X86 to EXACC with EXADB RAC modeSummary: I'm suffering about the sizing what migration X86 oracle 19c EE to EXACC with EXADB(not CDB), not only the DB level sizing, but also include VM Cluster level si…
-
Problem while intergrating OCI (DRCC) with external SMTPSummary: I need assistance in configuring SMTP for sending emails via Oracle APEX 24.2 on our Oracle 23ai Autonomous Database (ADB). I have followed the documentation pr…
-
DBMS_CLOUD Synonym No Longer Valid Autonomous Database 23AISummary: Attempting to execute a subprogram from DBMS_CLOUD and getting error that the synonym is no longer valid. Content (please ensure you mask any confidential infor…
-
Is Oracle RAC databases supported in AzureHello, I am looking more clarity about support of Oracle RAC in Azure cloud. I have seen many articles and found some of them saying, RAC is not supported or certified b…
-
conversion error loading table due to character set mismatchexported(using expdp) schema from oracle database that uses charset WE8MSWIN1252, and while import huge schema which has 1.5TB using impdp to Target where character set …
-
Data Safe/Data Discovery/Sensitive Data Model/Sensitive Data Creation is hanging at 65%As a pre-req for Data Masking, I am creating Sensitive Data Creation. It is hanging at 65% Content (please ensure you mask any confidential information): Version (includ…
-
ORA-20401: Authorization failed for URI using dbms_cloud access to object storageSummary: Getting authorization failed error connecting to the object storage from oci base 23 ai db. ORA-20401: Authorization failed for URI - https://objectstorage.us-c…
-
ORA-20401: Authorization failed for URI-dbms_cloud.put_object - Error While Creating Object—Create Credential ; BEGIN DBMS_CLOUD.CREATE_CREDENTIAL( credential_name => 'XXOBJ_CDN', username => 'xxemail@oracle.com', password => '112121' ); END; —Put Object Proce…
-
How to restore spfile from an RMAN backup stored in OCI Object Storage?Hello everyone, I’m currently working with an Oracle Database hosted on OCI, and I need to restore the spfile from a backup that resides in an Object Storage bucket (RMA…