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
Closing our afternoon we have @amitzil talking about how to create order in the Oracle database patching chaos.
It just started, still time to join us: https://t.co/V6Hf8b31bK

This ends the sessions we are hosting.
Check the coming days of #OGBEMEA at https://t.co/FFLHhnWmf4 https://t.co/2phfC7kuUD
View on Twitter
swissOUC photo
3
9
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
Second to last session for our afternoon of #OGBEMEA hosted by #SwissOUC is with @mjgangler presenting about "Managing DBA Applications With APEX".
And it starts with some philosophy that apply to many projects.

Still time to join us https://t.co/V6Hf8bkC3i https://t.co/NijXyXMHIa
View on Twitter
swissOUC photo
0
3
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
Do you ever ask yourself what a DBA should know about the Oracle REST API?
@JulianFreyCH is answering that question right now on the #OGBEMEA second afternoon hosted by #SwissOUC.

Join now, and there are 2 more sessions after this one.
https://t.co/V6Hf8b31bK

@OracleREST https://t.co/giOt5uzach
View on Twitter
swissOUC photo
3
4
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
Second session of today is @MikeDietrichDE and @dohdatabase talking about upgrades and migrations new features with 21c.

This is part of the #OGBEMEA virtual tour second afternoon hosted by #SwissOUC.

Still not too late, join us online: https://t.co/V6Hf8b31bK https://t.co/DItr1zqgiG
View on Twitter
swissOUC photo
2
4
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
The second afternoon of #OGBEMEA hosted by #SwissOUC started!

@phsalvisberg is delivering a great session full of super heroes

You can still join us, go on https://t.co/V6Hf8b31bK and click the "register" button! https://t.co/S5j8Zjdg5r
View on Twitter
swissOUC photo
2
5
Swiss Oracle User Community Swiss Oracle User Community ·
@swissOUC
We are getting started soon with our second #OGBEMEA afternoon! 🚀💻

Last chance to register ⏬
https://t.co/V6Hf8b31bK
#SwissOUC https://t.co/kKtLx2Rj6O
View on Twitter
swissOUC photo
CASOUG@CentralAsiaOUG
#CentralAsiaTechConf (as a part of #OGBEMEA Virtual Tour 2021) has finished, see you soon on sessions of
@swissOUC.

Thank you for your participation!

#Tajikistan #Uzbekistan #Kyrgyzstan #CentralAsia
@groundbreakers @oracleace @EOUC https://t.co/Jbww6pc29M
2
4

© Swiss Oracle User Community