Interested to Buy Any Domain ? << Click Here >> for more details...
what are the tunnig tables you used for tuning a query and
tell me some of coloumns in that tuning tables?
- 1 Answers
- 9377 Views
- Metric Stream, I also Faced
- E-Mail Answers
Answer / vyshak
select * from
(select sql_id,sql_fulltext,elapsedtime
from v$sql
order by elapsedtime desc)
where rownum<5;
| Is This Answer Correct ? | 5 Yes | 4 No |
what is a control file ? : Sql dba
Why is theta join required?
What is snowflake sql?
What is the different between Stored Procedure and Procedure?
What is a data manipulation language?
How many subqueries can be nested in a statement?
When is the update_statistics command used?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
How to rename a column in the output of sql query?
How many columns should be in an index?
What are the most important characteristics of pl/sql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
