DBCS
Discussion List
-
Onboarding new account PaaSHi Team, We are planning to onboard a new account supporting Oracle Fusion. As part of that,we will also have a paas environment. It will have dev,uat environment and on… -
Debug large proc/packageHi Team, We recently faced an issue after migrating an APEX application from DEV to UAT. The APEX page was not working as expected, and finally we found that the issue w…
-
Code migration scripts - oracle paasHi Team, we have recently procured a Fusion SaaS environment along with a small PaaS environment where we are hosting Oracle Database, APEX, and ORDS. For our developmen…
-
Object strorage file managementHi team, We are migrating our application files away from a legacy architecture to OCI Object Storage. Our Previous Setup: Previously, our application files lived on a s…
-
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…
-
Guudance on budgets in ociHi team, I can see the Budgets option in the OCI Console. Could you please explain what it is used for? Could you also provide some practical examples of how budgets can…
-
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…
-
Apex uploads Migration from local storage to Object StorageHi Team, Due to the limited storage available on the DBCS /u01 filesystem, we are proceeding with DBMS_CLOUD as the immediate solution to move the application files to O…
-
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…
-
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…