DBCS
Discussion List
-
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 …
-
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…
-
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…
-
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…
-
Metrics in DB system for CDB instance - OCI consoleHi Team, Current Logons,Parse count (total),Block Changes,Execute Count shown in DB system for CDB instance ---> Are these aggregated across the entire instance, which i…
-
Enable Diagnostics & ManagementHi Team, We are using oci base database service 19c version. We are trying to set basic database management for our base DB, Enable Diagnostics & Management. We are usin…
-
Database Management for OCI Base Database ServiceHi Team, Could you please confirm whether Database Management for OCI Base Database Service is a free feature? Specifically, we are planning to use Database Monitoring M…
-
Oracle Base Database Service on VM(DBCS VM)Dear Team, The environment is Oracle Base Database Service on VM(DBCS VM,) and we want to upload and retrieve files from application hosted in DB. We will have around 60…
-
Best database option in oracle cloud i.e. optimal in cost? Executed via Oracle Integration CloudSummary: I would like to know what is best database option we have in oracle cloud that is optimal in cost? Content (please ensure you mask any confidential information)…
-
backup destination of DBCS system from object storage to autonomous recovery serviceHi Team, We have changed backup destination of DBCS system from object storage to autonomous recovery service yesterday. After the change, in oci screen, it showed a mes…
-
Backup size in DBCS object storageDear Team, We are using oracle dbcs with automatic configured backups to object storage. We are trying to find the size of the backups in object storage. But looks like …
-
Index - Performance queryHi Team, We are using Oracle Database 19.28 version. We need your support in fixing the below SQL query appeared in SQL ordered by Elapsed Time in AWR report. CPU consum…
-
ORDS standalone port running on tcp6 port unable to connectSummary: ORDS standalone port running on tcp6 port unable to connect. ORDS version is 25.3 and how to make standalone port to run on tcp(IPV4) port. Content (please ensu…
-
ORA-20401: Authorization failed for URI using dbms_cloud access to object storageSummary: Getting authorization failed error connecting to the object storage from oci base 23 ai db. ORA-20401: Authorization failed for URI - https://objectstorage.us-c…
-
ORA-20401: Authorization failed for URI-dbms_cloud.put_object - Error While Creating Object—Create Credential ; BEGIN DBMS_CLOUD.CREATE_CREDENTIAL( credential_name => 'XXOBJ_CDN', username => 'xxemail@oracle.com', password => '112121' ); END; —Put Object Proce…
-
Oracle Database AIHi Team, We are planning to upgrade DBCS Oracle Base Database Service from19c to 23. Please kindly share with us about which version of 23 have AI features. Thanks, Sati…
-
Problem Connecting to Autonomous DatabaseSummary: Signed up for free trial → created database (instance type free) → trying to connect from desktop sql developer Never thought this would be so difficult - was s…
-
For OCI 2-node DBCS can we manually assign private IP address?Summary: For an Oracle cloud Infrastructure 2-node DBCS, is it possible to manually assign a private IP address during provisioning? Alternatively, is there an option to…
-
standby log apply pauseSummary: Hi, I have a critical activity to perform and part of the plan is to disable standby´s log apply temporarily : if everything goes well at primary site, log appl…
-
Help Understanding Binary Vectors and Jaccard Distance in Oracle DatabaseDear Team, Could you please help me understand the concept of binary vectors in the context of Oracle Database? Additionally, I would appreciate it if you could provide …Sridhar Gupta Yerram-Oracle 11 views 4 comments 0 points Most recent by Avishek Mazumdar-Oracle Database