Skip to content
GotoDBA
  • Blog
  • Presentations
  • Speakers
    • Speakers / Speaking
    • Becoming a Speaker
    • Building a Presentation
  • Consultants
    • Becoming a DBA Consultant
    • 8 things DBA Consultants Do
    • Before You Become a Consultant
    • Before You Become an Independent Consultant
    • Different Types of Projects for a Consultant
    • Personal Skills
    • Workplace Politics
    • The DiSC Assessment
    • Meeting a New Client
    • Financial Management
  • Podcast
  • Services
  • About
    • About Me
    • Contact
Close Button
Twitter Linkedin

High CPU With Queries Without Bind VariablesHigh CPU With Queries Without Bind Variables

August 6, 2020August 6, 2020 | Liron AmitziLiron Amitzi | 0 Comment | 8:45 am

Performance problems can be tricky, and everyone has a different method to approach them depending on the exact issue. In this case I’d like to cover a specific case of

Read MoreRead More

Moving ASM Diskgroups to another ServerMoving ASM Diskgroups to another Server

July 29, 2020July 29, 2020 | Liron AmitziLiron Amitzi | 3 Comments | 8:40 am

Lately I saw two posts about ASM diskgroups. One by Rodrigo Mufalani talking about migrating ASM diskgroups to another server after failure. The other one by Michael Dinh talking about

Read MoreRead More

Setup.exe -applyRU in WindowsSetup.exe -applyRU in Windows

July 21, 2020July 21, 2020 | Liron AmitziLiron Amitzi | 0 Comment | 8:25 am

After I created a gold image for 18.7 on Linux and wrote this post about it, it was time to do the same for Windows. But here things weren’t so

Read MoreRead More

Many Usm Processes in Oracle RestartMany Usm Processes in Oracle Restart

July 13, 2020July 13, 2020 | Liron AmitziLiron Amitzi | 0 Comments | 8:31 am

This is something I’ve seen for a while now. It all started when I upgraded an Oracle Restart environment from 11.2.0.4 to 18.7. Suddenly our monitoring system alerted that the

Read MoreRead More

ORA-01722 During Upgrade to 18.10ORA-01722 During Upgrade to 18.10

July 2, 2020July 2, 2020 | Liron AmitziLiron Amitzi | 3 Comments | 3:32 pm

These days I’m in the progress of patching all databases for a specific client to 18.10 (from 18.9 as we need to be up to date). However, we realized that

Read MoreRead More

Upcoming (and Past) Online Sessions and WebinarsUpcoming (and Past) Online Sessions and Webinars

July 2, 2020July 2, 2020 | Liron AmitziLiron Amitzi | 0 Comment | 8:34 am

As we all know, there will be no in-person conferences anytime soon, but at least with the technology today, we can have virtual conferences and meetups. In the past few

Read MoreRead More

Oracle Real Memory UsageOracle Real Memory Usage

June 17, 2020June 17, 2020 | Liron AmitziLiron Amitzi | 3 Comments | 8:17 am

I’ve been struggling with that for a while now, so in this post I’d like to explain what I’ve found so far and what I’m missing. If you can help

Read MoreRead More

Patching a Standby Database ConfusionPatching a Standby Database Confusion

May 20, 2020May 20, 2020 | Liron AmitziLiron Amitzi | 2 Comments | 8:55 am

In my post “all you need to know about Oracle database patching” I wrote the following procedure for patching a physical standby environment (for standby-first patches, assuming serverA is currently

Read MoreRead More

Did You Know #36 – List All Active RolesDid You Know #36 – List All Active Roles

May 13, 2020May 13, 2020 | Liron AmitziLiron Amitzi | 0 Comment | 8:38 am

When granting roles to users we need to remember two things: Any child role of the granted role is granted to the user as well (and this is hierarchical) You

Read MoreRead More

Oracle 20c DBCAOracle 20c DBCA

May 7, 2020May 7, 2020 | Liron AmitziLiron Amitzi | 0 Comment | 5:47 pm

As you probably know, Oracle 20c is available only as a preview on the cloud. If you’d like to create a new server on Oracle Cloud with 20c, here is

Read MoreRead More

Posts pagination

Previous 1 … 3 4 5 … 25 Next

Subscribe

Top Posts

  • Oracle Real Memory Usage
  • Checking SQL Progress in Oracle
  • SEHA - Standard Edition High Availability in Oracle DB
  • Analyzing the Listener.log
  • Oracle Data Guard Explained - Step By Step

Categories

  • Cloud (3)
  • Conferences (30)
  • Database Development (48)
  • Database Security (5)
  • Database Thoughts (26)
  • Database Tuning (29)
  • DB Camparison (5)
  • Did You Know (37)
  • Features (59)
  • Funny (1)
  • How Things Work (34)
  • Infrastructure (72)
  • Other stuff (30)
  • Troubleshooting (35)
  • Uncategorized (4)
  • Upgrade (11)

My Twitter

My Tweets

RSS Feed

  • RSS - Posts
  • RSS - Comments
Copywrite and disclaimer information
Privacy policy

Industrial WordPress Theme © Liron Amitzi, GotoDBA.com, 2019. Powered by

Scroll Up