DBaaS Monitor
Discussion List
-
How to Handle Redo Gaps/Apply Lag and Standby Backups in DBCS Data GuardHi Team, We have an Oracle Database Cloud Service (DBCS) environment with Data Guard configured between the primary and standby databases. In our previous on-premises en… -
OCI Generative AI - Guidance requiredHi Team, We would like to perform a Proof of Concept (POC) using Oracle Select AI. For testing purposes, it appears that we require access to an LLM (Large Language Mode…
-
Object Storage Migration Progress - Files Uploaded for VerificationHi Masi, Thanks for the options suggested in (https://community.oracle.com/customerconnect/discussion/comment/1702235). While performing the migration activity, we recei…
-
Security and Architecture GuidanceHi Team, We have an on-premises application currently deployed with the following architecture: One public IP address is NATed to an HAProxy server. HAProxy routes traff…
-
Analysis of DB-to-Disk File Discrepancy Prior to Object Storage MigrationHi Masi, We have refreshed the required data and files from PROD to TEST environment. We are currently migrating existing files from local storage to Object Storage. As …
-
Practical Use Cases of Oracle AI for SQL Optimization and TuningHi Team, I would like to understand the practical application of AI in Oracle Database performance tuning and SQL optimization. Traditionally, Oracle Database has provid…
-
Security - Small OCI environmentsHi Team, We are evaluating whether security best practices in our environment and would appreciate your guidance on its practical benefits, use cases, and cost implicati…
-
Oracle Database 26ai - How to Demonstrate Select AI (POC)?Hi Team, We have a test environment running Oracle Database 26ai and would like to build a simple Proof of Concept (POC) to demonstrate Oracle Select AI capabilities to …
-
rsync - copying files from prod to uatHi Team, We are choosing option 1 as suggested in https://community.oracle.com/customerconnect/discussion/comment/1699182#Comment_1699182 Option 1: Full directory synchr…
-
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
-
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…
-
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 …
-
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_…