DBA – Rodrigo Jorge – Oracle Dicas e Guias
405 FOLLOWERS
Blog About Databases and High Availability.
DBA – Rodrigo Jorge – Oracle Dicas e Guias
1M ago
Whenever we patch, upgrade, or migrate our database server, it is important to track what changes we have between the source/target release or patch level to track any possible regressions. One of the things I've been struggling with for years is how to track all the changes that happen to database parameters (including the underscores). …
The post How to get all historical changes on default values of Oracle Database parameters appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
4M ago
Sometimes, I have to debug and troubleshoot something, and I see myself in a position where I need to get the dictionary code of internal Oracle objects, and the most common way to do that is using DBMS_METADATA. Let's say, for example, that I need to get the view SQL code for DBA_USERS we had …
The post How to check the code of the most important Oracle internal objects without having a database appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
4M ago
In my daily work, sometimes I see myself in a position that I need to get the vision of an Oracle dictionary table for a specific release. Let's say, for example, that I need to get the list of all parameters we had back in 12.1.0.2 with July 2021 patch applied. Or maybe, what if …
The post How get the contents of the most important Oracle internal views without having a database appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
5M ago
Oracle Database 19.21 RU was just released! As soon as it is available in My Oracle Support to download, we also add it to ORAdiff app: https://oradiff.oracle.com/ So, what is new? You can check yourself by accessing ORAdiff website and comparing each section, but below I will give a summary of the main changes that …
The post What is new in Oracle Database 19.21 RU appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
7M ago
After 2 intensive weeks, the LAOUC Tour 2023 is over! It was the first tour after the 2019 pandemic and it was great to see all that legion of people interested in Oracle technologies. Over the 7 countries that I've visited during the tour, I gave the 4 sessions above: Secret Features of Oracle Data …
The post LAOUC 2023 Slides appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
1y ago
I had a requirement in one tool that I was working to find whether a given table column was power of 2. The easiest way to check would be using the LOG(2,y). If the result was an integer, the number would be power of 2. 2^X = Y -> LOG(2,Y)=X And …
The post LOG(x,y) returning wrong results in some cases appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
1y ago
In ORDS, I was working with a GET PL/SQL Handler and I need to produce an output variable inside a JSON Object. My ORDS version, as of today, is 22.1.6. Example: BEGIN ORDS.DEFINE_TEMPLATE( p_module_name => 'test', p_pattern => 'test', p_priority => 0, p_etag_type => 'HASH', p_etag_query => NULL, p_comments => NULL); ORDS.DEFINE_HANDLER( p_module_name => 'test', …
The post ORDS output variable inside a JSON Object appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
1y ago
Those days, I had a requirement to create an ORDS endpoint that would call a dynamic SQL. Also, my ORDS endpoint was using a GTT and thus first I needed to load this table with some temporary data. Thus, I was left with no other option than using the PL/SQL handler type in my ORDS. …
The post ORDS pagination with PL/SQL source type appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
1y ago
Below are the 3 views that will list the tables with identity columns in Oracle: USER_TAB_IDENTITY_COLS ALL_TAB_IDENTITY_COLS DBA_TAB_IDENTITY_COLS PS: I know this post does not make any sense, but sometimes I try to quickly find those table names in Google and for whatever reason, Google Indexer can't find proper websites. So I make this …
The post List tables with identity column oracle appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
DBA – Rodrigo Jorge – Oracle Dicas e Guias
1y ago
Those days, I was building a REST API service for retrieving the columns of a checksum table. The table structure was pretty simple: CREATE TABLE "DEMO" ( "PATH" VARCHAR2(500 CHAR), "MD5_HASH" RAW(16) ); INSERT INTO DEMO ( PATH, MD5_HASH ) VALUES ( 'bundle.xml', '70D53BE37073B31347EE42B622EA4A75' ); COMMIT; So, as you can see, very simple table with …
The post Oracle ORDS returns RAW columns as base64 encoding appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more