Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Category Archives: Parameters
Inactive sessions in the database.
Following a conversation regarding inactive sessions and the process limitation on the database, this client was having connection failures to the database. What should be done regarding this ?
Posted in Configuration., Oracle, Parameters
Tagged connection, pooling, processes, sessions, v$process, v$session
Comments Off
Archived Redo Log Creation in the Flash Recovery Area
Archived Redo Log Creation in the Flash Recovery Area How do I create archived logs in the flash recovery area, or move my existing ones to the flash recovery area ?
Posted in Configuration., Oracle, Parameters
Tagged Archive, DB_RECOVERY_FILE_DEST, DB_RECOVERY_FILE_DEST_SIZE, FLASH~RECOVERY~AREA, FRA, LOG_ARCHIVE_DEST, LOG_ARCHIVE_DUPLICATE_DEST, REDO
Comments Off
ALTER DATABASE ARCHIVELOG COMPRESS enable
This command SHOULD start compressing archivelogs written to remote and local destinations. That includes the local drive for archive logs. However, this command was not fully documented and released in oracle 11g, or 10g, except for the 10g beta documents, … Continue reading
Posted in Configuration., Oracle, Parameters
Tagged 00600, 600, Archive, archivelog, COMPRESSION, ORA-00600
Comments Off
archive_lag_target
Posted in Configuration., Oracle, Parameters
Tagged Archive, ARCHIVE_LAG_TARGET, Log, parameter, parameters, REDO, standby
Comments Off
active_instance_count
Posted in Configuration., Oracle, Parameters
Tagged ACTIVE_INSTANCE_COUNT, parameter, parameters
Comments Off
Using LOCAL_LISTENER
Local_Listener is used to tell the database not to register with the LISTENER on the host at port 1521, the default. You can change it as shown :
Posted in Configuration., Networking, Oracle, Parameters
Tagged LISTENER.ORA, LOCAL_LISTENER, network, parameter, parameters, TNSNAMES.ORA
Comments Off
Error 16047 creating remote archivelog file
Posted in Configuration., Oracle, Parameters, Physical Standby, Standby
Tagged 16047, db_unique_name, DGID, FAL, LOG_ARCHIVE_DEST, mismatch, ORA-16047, ORA-16055:, physical standby, request~rejected, standby
Comments Off
AWR and Statistics_level
Came across an interesting link between the statistics_level and the AWR data collected. Very easy to mess up the SYSAUX tablespace…..
Posted in Configuration., Enterprise Manager, Oracle, Parameters
Tagged awr, DATA~COLLECTION, STATISTICS_LEVEL, SYSAUX
Comments Off
SYSMAN tablespace grows excessively.
I had the sysman tablespace on a database grow to 22Gb and could not figure out why. Logged an SR for it and followed up with suprising results.
Posted in Configuration., Enterprise Manager, Oracle, Parameters
Tagged ALTER~TABLE, STATISTICS_LEVEL, SYSMAN, WRH$_LATCH_CHILDREN
Comments Off
Setting MAX_MEMORY and MAX_MEMORY_TARGET.
Defining Memory Limits in Oracle 11. Upgrading Oracle 10.2.0.4 to 11.1.0.7, we required to calculate the memory targets to allow automatic memory management to include SGA and PGA.
Posted in Configuration., Oracle, Parameters
Tagged automatic~memory~management;, MEMORY_MAX_TARGET, MEMORY_TARGET, PGA_AGGREGATE_TARGET, SGA_TARGET
Comments Off
