Sign In

Ubee Kwon

Oracle performance database engineer

Ubee Kwon is a Data System Engineer at Ally, with over 20 years of experience as an Oracle database administrator. He has a strong focus on resolving performance issues in his current role. Ubee is based in Novi, Michigan and is actively involved in the financial technology sector. His professional background emphasizes a deep expertise in database management and system performance optimization.12

Highlights

Oct 11 · linkedin

Today, I encountered a typical execution plan issue related to skewed data. The table contains millions of records. One column's data is skewed, meaning it's not evenly distributed in terms of NDV (number of distinct values). The value '0' accounts for 99% of the rows, while the rest are taken up by other values. A histogram is present, and there's an index on the column. A query access the column via a bind variable. Sometimes the passed value is non-zero, and at other times, it's zero. The Oracle optimizer chooses the index even for the zero value. This is when the query performance suffers. It will take a couple of executions for CBO to figure out and correct the execution plan. What will be an ultimate solution to this?

Aug 16 · linkedin

I have obtained AWS SAA cert lately. While preparing for it I have learned some basics of cloud concepts and practices. It was an awesome experience.

Related Questions

What specific projects has Ubee Kwon worked on at Ally?
How did Ubee Kwon transition from Oracle database administration to data system engineering?
What are some common performance issues Ubee Kwon resolves in their current role?
What skills does Ubee Kwon bring to their position at Ally?
How long has Ubee Kwon been with Ally?
Ubee Kwon
Ubee Kwon, photo 1
Ubee Kwon, photo 2
Add to my network

Location

Novi, Michigan, United States