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, ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
