Đang chuẩn bị liên kết để tải về tài liệu:
Oracle Database Administration for Microsoft SQL Server DBAs part 6

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

Oracle Database Administration for Microsoft SQL Server DBAs part 6 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 | 32 Oracle Database Administration for Microsoft SQL Server DBAs As you can see there are quite a few background processes running with Oracle. Depending on how many slaves are spawned and which different components are installed more processes may be running. Let me just say that there are definitely more than ten background processes The fact that particular processes are running on the database system can give you more information about the database such as which components are installed or if the database is in ARCHIVELOG mode. sp_configure Options and Parameters Those who say database administration is getting easier are not looking at all of the knobs that can be turned. More options and parameters are released with each new version of Oracle. I think that you will agree that more configurable parameters have been added to SQL Server as well. But setting the parameters is actually not the tricky part. The challenge is knowing which parameters might be related or impacted when you adjust a particular parameter. As discussed earlier Oracle has overall parameters such as memory_ TARGET which manage the other underlying parameters dynamically. This approach makes it easier to change the parameters but you still need to know which settings are appropriate for example which ones are for online transaction processing OLTP and which ones are for data warehouse systems. I think of these parameters and options like a stereo tuner or soundboard. Preconfigured settings for different types of music can be used and they will work for most people listening to the music. But then there are trained ears that need more of a definition of the tones or mixes of the music to make it sound exactly the way they want it. What happens if the music type changes or an instrument affects the volume What if it is playing in the orchestra hall How about in a small car For these cases more adjustments are needed. And when making such adjustments you need to consider whether changing one .