Select_catalog_role role for 9i and probably 8i.īeautification of ugly SQL is a great feature. (You really would not need to use the 9i version)ġ0g version appears to require that you have select any dictionary systemĩi version will not connect to 10g as someone noted and appears to require
(I think sql scratchpad was added in 9.2, not present in 9.0 which is why many overlooked it.)ġ0g Version of the “Java thingy” has same the features, except graphical tree as noted, and can still connect to 9i and 8i DBs.
TAB SQL SCRATCHPAD WINDOWS
Is an alternative quick way to start the console from windows command prompt (runs first version it finds in your PATH) Isn’t it just too cute – and it isn’t available in the 10g Web version of OEM.ġ0g version starts and is used the same way as 9.2 The way it is drawn is as I described in my note on “Left-Deep Trees” – You walk anticlockwsie around the tree, ignoring nodes on the way down, operating them as you go up, passing them to their right. The buttons still allow you to walk the plan in order. (The other buttons let you walk through the plan in order, forwards or backwards, view the statistics of each object in turn, or generate a complete of the query and plan). Click on that, and you get the graphic image of the execution plan. See the button that looks like some sort of flow chart. It’s not really a good example of using explain plan, as it doesn’t tell you about the predicates ( oh no! not that again) – but at least it gives you structure and the internal order of execution.īut the best is yet to come. For a cost-based query, the extra columns about cost, rows, and bytes would also be filled. Click on any step, and an explanation of the step appears at the bottom of the window. I’ve left a little bit of the SQL Scratchpad window in view so that you can see the available icons.Īs you can see from the picture, the right hand column of text shows you the order of execution of the steps. The first picture below is the result of explaining “select * from dba_objects”. Hit the icon below that to get the Explain Plan window. Type in a bit of SQL, make sure the cursor is somewhere in the SQL, and hit the “lightning” icon to the left of the window to make it run. Click on this, and you get the logon screen for the database.Īs you acquire a connection, the SQL Scratchpad window pops up. Right-click on one of the available databases and you get a drop-down menu which includes, third from bottom, “SQL Scratchpad”. To get this going, start up OEM, and click on the Databases icon to get the drop-down list of known databases. If you run Oracle Enterprise Manager for 9i – the Java thingy – there a little-known feature called the SQL Scratchpad (now there’s a coincidence) that allows you to run, and explain, SQL statements – a bit like a couple of commercial tools, but free(r). (See comment 8 for some extra notes from Dave Moore). Another is to use a little feature that I learned about from Dave Moore at Cargill last week. One way to find out is come on my next “Explain Plan” tutorial day – keep an eye on the website for dates and locations in Europe and the USA. Select from one of the available data tables note, the selected table must be from an activated pipeline.A common question about execution plans is the one ‘which line does Oracle operate first’.
Query is the simplest way to explore your data. Fitting Machine Learning model on Kafka dataįitting Machine Learning model on S3 data
0 kommentar(er)
