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 ...
Wednesday, June 25, 2014

How to gather dictionary statistics and fixed-objects statistics

›
Use the procedures dbms_stats.gather_dictionary_stats and dbms_stats.gather_fixed_objects_stats Examples: BEGIN DBMS_STATS.GATHER_...
Tuesday, June 24, 2014

Where to find the database characterset in the dictionary

›
SQL> select value$ from sys.props$ where name = 'NLS_CHARACTERSET'; VALUE$ ---------------------------------------------------...

How to work around dbca error "The Oracle system identifier ... already exists, specify another SID"

›
If you have previously created a database through dbca and saved it as a template for future use, you may see the following error when tryin...
Friday, June 20, 2014

Potential cause of ORA-12547: TNS:lost contact

›
I was running a script against the database directly on the host, when the script timed out with: ERROR: ORA-12547: TNS:lost contact Aft...
Thursday, June 19, 2014

How to disable or drop an SQL Profile

›
Find the profiles currently saved in the database: SELECT NAME, CREATED,LAST_MODIFIED,TYPE,STATUS,FORCE_MATCHING FROM DBA_SQL_PROFILES ORD...

What does the TERRITORY component of the NLS_LANG parameter control?

›
From OTN : "The territory component of the NLS_LANG parameter controls the operation of a subset of globalization support features. ...