yes it shows load on the db while running the query
When running SQL query , we use SQL Developper.
I saw execution plan from SQL Developper.
In that result, I saw select statament and cost in the top of the result of execution plan from SQL Developper.
That top select statement and its cost means the total query DB cost of over all SQL statement ?
Not really a sql developer question.
The Oracle documentation has entire chapters on Explain and Excecution plans, how to read them, and what information is, or can be, contained in them. See 'Reading Execution Plans':
7 Reading Execution Plans
This chapter contains the following topics:
The lead of Oracle's Optimizer has also written a white paper discussing this in greater detail. See 'What is Cost' on page 8.
What is Cost
The Oracle Optimizer is a cost-based optimizer. The execution plan selected for a SQL statement is
just one of the many alternative execution plans considered by the Optimizer. The Optimizer selects
the execution plan with the lowest cost, where cost represents the estimated resource usage for that
plan. The lower the cost the more efficient the plan is expected to be. The optimizer’s cost model
accounts for the IO, CPU, and network resources that will be used by the query.
Please mark this question ANSWERED.
If you need further help repost the question in the Database General forum. Before reposting search that forum and you will find PLENTY of previous threads that also answer your question.
Where is mark as answered check button ?( I googled for that)
I clicked Action in your answer but nothing is poped up. I guess it is brower problem.