![]() The “feedback only” option is a 12c option that means the session doesn’t display the results and shows only the final “N rows selected” report. Prompt SQL*Plus 20,000 rows, arraysize 2000Īll I’ve done is select 20,000 rows from view all_objects in a remote database with two different settings for the array fetch size. Prompt SQL*Plus 20,000 rows, arraysize 20 For this type of testing it’s probably sensible to use two database rather than faking things with a loopback database link in case the loopback introduces some special features (a.k.a. It’s fairly easy to get some ideas by running a couple of queries and checking session activity stats and wait events – so here’s a little test conducted between a database running 12.2.0.1 and a database running 11.2.0.4. ![]() Type in the character(s) to use to mark the end of each statement.ĭisplays the Help on the SQL Query Scratch Pad.ĭisplays a label providing a description of the current SQL, whether there are pending changes (indicated by a leading *), and the name of the loaded SQL Query object or Filename.Precis: The effects of setting the SQL*Net SDU_SIZE with particular reference to db linksĪ recent thread on the Oracle developer forum raised the question of how data moves across a database link – is it row by row or array based (or other)? It’s a good question as it’s fairly common knowledge that a distributed query can be very much slower than the same query when executed on an equivalent set of local tables, so it’s worth having a little poke around to see if there’s anything about the way that data moves across the link that could be tweaked to improve performance. sql file.Ī source file browser displays on which you type in the new file name and click on the Save button to save the Query.Īny Query displayed in the Scratch Pad remains there until you either replace it with another Query from file or you close the model.Īpplies the SQL comment characters '-' to the beginning of each selected line or, if the selected lines are already commented, removes the comment characters. ![]() Saves the currently-displayed Query to a new. If you created the Query from scratch, a source file browser displays in which you type the new file name and click on the Save button to save the Query. Saves the currently-displayed Query to the file it came from. Saves this SQL statement to the SQL Query object it came from.Ĭreates a new SQL Query object and saves this statement to that object. Click on the file name and on the Open button to display the file contents in the Scratch Pad. Open the Database Builder window, then display the ' SQL Scratch Pad' tab.Įxecutes the SQL Query currently shown in the Scratch Pad.Ĭheck the 'Results' and 'Messages' tabs for the output of executing the Query.Ĭlears the SQL Query editor fields so that you can enter a new query.Ī source file browser displays, defaulted to display SQL files.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |