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
-
DBMS_SCHEDULERHi, I have a requirement where a table needs to be truncated periodically. Before truncating the table, I want to preserve the last 7 days of data in a separate history … -
dbms_cloud - oracle base database serviceHi Team, We are using Oracle Base Database Service (DBCS VM), version 19.28, single-node environment. We are planning to use DBMS_CLOUD for integrating with OCI Object S…
-
Controlling sysaux usageHi Team, How to control the growth in sysaux tablespace - 19c DB Thanks, SGU
-
release space to OSHi Team, Dropping the backup tables XXTTD_FA_INVEST_REG_TBL_BKP and XXTTD_FA_INVEST_REG_TBL_BKP1 releases space back to XXTTD tablespace. But we want the space to be rel…
-
Custom Database Software ImageHi Team, We across the article "Using Custom Database Software Images to Create, Patch, and Upgrade your Cloud Databases" and would like to better understand this featur…
-
Recover table rmanHi Team, I need some guidance on the recommended approach for recovering a table using RMAN when the required Flashback logs are no longer available. Our requirement is …
-
Updates to OCI OEL 8 Compute instanceHi Team, We have an OCI Compute instance that was created approximately six months ago. Since its creation, we have not performed any OS updates, including package updat…
-
Scheduled Function/SIEM audit query → Notifications topicHi Team, Sign-on Policy changes are Identity Domain configuration events. OCI Audit remains the authoritative record, but the required event type may not always be avail…
-
Oci admin trackingHello Team, I have a question regarding auditing and tracking administrative activities in OCI. For example, if someone changes the Load Balancer configuration, such as …
-
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…
-
-
Recommended Approach to Validate DBCS DR EnvironmentWe have a production Oracle Database Cloud Service (DBCS) environment with the following DR architecture: Primary Region: Hyderabad DR Region: Mumbai We don't have DR fo…
-
Application rebuild - DRHi Team, We have an OCI Compute instance in our Primary region (Hyderabad), but we do not maintain a Compute instance in the DR region (Mumbai) due to cost consideration…
-
DBCS - Operating System UpdatesHI Team, We have OCI Base Database Service (DBCS) instances running Oracle Database 19.28 on OEL 8 [oracle@proddb ~]$ uname -a Linux proddb 5.4.17-2136.326.6.el8uek.x86_…
-
Clone DB SystemHi Team, We are evaluating the Clone DB System option and have a few questions: Can we clone a DB System into a different subnet while retaining the same hostname and da…
-
Remote PDB Clone - Base database service - 19cHi Team, Current Setup: Production: 1 CDB with 1 PDB Development: 1 CDB with 2 existing PDBs (DEVDB and UATDB) Source and target databases are in different subnets. We w…
-
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…
-
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 …
-
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…
-
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…
-
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…
-
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…
-
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…