blog.go-faster.co.uk
The Go-Faster Oracle Blog: Editing Hints in Stored Outlines
http://blog.go-faster.co.uk/2012/03/editing-hints-in-stored-outlines.html
The Go-Faster Oracle Blog. The PeopleSoft stuff is at blog.psftdba.com. This is the non-PeopleSoft Oracle Blog. Friday, March 02, 2012. Editing Hints in Stored Outlines. This note describes changing a hint in a SQL Outline by updating the OUTLN.OL$. Tables directly. It shows that in the limited test case that it does affect the resulting execution plan. Hint to an outline, that would not otherwise be included if the outline was generated in the conventional manner. I'll start by creating a table to use.
blog.go-faster.co.uk
The Go-Faster Oracle Blog: Partition Maintenance with Global Indexes
http://blog.go-faster.co.uk/2009/10/partition-maintenance-with-globally.html
The Go-Faster Oracle Blog. The PeopleSoft stuff is at blog.psftdba.com. This is the non-PeopleSoft Oracle Blog. Wednesday, October 21, 2009. Partition Maintenance with Global Indexes. Updated 3.12.2009 to deal with UPDATE GLOBAL INDEXES option). Management of Global Partitioned Indexes. Global partitioned indexes are harder to manage than local indexes:. The key point is that the global index is invalidated if rows of data. DROP TABLE t PURGE;. A NUMBER NOT NULL. B VARCHAR2(100) NOT NULL. ADD PARTITION t...
uhesse.com
Data Guard | The Oracle Instructor
https://uhesse.com/tag/data-guard
Explain, Exemplify, Empower. Posts Tagged Data Guard. Another reason why you should use the Data Guard Broker for your #Oracle Standby. Posted by Uwe Hesse. On May 18, 2016. The Data Guard Broker is recommended for various reasons,. This one is less obvious: It prevents a Split-Brain problem that may otherwise occur in certain situations. Let me show you:. Oracle@uhesse ]$ dgmgrl sys/oracle@prima. Oracle@uhesse ]$ ps -ef grep smon. Oracle 6279 1 0 08:30? 00:00:00 ora smon prima oracle 6786 1 0 08:32?
blog.go-faster.co.uk
The Go-Faster Oracle Blog: Gathering Aggregated Cost-Based Optimiser Statistics on Partitioned Objects
http://blog.go-faster.co.uk/2012/07/gathering-aggregated-cost-based.html
The Go-Faster Oracle Blog. The PeopleSoft stuff is at blog.psftdba.com. This is the non-PeopleSoft Oracle Blog. Thursday, July 19, 2012. Gathering Aggregated Cost-Based Optimiser Statistics on Partitioned Objects. Recently, I have been looking into how to gather cost-based optimizer statistics on composite partitioned objects. Collecting global statistics on a large partitioned object can be a time-consuming and resource intensive business as Oracle samples all the physical partitions or sub-partitio...
uhesse.com
Exadata | The Oracle Instructor
https://uhesse.com/exadata
Explain, Exemplify, Empower. This page lists my Exadata related postings. I’m a certified Oracle Exadata Database Machine X3 Administrator. Exadata Part I: Smart Scan. Exadata Part II: Storage Index. Exadata Part III: Compression. Exadata Part IV: Flash Cache. Exadata Part V: Monitoring with Database Control. Exadata Part VI: Cell Administration with dcli. CELL PARTITION LARGE EXTENTS now obsolete. No DISK REPAIR TIME on Exadata Cells. Invisible Indexes & Exadata. Exadata Quarter Rack Architecture Picture.
uhesse.com
Invisible Indexes & Exadata | The Oracle Instructor
https://uhesse.com/2011/05/05/invisible-indexes-exadata
Explain, Exemplify, Empower. Laquo; Now OCM for 10g AND 11g. My Exadata Series made it into the OU Newsletter. Invisible Indexes & Exadata. You may have noticed that we introduced. As an 11g New Feature. Their main benefit is that we can test whether performance differs if we would drop an index. Without actually dropping it. This is particular useful after an Exadata Migration because we expect that some conventional indexes migrated are now obsolete and may be substituted by Storage Indexes. Index alte...
uhesse.com
Uwe Hesse | The Oracle Instructor
https://uhesse.com/author/uhesse
Explain, Exemplify, Empower. This user hasn't shared any biographical information. Homepage: http:/ uhesse.com. How to fix a problem with the spfile in #Oracle. On August 31, 2016. An invalid entry in the spfile may prevent the instance from starting up:. SQL alter system set sga target=500m scope=spfile;. System altered. SQL shutdown immediate. Database closed. Database dismounted. ORACLE instance shut down. SQL startup. The instance doesn’t come up! File created. SQL startup. On August 9, 2016. ADAM@pd...
uhesse.com
Reorganizing Tables in Oracle – is it worth the effort? | The Oracle Instructor
https://uhesse.com/2010/08/23/reorganizing-tables-in-oracle-is-it-worth-the-effort
Explain, Exemplify, Empower. Laquo; Using Flashback in a Data Guard Environment. Data Guard and Oracle Restart in 11gR2. Reorganizing Tables in Oracle – is it worth the effort? This topic seems to be some kind of “Evergreen”, since it comes up regularly in my courses and also in the OTN Discussion Forum. I decided therefore to cover it briefly here in order to be able to point to this post in the future. Short answer: Probably not. SQL select * from v$version;. CORE 11.2.0.1.0 Production. SQL delete from...
uhesse.com
OU course formats | The Oracle Instructor
https://uhesse.com/ou-course-formats
Explain, Exemplify, Empower. Oracle University (OU) course formats explained. Over the years, we have developed various different course formats, each for a good reason. This can be sometimes confusing for (potential) attendees as I know from many events where I talked about that topic with participants of my courses. If you want to get Education from Oracle University or if you are an OU Sales person or Reseller, you may find the following brief explanation helpful. ILT comes in two formats:. Means we h...
blog.go-faster.co.uk
The Go-Faster Oracle Blog: Global Temporary Tables Share Statistics Across Sessions
http://blog.go-faster.co.uk/2009/10/global-temporary-tables-shared.html
The Go-Faster Oracle Blog. The PeopleSoft stuff is at blog.psftdba.com. This is the non-PeopleSoft Oracle Blog. Tuesday, October 13, 2009. Global Temporary Tables Share Statistics Across Sessions. In another blog posting. We will need two database sessions. I will create a test Global Temporary table with a unique index. DROP TABLE t PURGE; TRUNCATE TABLE t; CREATE GLOBAL TEMPORARY TABLE t (a NUMBER,b VARCHAR2(1000) ON COMMIT PRESERVE ROWS; CREATE UNIQUE INDEX t ON t(a);. To generate a plan. Alter sessio...
