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
- 9224 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 |
How do I sort a table in sql?
Can there be 2 primary keys in a table?
Can we use having without group by in sql?
Can we call a function containing dml statements in a select query?
Differences between UNIQUE and DISTINCT in select statements
26 Answers ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
How many rows can sqlite handle?
Can a primary key be a foreign key?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
How to rename a column in the output of sql query?
What is an inconsistent dependency?
How do I create an index in word?
How do you modify a column in sql?
-
Oracle (3259) - 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)
