Answer / irimi

DBCC commands are most useful for performance and troubleshooting

PROCCACHE
SHOW_STATISTICS
TRACESTATUS
SHOWCONTIG
....

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

What is replication? : sql server DBA

0 Answers  

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---