SORA Magazine - Swiss Oracle User Community - SOUC
  • Home
  • Authors
  • Tip Cards
  • SOUC
  • Get in touch!
  • Become an Author!

Select Page

Community Tips

SORA regularly publishes community tips! – If you have a tip you want to share, click on the button on the right!

Submit Community Tip

swissouc

SORA's Tip #57 Use DBMS_APPLICATION_INFO to instr SORA's Tip #57

Use DBMS_APPLICATION_INFO to instrument your PL/SQL code.

#CommunityTips #SwissOUC #sql
SORA's Tip #56 Better spend 5sec workload doing t 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 #sql
SORA's Tip #55 Make it possible for everyone on t SORA's Tip #55

Make it possible for everyone on the team to put changes into production!

#CommunityTips #SwissOUC #sql
SORA's Tip #54 The qb_name hint allows you to nam SORA's Tip #54

The qb_name hint allows you to name your SQL subqueries in the execution plan!

#CommunityTips #SwissOUC #sql
SORA's Tip #53 Putting 200+ columns into a flat t SORA's Tip #53

Putting 200+ columns into a flat table is not analytical data modeling!

#SwissOUC #CommunityTips
SORA's Tip #52 Don't be afraid to ask questions! SORA's Tip #52

Don't be afraid to ask questions!

#SwissOUC #CommunityTips
SORA's Tip #51 Always label the axes of your char SORA's Tip #51

Always label the axes of your charts!

#SwissOUC #CommunityTips #reporting
SORA's Tip #50 Communication is key! #SwissOUC SORA's Tip #50 

Communication is key!

#SwissOUC #CommunityTips
SORA's Tip #49 When doing changes, test them in a SORA's Tip #49

When doing changes, test them in an integration environment first, before putting them into production!

#CommunityTips #SwissOUC
SORA's Tip #48 Never use UPDATE without a WHERE c SORA's Tip #48

Never use UPDATE without a WHERE clause!

#SwissOUC #CommunityTips #sql #OracleDatabase
SORA's Tip #47 You're not supposed to use pie cha SORA's Tip #47

You're not supposed to use pie charts in reporting.

#SwissOUC #CommunityTips #OracleDatabase #reporting
SORA's Tip #46 Always keep on learning! #Communi SORA's Tip #46

Always keep on learning!

#CommunityTips #SwissOUC
SORA's Tip #45 If you are writing a database migr SORA's Tip #45

If you are writing a database migration, check at the beginning if the migration is aleeady done.

#CommunityTips #SwissOUC #sql #plsql #OracleDatabase
SORA's Tip #44 Test your High Availability soluti SORA's Tip #44

Test your High Availability solution on a regular basis!

#CommunityTips #SwissOUC #OracleDatabase
SORA's Tip #43 Don't be hard on avoiding redundan SORA's Tip #43

Don't be hard on avoiding redundancy if performance is crucial!

#CommunityTips #SwissOUC #sql #OracleDatabase
SORA's Tip #42 When you are writing PL/SQL code, SORA's Tip #42

When you are writing PL/SQL code, make sure it works efficiently for large amounts of data.

#CommunityTips #SwissOUC #sql #OracleDatabase
SORA's Tip #41 Provide a data access layer to iso SORA's Tip #41

Provide a data access layer to isolate your database objects!

#CommunityTips #SwissOUC #OracleDatabase #sql
SORA's Tip #40 Your Service Level Agreement defin SORA's Tip #40

Your Service Level Agreement defines your High Availability solution.

#CommunityTips #SwissOUC #OracleDatabase
👩‍💻 SORA's Tip #39 Keep your documentatio 👩‍💻 SORA's Tip #39

Keep your documentation up to date with your latest changes!

#CommunityTips #SwissOUC #sql #OracleDatabase
👩‍💻 SORA's Tip #38 You cannot expect goo 👩‍💻 SORA's Tip #38 

You cannot expect good results coming out of bad data.

#CommunityTips #SwissOUC #sql #OracleDatabase
Load More... Follow on Instagram

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!

Follow @SwissOUC
Swiss Oracle User Community
Swiss Oracle User Community @swissOUC

👩‍💻SORA's Tip #57

Use DBMS_APPLICATION_INFO to instrument your PL/SQL code.

#CommunityTips #SwissOUC https://t.co/vTt0jDcUGq
View on Twitter
swissOUC photo
4
12
Swiss Oracle User Community
Swiss Oracle User Community @swissOUC

👩‍💻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
View on Twitter
swissOUC photo
0
2
Swiss Oracle User Community
Swiss Oracle User Community @swissOUC

🤩🎉 #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
View on Twitter
swissOUC photo
1
10
Swiss Oracle User Community
Swiss Oracle User Community @swissOUC

👩‍💻SORA's Tip #55

Make it possible for everyone on the team to put changes into production!

#CommunityTips #SwissOUC https://t.co/vCqOKiCBLi
View on Twitter
swissOUC photo
0
6
Swiss Oracle User Community
Swiss Oracle User Community @swissOUC

👩‍💻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
View on Twitter
swissOUC photo
3
10
Swiss Oracle User Community
Swiss Oracle User Community @swissOUC

👩‍💻SORA's Tip #53

Putting 200+ columns into a flat table is not analytical data modelling!

#CommunityTips #SwissOUC https://t.co/i9NpPwUUDu
View on Twitter
swissOUC photo
1
5

© Swiss Oracle User Community