Welcome to my Oracle blog and here are the Posts. The slides for my UKOUG Tech14 presentation All about joins can be downloaded here. The UKOUG Tech14 quiz is now closed. Quiz questions. Here are the answers: Quiz answers My book Expert Oracle SQL is out now! This book has over 600 pages to help you…
http://tonyhasler.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
0.4 seconds
16x16
32x32
64x64
PAGES IN
THIS WEBSITE
10
SSL
EXTERNAL LINKS
45
SITE IP
192.0.78.12
LOAD TIME
0.391 sec
SCORE
6.2
Tony's Oracle Tips | Tony Hasler’s light hearted approach to learning about Oracle | tonyhasler.wordpress.com Reviews
https://tonyhasler.wordpress.com
Welcome to my Oracle blog and here are the Posts. The slides for my UKOUG Tech14 presentation All about joins can be downloaded here. The UKOUG Tech14 quiz is now closed. Quiz questions. Here are the answers: Quiz answers My book Expert Oracle SQL is out now! This book has over 600 pages to help you…
tonyhasler.wordpress.com
Interview question: second largest value | Tony's Oracle Tips
https://tonyhasler.wordpress.com/2015/06/13/interview-question-second-largest-value
Tony’s Oracle Tips. June 13, 2015. Interview question: second largest value. Filed under: Interview questions. 8212; tonyhasler @ 8:32 pm. This is my first blog for a very very long time. I stopped blogging a couple of years ago when I started working on my book. And after I finally finished the book I felt I needed a break to recuperate. However, I have finally decided to put my toe back in the water. This isn’t a very serious post but I hope you find it thought provoking and a bit of fun. Solution 1 sh...
UKOUG Oracle Scene Articles | Tony's Oracle Tips
https://tonyhasler.wordpress.com/ukoug-oracle-scene-articles
Tony’s Oracle Tips. UKOUG Oracle Scene Articles. The PDF documents below are articles I have written for Oracle Scene, the periodical from the UK Oracle User Group. Checking your ability to recover using rman backups part1. Checking your ability to recover using rman backups part2. Why I like ANSI SQL. 11g partitioning features part1. 11g partitioning features part2. To gather statistics or not to gather statistics that is the question. Leave a Comment ». Feed for comments on this post.
Launching SQL*PLUS or PuTTY from Application Express | Tony's Oracle Tips
https://tonyhasler.wordpress.com/launching-sqlplus-or-putty-from-application-express
Tony’s Oracle Tips. Launching SQL*PLUS or PuTTY from Application Express. A couple of years ago I developed an Application Express (well, HTMLDB in those days) report that included the ability to launch SQL*PLUS and PuTTY sessions. The technique can be used to launch any script or application. I was recently asked to explain how this works so I was given the perfect nudge to write this blog entry. The URLs look something like this:. Putty:-ssh -l oracle -pw password1 myhost. You will need to edit this fi...
Non-inclusive windows for yearly or monthly intervals | Tony's Oracle Tips
https://tonyhasler.wordpress.com/2012/10/23/non-inclusive-windows-for-yearly-or-monthly-intervals
Tony’s Oracle Tips. October 23, 2012. Non-inclusive windows for yearly or monthly intervals. Filed under: SQL Fun. 8212; tonyhasler @ 1:01 pm. About six months ago I came across the need to use analytic functions with a moving one year window. This is supposedly supported in Oracle 10g and beyond but the behaviour was not what I expected. Consider this test query:. This is the result:. I may have been inspired by Stephen Hawking’s invention of virual time. When I finally came up with this solution:.
October | 2012 | Tony's Oracle Tips
https://tonyhasler.wordpress.com/2012/10
Tony’s Oracle Tips. October 24, 2012. Model clause use cases. Filed under: SQL Fun. 8212; tonyhasler @ 9:22 pm. This note describes a couple of real-life use cases for the SQL MODEL (or SPREADSHEET) clause that appeared in Oracle 10g. This is mainly targeted at people attending my UKOUG presentation on the model clause (materials TBS) but anybody who knows the syntax of the model clause may find this of some interest. If so why wouldn’t we just use PL/SQL? Implementing calculations in parallel. A genuine...
TOTAL PAGES IN THIS WEBSITE
10
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.
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...
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...
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...
Don’t pre-empt the CBO from doing its work | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/07/02/dont-pre-empt-the-cbo-from-doing-its-work
Mohamed Houri’s Oracle Notes. July 2, 2015. Don’t pre-empt the CBO from doing its work. 8212; hourim @ 2:03 pm. This is the last part of the parallel insert/select saga. As a reminder below is the two preceding episodes:. Where I have explained why I was unable to get the corresponding SQL monitoring report because of the sqlmon max planlines parameter. Where I have explained the oddity shown by the SQL monitoring report when monitoring non active parallel server for more than 30 minutes. Observe careful...
Mohamed Houri’s Oracle Notes | Qui se conçoit bien s’énonce clairement | Page 2
https://hourim.wordpress.com/page/2
Mohamed Houri’s Oracle Notes. September 5, 2015. Bind aware secret sauce (again). 8212; hourim @ 8:21 am. I am sure many of you have already become bored by my posts on adaptive cursor sharing. I hope this article will be the last one🙂. In part III. Of the installment I was unable to figure out the secret sauce Oracle is using to mark a cursor bind aware when count of the 3 buckets. Of a bind sensitive cursor are greater than 0. To make things simple I created the following function. Now change again th...
Degree of Parallelism is 16 because of table property | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/08/04/degree-of-parallelism-is-16-because-of-table-property
Mohamed Houri’s Oracle Notes. August 4, 2015. Degree of Parallelism is 16 because of table property. 8212; hourim @ 10:11 am. I have been pleasantly surprised by the following Note at the bottom of an execution plan coming from a 12.1.0.2.0 Oracle instance. As you can point it out, thanks to the above Note, we can immediately guess that the Optimizer decided to run the query in parallel because the T PAR table has been decorated with a DOP of 16. A nice 12c add. Unfortunately there is no Note indicating ...
Resumable time out | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/02/14/resumable-time-out
Mohamed Houri’s Oracle Notes. February 14, 2015. 8212; hourim @ 9:47 am. I was trying to create a very big table through a. Create table as select. I launched the create table and started monitoring it with Tanel Poder snapper script, v$active session history and the Real Time SQL Monitoring feature ( RTSM. This is what the monitoring was showing. However few minutes later Tanel Poder. Snapper started showing the following dominant wait event. No available free space left in TEMP tablespace. Popping up i...
Why Dynamic Sampling has not been used? | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/06/12/why-dynamic-sampling-has-not-been-used
Mohamed Houri’s Oracle Notes. June 12, 2015. Why Dynamic Sampling has not been used? 8212; hourim @ 10:15 am. Experienced tuning guys are known for their pronounced sense of looking at details others are very often ignoring. This is why I am always paying attention to their answers in otn and oracle-l list. Last week I have been asked to look at a query performing badly which has been monitored via the following execution plan:. As you can see apart from the optimizer index cost adj. About dynamic sampli...
August | 2015 | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/08
Mohamed Houri’s Oracle Notes. August 21, 2015. Cardinality Feedback: a practical case. 8212; hourim @ 5:36 pm. Here it is an interesting case of cardinality feedback collected from an 11.2.0.3 running system. A simple query against a single table has a perfect first execution response time with, according to the human eyes, a quite acceptable difference between Oracle cardinality estimates and actual rows as shown below:. It might be “possible” that when Oracle rounds up its cardinality estim...SQL selec...
TOTAL LINKS TO THIS WEBSITE
45
Tony Hasbun Company
Get THC News and Music. Sin Fingimiento “The Album”. 8220;Corre La Voz” New Video. Sin Fin Snack Back! June 24, 2015. GORDO BREGA EN #LIDERES DELA NUEVA ESCUELA. UNO DE LOS ARTISTAS CALLJEROS DE HIP HOP RAP CON UNA TRAYECTORIA DE 13 ANOS RAPIANDO EN CONCIERTOS , PARTYS , ESQUINAS Y ESTUDIOS , YA CON BARIAS PRODUCIONES BUSCANO EL EXITO PERO ESTANCADO POR LOS MONOPOLIOS MUSICALES QUE LE TEMEN A SU TALENTO VERSATIL Read more. June 23, 2015. Juan Nina "Lideres de la nueva escuela". June 15, 2015. June 9, 2015.
put web site name and searcg engen key words / page titles
Tony does have deals. We have what you need. There is always more being added so check back often. Enter text row 1 pic 1. Place text discription here row 1 pic 2. Enter text row 1 pic 3. Enter text row 1 pic 4. Enter text row 2 pic 1. Enter text row 2 pic 2. Text row 2 pic 3. Text row 2 pic 4. Text row 3 pic 1. Text row 3 pic 2. Text row3 pic 3. Text row 3 pic 4. Enter text row 4 pic 1. Enter text row 4 pic 2. Text row 4 pic 3. Text row 4 pic 4. Enter text row 5 pic 1. Enter text row 5 pic 2.
SERIOUS Players Only: Access to the BEST Wholesale Real Estate Deals
I have discovered a way to secure an endless supply of cheap local houses for pennies on the dollar . and I'd like to give them to you! I Personally Control Them All (no third parties). NO ONE Has Access To These Houses But Me. All of Them Are Under 50% Of Market Value. We will not share your email address with anyone. Get FREE Access ». Attention Landlords and Rehabbers:. If you are a serious investor. Buying at least one house per quarter for rental or rehab, then you are in the right place right now.
Tony Haske-Cheap Website builder, Websites, simple, easy
Kirkbride Aeroclub | The home of flying in Cumbria
The home of great flying. Tony’s Home Page. January 21, 2016. January 24, 2016. This is an example page. It’s different from a blog post because it will stay in one place and will show up in your. Ite navigation (in most themes). Most people start with an About page that introduces them to potential site visitors. It might say something like this:. 8230;or something like this:. As a new WordPress user, you should go to your dashboard. 8230;or something like this:. The XYZ Doohickey Company was founded in...
Tony's Oracle Tips | Tony Hasler’s light hearted approach to learning about Oracle
Tony’s Oracle Tips. Welcome to my Oracle blog and here are the Posts. The slides for my UKOUG Tech14 presentation All about joins. Can be downloaded here. The UKOUG Tech14 quiz. Here are the answers:. My book Expert Oracle SQL. This book has over 600 pages to help you understand how to tune SQL statements and manager statistics in a runtime environment. See your country’s Amazon website for more details. Or use the “Follow” button on the right? The powerpoint presentation is here:. Note: The script from ...
Tony Hassler Photography
Home - Tony Hastad Memorial
Welcome to the Tony Hastad Memorial Homepage. The Tony Hastad Memorial Scholarship Fund was started in 2010 with the help of LqPV Dollars for Scholars. And Appleton Farmers and Merchants Bank State Bank(F&M State Bank). If you would like to Donate to the fund please see the details below:. Make checks payable to "Tony Hastad Memorial Fund". Payments can be mailed to or dropped off at F&M State Bank at the address below:. Farmers and Merchants State Bank. 239 N Miles St. Appleton, MN 56208.
Tony Has Thoughts | A podcast that crudely explores a crude mind.
A podcast that crudely explores a crude mind. July 11, 2015. 67: Napalm and Nosebleeds. June 16, 2015. It’s summer in Howtonia, but for Tony the warm weather just means hot tempers on the bus. Liam and Tony discuss bus drivers who stop wherever they want, 70′s movies …. June 3, 2015. 65: The Viagra Years. Liam and Tony discuss ice cream, couch-surfing and ED drugs in an unusually junk-centric episode. Intro: Acid Black Cherry, “Greed Greed Greed”. 65: The Viagra Years. May 14, 2015. May 11, 2015. Liam is...
Tony Hastings | Art, Design and Ecology
Art, Design and Ecology. Bell Miners and Rainforest. Hi and welcome to my website. Here you may find a gallery of my paintings, some speccy photos, some samples of design work, and some environmental reports. I offer the following services:. Art: fine art paintings of any subject you choose. Illustrations for fiction or technical work. Large, painted banners. Photography and film production. Tuition: basic and advanced computer use, sailing, art and many others topics. Find me on social media:.
TonyHAT | H@cking & Pentesting
17 agosto, 2015. 17 agosto, 2015. Básicos 10: Thinking about security (aspectos básicos) (parte. I). 16 agosto, 2015. 16 agosto, 2015. Básicos 9: Nessus (Creating an SSH tunnel). 15 agosto, 2015. 15 agosto, 2015. Chema Alonso and Hugo Teso: Trademark Hackers! 14 agosto, 2015. 14 agosto, 2015. Kali Linux 2.0: Distro for Hackers ready for use? 13 agosto, 2015. 13 agosto, 2015. Básicos 8: knows basic Metasploit basic Meterpreter (parte. III). 12 agosto, 2015. 12 agosto, 2015. 11 agosto, 2015. 10 agosto, 2015.
