All
Popular
Firefighting “updates” with “merge”
I was recently invited to a meeting in advance of a maintenance window for one of the biggest...
Read More
Oracle Exadata: A Truly Disruptive Technology – Journey of Von Neumann’s Architecture to RoCE V2
Do you believe that most of the modern computers are still using the architecture of 1945? In this...
Read More
What to do when RMAN „forgets“ the datafile backupset
Please note that to view the My Oracle Support documents linked in this post you have to register...
Read More
How to capture used privileges in an Oracle Database? – Part 2
In the first part of this blog post, we described what Privilege Analysis is and explored its...
Read More
Setting up Oracle Cloud Free tier
Starting with Oracle is complex and requires time, right? Everybody keeps saying that, so it must...
Read More
How to get the ddl of a database object with Data Pump
In the first blog post – How to get the DDL of a database object with dbms_metadata –...
Read More
Database Unit Testing – The setup and bigger picture
The previous article – An introduction into unit testing of your database –...
Read More
How to capture used privileges in an Oracle Database? – Part 1
Have you ever been in a situation where users in a database seem to have way too many privileges?...
Read More
Stand-alone installation of Oracle Graph Server
With the first release of Oracle Graph Server 20.1 at the beginning of 2020, Oracle made the...
Read More
An introduction into unit testing of your database!
Unit Tests in the database are still not used in all database applications. This lack of testing...
Read More
Meet SORA
Hi, I'm SORA, the Swiss Oracle User Community mascot!
👩💻SORA's Tip #57
Use DBMS_APPLICATION_INFO to instrument your PL/SQL code.
#CommunityTips #SwissOUC https://t.co/vTt0jDcUGq
👩💻SORA's Tip #56
Better spend 5sec workload doing things physically ONCE rather than degrade logical query performance of 200’000 queries by 0.5 sec each.
#CommunityTips #SwissOUC https://t.co/orYaP65RSu
🤩🎉 #OracleBeerBern and #OracleBeerZürich have got new logos! Thank you @edorexAG for the design! ❤
📅If you don't want to miss future events, join the meetups here 🔽
https://t.co/QcjOqkxZoZ
🔽
https://t.co/20wAbnR1pB https://t.co/MyB89bVOn9
👩💻SORA's Tip #55
Make it possible for everyone on the team to put changes into production!
#CommunityTips #SwissOUC https://t.co/vCqOKiCBLi
👩💻SORA's Tip #54
The qb_name hint allows you to name your SQL subqueries in the execution plan.
#CommunityTips #SwissOUC https://t.co/BlDFQqjlRx
👩💻SORA's Tip #53
Putting 200+ columns into a flat table is not analytical data modelling!
#CommunityTips #SwissOUC https://t.co/i9NpPwUUDu
