connormcdonald.wordpress.com
Learning is not a spectator sport | Connor McDonald's Oracle blogConnor McDonald's Oracle blog
http://connormcdonald.wordpress.com/
Connor McDonald's Oracle blog
http://connormcdonald.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
16x16
32x32
PAGES IN
THIS WEBSITE
10
SSL
EXTERNAL LINKS
121
SITE IP
192.0.78.13
LOAD TIME
0 sec
SCORE
6.2
Learning is not a spectator sport | Connor McDonald's Oracle blog | connormcdonald.wordpress.com Reviews
https://connormcdonald.wordpress.com
Connor McDonald's Oracle blog
connormcdonald.wordpress.com
NUMBER data type…what harm can it do ? | Learning is not a spectator sport
https://connormcdonald.wordpress.com/2015/04/20/number-data-type-what-harm-can-it-do
Learning is not a spectator sport. Connor McDonald's Oracle blog. NUMBER data type…what harm can it do? NUMBER data type…what harm can it do? April 20, 2015. April 20, 2015. There’s a somewhat sour discussion going on based attached to the video at https:/ www.youtube.com/watch? Let’s start with a simple comparison between two dates. In this case, I’ve just used times, because it still serves to demonstrate the anomaly. SQL set serverout on SQL declare 2 x number;. 3 begin 4 SELECT (TO DATE('14:03:15','h...
WHEN OTHERS … sometimes just not enough | Learning is not a spectator sport
https://connormcdonald.wordpress.com/2015/03/20/when-others-sometimes-just-not-enough
Learning is not a spectator sport. Connor McDonald's Oracle blog. WHEN OTHERS … sometimes just not enough. WHEN OTHERS … sometimes just not enough. March 20, 2015. March 20, 2015. We currently are working on a bug with Oracle Support with dbms stats in 12.1.0.2. That may be the subject of a latter post, but in a nutshell, here’s the issue. By the way, if you’re encountering this issue, delete your INCREMENTAL stats preference as a temporary workaround. V$object usage catches me out every time :-). Intere...
v$object_usage catches me out every time :-) | Learning is not a spectator sport
https://connormcdonald.wordpress.com/2015/03/14/vobject_usage-catches-me-out-every-time
Learning is not a spectator sport. Connor McDonald's Oracle blog. V$object usage catches me out every time :-). V$object usage catches me out every time :-). March 14, 2015. Every …. single …. time…. Why does index monitoring make me scratch my head and charge off to google so many times…Well, I’m over it, so time to put it on my blog (even though its already on many other places) so I do not get caught out anymore. It always starts like this:. Turn on index monitoring on some indexes. But I have to wait...
dropping tablespaces and queues – not happy companions | Learning is not a spectator sport
https://connormcdonald.wordpress.com/2015/05/02/dropping-tablespaces-and-queues-not-happy-companions
Learning is not a spectator sport. Connor McDonald's Oracle blog. Dropping tablespaces and queues – not happy companions. Dropping tablespaces and queues – not happy companions. May 2, 2015. SQL drop tablespace MY TSPACE including contents; drop tablespace MY TSPACE including contents * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-24005: Inappropriate utilities used to perform DDL on AQ table MY SCHEMA.MY QUEUE TABLE. You can workaround the issue by running. Top Posts and Pages.
RETURNING BULK COLLECT and database links | Learning is not a spectator sport
https://connormcdonald.wordpress.com/2015/02/24/returning-bulk-collect-and-database-links
Learning is not a spectator sport. Connor McDonald's Oracle blog. RETURNING BULK COLLECT and database links. RETURNING BULK COLLECT and database links. February 24, 2015. Looks like the nice PL/SQL facility for returning a set of updated rows is restricted when it comes to database links. This tested on 12.1.0.1). Where object id = b.key col) 8 where b.my col is null 9 returning b.other col bulk collect into l results;. When we remove the database link, things revert to what we would expect. Address neve...
TOTAL PAGES IN THIS WEBSITE
10
KiBeHa - a Danish Sql and Pl/Sql Developer: The upcoming year
http://www.kibeha.dk/2015/12/the-upcoming-year.html
Tuesday, December 29, 2015. Right smack in the middle of the busiest time of the year for the business (this time of year we sell fireworks for New Year) I have opportunity to reflect a bit on the upcoming year and what 2016 will bring of challenges and joys. More directly I'll have a new label in 2016 that I was told about just before Christmas. The great honor of being Oracle ACE. Oracle User Group Norway ( OUGN. Has their traditional top-notch floating spring conference. On March 10-12th 2016. I h...
KiBeHa - a Danish Sql and Pl/Sql Developer: June 2015
http://www.kibeha.dk/2015_06_01_archive.html
Friday, June 26, 2015. ODCI dynamic table function parser. Supposing youve got data as a text string with row and column delimiters and you would like to parse out those columns and rows. The external table syntax would actually be great for this, but that requires writing the text out to a file first, and then you can import it back again as columns and rows. Demonstrates the use of ODCITable* functions. Links to this post. Monday, June 22, 2015. Escope very early status. The more responses we can get, ...
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.
KiBeHa - a Danish Sql and Pl/Sql Developer: Welcome
http://www.kibeha.dk/p/welcome.html
Welcome to my blog (or at least an attempt to blog something about Oracle SQL and PL/SQL :-). I'm Kim Berg Hansen. And I work as Senior Developer at Trivadis Danmark. Since the year 2000 I have programmed quite a lot of Oracle SQL, a good deal of Concorde XAL, some Oracle PL/SQL, and a smattering of all sorts of other programming languages as the various tasks have mandated. I am OCE (Oracle Certified Expert) on Oracle SQL, and being honored to be an Oracle ACE as well. On the PL/SQL Challenge. Anyway - ...
KiBeHa - a Danish Sql and Pl/Sql Developer: March 2016
http://www.kibeha.dk/2016_03_01_archive.html
Tuesday, March 15, 2016. OUGN Spring Conference 2016. Im back after one of the best ocean voyages ever - the OUGN Spring Conference 2016. Links to this post. Subscribe to: Posts (Atom). Senior Developer at Trivadis Denmark. OUGN Spring Conference 2017. Member of Danish Beer Enthusiasts. View my complete profile. OUGN Spring Conference 2016. Oracle Database 12c Release 2 (12.2) : Default APEX Installation Gone! Steven Feuerstein on Oracle PL/SQL. Latest UI for Oracle Dev Gym. Oracle Database PL/SQL and EBR.
Avoiding Lost Updates – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/other/avoiding-lost-updates
Oracle Database: Get it Right. Jeff Kemp on Oracle. Category: Avoiding Lost Updates. Avoiding Lost Updates #3: The Solution. Background: see my earlier posts Avoiding Lost Updates. And Avoiding Lost Updates #2: Updateable Views. I’ve discussed this problem with my colleagues and have come up with a number of potential solutions, one of which we believe is bulletproof. Use ORA ROWSCN instead of version. Cause an update on the view to. Do at least one update of one of the non-outer-joined tables (even if i...
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...
Database | The Oracle DB inn
https://www.protractus.com/category/database
The Oracle DB inn. Your source to the Oracle DB. Oracle General Database Discussion. Increase Database performance using Native PL/SQL compilation. August 23, 2016. Most of the times you want/need to squeeze the most out of your Database. One simple way of doing this is by using Native compilation (Available from version 9). To illustrate this I will create a … [Read more.]. March 2, 2015. Duplicate Active database using RMAN. November 23, 2014. Clone the Oracle Database to new host, without RMAN. This s...
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...
Forum: Oracle RAC discussions | The Oracle DB inn
https://www.protractus.com/forums/forum/oracle-in-general/oracle-rac-discussions
The Oracle DB inn. Your source to the Oracle DB. Oracle General Database Discussion. You are here: Home. This forum is empty. No topics were found here! You must be logged in to create new topics. My name is André Karlsson and work as an Oracle DBA at SaveCore ( http:/ www.savecore.se. View my Social profiles. Connor Mcdonald – Learning is not a spectator sport. ORACLE DBA BLOG 2.0. Increase Database performance using Native PL/SQL compilation. The NoJoy DI, a python Dependency Injector to trust!
TOTAL LINKS TO THIS WEBSITE
121
Relaxed Alternative Wedding Photography in Northern Ireland by Creative Relaxed Alternative Northern Ireland Wedding Photography | Connor McCullough Photography
connormccutcheon.wordpress.com
Connor McCutcheon's Bike Racer Blog | The adventures of an aspiring cyclist.
Connor McCutcheon's Bike Racer Blog. The adventures of an aspiring cyclist. Posted by: Connor McCutcheon. April 11, 2014. Media from Mzansi Tour in South Africa. A few pictures and videos from the Mzansi Tour in South Africa. For results and other information about the tour you can visit: http:/ www.mzansitour.co.za/Tour2013/MzansiResults.aspx. The D3Devo/Airgas Team international debut. The result of stage 1…. Lookin’ for help. Grifin Easter out front, with Connor, working together. April 8, 2014. After...
1&1 Internet - Web hosting, domain nameregistration and web services
Are you looking to secure your own domain name? Check the availability now and register your domain name quickly and easily! Discover all of 1&1’s web solutions. Is a leader amongst global web hosting providers, offering innovative web products at competitive prices. Whether you’re a beginner or a web professional, 1&1 has the online solution you need:. Top level domains at low prices. The complete, easy solution to get your business online. E-mail packages for every business or personal need.
ConnorMcDClan (Lidya Amalia Jones) - DeviantArt
Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) " class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 4 Years. This deviant's full pageview. July 8, 1995. Last Visit: 1 hour ago. This is the place where you can personalize your profile! By moving, adding and personalizing widgets. Why," you ask?
connormcdivitt (connor mcdivitt) - DeviantArt
Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 5 Years. This deviant's full pageview. Last Visit: 265 weeks ago. This is the place where you can personalize your profile! Jan 24,...
Learning is not a spectator sport | Connor McDonald's Oracle blog
Learning is not a spectator sport. May 2, 2015. Dropping tablespaces and queues – not happy companions. 8212; connormcdonald @ 11:37 am. SQL drop tablespace MY TSPACE including contents; drop tablespace MY TSPACE including contents * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-24005: Inappropriate utilities used to perform DDL on AQ table MY SCHEMA.MY QUEUE TABLE. You can workaround the issue by running. On each queue table before dropping the tablespace. April 28, 2015. So yo...
Connor M. McEvoy's Properties Portfolio
Connor McFadden | Android Developer.
Material Design Ripple effect. January 16, 2015. As much as every Android developer loves Lollipop and the Material Design which comes with it, updating your app to feature the new designs can be slightly annoying. I mean, adding features which only Lollipop users can see is always going to be more effort than we’d like, right? Especially when there isn’t many Lollipop users around just yet, let alone all devices support it. Xml version=”1.0″ encoding=”utf-8″? Now, before I started implementing this I th...
www.connormcgarvey.com
This Web page parked FREE courtesy of CheapDomainSeller.com. Search for domains similar to. Is this your domain? Let's turn it into a website! Would you like to buy this. Find Your Own Domain Name. See our full line of products. Easily Build Your Professional Website. As low as $4.99/mo. Call us any time day or night (480) 624-2500.
Connor McGauley
Coming Soon...
SOCIAL ENGAGEMENT