Using dbms_xplan.display_cursor function we are also setting the session level parameter to retrieve the explain plan of query. Where the condition is showing that select the data from the specified column. Table name is showing that we are selecting, inserting, updating and deleting data from the specified table. In the above syntax, select is the command which was used to select the data from the specified table. Select * from table (function_name (dbms_xplan.display_cursor) (format)) Select * from table_name where condition Syntax of dbms_xplan.display_cursor function:
#Xplan login how to#
We can use dbms_xplan.display_cursor function to display the actual plan of the query by using cursor cache.īelow syntax shows that how to use dbms_xplan.display_cursor function in oracle as follows: The keyword of the format is separated by using space or comma. This level contains all information of the typical level as well as it contains the information of alias, projection and remote SQL.
#Xplan login serial#
The serial level works the same as typical, it is not excepting the parallel information, even if our plan was executing in a parallel fashion. Parallel and pruning information using this level will have displayed only when it was applicable. operation name, option, id and cost of optimizer. Typical level is displaying relevant information from the plan i.e. Typical is default level of format parameter in dbms_xplan.display_cursor function. The basic level is displaying minimum information from the plan like operation name, id and other options. The format parameter will be accepting the four levels to control the query plan. To display the available display format settings for this function, have RUNSTATS_TOT and RUNSTATS_LAST to displaying the total statistics of runtime.This option is required to set the STATISTICS_LEVEL parameter as ALL.If we are not specifying child_number then all SQL_ID from the cursor cache will be displayed.This parameter is specified by the SQL_ID parameter from the function of dbms_xplan.display_cursor.If suppose we are omitting the session, it will be displaying the last cursor executed session.This parameter is also available in V$SESSION view by using column name as PREV_SQL_ID.This parameter is available in V$SQL_AREA and V$SQL views. This is existing in the cache of cursor.Past performance isn't a reliable indication of future performance.To use dbms_xplan.display_cursor function on a query we are using below parameter, these all three parameters are optional. Read the Spirit Super Advice Financial services guide or call us on 1800 005 166 for a copy.
Read the relevant Spirit Super Product disclosure statement (the Member guide or Pension guide) and Target market determination or call us on 1800 005 166 for a copy.Īny advice given on this website is provided by Quadrant First Pty Ltd (ABN 78 102 167 877, AFSL 284443) (Spirit Super advice) which is wholly owned by Motor Trades Association of Australia Superannuation Fund Pty. If you're considering acquiring or continuing to hold a particular financial product, you should obtain the Product disclosure statement relating to the product and consider it before making any decision. You should assess your financial position, personal objectives and needs before making a decision based on this information. This website is for general information only and doesn't take into account your objectives, financial situation or needs. We honour the wisdom of, and pay respects to, Elders past, present and future. We acknowledge and pay our respects to Aboriginal and Torres Strait Islander Peoples as the First Peoples of Australia, whose ancestral lands and waters we work and live on throughout Australia.
0 kommentar(er)
