tailieunhanh - Oracle Database Administration for Microsoft SQL Server DBAs part 23

Oracle Database Administration for Microsoft SQL Server DBAs part 23 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 202 Oracle Database Administration for Microsoft SQL Server DBAs Database knUrne MMDCVl Tablespaces COMt Type Tabb M Search Cnw an object name to filter the data that it displayed n your results Mt Object Name t Go Bydrta itasaarthrmmsalitefrrawiMtthmbegmngxhthaemgyttjaMrrad. Tonnanaiart er taw wnWMmatrh doutteojota the snarchemg You can use the xtdrard s t ei n a dautte jetad mg Total Allocated See MB 13506 Cnlne x ofltae Rnad Only Total used MB 1 Total AitxaM rrw Space MB Database I rM l I I 1 JQU FIGURE 7-12. Tablespace listing in OEM system tends to cause some issues with the entire database not with just the tablespace that has run out of space. Also a couple of tablespaces could possibly cause some issues if just left to autoextend. The undo and temporary tablespaces should be sized as needed. Joins views and sorts could take up a lot of the temporary tablespace. Just as you would look at actions that were using up more space in the tempdb database on SQL Server you should investigate the statements running against the database before adding more space to the temporary tablespace. When monitoring the tablespaces it might appear that the temporary tablespace is completely used but the space does get reused just as with tempdb. The undo tablespace also could appear full but the new transactions reuse the space if the old transactions are completed. Resizing the temporary and undo tablespaces might just open up the database for other issues without solving the problem of transactions that are using up the space. One indicator of problems is when the temporary or undo tablespace is using two or three times the space used by all of the other tablespaces. When transactions are needing that much space examining the queries is a good first step. We will take a closer look at this in the next chapter. Chapter 7 Database Maintenance 203 Maintaining the SYSAUX and SYSTEM tablespaces is somewhat easier than managing the user tablespaces. Placing user objects .

• Chứng chỉ quốc tế
• Học Oracle
• quản lý cơ sở dữ liệu
• luyện thi chứng chỉ quốc tế
• môi trường SQL Server
• cơ sở dữ liệu oracle