Performance
Discussion List
-
GA Announcement: Set CPU/IO Shares for Autonomous Data WarehouseSummary Autonomous Database now allows customers to change the CPU/IO shares for the consumer groups within their ADB instance (high, medium, low, tp, tpurgent).Content …Keith Laker-Oracle 23 views 2 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database -
Announcing new advanced monitoring for Autonomous Databases with OCI Database ManagementWe are excited to announce that OCI Database Management service now has new, easy-to-use tools that enable advanced monitoring and management of ADB resources. These too…
-
May's latest new feature announcements for Autonomous DatabaseSummary: As May comes to a close, here is information about the new features released during the last 2 weeks along with some customer success stories. Don't forget to s…
-
Query on data storage/performanceSummary: Due to excess data (5M records) causing performance issues and a heavy load on the application, we have decided to migrate the aged data to the Oracle database.… -
My database keeps stoppingSummary: I am using Always Free tier Autonomous Database. It stops continuously. Content (required): I think that same question is below. I have the problem that my ADB …User_2025-03-07-06-14-47-860 131 views 23 comments 0 points Most recent by Sasa M. Autonomous Database
-
ANNOUNCEMENT: February's newsletter covering all the latest new features in Autonomous DatabaseList of all the new features recently added to Autonomous Database (too many to list) in our regular "What's New" newsletter - https://blogs.oracle.com/datawarehousing/p…Keith Laker-Oracle 81 views 2 comments 3 points Most recent by Jayendra G-Oracle Autonomous Database
-
Star TransformationIn a shared ADW instance, does the Star Transformation works? If yes, then how can we make sure that the same can be enable for the SELECT statements. Is it by setting v…SaurabhJaiswal-Oracle 62 views 1 comment 0 points Most recent by Sarma NS-Oracle Autonomous Database -
Cannot create table clusters on ADB shared infrastructureSummary: Cannot create table clusters on ADB shared infrastructure Content (required): Is it intended that u cannot assign tables to clusters on adb? Instead Oracle is c…
-
Why does my ADB keep stopping?Summary: I am using an Always Free tier Autonomous Database with workload type Data Warehouse. It keeps stopping and every time I start it again it will stay up for 1-5 …
-
Automatic Indexing enabled?Content https://cloudcustomerconnect.oracle.com/resources/ae46f0cd09/posts/create?type=6 According to the document, Automatic Indexing is enabled in ATP. By default does…
-
Oracle Autonomous Database - check used storage spaceSummary: Content (required): Hello. I recently noticed that my Autonomous Database is running out of free storage space. This is strange since I store a small amount of …
-
Does ATP on shared infrastructure support shared server architecture?Summary: Content (required): ATP on dedicated infrastructure supports shared server infrastructure. Check https://docs.oracle.com/en/cloud/paas/autonomous-database/adbcc…
-
Hi I am facing issue while fetching ORDS records limit more than 1000Summary: Hi , I am trying to fetch all tables records from ATP database using ORDS service but I am only getting 1000 records after setting ?limit=1001&offset=25 when I … -
Are there issues with Autonomous Database in Frankfurt region ?Summary: Since this afternoon (CET) the free tier instance in the Frankfurt region is having issues. Content (required): We're experiencing disconnections and slowness s…User_303W0 12 views 1 comment 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
Autonomous Database Now Supports SQL Tracing To Cloud Object StoreContent If you are an experience Oracle developer or DBA then you will know all about the benefits of using SQL tracing and how it can help identify the source of an exc…Keith Laker-Oracle 22 views 0 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
ADW ArchitectureContent Hi team, Are there any resources regarding architecture of ADW, whether the architecture of ADW comprises of any 2-tier or 3-tier layer? Thanks and Regards Ankan
-
ORDS - 500 Internal Server Error when using Ressource limitsSummary Setting a Ressource Query time limit for "Low" and ORDS will stop working (500 Internal Server Error)Content Steps to reproduce (on free tier cloud) 1. Create an… -
Can an APEX page generate a URL link?Content Hi team, I just want to know, can an APEX page generate a URL link so that an external application can redirect to that particular APEX page? So there is this mi…
-
to integrate MS SQL Server dB with ADWContent Can we integrate SQL Server dB with Oracle ADW using Oracle Application Integration where operations like POST,GET,PUT can take place between ADW and SQL Server …
-
Oracle DataSafe Product Enhancement IdeasSummary Oracle DataSafe Product Enhancement IdeasContent Hi Team, We have been using Oracle DataSafe on ADW for sometime now. We use Data Masking functionality extensive…User_2025-02-10-16-52-46-302 26 views 2 comments 0 points Most recent by User_2025-02-10-16-52-46-302 Autonomous Database -
GA ANNOUNCEMENT - Oracle Cloud Infrastructure Operations InsightsContent Oracle Cloud Infrastructure Operations Insights provides 360-degree insight into database resource utilization and capacity. It is FREE to use with ADW and ATP -…Keith Laker-Oracle 24 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Download AWR Reports From Performance HubContent Automatic Workload Repository (AWR) report is a vital tool to collect historical performance statistics of an Oracle Database by DBAs and System Performance engi…Keith Laker-Oracle 25 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Everything is broken. 503 ErrorSummary APEX, SQL Developer, Admin Reset, Restart, Stop, Start.... all do not workContent ------ EDIT: SOLVED ISSUE ------- This was not an APEX issue, but an Always-Fre…User_2025-02-10-08-19-53-983 41 views 9 comments 0 points Most recent by User_2025-02-08-02-57-36-009 Autonomous Database
-
ATP Database keeps stoppingSummary Database stops by itselfContent I have had this problem for the past few days: my ATP database stops by itself shortly (about 10 minutes!) after starting. Someti…User_2025-02-08-03-46-11-023 31 views 1 comment 0 points Most recent by Mohammed Appas Autonomous Database
-
GA ANNOUNCEMENT - Latency Metrics Now Available in Service MetricsContent The Database Service Metrics information help Cloud Admins measure useful quantitative data about their Autonomous Databases. This list of available metrics now …Keith Laker-Oracle 24 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Performance Hub Now Has a Timezone SelectorContent A time zone control has been added to Performance Hub. This will allow users to view data using an alternate time zone to UTC. They will have the choice of viewi…Keith Laker-Oracle 63 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Workload Metrics on Performance HubSummary Performance Hub has been expanded to include a new tab, "Workload". This can be used to monitor the workload in the database and helps the user identify performa…
-
GA Announcement: Support For Hybrid Partitioned Tables Now Available (19c Preview only)Summary Support For Hybrid Partitioned Tables Now Available (19c Preview only)Content Hybrid partitioned tables allows a query to access both internal data and multiple …Keith Laker-Oracle 13 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Annoncement: Support for External Partitioned Tables Now AvailableSummary This new feature, external partitioned table, creates the ability to query multiple data files in the Object Store as a single external tableContent This new fea…Keith Laker-Oracle 22 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
OCI Performance Hub real-time monitoring now available for ADBSummary You can now get a real-time and historical view of performance data directly on the OCI console using Performance Hub.Content You can now get a real-time and his…Keith Laker-Oracle 26 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database