dfitzjarrell.wordpress.com
Perception Is Everything | Oracle Tips and Tricks -- David Fitzjarrell
https://dfitzjarrell.wordpress.com/2015/05/18/perception-is-everything
Oracle Tips and Tricks — David Fitzjarrell. May 18, 2015. 8212; dfitzjarrell @ 08:22. There is much worth noticing that often escapes the eye." - Norton Juster, The Phantom Tollbooth. SQL CREATE TABLE M 2 (EMPNO NUMBER(4) NOT NULL, 3 MGR NUMBER(4), 4 JOB VARCHAR2(9), 5 ENAME VARCHAR2(10), 6 HIREDATE DATE, 7 SAL NUMBER(7, 2), 8 COMM NUMBER(7, 2), 9 DEPTNO NUMBER(2) ; Table created. SQL. There are 18 rows in this slightly modified data set so 18 exceptions were generated. All of the exceptions were rep...
dfitzjarrell.wordpress.com
It Isn’t The Index | Oracle Tips and Tricks -- David Fitzjarrell
https://dfitzjarrell.wordpress.com/2015/07/28/it-isnt-the-index
Oracle Tips and Tricks — David Fitzjarrell. July 28, 2015. It Isn’t The Index. 8212; dfitzjarrell @ 15:36. If you want sense, you'll have to make it yourself." - Norton Juster, The Phantom Tollbooth. Next, build the index and generate the statistics:. SQL SQL create index clust fact idx on clust fact(id); Index created. SQL SQL exec dbms stats.gather table stats(user, 'CLUST FACT', cascade= true); PL/SQL procedure successfully completed. SQL. Query the clustering factor computed by Oracle:. SQL select in...
dfitzjarrell.wordpress.com
Too Much Time | Oracle Tips and Tricks -- David Fitzjarrell
https://dfitzjarrell.wordpress.com/2015/05/01/too-much-time
Oracle Tips and Tricks — David Fitzjarrell. May 1, 2015. 8212; dfitzjarrell @ 12:44. It's bad enough wasting time without killing it." Norton Juster, The Phantom Tollbooth. Let’s create a copy of EMP that has a non-0 degree of parallelism:. SQL CREATE TABLE EMP 2 (EMPNO NUMBER(4) NOT NULL, 3 ENAME VARCHAR2(10), 4 JOB VARCHAR2(9), 5 MGR NUMBER(4), 6 HIREDATE DATE, 7 SAL NUMBER(7, 2), 8 COMM NUMBER(7, 2), 9 DEPTNO NUMBER(2) 10 parallel 4; Table created. SQL. Now let’s make it a fairly large table:. SELECT ...
dfitzjarrell.wordpress.com
Some People’s Kids | Oracle Tips and Tricks -- David Fitzjarrell
https://dfitzjarrell.wordpress.com/2015/05/14/some-peoples-kids
Oracle Tips and Tricks — David Fitzjarrell. May 14, 2015. Some People’s Kids. 8212; dfitzjarrell @ 13:39. Expectations is the place you must always go to before you get to where you're going. Of course, some people never go beyond Expectations, but my job is to hurry them along whether they like it or not." - Norton Juster, The Phantom Tollbooth. From time to time I find a situation where a developer believes that:. So far, so good, but let’s look at the second session:. SQL - SQL - Using a sequence and ...
dfitzjarrell.wordpress.com
Stop That! | Oracle Tips and Tricks -- David Fitzjarrell
https://dfitzjarrell.wordpress.com/2015/05/26/stop-that
Oracle Tips and Tricks — David Fitzjarrell. May 26, 2015. 8212; dfitzjarrell @ 13:05. It seems to me that almost everything is a waste of time." - Norton Juster, The Phantom Tollbooth. Jonathan Lewis has coined a term and its definition that, I believe, we’ll be using quite a bit:. Stoptimisation - the art of optimisation by not doing the things you don't need to do. Locks the table and index until the rebuild is finished * Invalidates cursors using the associated table * Serves no useful purpose. A Bloo...
dfitzjarrell.wordpress.com
That Depends | Oracle Tips and Tricks -- David Fitzjarrell
https://dfitzjarrell.wordpress.com/2015/05/20/that-depends
Oracle Tips and Tricks — David Fitzjarrell. May 20, 2015. 8212; dfitzjarrell @ 11:00. They all looked very much like the residents of any small valley to which you've never been. Norton Juster, The Phantom Tollbooth. In every universe there are questions that either:. Have no answer or Have an answer that is situation-dependent. In Resurrecting The Dead. Flashback operations were discussed as an option to restore table data to before an errant update. The post started with this:. So, what is a DBA to do?
dfitzjarrell.wordpress.com
What’s In A (User) Name? | Oracle Tips and Tricks -- David Fitzjarrell
https://dfitzjarrell.wordpress.com/2015/07/31/whats-in-a-user-name
Oracle Tips and Tricks — David Fitzjarrell. July 31, 2015. What’s In A (User) Name? 8212; dfitzjarrell @ 13:44. So each one of you agrees to disagree with whatever the other one agrees with, but if you both disagree with the same thing, aren't you really in agreement? Norton Juster, The Phantom Tollbooth. Recently a blog post. Nothing unusual there, but now the fun part begins. The business rules for usernames are as follows:. A procedure, like this one, could be written:. This certainly isn’t the ...
dfitzjarrell.wordpress.com
Let Me Say That Another Way … | Oracle Tips and Tricks -- David Fitzjarrell
https://dfitzjarrell.wordpress.com/2015/06/17/let-me-say-that-another-way
Oracle Tips and Tricks — David Fitzjarrell. June 17, 2015. Let Me Say That Another Way …. 8212; dfitzjarrell @ 08:50. I never knew words could be so confusing," Milo said to Tock as he bent down to scratch the dog's ear. "Only when you use a lot to say a little," answered Tock. Milo thought this was quite the wisest thing he'd heard all day. - Norton Juster, The Phantom Tollbooth. Http:/ docs.oracle.com/cd/E11882 01/server.112/e26088/statements 10002.htm#SQLRF01702. SQL select * 2 from 3 (select name, qu...
dfitzjarrell.wordpress.com
Resurrecting The Dead (or Gee, I Thought That Data Was Gone Forever) | Oracle Tips and Tricks -- David Fitzjarrell
https://dfitzjarrell.wordpress.com/2008/01/09/resurrecting-the-dead-or-gee-i-thought-that-data-was-gone-forever
Oracle Tips and Tricks — David Fitzjarrell. January 9, 2008. Resurrecting The Dead (or Gee, I Thought That Data Was Gone Forever). 8212; dfitzjarrell @ 16:29. Occasionally an end-user does the unthinkable, and changes data permanently (or so it appears) without checking the results before issuing a commit. Ooops. It used to be that to restore that data one had basically two choices:. A) Restore the data from a known good copy made before the changes were enacted. Enter Oracle 10g and later releases where...