Necessary Initialization Parameters Without Performance Impact
==============================================================
DB_NAME := Name of the database. This should match the ORACLE_SID environment
variable.
DB_DOMAIN := Location of the database in Internet dot notation.
OPEN_CURSORS := Limit on the maximum number of cursors (active SQL
statements) for each session. The setting is
application-dependent; 500 is recommended.
CONTROL_FILES := Set to contain at least two files on different disk drives to
prevent failures from control file loss.
DB_FILES := Set to the maximum number of files that can assigned to the
database.
Halim, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment