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 #100 Database design flaw 👩‍💻 SORA's Tip #100 

Database design flaws will have an impact on its performance! 

#SwissOUC #CommunityTips
👩‍💻 SORA's Tip #99 Remember that SYSDATE 👩‍💻 SORA's Tip #99

Remember that SYSDATE returns the time and date of your DBs operating system!

#SwissOUC #CommunityTips
👩‍💻 SORA's Tip #98 If you do not have ref 👩‍💻 SORA's Tip #98

If you do not have referential integrity enforced within the database you have almost certainly got damaged data.

#SwissOUC #CommunityTips
👩‍💻 SORA's Tip #97 If your data is import 👩‍💻 SORA's Tip #97

If your data is important to you then you need to design your database: having an ERD is fundamental.

#SwissOUC #CommunityTips
👩‍💻 SORA's Tip #96 Performance tuning yo 👩‍💻 SORA's Tip #96 

Performance tuning your database without an ERD is like trying to drive a car by steering with your knees.

#SwissOUC #CommunityTips
👩‍💻 SORA's Tip #95 If you have no ERD, do 👩‍💻 SORA's Tip #95

If you have no ERD, do you really know your data?

#SwissOUC #CommunityTips
👩‍💻 SORA's Tip #94 Brook's Law (1975) sti 👩‍💻 SORA's Tip #94

Brook's Law (1975) still applies today: "Adding manpower to a late software project makes it even later."

#SwissOUC #CommunityTips
👩‍💻 SORA's Tip #93 Stop using parameter S 👩‍💻 SORA's Tip #93

Stop using parameter SERVICE_NAMES as it is deprecated. Use DBMS_SERVICE package or srvctl CLI instead.

#SwissOUC #CommunityTips
👩‍💻SORA's Tip #92 PDB default service sho 👩‍💻SORA's Tip #92

PDB default service should only be used for administrative tasks.

#SwissOUC #CommunityTips
👩‍💻 SORA's Tip #91 Always specify the col 👩‍💻 SORA's Tip #91

Always specify the columns in INSERT statements!

#SwissOUC #CommunityTips
👩‍💻SORA's Tip #90 The WHERE-clause filter 👩‍💻SORA's Tip #90

The WHERE-clause filters data before aggregations are applied. To filter aggregationsuse the HAVING clause.

#SwissOUC #CommunityTips
👩‍💻SORA's Tip #89 Table aliases can help 👩‍💻SORA's Tip #89

Table aliases can help you write less when doing JOINS, they also improve your codes readability.

#SwissOUC #CommunityTips
👩‍💻SORA's Tip #88 Instead of using long d 👩‍💻SORA's Tip #88

Instead of using long data value lists in your IN keyword, think about if you can solve it with a JOIN.

#SwissOUC #CommunityTips
👩‍💻SORA's Tip #87 Avoid WHERE clauses wit 👩‍💻SORA's Tip #87

Avoid WHERE clauses with functions when writing SQL statements.

#SwissOUC #CommunityTips
👩‍💻SORA's Tip #86 Do one change at a time 👩‍💻SORA's Tip #86

Do one change at a time - don't change multiple things at once.

#SwissOUC #CommunityTips
👩‍💻SORA's Tip #85 After applying a patch 👩‍💻SORA's Tip #85

After applying a patch to your database verify if your performance workarounds are still required (e.g. Hints, Profiles).

#SwissOUC #CommunityTips
SORA's Tip #84 If you start fixing a broken syste SORA's Tip #84

If you start fixing a broken system, take a backup of the broken system first.

#SwissOUC #CommunityTips
SORA's Tip #83 Agree on a set of coding guideline SORA's Tip #83

Agree on a set of coding guidelines with your team.

#SwissOUC #CommunityTips
SORA's Tip #82 Write down the things you learn! SORA's Tip #82

Write down the things you learn!

#SwissOUC #CommunityTips
SORA's Tip #81 Make sure Grants and Synonyms are SORA's Tip #81

Make sure Grants and Synonyms are created after deploying changes!

#SwissOUC #CommunityTips #sql
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
💬Call to our Swiss / German-speaking bubble:

👩‍🏫Do you want to pass on your #database knowledge to the next generation?

🎓The University of Applied Sciences of Northwestern Switzerland is looking for a lecturer for databases:
https://t.co/HxZXIIPdgY
View on Twitter
2
6
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
Aaaaand, it's on!
#TechPubQuiz #SwissOUC #OracleBeerBern https://t.co/lgv8asu2Lz
View on Twitter
swissOUC photo
Dear DBA Frank@fdernoncourt
Yeah, I won the 1st round of tonight's #techpubquizz organized by @SOUG_CH
#DBAlife https://t.co/mh1sol62hR
1
3
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
🃏🎲Today 20:00 CET the next #TechPubQuiz will take place. 🎙

Enough time to register and fill your fridge! 🥂🍺🥛
🔽
https://t.co/WYD1JsORBF

#OracleBeerBern #SwissOUC @oracleace
View on Twitter
3
7
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
📆Two more days until the 8th edition of #OracleBeerBern #TechPubQuiz takes place!

🚀We are ready and are looking forward to having a great #QuizTime!

✏If you didn't register yet, you still can sign up on the #Meetup page!
🔽
https://t.co/WYD1Jsxgd5

#SwissOUC https://t.co/o6Zo27NC7m
View on Twitter
swissOUC photo
4
10
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
🥳 Congrats to @pdevisser for submitting question 100!

We're really looking forward to next weeks #Techpubquiz! 🃏

If you have not registered, go do it! ⬇️
https://t.co/WYD1JsPprd https://t.co/UV82enDvxf
View on Twitter
Swiss Oracle User Community@swissOUC
❤Wow! We already received 95 questions for #OracleBeerBern #TechPubQuiz! 🤩🤯

Who will submit question 100?

✏💬Submit your question here🔽
https://t.co/EiOTC4Iixc

#SwissOUC
0
5
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
❤Wow! We already received 95 questions for #OracleBeerBern #TechPubQuiz! 🤩🤯

Who will submit question 100?

✏💬Submit your question here🔽
https://t.co/EiOTC4Iixc

#SwissOUC
View on Twitter
2
7

© Swiss Oracle User Community