amitzil.wordpress.com
Did You Know #8 – Identifiers | amitzil - Oracle DBA blog
https://amitzil.wordpress.com/2015/06/22/did-you-know-8-identifiers
Amitzil – Oracle DBA blog. Did You Know #8 – Identifiers. Did You Know #8 – Identifiers. June 22, 2015. September 8, 2016. Database Identifiers are basically names of objects in the database, like tables, indexes, etc. Analyzing Raw Trace Files. Did You Know #9 – OPT PARAM Hint →. One thought on “ Did You Know #8 – Identifiers. March 8, 2016 at 12:01 pm. Another downside is that you will ALWAYS have to double quote the identifier. Of course, coming from a Sybase background, the configuration of our s...
amitzil.wordpress.com
Exciting News | amitzil - Oracle DBA blog
https://amitzil.wordpress.com/2015/07/20/exciting-news
Amitzil – Oracle DBA blog. July 20, 2015. September 8, 2016. I know I haven’t published a technical post for a while now, I’m quite busy lately. As you might know, I’m moving to Vancouver, Canada on August 3rd, and it’s quite a lot of work to pack up your entire life and move. So I don’t have much time now. The move is 2 weeks from today, and I’m both excited and sad. It’s not easy to leave everything and everyone behind, but we are looking forward to our new life. Did You Know #9 – OPT PARAM Hint. You a...
amitzil.wordpress.com
My Big Move | amitzil - Oracle DBA blog
https://amitzil.wordpress.com/2015/06/14/my-big-move
Amitzil – Oracle DBA blog. June 14, 2015. September 8, 2016. I’m moving to Vancouver, Canada! This is one of the biggest decisions I’ve made in my life, and it wasn’t an easy one. My wife decided to leave her job and do a Ph.D. and after many years of thinking about moving to a different country, we decided to take this opportunity as an excuse to move. IlOUG Tech Days – June 2015. Analyzing Raw Trace Files →. 5 thoughts on “ My Big Move. June 14, 2015 at 1:26 pm. I am sure you will succeed in Canada.
amitzil.wordpress.com
amitzil | amitzil - Oracle DBA blog
https://amitzil.wordpress.com/author/amitzil
Amitzil – Oracle DBA blog. Articles posted by amitzil. November 2, 2016. November 2, 2016. Continue reading →. October 26, 2016. October 11, 2016. Lately I wrote a couple of posts about bash scripting for DBAs ( part 1. Continue reading →. Did you Know #15 – Role Based Stuff. October 20, 2016. October 25, 2016. Continue reading →. More Cool 12.2 Features. October 17, 2016. October 17, 2016. If you’ve read my post about 12.2 new features. I’d like to thanks Keith for uploading the presentation. ...As I...
amitzil.wordpress.com
Analyzing Raw Trace Files | amitzil - Oracle DBA blog
https://amitzil.wordpress.com/2015/06/17/analyzing-raw-trace-files
Amitzil – Oracle DBA blog. Analyzing Raw Trace Files. Analyzing Raw Trace Files. June 17, 2015. September 8, 2016. Many times we need to understand what our server process does. When we run an application flow or in cases we cannot get or analyze a specific query, we turn tracing on and analyze the trace file. There are several things that are missing from the formatted file, I’ll address two of them here: wait events and bind variables. If we need to analyze the bind variables, the details of the wait e...
amitzil.wordpress.com
Real Application Testing – DB Replay | amitzil - Oracle DBA blog
https://amitzil.wordpress.com/2015/06/01/real-application-testing-db-replay
Amitzil – Oracle DBA blog. Real Application Testing – DB Replay. Real Application Testing – DB Replay. June 1, 2015. September 8, 2016. This is the post that will complete my Real Application Testing series (for now at least). In this post I’ll talk about the DB Replay. If you haven’t read my previous post about RAT, you should probably start with them. The first post was introduction to RAT. And the second was about the SPA. With SPA we checked each SQL statement individually, here we will run the real ...
amitzil.wordpress.com
Did You Know #9 – OPT_PARAM Hint | amitzil - Oracle DBA blog
https://amitzil.wordpress.com/2015/06/30/did-you-know-9-opt_param-hint
Amitzil – Oracle DBA blog. Did You Know #9 – OPT PARAM Hint. Did You Know #9 – OPT PARAM Hint. June 30, 2015. September 8, 2016. Over the years I ran into many Oracle bug related to the optimizer (the last one was yesterday with join push predicates). Many times this is related to Optimizer new features or new behavior and can be disabled using a hidden parameter (in the case from yesterday, the “ optimizer push pred cost based” parameter). Did You Know #8 – Identifiers. Exciting News →. You are commenti...
SOCIAL ENGAGEMENT