You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
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.

Database

Discussion List

  • SGU
    Security - DBCS System Login Using OPC User
    Hi Team, We would like your guidance on the recommended security and auditing best practice for user access to our OCI Base Database Service (DBCS) environment. Currentl…
    Accepted answer
    SGU 86 views 11 comments Most recent by Sarma NS-Oracle
  • SGU
    Consumption - OCI
    Hi Team, From feb 2026, graph suddenly shows surge and became stable. Our PRODB instance created in DEC 2025 and we went go live on Apr 2026. Monthly usage. Monthly usag…
    Accepted answer
    SGU 50 views 7 comments Most recent by SGU
  • SGU
    OCI Billing Infrastructure
    Hi Team, We have a tenancy with fusion application and paas. In second screenshot, Account type is annual commitment. Account Type: Annual Commitment Contract Start Date…
    Accepted answer
    SGU 50 views 6 comments Most recent by SGU
  • SGU
    Connectivity to oracle
    Hi Team, We are connecting from Postgresql to Oracle database with connection details provided by oracle team. Target oracle DB is multitenant with single CDB and single…
    Accepted answer
    SGU 80 views 17 comments Most recent by Sarma NS-Oracle
  • SGU
    Alerts - Automated backups - DBCS
    Hi Team, We have configured OCI Events Service to send email notifications for database backup status using the following event rule: Rule Name: BkpNotifyRule Descriptio…
    Accepted answer
    SGU 85 views 16 comments Most recent by SGU
  • SGU
    OCI WAF Billing Clarification - WAF Policies vs WAF Instances 2
    Hi Team, I am trying to understand OCI WAF billing. We have deployed two Web Application Firewall (WAF) policies in OCI: Production WAF Policy UAT WAF Policy Both polici…
    Accepted answer
    SGU 20 views 4 comments Most recent by SGU
  • SGU
    Autonomous Recovery Service Alerts
    Hi Team, My DB size is 500 GB and retention is set to 14 days using Autonomous recovery service. We are also planning to configure a alarm for Autonomous recovery servic…
    Accepted answer
    SGU 20 views 2 comments Most recent by SGU
  • SGU
    Query performance
    Hi Team, We are currently investigating CPU spike issues and have reviewed the AWR report. Based on the report, the attached graph is ordered by CPU Time, and we would a…
    Received Response
    SGU 50 views 16 comments Most recent by SGU
  • SGU
    Undo retention
    Hi Team, We specifically want to ensure that we can retain sufficient undo to perform a Flashback Table/Flashback operation for at least 24 hours. We would like Oracle S…
    Accepted answer
    SGU 50 views 7 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    heavy swap usage
    Hi Team, Today we experienced significant database/application performance degradation for approximately 2 hours. During the issue window, the system performance was ver…
    Accepted answer
    SGU 143 views 21 comments Most recent by SGU
  • Renato Baietta
    DBMS_CLOUD.CREATE_EXTERNAL_TABLE for csv with newline inside field
    Summary: I have a standard comma-separated csv file stored in a bucket, with header composed by the first 2 rows. Some text contains \n (newline) that is not the end of …
    Received Response
    Renato Baietta 31 views 4 comments Most recent by Renato Baietta
  • User_M73EK
    Best practice for setting up databases on quarter Exadata Rack
    Content Hi All, A customer has subscribed for quarter Exadata Rack. The requirement is to have multiple PDBs for Cloud native application which will comprise of support …
    Received Response
    User_M73EK 28 views 6 comments Most recent by Smarajit Samantaray-Oracle
  • SGU
    19c Database Patching with Primary/DR Data Guard Environment - DBCS
    Hi Team, We Request for Oracle Guidance on 19c Database Patching with Primary/DR Data Guard Environment We are using Oracle Database 19c in OCI Base Database Service. Ou…
    Accepted answer
    SGU 279 views 7 comments Most recent by SGU
  • SGU
    Performance issue
    Hi Team, Hi Team, We are using oracle database 19.17 version. We identified performance issue with attached query, consuming 100% CPU. At the same time we have seen mult…
    Accepted answer
    SGU 50 views 14 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Query ending with spilling huge temp space
    Hi Team, We have a procedure running in DEV instance that is failing within 5 minutes with the error: "Unable to extend temp space", despite having 20 GB of TEMP space a…
    Accepted answer
    SGU 92 views 9 comments Most recent by SGU
  • Namrata_20
    Master tables and employees transactions table
    Summary: We need to Archive all information of the system so want to know which all Master tables which stored configuration details and which all tables stores employee…
    Received Response
    Namrata_20 95 views 2 comments Most recent by Sarma NS-Oracle
  • SGU
    Upgrade from 19.28 to 26ai
    Hi Team, We are currently evaluating an upgrade of our Oracle Database environment from Oracle Database 19c to Oracle Database 26ai. Our team has experience administerin…
    Accepted answer
    SGU 225 views 4 comments Most recent by SGU
  • SGU
    Memory Interpretation Graph - DB System
    Hi Team, Does the OCI DB System "Memory Utilization" metric represent total host memory consumption including Oracle SGA, PGA, Oracle processes, OS cache, and other oper…
    Accepted answer
    SGU 40 views 2 comments Most recent by SGU
  • SGU
    Metrics in DB system for CDB instance - OCI console
    Hi 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…
    Accepted answer
    SGU 50 views 2 comments Most recent by SGU
  • SGU
    Enable Diagnostics & Management
    Hi 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…
    Accepted answer
    SGU 60 views 10 comments Most recent by SGU
  • SGU
    Database Management for OCI Base Database Service
    Hi 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…
    Accepted answer
    SGU 57 views 6 comments Most recent by SGU
  • Kondala Rao-Oracle
    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…
    Received Response
    Kondala Rao-Oracle 507 views 11 comments Most recent by Smarajit Samantaray-Oracle
  • SGU
    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…
    Accepted answer
    SGU 11 views 6 comments Most recent by SGU
  • Larry Morris
    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…
    Received Response
    Larry Morris 51 views 7 comments Most recent by Smarajit Samantaray-Oracle
  • Abdullah Munaz
    Best database option in oracle cloud i.e. optimal in cost? Executed via Oracle Integration Cloud
    Summary: 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)…
    Accepted answer
    Abdullah Munaz 881 views 5 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    backup destination of DBCS system from object storage to autonomous recovery service
    Hi 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…
    Accepted answer
    SGU 41 views 1 comment Most recent by Masiuddin Ahmed-Oracle
  • SGU
    storage quota exceeded
    Hi 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…
    Accepted answer
    SGU 31 views 9 comments Most recent by Masiuddin Ahmed-Oracle
  • SGU
    Backup size in DBCS object storage
    Dear 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 …
    Accepted answer
    SGU 71 views 6 comments Most recent by Masiuddin Ahmed-Oracle
  • jkorhone-Oracle
    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…
    Accepted answer
    jkorhone-Oracle 41 views 1 comment Most recent by L. Fernigrini
  • Nallapareddy-Oracle
    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
    Accepted answer
    Nallapareddy-Oracle 253 views 3 comments Most recent by Nallapareddy-Oracle