Showing posts with label Parameters. Show all posts
Showing posts with label Parameters. Show all posts
Tuesday, June 3, 2025

PostgreSQL Memory Parameters and how they relate

›
Here are some of the important memory parameters in a postgreSQL server, and how they relate to one another. shared_buffers The amount o...
Tuesday, August 15, 2023

Simple PL/SQL script to alter parameter in database

›
At my current workplace, we use emcli for mass-updates of database parameters in groups of databases. Below is a simple PL/SQL script that...
Monday, June 26, 2023

How to show current utilization of sessions, processes and other important settings for a database

›
Example: set lines 300 col RESOURCE_NAME format a30 select RESOURCE_NAME,CURRENT_UTILIZATION,MAX_UTILIZATION,INITIAL_ALLOCATION,LIMIT_VAL...
Tuesday, August 2, 2022

How to change an Oracle instance parameter based on database version and container type

›
Here is a simple pl/sql script that will set parameters based on version and container type. set serveroutput on DECLARE v_version ...
Tuesday, June 28, 2022

List parameters in a container database

›
To see the list of parameters in a container database, use can use the following query. select name,value,display_value, default_value,...
Wednesday, March 2, 2022

How to check when a parameter was changed

›
Thanks to Sandeep Singh for providing this very useful information. The following query will reveal any changes to a particular parameter...
Wednesday, January 5, 2022

How to set a dynamic parameter in a postgreSQL database cluster

›
As with oracle, some parameters may be set dynamically in a postgreSQL database cluster. A postgreSQL database cluster uses a parameter f...
Thursday, September 30, 2021

How to rename a database to use lower case instead of upper case characters

›
At my customer's site, we have standardized the Oracle SIDs (System ID) to use lower case character. During an upgrade, the SID was ...
Thursday, November 5, 2020

How to change the control_files parameter used in the spfile

›
Mind your syntax when you are changing certain multi-value parameters directly in the spfile. Oracle will tell you that the syntax is accep...
Friday, September 21, 2018

Parameters that can be removed after upgrade to 12.2

›
From Information For Parameters _upgrade_optim and _upgrade_capture_noops (Doc ID 2182783.1): Below parameters gets added after upgrade t...
Friday, December 1, 2017

How to remove unwanted parameters from init.ora using a shell script

›
1. Create a "removal list" containing your unwanted parameters. For example, put the following into a text file called removal_lis...
Monday, August 21, 2017

Some important tuning parameters in Oracle 12c

›
Here are some parameters that you will have to deal with when tuning an Oracle 12c database. Execute the following SQL to view their curr...
Friday, April 7, 2017

How to create a logon trigger

›
In this particular example, I create a logon trigger that sets one of many available NLS session parameters, as well as sets an undocumentet...
Thursday, December 15, 2016

How to create a line-by-line comparison between the parameters used in two different databases

›
Here is a simple way to create a line-by-line comparison between two databases over a database link. First make sure there is tns Connecti...
Wednesday, February 3, 2016

11.2.0.2 and onwards: v$parameter reflects the NLS session parameters, not the NLS instance parameters

›
After a migration of a database from single-byte to multi-byte character set, I wanted to compare the nls_parameters. As a part of the m...
Friday, October 30, 2015

Syntax for setting hidden parameter in Oracle

›
Syntax example: alter system set "_system_trig_enabled"=TRUE scope=both;
Thursday, October 9, 2014

How to find hidden parameters in the database

›
set lines 200 col description format a70 col value format a20 col name format a30 SELECT name,value,description from SYS.V$PARAMETER WHERE n...
Monday, June 30, 2014

log_archive_format default value

›
Having trouble finding out why the value of the parameter LOG_ARCHIVE_FORMAT does not seem to apply to your database? From Oracle 10g and ...
Thursday, June 12, 2014

How to set the db_file_name_convert and log_file_name_convert parameters

›
In this example, I want to redirect the files to a slightly different path during a clone from prod to test. In prod, files are to be foun...