Oracle Tips  by Burleson Consulting

The Data Warehouse Development Life Cycle

Managing SQL*Net Connections

Listing 9.3 describes some of the utilities you can use to manage SQL*Net sessions effectively. You should be aware that some of the examples in this section are operation system-dependent and may not apply to your environment.

Listing 9.3 Commit point strength.

commit.sql - Reports the commit point strength for the database.

set feedback off
column name format a30 heading 'Name'
column type format a7 heading 'Type'
column value format a60 heading 'Value'

prompt Commit Point-strength Report Output:
prompt
prompt
select name,
decode(type,1,'boolean',
2,'string',
3,'integer',
4,'file') type,
replace(replace(value,'@','%{sid}'),'?','%{home}') value
from v$parameter
where name = 'commit_point_strength';

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.  You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.