Summary
SQL Server has system databases, such as master,msdb,model, and tempdb. Even though Oracle does not have individual system databases that match the ones in SQL Server, the platforms share some similar concepts. There is a need for system information, there are parameters and options that can be configured and viewed, and transaction logging keeps track of changes.
Oracle has memory structures for supplying memory to server processes and user processes. There are individual parameters to manually configure memory, or dynamic settings that are available in Oracle Database 11g by setting one parameter. Data dictionary views show the system information, including the values of the parameters. Oracle offers quite a few parameters for tuning ...
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.
