SORA Magazine - Swiss Oracle User Community - SOUC
  • Home
  • Authors
  • Tip Cards
  • SwissOUC
  • 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
🍻Join the first #OracleBeerBern of 2023 on 2. March! πŸ“…
#SwissOUC https://t.co/AEf9Fn3bEH
View on Twitter
Julian Frey@JulianFreyCH
Nach viel zu langer Zeit halten wir das nÀchste #OracleBeerBern Meetup ab 🍻

"Testautomatisierung fΓΌr Infrastruktur und DB as Code"

πŸ—“οΈ02.03.2023 18:00 in Bern
@oracleace @swissOUC #ansible #IaC

πŸ‘‡ Meldet euch jetzt anπŸ‘‡

https://t.co/oOXJpgc8Wn
1
0
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
And we are on! πŸš€ Round one of #TechPubQuiz started! πŸƒ

https://t.co/S7uZyaySog
#SwissOUC #OracleBeerBern https://t.co/rOwYkIDMuK
View on Twitter
swissOUC photo
3
6
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
πŸ—“ Tonight the 10th edition of #TechPubQuiz starts at 8pm CET!

πŸƒIf you haven't registered, head over to our meetup page and make sure to refrigerate some refreshing beverages! 🍺πŸ₯‚πŸ₯›πŸΆ

https://t.co/S7uZyaySog
#OracleBeerBern #SwissOUC
View on Twitter
4
7
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
What would be your favourite food choice for a #SwissOUC community event in Switzerland? πŸ«•πŸ§€πŸ₯”πŸ₯˜

Go vote! ‡️ https://t.co/icSouRcPGv
View on Twitter
Jasmin Fluri@jasminfluri
@alexnuijten @JulianFreyCH @dani_schnider @swissOUC @RoelH I know you said fondue, but for the event food discussions that might or might not happen: what's the real favorite? Who's for...
4
5
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
πŸ”½ The 10th edition of #TechPubQuiz is happening in January! Head over and register! ✏ https://t.co/UdQHJPf0bD
View on Twitter
Julian Frey@JulianFreyCH
In two weeks we will start the year with the TechPubQuiz #10πŸ₯³
More than enough time to ✍️ up
@swissOUC #TechPubQuiz @oracleace

https://t.co/sHGEk283Tf
3
6
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
It's great to have a chance to meet the local #datacommunity again! πŸ’¬
Have a great #datacomconf2022! https://t.co/QwxbUjcaBW
View on Twitter
swissOUC photo
3
10

© Swiss Oracle User Community