If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

277

What does dba stand for database?

294

How can you determine if an index needs to be dropped and rebuilt?

294

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

263

How to uncatalog backup?

291

What do you understand by the oracle?

256

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

343

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

305

How can you find dead processes?

278

How would you find total size of database in os level?

287

Explain the wait events in statspack report 'db sequential real'?

279

How do you prevent output from coming to the screen?

260

How does one coalesce free space?

285

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

302

How do you install statspack?

397