TAILIEUCHUNG - Oracle Database Administration for Microsoft SQL Server DBAs part 5

Oracle Database Administration for Microsoft SQL Server DBAs part 5 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 | 22 Oracle Database Administration for Microsoft SQL Server DBAs Also think about the data being accessed. Is all of the data always being read And if it is what about growth It will be hard to keep up with supplying memory to the server as the size of the database grows. Full scans of tables will flush some of the blocks out of memory and when code pulls more data than expected having everything in memory might prove difficult. Tuning queries to pull just the data that is needed might avoid some of these larger scans at least minimizing the physical reads. Blocks that are read into the buffer cache are ordered from most recently used MRU to least recently used LRU . Blocks that are read as part of a full-table scan are put on the LRU end. If the buffer cache is full the LRU blocks will be flushed out of the cache. The goal is to keep the most frequently used data in memory for quicker access. This also includes the code SQL statements in the library cache. So you will want to size the SGA to follow these guidelines and then tune it as the database changes and grows. PGA Considerations The PGA is used for the program or user processes. As shown earlier in Figure 2-1 there are manual and automatic options for managing the PGA. Setting the workarea_SIZE_policy auto parameter has Oracle use the PGA_AGGREGATE_TARGET parameter for sizing the user processes for SQL that use memory such as for sorts group by hash joins and bitmaps. You can find information about PGA usage in the v pgastat view and also by looking at the maximum values of the pga_used_mem pga_alloc_mem and pga_max_mem columns in the v process view. There is also an advice table for PGA v pga_target_advice to help determine a good setting for pga_aggregate_target. Where Are the master msdb and tempdb Databases The SQL Server master msdb and tempdb databases do not exist in the Oracle world. In Oracle other areas keep the system information provide a way to schedule jobs and maintain a temporary space for .

• 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
• Đề cương môn Chuyên đề Oracle
• Chuyên đề Oracle
• Quản trị cơ sở dữ liệu
• Biện pháp bảo vệ cơ sở dữ liệu
• Cấu trúc lưu trữ
• Tin học thực dụng
• Thực hành ORACLE 11g
• Lý thuyết ORACLE 11g
• Ngôn ngữ lập trình PL SQL
• Lập trình nâng cao với PL SQL
• Thư viện Java
• Topic Focused
• Multi document Summarization
• Approximate Oracle Score
• báo cáo khoa học
• mô hình ngôn ngữ
• xử lý ngôn ngữ tự nhiên