
All


An introduction into unit testing of you...

How to capture used privileges in an Ora...

What to do when RMAN „forgets“ the dataf...
Firefighting “updates” with “merge”
by Julian Frey | Feb 2, 2021 | Getting Started, SQL | 0
I was recently invited to a meeting in advance of a maintenance window for one of the biggest...
Read MoreOracle Exadata: A Truly Disruptive Technology – Journey of Von Neumann’s Architecture to RoCE V2
by Mani Mohan Raj Selvaraj | Jan 19, 2021 | System Engineering | 4
Do you believe that most of the modern computers are still using the architecture of 1945? In this...
Read MoreWhat to do when RMAN „forgets“ the datafile backupset
by Christian Marquardt | Jan 13, 2021 | Database Management | 0
Please note that to view the My Oracle Support documents linked in this post you have to register...
Read MoreHow to capture used privileges in an Oracle Database? – Part 2
by Flora Barriele | Jan 6, 2021 | Database Management, Security | 0
In the first part of this blog post, we described what Privilege Analysis is and explored its...
Read MoreSetting up Oracle Cloud Free tier
by Christian Berg | Dec 29, 2020 | Cloud, Getting Started | 0
Starting with Oracle is complex and requires time, right? Everybody keeps saying that, so it must...
Read MoreHow to get the ddl of a database object with Data Pump
by Julian Frey | Dec 15, 2020 | Database Management | 0
In the first blog post – How to get the DDL of a database object with dbms_metadata –...
Read MoreDatabase Unit Testing – The setup and bigger picture
by Jasmin Fluri | Dec 10, 2020 | PL/SQL, Testing, Toolchain | 0
The previous article – An introduction into unit testing of your database –...
Read MoreHow to capture used privileges in an Oracle Database? – Part 1
by Flora Barriele | Dec 1, 2020 | Database Management, Security | 0
Have you ever been in a situation where users in a database seem to have way too many privileges?...
Read MoreStand-alone installation of Oracle Graph Server
by Gianni Ceresa | Nov 24, 2020 | Graphs | 0
With the first release of Oracle Graph Server 20.1 at the beginning of 2020, Oracle made the...
Read MoreAn introduction into unit testing of your database!
by Jasmin Fluri | Nov 17, 2020 | PL/SQL, Testing | 1
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!
Subscribe
Be part of our community
Join our mailing list to receive the latest news and updates from our community.
You have Successfully Subscribed!
👩💻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
