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
Monthly Archives: November 2010
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
Upgrade 11g R1 to oracle 11g R2.
I was testing the upgrade for 11.1.0.7 to 11.2 and ran into a couple of problems which I’ll document later.
Upgrade 10g R2 to oracle 11g R2.
I was testing the upgrade for 10.2.0.4 to 11.2 and ran into a couple of problems which I’ll document later. Here’s the basic steps to upgrade.
Disabling Flashback.
Posted in Configuration., Oracle
Tagged ALTER~DATABASE, DBMS_FLASHBACK, DISABLE~FLASHBACK
Comments Off
Why SPU fails
Hi, Our DB is in one of netezza box, from last 7 days 2 SPU’s got failed. Can i know what are all the possiblity for this?. Like query issue or Num of records etc? Harish Continue reading
Netezza Query Monitoring
Netezza query monitoring Netezza twinfin uses a little different architecture compared to old Mustang. Each node maps to eight disks with 1 TB on each disk on TwinFin 12 system. That is, if we have a TwinFin 12, total capacity is 12 x 8 = 96TB. Here are steps that I used for monitoring purpose; [...]
Continue reading
Question on Statistics
I am new to netezza ( and posting questions). I am trying to find out when the last time statistics were run on a set of tables? Is there a table I can look in? thanks Continue reading
