orawin.info

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...

marist89.blogspot.com

So What Co-operative: For People That Have Managers

http://marist89.blogspot.com/2012/01/for-people-that-have-managers.html

Oracle, MySQL, and IT Related stuff from the front lines. Monday, January 09, 2012. For People That Have Managers. Interesting take on what managers are thinking: http:/ quickbase.intuit.com/blog/2012/01/09/10-things-your-boss-isnt-telling-you/. So, exactly when does emotion become passion? Funny how the goalpost seems to change, to suit the blog. Talking about contents of the linked post, not this one! Subscribe to: Post Comments (Atom). MySQL to an Oracle DBA, Part I. MySQL to an Oracle DBA, Part II.

marist89.blogspot.com

So What Co-operative: Top N

http://marist89.blogspot.com/2005/09/top-n.html

Oracle, MySQL, and IT Related stuff from the front lines. Thursday, September 15, 2005. A Frequently Asked Question on many Oracle related forums is “How can I get the first/last N rows in my table? First/Last – in an ordered set. This one is easy. You take advantage of inline views and Oracle’s pseudocolumn ROWNUM. People usually get tripped up when they use ROWNUM because while ROWNUM is relevant in all queries, in this type of query it only makes sense when coupled with an ORDER BY. ROWNUM X Y Z.

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...

oraclesop.wordpress.com

Oracle S.O.P | Amat Victroria Curam | Page 2

https://oraclesop.wordpress.com/page/2

Oracle S.O.P. Skip to primary content. Skip to secondary content. Newer posts →. Here’s how to extract the sql commands to recreate any tablespace. Useful when creating a partial database copy. You can modify the query to only get a specific set of tablespaces you need. Set heading off set echo off set pages 999 set long 90000 spool ddl tablespaces.sql select dbms metadata.get ddl('TABLESPACE',tb.tablespace name) from dba tablespaces tb;. Registering with the listener. ALTER SYSTEM REGISTER;. Gzip -c tes...

oraclesop.wordpress.com

samygejz | Oracle S.O.P

https://oraclesop.wordpress.com/author/samygejz

Oracle S.O.P. Skip to primary content. Skip to secondary content. In this article, I’ll demonstrate multiple solutions to move datafiles. Method 1: using symbolic links. Stop the Mysql instance. Then move the files and put symbolic links to lure Mysql into thinking the files are still in place. Mkdir /new dir/datafiles/my db. Cp -Rvp my db/* /new dir/datafiles/my db/. Rm my db/* & rmdir my db/. Ln -s /new dir/datafiles/my db/ my db. Method 2: changing the configuration file. The Incorrect key file error:.

marist89.blogspot.com

So What Co-operative: Resumes & Job Objectives

http://marist89.blogspot.com/2012/01/resumes-job-objectives.html

Oracle, MySQL, and IT Related stuff from the front lines. Tuesday, January 24, 2012. Resumes and Job Objectives. I've been reviewing a lot of resume's lately. Please tell me, what is the purpose stating your "Job Objective"? Isn't it implied that your objective is to find a new job, specifically my job? I assume you're dynamic and technical and your vast expertise will help my company conquer the world. Seriously, doesn't resume mean summary? Back to the stack. Many people want to know what companies you...