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

This error message is only visible to WordPress admins

Error: Access Token is not valid or has expired. Feed will not update.

Meet SORA

Subscribe

Swiss Oracle User Community

Swiss Oracle User Community @swissOUC

🍺🎲The best way to spend a rainy evening at home - join #TechPubQuiz at 8:00 CEST!

There's still enough time to register and put refreshing drinks in the fridge! 🃏💻

Register now! 🔽
https://t.co/eJKJ8ZTfbP

#OracleBeerBern #SwissOUC

View on Twitter

Swiss Oracle User Community

Swiss Oracle User Community @swissOUC

☀🏝To celebrate summer break, we'll have the fourth edition of #TechPubQuiz on Thursdays!

💻Join us at 8:00 p.m. CEST for the online quiz!
It's free and for everybody interested in tech!

🔽Register now!
https://t.co/eJKJ8ZTfbP

#SwissOUC #OracleBeerBern

View on Twitter

Swiss Oracle User Community

Swiss Oracle User Community @swissOUC

#SwissOUC will be part of the #OGBEMEA virtual tour this fall! 🎬👩‍💻

If you want to be part of it as a speaker, the #CfP is open until August 15! 📑📆
Submit below!
🔽
https://t.co/g9gYZwaRVy https://t.co/mA8PGiAoZT

View on Twitter

Swiss Oracle User Community

Swiss Oracle User Community @swissOUC

📑 Both #OracleBeerBern and #SwissOUC are now listed on the @SwissDevJobs #community site!

🔍Go check it out to discover interesting meetups, hackathons and communities! 👩‍💻👨‍💻

🔽
https://t.co/i7vnbOJ3gB https://t.co/Jp8bgOfkRK

View on Twitter

Swiss Oracle User Community

Swiss Oracle User Community @swissOUC

👩‍💻 SORA's Tip #103 by @martinberx

Before messing with OPTIMIZER_INDEX_COST_ADJ, think if the preference TABLE_CACHED_BLOCKS on a given table can do a better job.

#SwissOUC #CommunityTips https://t.co/kfSrjsbY3P

View on Twitter

Swiss Oracle User Community

Swiss Oracle User Community @swissOUC

📆Save the date!📆

The last https://t.co/6Wty4u9v0h before the summer break will take place in exactly one month! 🎲🃏

🔽08.07.2021🔽
https://t.co/eJKJ8ZTfbP

#SwissOUC #OracleBeerBern

View on Twitter