Webinar June 10 - Jonathan Lewis and I on Visual SQL Tuning
0 Comments Published by Kyle Hailey June 2nd, 2010 in Uncategorized
| Tune in for the Ultimate SQL Tune-off |
| According to Jonathan Lewis, there is a basic strategy to writing efficient SQL, but it requires knowledge of the data, the metadata, and the intent of the query.
Jonathan will start with the basic principles of efficient data access and then show different ways of analyzing the data. He’ll then describe a graphical approach to finding the most efficient access path for a query and then apply the method to a problem he recently saw with one of his clients. But wait… is there more than one way to skin a cat? Kyle Hailey thinks so, and he’s not afraid to let Jonathan know it! Kyle’s fancy footwork will include his own approach to Visual SQL Tuning (VST) with some ring side support from DB Optimizer XE. Hitting below the belt? You be the judge. Live! June 10, 2010 at 11AM Pacific
|
test
Finally installed a spam filter so you can now post questions here as well as http://db-optimizer.blogspot.com/ThanksKyle
For all questions reguarding content on http://ashmasters.com, please post them at:
http://db-optimizer.blogspot.com/2009/10/ashmasterscom.html
The questions posted here at ashmasters.com are not being addressed currently, due to the inordinate amounts of spam. If you have any questions on the content at ashmasters.com or would like to update or add new scripts, please post your ideas and and feedback on the link above at my blog and I will address them.
Thanks!
Kyle Hailey
As some of you might now, I joined Embarcadero Technologies in July to pursue my dream of building a production version of ASHMON. It’s now ready and will be released March 17th, 2009.If you act within the next two weeks you can still get in on the beta testing program.
More information on: http://sites.google.com/site/embtdbo
Beta versions available until March 13th Beta testing signup
Video Presentation on DB Optimizer
Cialis generic brand name differences
Cialis taken by women in europe
Cialis tadalafil cialis tadafil tal
!Viagra and buy^
!Buy diet online phentermine pill prescriptioncom viagra^
!Cialis medicine online order rx viagra^
!Wwwrxfamilycom buy cheap cheap kamagra uk viagra^
!Viagra online purchase^
!Buy onlinecom phentermine viagra^
!Buy cheap cheap kamagra uk viagra niy cheap cgeap kamagra^
!Buy viagra for cheap^
!Mail order viagra in uk^
!No prescription order viagra online^
!Viagra where to buy in the united kingdom^
!In canada buy viagra^
!Buy viagra cheap online^
!Purchase viagra in australia^
!Buy sildenafil viagra^
!Cheap viagra in uk^
!Buy viagra cialis levitra^
!Cheap viagra in india^
!Cheapest place buy viagra online^
!Generic viagra cheap^
!Buy viagra online uk^
!Cheap pharmaceutical viagra^
!Buy viagra pill online^
!Buy cheap cheap kamagra uk viagra buy cgeap cheap kamagra^
!Viagra uk cheap purchase buy^
!Where to buy viagra online^
!Viagra edinburgh page buy eggs find 10years 31am charles july^
!Buy cheap cheap kamagra uk viagra nuy cheao cheao kamagra^
!Cheap viagra cialis^
!Buy viagra pill^
!Buy levitra online viagra^
!Book buy online order viagra^
!Cheap source viagra^
!Can i buy viagra online^
!Buy viagra alternative apcalis cialis jel jelly kamagra^
!Mail order viagra china^
!Cheap viagra uk^
!Buy viagra online^
!Cheap buy viagra^
!Keywords buy viagra^
!Buy cheap viagra^
!Purchase generic viagra^
!Generic viagra caverta cialis cheap^
!Buy viagra discrete england^
!Order viagra onlines^
!Buy viagra cialis china shanghai no prescription^
!Viagra purchase^
!Cheap viagra kamagra^
!Viagra buy online^
!Viagra to buy cheap^
!Buy viagra phuket^
!Buy generic viagra online^
!Cheap generic kamagra kamagra uk viagra^
!Buy viagra online and get prescription^
!Diigo user viagra cheap buy^
!Buy cheap cheap kamagra uk viagra^
!Cheap viagra from pfizer^
!Viagra india mail order^
!Where to buy generic viagra^
!Buy viagra uk^
!Generic viagra 3a caverta 2c cialis cheap^
!Best buy viagra^
!Buy viagra on line^
!Cheap kamagra generic viagra videos^
!Buy meltabs generic viagra kamagra caverta edegra silagra^
!Buy viagra online inu^
!Purchase viagra^
!Buy low price viagra^
!Order viagra cheap^
!Buy online viagra^
!Buy viagra order viagra^
!Buy kamagra viagra india^
!Cheap viagra order online^
!To buy viagra how^
!Purchase viagra cialis levitra^
!Buy viagra line^
!Buy viagra online get prescription^
!Buy best k viagra btvmix^
!Buy cheap cheap kamagra uk viagra buy cheap cgeap kamagra^
!Buy viagra fedex^
!Mail order viagra^
!Cheap kamagra uk viagra^
!Order zenegra viagra^
!Order viagra canada^
!Cheap discount viagra^
!Where can i buy viagra^
!Buy viagra prescription^
!Cheap no prescription viagra^
!Buy now online viagra^
!Order 50mg viagra^
!Buy cheap cheap kamagra uk viagra buy cheap cheap kamahta^
!Viagra search find 74k generic buy free online pages cialis^
!Mail order and viagra^
!Buy brand viagra in the united states^
!Buy cheap cheap kamagra uk viagra buy cheap cheap kamagra^
!Cheap generic viagra substitutes^
!Buy online viagra where^
!Cheap viagra cialis india^
!Is it safe to buy viagra online^
!Edinburgh viagra good search charles linskaill pages buy^
!Buy cheap cheap kamagra uk viagra buy cheap cheap ksmagra^
!Buy cheap online viagra viagra^
!Where to buy viagra^
!Viagra postal order^
!Viagra buy^
!Cheapest place to buy viagra^
!Viagra edinburgh search pages buy online soft sites free find^
!Buy kamagra viagra^
!Buy viagrabuy viagra onlinebuy cialis onlinebuy levitra^
!Buy viagra^
!Can you order viagra from a canadian pharmacy^
!Internet order viagra^
!Buy viagra sale^
!Buy cialis online viagra^
!Buy viagra in hong kong^
!Mail order viagra online^
!Cheap say viagra wordpress^
!Cheap viagra generic^
!Order viagra viagra^
!Buy cheap online prescription viagra^
!Viagra to buy^
!Cheap viagra credit^
!Viagra purchase on line^
!Order viagra now^
!Order generic viagra^
!Where to purchase viagra cialis levitra online^
!Viagra online cheap^
!Viagra cheap online^
!Cheap viagra pill^
!Viagra buy viagra^
!Cheap viagra for sale^
!Cheap but effective alternative to viagra^
!Buy online viagra viagra^
!Buy cheapest viagra^
!Viagra cheap^
!Buy viagra onlines^
!Cheap generic viagra deals^
!Buy viagra 61291ps1e^
!Buy com online phentermine viagra^
!Order viagra buying viagra uk^
!Cheap viagra online prescription^
!Buy viagra internet^
!Viagra viagra buy^
!Buy no prior viagra cialis levitra^
!Buy online pharmacy viagra^
!Online medicine rx cialis viagra order^
!Viagra edinburgh pages search find boring free buy girl generic^
!Viagra purchase online^
!Buy levitra viagra online^
!Cheap online generic viagra^
!How to buy viagra cheap^
!Buy generic viagra generic cialis meltabs caverta^
!Cheap viagra uks^
!Buy citrate com generic sildenafil viagra^
!Order viagra without prescription^
!Order viagra over internet need no doctor^
!Best way to buy viagra^
!Order viagra online^
!Cheap meltabs viagra^
!Uk mail order viagra^
!Buy viagra onli^
!Buy viagra zenegra^
!Buy cheapest viagra online^
!Buy viagra online without prescription^
!Best buy meridia phentermine propecia viagra^
!Viagra online order^
!Buy cheap cheap kamagra uk viagra buy cjeap cheap kamagra^
!Buy discount viagra^
!Shop for cheap kamagra uk kamagra indian viagra kamagra uk no^
!Online pharmacy cheap viagra^
!Air order travel viagra articles web design videos^
!How to order viagra^
!Buy overseas viagra^
!Viagra on line order^
!Levitra buy levitra online viagra^
!Buy viagra online in uk^
!Buy discount viagra online^
!Cheap viagra ambien generic cananda^
!Online medicines rx cialis viagra order^
!Cheap generic viagra online^
!Buy loss online com phentermine prescription viagra weight^
!Purchase viagra in uk^
!Buy viagra usa^
!Very cheap viagra^
!Can you buy viagra over the counter^
!Cheapest place to buy viagra online^
!Where can i buy viagra in london^
!Generic viagra 3a caverta cialis cheap^
!Buy softtabs viagra^
!Cheap viagra rings^
!Cheap 100 mg viagra^
!Viagra viagra viagra buy^
!Buy cheap cialis generic levitra viagra^
!Buy viagra online no prescription^
!Buy viagra now online^
!Find viagra cheap overnight mail^
!Buy viagra pay with paypal^
!Order phentermine onlineorder viagra^
!Buy herbal viagra^
!Cheap kamagra uk kamagra indian viagra kamagra uk no^
!Buy cheap viagra online next day delivery^
!Buy xenical viagra propecia^
!Cheap viagra without prescription^
!Buy viagra 1^
!Cheap viagra^
!Where to buy viagra forum^
!Online order viagra^
!Purchase viagra without prescription^
!Buy and purchase viagra online^
!Buy now viagra^
!Cheap viagra online^
!Buy generic soft tab viagra^
!Buy generic viagra and generic sildenafil citrate^
!Cheap viagra canada^
!Cheap genaric viagra kamagra^
!Viagra cheap prescription^
!How to buy viagra without prescription^
!Canada viagra buy^
!How to buy viagra^
!Buy best k viagra kqdbyb^
!Viagra samples generic viagra buy viagra online videos^
!Buy lady uk viagra^
!Generic zantac viagra online pharmacy cheap onlin^
!Searchstarwarecom buy cheap cheap kamagra uk viagra^
!Cheap fioricet soma tramadol viagra^
!Where to purchase viagra cialis levitra^
!Viagra no prescription needed cheap^
!Sildenafil citrate viagra generic cheap^
!Kuwait buy viagra now^
!Buy herbal viagra longer erections^
!Honest place to buy viagra^
!Viagra best buy^
!Generic cheap viagra^
!Viagra mail order india^
!Viagra mail order^
!Buy uk viagra^
!Where buy viagra^
!Buy levitra viagra^
!Viagra online buy^
!Order viagra^
!Buy viagra levitra alternative lavitra^
!Free online order viagra^
!Viagra find sites search buy free online pages edinburgh charles^
!Where can you buy viagra in the uk^
!Cheap online viagra^
!Viagra edinburgh pages find search cheap overnight^
!Cheap viagra order online order discount viagra packs from 10^
!Buy cheap viagra online^
!Viagra cheap less^
!Buy generic viagra^
!Cheap herbal viagra^
!Buy online order viagra^
!Buy viagra now^
!Viagra free order^
!Can you buy viagra without a doctors prescription^
!Buy cheap generic viagra^
!How to buy viagra to ship to canada^
!Buy generic viagra si^
!Order viagra on line^
!Buy soft generic viagra cheapest^
!Cheap order prescription viagra^
!How to buy viagra online^
!Kamagra cheap viagra^
!Viagra order mail^
!Buy keyword online viagra generic viagra caverta silagra^
!Online pill viagra buy^
!Viagra pages edinburgh search cheap buy^
!Buy cheap online viagra^
!Buy viagra online cheap^
!Buy cheao cgeap kamagra uk viagra^
!Order 100 milligram phyzer viagra no prior rx needed^
!Viagra purchase uk^
!Purchase viagra uk^
!Cheap pfizer viagra^
!Viagra mail order uk^
!About buy viagra online links^
!Buy viagra online inurl^
!Viagra cialis cheap^
!Free viagra order online^
!Buy viagra in england^
!Air order travel viagra videos^
!Online purchase viagra^
!Prescription order viagra without^
!Viagra money order^
!Viagra order^
!Buy xenical viagra propecia com^
!Alternative buy viagra^
!Buy real viagra^
!Viagra online alternative apcalis buy cialis jel jelly^
!Buy generic viagra generic cialis meltabs caverta silagra^
!Order viagra air travel^
!Buy cheap uk viagra^
!Esnips user cheap viagra buy^
!Buy cheap purchase uk viagra^
!Viagra 25 mg order^
!Generic online order viagra^
!Buy online com phentermine viagra^
!Cheap viagra overnight^
!Viagra buy in uk online^
!Buy cialis levitra low online pharmacy price soma viagra^
!Viagra order online^
!Viagra edinburgh pages search find buy cheap cialis^
!Order generic viagra from india^
Thanks to Jared Still who posted this one on Oracle-l:
Picks: Oracle World Presentation on Performance
1 Comment Published by khailey September 20th, 2008 in Uncategorizeddue to inordinate amount of comment spam, I’ve had to make comments post-able only by people logged on.
Sorry for the inconvenience
check out SASH v2 on http://ashmasters.com/ash-simulation
The old version v1 required the partioning option which required Enterprise Edition, so I re-wrote the collection code to
1) install on windows as well as UNIX
2) simplify the code
3) use “poor mans partitioning”
Poor mans partitioning takes 7 ASH like tables and does a using “union all” to create the view v$active_session_history. This allows me to use truncates instead of deletes when purging data. Truncates are much cheaper than deletes and since alot of data is being collected the option of truncating is important. The collection package on the target inserts into a view on the repository called SASH. The view SASH points to one of 7 base tables SASH1 - SASH7. If there is no purge job running the the table base table will just keep filling up. If the optional job sash_repo.purge is started, then it will change which base table SASH points to (sash1 through sash7). Then every minute, hour or day (configurable) the job switches the view sash to point to the next base table, truncating the base table before the switch so that there is 7 minutes, 7 hours or 7 days of rolling data.
The Oracle community has proven to be impressively intelligent, insightful and supportive. There are so many people who have inspired and helped me. It’s the community that makes all this work worth while.
First off the idea and inspiration for ashmasters.com came from John Beresniewicz and Graham Wood, two people I had the privilege to work with at Oracle when redesigning the OEM performance screens in 10g. Both JB and Graham were people who inspired me, kept me sane and mentored me at Oracle. Graham is known as the father of ADDM and JB is man behind most anything worth while you seeing in OEM 10g performance monitoring. The 10g OEM group had a dream design team of Gaja Vaidyanatha, James Morle, John Beresniewicz with Graham helping us out in Server Technologies. The team was only together at the same time for a few months but those few months were probably the most fun I’ve had working with Oracle and I think there was some great improvements in the power and ease of the OEM performance interface that came out of that collaboration (though we all would have liked to have done much more with it).
I’m constantly indebted to people like Steve Adams, Jonathan Lewis who’s deep understanding , helpful responses and encouraging words have motivated me to go farther.
The list of people who have been a major part of my learning and enjoyment with Oracle goes on and on - Anjo Kolk , Connor McDonald , Julian Dyke, Tim Gorman, Stephan Haisley, Jared Still, Tanel Põder and luckily most of them are in the Oaktable which was the creation from Mogens Nogard who I can’t thank enough.
It’s ironic - there are people who take credit and people who want credit and then there are people who do tons and no one knows about them. The fellow who first introduced me to the wait interface in 1994 (!) not only introduced me to it but showed me how to connect to the SGA directly with C and monitor the sessions almost like ASH but many years ahead of it’s time. No one hardly knows the fellows name - thanks Roger Sanders!
I want to make contribution via making things simple and harnessing graphics. I admit that some of the central graphical ideas ideas I that I rallied for in the OEM team came from small but pivitol pieces I saw in Quest products. I have since seen many of the ideas brought forth in OEM 10g showing up in other products on the market. What goes round comes round. Ideas build off ideas. No inventor is an island to themselves. We all build of existing ideas or are inspired by current ideas, but when there is discussion, sharing and community the ideas can grow faster, be more fun and become more powerful.
I’m looking for is work that inspires me and to work with people who share in the inspiration.