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...
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...
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...
carymillsap.blogspot.com
Cary Millsap: December 2011
http://carymillsap.blogspot.com/2011_12_01_archive.html
My web log for things I’m interested in, including design, software development, performance analysis, learning, and entrepreneurialism. Sunday, December 4, 2011. Gwen Shapira on SSD. If you haven’t seen Gwen Shapira’s article about de-confusing SSD. I recommend that you read it soon. One statement stood out as an idea on which I wanted to comment:. You don’t have to guess about the effect that SSD will have upon any business task you care about. In 2009, I wrote a blog post that explains.
carymillsap.blogspot.com
Cary Millsap: I Wish I Sold More
http://carymillsap.blogspot.com/2015/07/i-wish-i-sold-more.html
My web log for things I’m interested in, including design, software development, performance analysis, learning, and entrepreneurialism. Wednesday, July 29, 2015. I Wish I Sold More. I flew home yesterday from Karen’s memorial service. In Jacksonville, on a connecting flight through Charlotte. When I landed in Charlotte, I walked with all my stuff from my JAX arrival gate (D7) to my DFW departure gate (B15). The walk was more stressful than usual because the airport was so crowded. WHAT ROW ARE YOU IN?
blog.go-faster.co.uk
The Go-Faster Oracle Blog: UKOUG EMEA PeopleSoft Road Show
http://blog.go-faster.co.uk/p/oracle-openworld-2012.html
The Go-Faster Oracle Blog. The PeopleSoft stuff is at blog.psftdba.com. This is the non-PeopleSoft Oracle Blog. UKOUG EMEA PeopleSoft Road Show. The UKOUG EMEA PeopleSoft Road Show. Is coming to London on 31th April 2015. Subscribe to: Posts ( Atom ). David Kurtz @ Accenture Enkitec Group. The PeopleSoft DBA Blog. Complete Refresh of Materialized Views: Atomic, No. Global Temporary Tables Statistics. Enq: TM - contention. Latch: Cache Buffers Chains. Christian Antognini: Striving for Optimal Performance.
blog.go-faster.co.uk
The Go-Faster Oracle Blog: July 2012
http://blog.go-faster.co.uk/2012_07_01_archive.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...
blog.go-faster.co.uk
The Go-Faster Oracle Blog: January 2009
http://blog.go-faster.co.uk/2009_01_01_archive.html
The Go-Faster Oracle Blog. The PeopleSoft stuff is at blog.psftdba.com. This is the non-PeopleSoft Oracle Blog. Tuesday, January 20, 2009. Detecting and Fixing Row Migration. In my previous posting. I discussed how migrated rows led to latch connection problems on a system. In this entry I will explain how I identified and removed the migrated rows, and correctly set PCTFREE on each table so that the problem will not recur. Having identified the migrated rows, I produced a simple report. NB: This approac...
plsqlframework.blogspot.com
Oracle PL/SQL Framework Blog: Why do we need PL/SQL frameworks and libraries ?
http://plsqlframework.blogspot.com/2009/07/why-do-we-need-plsql-frameworks-and.html
Oracle PL/SQL Framework Blog. All the news and comments about PL/SQL frameworks and libraries. Here is the program! You will find here all the news about the PL/SQL frameworks and libraries that you can find on internet. We will also discuss about the tools needed in each development phase (development, production, maintenance), the error management and so on. And then, whether frameworks and libraries are commercial or open source, I will try to test them all. Oracle guys, you are welcome on that blog!