O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required