If CPU is very slow What can u do to speed up?
Answer / braj123
--> use VMSTAT to check the cpu enqueues.
--> also use top and sar commands for cpu load.
| Is This Answer Correct ? | 1 Yes | 0 No |
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What would you use to improve performance on an insert statement that places millions of rows into that table?
why Datapump is faster than traditional export and import
What is the importance of a recovery model? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
Query processing is slow(eg select query)how will u solve that
how can you find out if a table can be redefined?
wat is global index and local indes
If we issue alter database begin backup. What happens to database?
what is the use of recording information about current session?
Explain the concept of the DUAL 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)