Maria Colgan shared, “The longer an application has been successfully run, the more likely you are to have indexes that are no longer used or beneficial. Removing these indexes not only saves space but can also improve the performance of any DML operations. But knowing which indexes can be safely dropped can be tricky.
In Oracle Database 12c, things got a little easier with the introduction of a new view called DBA_INDEX_USAGE.”
Read the blog for more details.
This blog begins by saying, “We previously had an infrastructure running Oracle Enterprise Manager Cloud Control 13.2 version on Solaris OS. Upon upgrading our database version from 12 to 19c, we encountered numerous errors due to the failure to update our application version an oversight that proved to be a significant mistake. Despite our efforts, we couldn’t manage to upgrade the Oracle Cloud Control application. Consequently, we decided to proceed with a clean install. In this article, I will detail the step-by-step process of applying the Update 17 patch on Oracle Cloud Control 13.5 software.”
3. Oracle SQL Developer Extension for VS Code
This blog goes through:
- Setup
- Installation and Connections Tutorial
- Oracle SQL Developer vs Oracle Developer Tools Extension
- Common Functionality – Key Features
- Connection and Object Browser
- SQL Worksheet
- Quick Fixes for Errors
- Explain Plan
- Live Code Completion
- New Features
- GitHub Copilot
- Integrated SQLcl
- Breadcrumbs
- Scroll Ribbon
- Generating Queries for Objects
- SQL Snippets
- Pin Tabs
- Current Limitations
- Results Filtering
- No Commit or Rollback Buttons
- No Creation Wizard for Objects
- What’s Next
4. How to get all historical changes on default values of Oracle Database parameters
Rodrigo Jorge shares this video:
5. Similarity Search with Oracle’s Vector Datatype
Bobby Curtis shares, “In my last two posts I showed you what the Oracle Vector Datatype is and how to update existing data after adding a vector datatype column. In this post, we are going to quickly look at how to use those examples to implement a “similarity search” based on the vector stored in the vg_vec1 column of the table.”
6. Directly connect to your OCI Compute Instances from the OCI Console
This blog shares the below video:
In this blog, Satishbabu Gunukula begins his blog with, “SQL Firewall inspects all incoming statements and ensures only authorized SQL is run and it is embedded in the Oracle Database and unauthorized SQL Statements will be logged and blocked. SQL firewall provides real-time protection from attacks and mitigate risks from SQL injection attacks, anomalous access, credential abuse or theft. SQL Firewall supports all commands except transaction control commands such as SAVEPOINT, COMMIT, ROLLBACK.”
8. Oracle APEX – Compared to Microsoft Power Apps
This blog states, “The purpose of this blog post is to offer a detailed comparison between Oracle APEX and Microsoft Power Apps, equipping you with the insights necessary to make a knowledgeable decision.
Comparing Oracle APEX and Microsoft Power Apps is not a straightforward task, as they serve different purposes and cater to different user bases. In the following sections, we will present the features and limitations of both platforms.”
9. Tips for APEX Application Constants – How to use Text Messages for Constants
Martin Giffy D’Souza says, “It’s very common for APEX application to have application level items (usually these are named APP_... or G_... and are defined in Shared Components > Application Items). For values that are unique to a given user/session application items are a logical place to store them (ex: APP_USER_ID). When the item contains a value a new row is inserted into the apex_application_items table (this is really a view but there’s an underlying table that stores the value).”
10. Oracle SQLDev extension for VS Code Update, 23.4.1
Jeff Smith writes, “We’ve just published our first update! Big thanks to all of our early adopters who shared feedback, primarily on the Extension Marketplace Q&A and our Forums.
Based on that feedback, we’ve identified and fixed a couple dozen bugs and opportunities for improvement. You can see the entire changelog here. But I want to call out a couple of the biggest ones.”
These are:
Fix #1 Default to Best Fit on the Grids
Fix #2 Remember :binds on Statement Execution