righettidba.com
Partitioned Table Global Stats, they are not just decorative. | Rodrigo Righetti DBA
https://righettidba.com/2016/05/03/partitioned-table-global-stats-they-are-not-just-decorative
So they say :). Partitioned Table Global Stats, they are not just decorative. Partitioned Table Global Stats, they are not just decorative. May 3, 2016. May 3, 2016. One of my favorite features, especially when dealing with big databases is partitioning, they have been around since Oracle 8.0, and a lot has evolved and improved over the years. Although they are widely used there is still some basic principles that seems to fall through the cracks of our busy DBA life. So why Global Stats are important?
righettidba.com
April | 2016 | Rodrigo Righetti DBA
https://righettidba.com/2016/04
So they say :). Everything in excess is bad. Except Ice Cream :). April 19, 2016. April 26, 2016. Unfortunately this feature is abused, has always been and I’m afraid it always will, just google about this subject and you will see the number of posts about monitoring indexes or the cost to maintain them and still on almost every database we perform an assessment (Health-Check) we see this issue. Continue reading →. And by the way SQL is a program language. April 10, 2016. April 26, 2016. My postings refl...
righettidba.com
May | 2016 | Rodrigo Righetti DBA
https://righettidba.com/2016/05
So they say :). Partitioned Table Global Stats, they are not just decorative. May 3, 2016. May 3, 2016. One of my favorite features, especially when dealing with big databases is partitioning, they have been around since Oracle 8.0, and a lot has evolved and improved over the years. Although they are widely used there is still some basic principles that seems to fall through the cracks of our busy DBA life. Continue reading →. Partitioned Table Global Stats, they are not just decorative. The Tom Kyte Blog.
righettidba.com
Tuning | Rodrigo Righetti DBA
https://righettidba.com/category/tuning
So they say :). Partitioned Table Global Stats, they are not just decorative. May 3, 2016. May 3, 2016. One of my favorite features, especially when dealing with big databases is partitioning, they have been around since Oracle 8.0, and a lot has evolved and improved over the years. Although they are widely used there is still some basic principles that seems to fall through the cracks of our busy DBA life. Continue reading →. Everything in excess is bad. Except Ice Cream :). April 19, 2016. Such a small...
righettidba.com
Rodrigo Righetti DBA | so they say :) | Page 2
https://righettidba.com/page/2
So they say :). You should take these things seriously …. March 25, 2016. March 25, 2016. From Oracle …. March 23, 2016. Oracle Security Alert for CVE-2016-0636 for Java SE. Dear Oracle Security Alert Subscriber,. Oracle Security Alert for CVE-2016-0636 for Java SE was released on March 23rd, 2016. Oracle strongly recommends that customers follow the recommended actions noted in the Security Alert. Continue reading →. First Blog …. March 25, 2016. March 28, 2016. From this decade at least …. One thing th...
righettidba.com
Uncategorized | Rodrigo Righetti DBA
https://righettidba.com/category/uncategorized
So they say :). First Blog …. March 25, 2016. March 28, 2016. From this decade at least …. Long ago I tried to join the blog community to share my experience like many others so nicely do, but the work and life balance is not easy for a DBA and with my circumstances I had to prioritize and blog had to be out of my life, that is just life. All constructive feedback will be deeply appreciated. I always find myself analyzing a lot of stuff in life, family, politics, universe, etc …. How did we manage to go ...
righettidba.com
March | 2016 | Rodrigo Righetti DBA
https://righettidba.com/2016/03
So they say :). The PLAN TABLE disruption attack or I may be getting paranoid. March 30, 2016. March 31, 2016. Please be aware that using these techniques on a production database may leave it on a non-supported state, always consult with Oracle support. Think again …., Oracle unfortunately grants several tables and packages to PUBLIC, meaning that even an user with “CREATE SESSION” automatically has privileges to insert on those tables. Continue reading →. March 28, 2016. Unfortunately the most importan...
righettidba.com
The PLAN_TABLE disruption attack or I may be getting paranoid | Rodrigo Righetti DBA
https://righettidba.com/2016/03/30/the-plan_table-disruption-attack-or-i-may-be-getting-paranoid/comment-page-1
So they say :). The PLAN TABLE disruption attack or I may be getting paranoid. The PLAN TABLE disruption attack or I may be getting paranoid. March 30, 2016. March 31, 2016. Please be aware that using these techniques on a production database may leave it on a non-supported state, always consult with Oracle support. Again an user with only “CREATE SESSION” can insert and cause certain disruption, which I will demonstrate below. The PLAN TABLE case is definitely not the worse case, several of the other ta...
righettidba.com
Divide to Conquer !!! and by the way SQL is a program language. | Rodrigo Righetti DBA
https://righettidba.com/2016/04/10/divide-to-conquer-and-by-the-way-sql-is-a-program-language
So they say :). And by the way SQL is a program language. And by the way SQL is a program language. April 10, 2016. April 26, 2016. It is interesting(to myself at least) the two very distinct feelings I have when I see these “beasts”. First, if a SQL developer can write something so extensive and complex, imagine if they knew how Oracle really works, they would be able to write extremely efficient code, I would hope at least. The second feeling is “hole cr…” how am I going to fix this? Where do I start?
righettidba.com
How to install BBED on any release, yes it does work on 12c. | Rodrigo Righetti DBA
https://righettidba.com/2016/03/26/how-to-install-bbed-on-any-release-yes-it-does-work-on-12c
So they say :). How to install BBED on any release, yes it does work on 12c. How to install BBED on any release, yes it does work on 12c. March 26, 2016. March 27, 2016. Please be aware that using these techniques on a production database would leave it on a non-supported state. BBED -Block Browser and Editor, which is an Oracle internal tool to debug and correct block level corruption, it used to be available until 10g. To make it work:. Link the BBED on the Oracle 11g:. For Oracle Internal Use only!
SOCIAL ENGAGEMENT