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
-
debugging plsql/sql statementsHi Team, We generated an ASH report attached for a performance issue and identified two PL/SQL blocks/packages. However, we are unable to determine the actual SQL statem… -
Autostop of oci compute instanceHi Team, When we click on create schedule,it throws away below error, can you please guide us what was the reason for this error. Thanks, SGU
-
performance issue with reportHi Team, We have report generation from apex calling bipublisher which is there in onpremise environment connected through site to site vpn. We have verified the sesssio…
-
Security oci computeHi Team, We have a PaaS environment supporting our Fusion environments, consisting of two compute servers and two dbcs base db database servers, with separate servers fo…
-
Upgrade 26aiHi Team, We are currently evaluating an upgrade from Oracle Database 19c to Oracle AI Database 26ai. From a DBA perspective, I would like to understand the AI-related ca…
-
Upgrade OCI Base Database Service from 19.28 to Oracle AI Database 26aiHi All, We are currently managing OCI Base Database Service environments running Oracle Database 19.28 with CDB/PDB architecture. As part of an AI initiative, we are pla…
-
Upgrading specific pdb - OCI console basedbHi Team, Please help us understand the upgrade of specific PDB in CDB. In one of our environment, we have CDB with 2 PDB(test & uat). Looks like there is no option to up…
-
Oracle DashboardsHi Team, Oracle databases hosted in OCI, many of these capabilities are already available through native OCI services and dashboards, including: Database availability an…
-
Testing file upload to OCI Object StorageHi Team, We have an APEX application hosted on a Base Database Service (DBCS). Currently, user-uploaded files from apex are stored on the DBCS server under the /u01 file…
-
Network Stats for BaseDBHi Team, We are able to view NetworkBytesIn and NetworkBytesOut metrics for Compute instances through Metrics Explorer to monitor network traffic. However, we could not …
-
Uploading files from apex to object storageHi Team, We have reviewed the recommended options suggested: https://community.oracle.com/customerconnect/discussion/comment/1694897 For immediate option for minimal cha…
-
APEX 24.2 OCI Web Credential Authentication Failed with APEX_WEB_SERVICE.MAKE_REST_REQUESTHi Team, I'm testing Oracle Cloud Infrastructure (OCI) Web Credentials in APEX 24.2 and facing an authentication issue when calling OCI Object Storage using APEX_WEB_SER…
-
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…
-
Recommended approach to email backup log files from OCI Compute/DBCSHi Team, We have a daily backup script running on an OCI Compute/DBCS instance. The script performs an rsync operation to copy files from one location to another locatio…
-
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…