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
-
Last Chance to Register: Innovate with AI Built Into Your Database - Everywhere. (April 8, 2026)Lead the change with the only database that natively architects AI into your data everywhere. AI promises faster insights, better decisions, and higher productivity, but… -
How can we automate OCI compute shutdown and startupHi Team, How can we automate server shutdown and startup? Requirement: Stop the server automatically every day at 12:30 AM. Start the server automatically every day at 0…
-
services autorestart after reboot - OEL 8 OCIHi Team, We have an OCI Compute instance running Oracle Linux 8.9. The server hosts the following components: Oracle REST Data Services (ORDS) – currently running on the…
-
-
Guidance Required on High CPU Usage Observed - 19cHi Team, We are using an Oracle Database environment with APEX installed, which supports our Fusion integration. Our application code invokes various Fusion REST APIs th…
-
Security Dbcs auditHi, We are currently discussing and evaluating whether the administrators should continue using the shared application schema credentials for activities such as compilin…
-
Remote Audit Log Forwarding for Oracle Linux DB SystemsHi Team, We have implemented auditing for commands executed by users after they switch to the root account from their respective login IDs. While this provides accountab…
-
DBA Accountability and Shared Application Schema Access -19cHi Team, We have created dedicated named users for the DBAs and granted the required CDBA privileges, the users are able to log in and perform the required activities. I…
-
Logging of All Commands Executed by a UserHi Team, We are testing the steps from Oracle KB "Oracle Linux: How to Enforce the Logging of All Commands Executed by a User in OL7 (KB100466)" to capture all commands …
-
Understanding OCI Billing:Object Storage-Database Backup / Image Storage Size Much Larger Than DataHi Team, We are trying to understand the OCI billing component below: B91628 OBJECTSTORE Object Storage - Database Backup / Image Storage Quantity: 2,569.47 GB-Month Env…
-
Dataguard switchoverHello Team, We have an OCI environment with separate UAT and PROD database systems. Our current setup is: UAT/Test environment: OCI DB System without Data Guard/DR. PROD…
-
Security - DBCS System Login Using OPC UserHi 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…
-
Consumption - OCIHi 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…
-
OCI Billing InfrastructureHi 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…
-
Connectivity to oracleHi 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…
-
Alerts - Automated backups - DBCSHi Team, We have configured OCI Events Service to send email notifications for database backup status using the following event rule: Rule Name: BkpNotifyRule Descriptio…
-
OCI WAF Billing Clarification - WAF Policies vs WAF Instances 2Hi 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…
-
Autonomous Recovery Service AlertsHi 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…
-
Query performanceHi 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…
-
Undo retentionHi 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…
-
heavy swap usageHi Team, Today we experienced significant database/application performance degradation for approximately 2 hours. During the issue window, the system performance was ver…
-
DBMS_CLOUD.CREATE_EXTERNAL_TABLE for csv with newline inside fieldSummary: 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 …
-
Best practice for setting up databases on quarter Exadata RackContent 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 … -
Procedure to rollback applied OS patches in DBCS/DB systemSummary: Hello Team, We have a 19.25.0.0 Version DB system/DBCS. We have applied OS patches through DBCLI using below command : dbcli get-availableospatches dbcli update…
-
19c Database Patching with Primary/DR Data Guard Environment - DBCSHi 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…
-
Performance issueHi 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…
-
Query ending with spilling huge temp spaceHi 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…
-
Master tables and employees transactions tableSummary: 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…
-
Apex files uploadTeam, We are building one application in apex where customers use it to upload files and retrieve files. There will be multiple files around 100 per day and there will c…
-
Upgrade from 19.28 to 26aiHi 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…
-
Memory Interpretation Graph - DB SystemHi 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…