APPEND hint and index maintenance323 (4/18/2008 10:28:06 AM) comp.databases.oracle.server Sorry for asking what seems to be an obvious question: Records are inserted into a table A using INSERT /*+ APPEND */ into A SELECT * FROM B; There are indexes on table A, and these indexes are in VALID state ... Vsevolod
Slow connection to Oracle on AIX: using truss220 (2/21/2008 5:01:23 AM) comp.databases.oracle.server Hi All, We are investigating slow connection to Oracle on AIX 5.2 using truss utility: > truss -d -o truss.out sqlplus user/pass @connect.sql where connect.sql contains only one line: exit The output file c... Vsevolod
UPDATE GLOBAL INDEXES #2731 (10/17/2007 11:34:53 PM) comp.databases.oracle.server It is interesting that global and *non-partitioned* indexes can be kept valid during operations such as ALTER TABLE MOVE PARTITION using UPDATE GLOBAL INDEXES clause while similar option isn't available for non... Vsevolod
11g: how to get Client Result Cache to work?629 (10/10/2007 1:07:38 AM) comp.databases.oracle.server I am trying to get Client Result Cache to work in Oracle 11g database. This feature is described in OCI Programmer's Guide, pages 10-22 - 10-27. 1. Parameter CLIENT_RESULT_CACHE_SIZE has been set to 1000000 an... Vsevolod
Executions != Rows_Processed for single-row INSERT224 (5/15/2007 6:54:20 AM) comp.databases.oracle.server Hi, I've noticed strange discrepancy in Oracle statistics: for particular singe-row INSERT statement value of V$SQL statistics Executions != Rows_Processed. For example: INST_ID EXECUTIONS FIRST_LOAD_TIME ... Vsevolod
Oracle Snapshot column size333 (1/27/2007 9:30:37 AM) comp.databases.oracle.server Hi, Oracle 9.2.0.6.0 on Linux I neded to replicate a few tables from one database to another database. This is simple on-way replication with refresh on demand. So I created snapshot logs in the source (master... Vsevolod
Patching Oracle without shutting down the database532 (11/13/2006 7:03:05 AM) comp.databases.oracle.server Somehow it appears to be possible to patch Oracle on AIX 5.3 without shutting down the databases - and everything works fine! - We have several AIX 5.3 servers running Oracle 9.2.0.7.0 Enterprise Edition - Part... Vsevolod
Using "whenever oserror" on Windows565 (4/2/2005 12:57:41 PM) comp.databases.oracle.server When writing SQL scripts for batch execution on UNIX I normally put "whenever sqlerror", "whenever oserror" at the top, for example --------------------------------------- whenever sqlerror exit failure rollba... vafanassiev(40)
Refreshing test d/base1531 (4/13/2005 9:53:05 PM) comp.databases.oracle.server Hi all, DB: 9.2 OS: Win 2003 We need to refresh test d/base, but last time when we did that all the procedures and packages were overriden by the prod scripts. Is there a way to back up a source$ table, for ins... epipko(35)
sqlldr / as sysdba328 (4/20/2005 7:11:01 PM) comp.databases.oracle.server Hi, bit of a mind block :( Why am I seeing prod3 as the database name when ORACLE_SID=prod3 or prod4 ? Thank you in advance Barry (oracle@svr12UK)$ (oracle@svr12UK)$ set ORACLE_SID=prod3 (oracle@svr12UK)$ s... bbulsara23(133)
Need your advice and suggestions330 (10/1/2006 5:35:34 PM) comp.databases.oracle.server hi everyone, i would require your valuable suggestion. I have around 7 years of experience as developer in oracle in pl/sql and pro*c. I got an opportunity to move as DBA now. I would like to know what all th... gkodakalla(18)
Oracle Snapshot column size333 (1/27/2007 9:30:37 AM) comp.databases.oracle.server Hi, Oracle 9.2.0.6.0 on Linux I neded to replicate a few tables from one database to another database. This is simple on-way replication with refresh on demand. So I created snapshot logs in the source (master... vafanassiev(40)
UPDATE GLOBAL INDEXES #2731 (10/17/2007 11:34:53 PM) comp.databases.oracle.server It is interesting that global and *non-partitioned* indexes can be kept valid during operations such as ALTER TABLE MOVE PARTITION using UPDATE GLOBAL INDEXES clause while similar option isn't available for non... vafanassiev(40)
APPEND hint and index maintenance323 (4/18/2008 10:28:06 AM) comp.databases.oracle.server Sorry for asking what seems to be an obvious question: Records are inserted into a table A using INSERT /*+ APPEND */ into A SELECT * FROM B; There are indexes on table A, and these indexes are in VALID state ... vafanassiev(40)