What is an initialization parameter file in Oracle?

Oracle - What is an initialization parameter file in Oracle? - June 27, 2009 at 11:00 AM

What is an initialization parameter file in Oracle?

The initialization parameter file contains a list of initialization parameters.
It should be written in the client's default character set.
Oracle distribution medium provides sample initialization parameter files for each OS which are sufficient for initial use.
However, for performance reasons, the file could need modifications for database tuning.
The system needs to be restarted for the changes to come into effect.

Also read

What is clusters?

Clusters group together tables that share common columns. These tables are often used together.........

What is Data Block?

Data blocks are also called logical blocks, Oracle blocks, or pages. At the finest level of granularity, Oracle stores data in data blocks............

What is SQL*Plus?

SQL*Plus is an interactive and batch query tool, it gets installed with every Oracle Database Server or Client installation.............

Explain the concepts of Exception in Oracle. Explain its type.

Exceptions in oracle occur when unwanted situations happen during the execution of a program. They can occur due to system error, user error or application error..............

<<Previous Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Oracle interview Oracle architecture Oracle FAQs Download Oracle/Java FAQ Test Oracle skills New More Oracle FAQs Oracle processes Oracle memory area Oracle file types Oracle database objects Oracle operators Oracle composite Oracle constraints Oracle data types Oracle DCL and TCL Oracle DML commands Oracle error handling Oracle functions Oracle procedure, package Oracle import and export Oracle sub queries Oracle table Oracle triggers Oracle views Oracle synonym Oracle indexes Oracle joins Oracle cursors Oracle form Oracle security Oracle system privilege Oracle object privileges Oracle table privileges Oracle view privileges Oracle backup & recovery Oracle DBA Oracle PL/SQL Oracle nested table & varrays Oracle large objects Oracle replication Oracle transaction Oracle optimizer Oracle auditing Oracle backup Oracle database tuning Oracle application tuning Oracle procedures Oracle functions Oracle loops Oracle exceptions Oracle Select into clause Oracle string functions Oracle numeric functions Oracle date functions Oracle translate and decode Oracle correlated sub-queries Oracle union, intersect, minus Oracle clusters Oracle sequences Oracle tablespaces Oracle object datatypes Oracle Tutorial


Latest MCQs
» General awareness - Banking	» ASP.NET	» PL/SQL	» Mechanical Engineering
» IAS Prelims GS	» Java	» Programming Language	» Electrical Engineering
» English	» C++	» Software Engineering	» Electronic Engineering
» Quantitative Aptitude	» Oracle	» English	» Finance
Home \| About us \| Sitemap \| Contact us \| We are hiring
© Copyright 2016. All Rights Reserved. Terms of use \| Follow us on Facebook!

What is an initialization parameter file in Oracle?