How do I create a pfile?

Published by Anaya Cole on

How do I create a pfile?


  1. If the current container is the root, then the database creates a text file that contains the parameter settings for the root.
  2. Starting with Oracle Database 12c Release 1 (12.1. 0.2), you can create a text parameter file when the current container is a PDB. In this case you must specify a pfile_name .

What is Tkprof in Oracle with example?

TKPROF determines execution plans by issuing the EXPLAIN PLAN statement after connecting to Oracle with the user and password specified in this parameter. The specified user must have CREATE SESSION system privileges. TKPROF takes longer to process a large trace file if the EXPLAIN option is used. RECORD.

What is Oracle compatibility parameter?

The COMPATIBLE Initialization Parameter. The Oracle Database enables you to control the compatibility of your database with the COMPATIBLE initialization parameter. By default, when the COMPATIBLE initialization parameter is not set in your parameter file, it defaults to 10.2. 0 for Oracle Database 10g release 10.2.

How do I start a database using Pfile?

Migrating to Oracle9i SPFILE

  1. Create the spfile from the existing pfile using: SQL> CREATE SPFILE FROM PFILE=’d:init. ora’; File created.
  2. Restart the database to start using the newly created spfile. SQL> STARTUP ORACLE instance started.

Where can I find Pfile in Oracle?

By default, PFILE is located in $ORACLE_HOME/dbs .

What is SQL trace and Tkprof?

The SQL trace facility and TKPROF are two basic performance diagnostic tools which can help you monitor and tune applications that run against the Oracle Server.

How do I Analyse a Tkprof trace file in Oracle?


  1. Identify SQL statements that do not use bind variables.
  2. Identify statements that perform full table scans.
  3. Identify statements that are doing multiple disk reads or have high CPU consumption.
  4. Compare the number of parses and executions.

What is compatible parameter in Oracle 19c?

Values for the COMPATIBLE Initialization Parameter in Oracle Database

Oracle Database Release Default Value Minimum Value
Oracle Database 19c 19.0.0 11.2.0
Oracle Database 12c Release 2 (12.2) 12.2.0 11.2.0
Oracle Database 12c Release 1 (12.1) 12.0.0 11.0.0
Oracle Database 11g Release 2 (11.2) 11.2.0 10.0.0

How do I get rid of restore points?

To drop a normal restore point, you must have either the SELECT ANY DICTIONARY or the FLASHBACK ANY TABLE system privilege. To drop a guaranteed restore point, you must have the SYSDBA system privilege.

What is Pfile and Spfile in Oracle?

SPFILE is a binary file that contains the same information as the old PFILE. SPFILE permits dynamic changes without requiring you to restart that instance. By default, if you do not specify PFILE in your STARTUP command, Oracle will use server parameter file (SPFILE).

How do I know if my database is running with Pfile or Spfile?

Select * from v$spparameter;(to check the Spfile). Select * from v$parameter(to check the pfile). If any Path available in Value column. DB is running in SPFile, else Pfile.

What is an Spfile in Oracle?

How can I tell if Oracle is using Pfile or Spfile?

How do I check my Pfile?

What does Tkprof stand for?

the Transient Kernel PROFile
Answer: TKPROF stands for the Transient Kernel PROFile, set via the sql_trace parameter, and used to format a trace file into readable form.

What is SQL trace in Oracle?

What is query in Tkprof?

Query – The number of buffers retrieved for all parse, execute, or fetch calls. ยท Current – The number of buffers retrieved in current mode (INSERT, UPDATE, or DELETE statements). Observe from the tkprof output above that the SQL statement performed a TABLE ACCESS FULL, meaning a full-table scan.

What is difference between Oracle 12c and 19C?

Oracle Database 19C was released on Oracle Live SQL in January 2019 and is the final version of the Oracle Database 12C family of products. Oracle Database 19C comes with four years of premium support and at least three extended supports.

Can Oracle 19C client connect to 12c database?

Yes. You can think of 12, 18 and 19 as being part of the same “12c” family of databases.

Categories: FAQ