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: March 2011
What’s the difference between logfiles and archive logfiles ?
The log files are part of the database, called online redo files. These hold the transactions from the database not already on disk allowing recovery in the event of a database crash. These are then turned into offline redo files, … Continue reading
Loading data through external tables.
Loading eternal csv data. Here’s a working example of checking for a file and loading the data into another table.
ORA-39001: invalid argument value with dbms_datapump
Posted in datapump
Comments Off
ORA-01274: cannot add datafile
Automatically adding a datafile on the physical standby database. On production. SQL> alter tablespace my_db add datafile ‘/oradata/data/my_db/my_db_DATA_11.ora’ 2 size 100m autoextend on next 100m maxsize 20g; On Standby. SQL> select ts# from v$tablespace where name = ‘my_db’; TS# ———- … Continue reading
Posted in Configuration.
Tagged cannot add datafile, DB_FILE_NAME_CONVERT, ORA-01274, physical standby, standby_file_management
Comments Off
Optimal Redo Log Size
Posted in Tuning in General
Tagged LOG FILES, PHYSICAL, RECOVER, Recovery, REDO, standby, V$INSTANCE_RECOVERY
Comments Off
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by ‘inst 1, osid 70070′
ORA-00494, instance crashes. ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by ‘inst 1, osid 70070′ occured where a problem exists on getting a control file enqueue lock by the LGWR. However the instance shutsdown because CTKP … Continue reading
Posted in Tuning in General
Tagged ckpt, contention, controlfile, enqueue, enqueue blocker, fast_start_mttr_target, kill, lwgr, ORA-00494, redo log
Comments Off
Revolution Analytics and IBM Netezza Bring Enterprise-Ready R to the Data Warehouse
New relationship brings Revolution R Enterprise to IBM Netezza’s TwinFin Data Warehouse Appliance Customers
Predictive Analytics World 2011 SAN FRANCISCO–14, March 2011–PREDICTIVE ANALYTICS WORLD, Booth #107 and #112 – Revolution Analytics, the l… Continue reading
Creating a network ACL.
A client upgraded from 10g to 11g, but the consultant didn’t consider the fact that they were using network connections with http.
Querying Materialized Views.
Posted in Oracle
Tagged dba_jobs, dba_mviews, dba_refresh_children, materialized view, snapshots
Comments Off
