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
- 9322 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 the purpose of using pl/sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
How does sql*loader handles newline characters in a record? : aql loader
How to add a column ‘salary’ to a table employee_details?
When to use inner join and left join?
Why we use joins in sql?
wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010
Its possible to add more than one primary key for the table
How do I run sql?
What are predefined functions in sql?
while loading data into database how can u skip header and footer records in sql*loader
How many triggers can be applied to a table?
-
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)
