vafanassiev's articles:

Items(27) /3 Next >> Last >|

max extent size in locally managed tablespace with AUTOALLOCATE 4 54 (6/13/2008 9:31:43 AM) comp.databases.oracle.server What is the maximum extent size possible in locally managed tablespaces (LMT) with autoallocate? Let me clarify the question: I am interested in conventional datafiles (not bigfiles). I understand that "strictl... Vsevolod

APPEND hint and index maintenance 3 23 (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 truss 2 20 (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

Why Oracle creates two shared memory segments instead of one? 10 34 (10/25/2007 10:44:45 PM) comp.databases.oracle.server I noticed that on some platforms Oracle always creates two shared memory segments instead of one, even when both segments are much smaller than the limit. For example, on this Tru64 box the limit is set to 2 G... Vsevolod

UPDATE GLOBAL INDEXES #2 7 31 (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? 6 29 (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 INSERT 2 24 (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 size 3 33 (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 database 5 32 (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

Migrating large database between platforms: using snapshots 9 36 (9/30/2006 11:55:18 PM) comp.databases.oracle.server Hi, I need to migrate 500 GB Oracle 9.2.database from one platform (Sun SPARC Solaris) to another (Sun x86 Solaris) with minimal outage. The plan is: 1. Create empty database on the new server. 2. Shutdown appl... Vsevolod

vafanassiev's replies:

Items(11) /2 Next >> Last >|

Using "whenever oserror" on Windows 5 65 (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/base 15 31 (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 sysdba 3 28 (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)

Migrating large database between platforms: using snapshots 9 36 (9/30/2006 11:55:18 PM) comp.databases.oracle.server Hi, I need to migrate 500 GB Oracle 9.2.database from one platform (Sun SPARC Solaris) to another (Sun x86 Solaris) with minimal outage. The plan is: 1. Create empty database on the new server. 2. Shutdown appl... vafanassiev (40)

Need your advice and suggestions 3 30 (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 size 3 33 (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)

11g: how to get Client Result Cache to work? 6 29 (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... vafanassiev (40)

UPDATE GLOBAL INDEXES #2 7 31 (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)

Did you once had to back out from an CPU implementation? 2 28 (4/16/2008 3:36:51 PM) comp.databases.oracle.server Hi all, More a question of curiosity, but did you ever had to undo a CPU implementation? I've run across shops who a) never applied CPU's b) applied them without testing and c) read the documentation to check... helma.vinke (125)

APPEND hint and index maintenance 3 23 (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)