epipko's articles:

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

need your help with Oracle 7.3.4, please 4 23 (8/15/2005 4:53:52 PM) comp.databases.oracle.server Hi all, I am getting: ERROR: ORA-01034: ORACLE not available ORA-09243: smsget: error attaching to SGA OSD-04101: invalid SGA: SGA not initialized How do I fix it? It is urgent, please. Eugene ... Eugene

I/O problem when extra storage is added 0 47 (8/11/2005 5:02:41 PM) comp.databases.oracle.server Hi all, We started to experience I/O problem after our network admin added an extra shelve to our NatApp storage. He didn't assign that extra storage to an existing d/b storage configuration. He simply physical... Eugene

partitioning an exesting table 8 64 (8/10/2005 9:10:48 PM) comp.databases.oracle.server Hi all, I am using Oracle 9.2 enterprice addition on Win2003. I am looking a way to partition an existing (packaged application) table with 3M rows. It has 24 indexes and 2 triggers on it as well. Could you, pl... Eugene

flashback question 8 21 (8/8/2005 10:22:49 PM) comp.databases.oracle.server Hi all, I have a question about flashback. For some reason it doesn't work?! Here is what I do: show parameter undo_retention; NAME TYPE VALUE ---------------------------... Eugene

automatic arch log delete 3 28 (7/11/2005 6:56:40 PM) comp.databases.oracle.server Hi all, Is it possible to find and delete archive logs that are 3 days old using PL/Sql? Could you, please refer me to an online document? Thanks, Eugene ... Eugene

ORA-00376 5 42 (6/27/2005 3:08:57 PM) comp.databases.oracle.server Hi all, I have an "unussual" problem here: ORA-00376: file 90 cannot be read at this time ORA-01110: data file 90: 'L:\ORACLE\ESST\DATA\ESST_CUSTOM_INDEX_7.DBF' I queried the v$datafiles and see that file bein... Eugene

group by and sorting 4 32 (5/31/2005 9:04:16 PM) comp.databases.oracle.server Hi all, Is there a way to "tell" Oracle not to sort when it's doing GROUP BY? I think I saw something like ... group by nosort somewhere. Eugene ... Eugene

log writer check 3 40 (5/23/2005 4:17:21 PM) comp.databases.oracle.server Hi all, I have noticed that REDO LOG WRITER is taking very long time. It took 150 ms to write to a datafile. I have 12 groups with 2 members in each. How do I go about it? What do I check? Is there a way to see... Eugene

so, what is the right way to count tablespace free space 3 38 (5/20/2005 5:33:58 PM) comp.databases.oracle.server Hi all, You may say: There is tonn of stuff on the web and in Oracle docs, but the problem with that it that I get different results with each one(take SYSTEM ts as an example). Example 1: Result: SYSTEM 9... Eugene

bulk binding 4 43 (5/16/2005 6:16:47 PM) comp.databases.oracle.server Hi all, I have the following code: ========================================================= PROCEDURE upc_reuse_gen_upc_list_p (vArray_size IN PLS_INTEGER DEFAULT 100) IS TYPE sku_row IS TABLE OF sku%ROWTYPE;... Eugene

epipko's replies:

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

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)

parallel query 6 36 (5/2/2005 6:05:38 PM) comp.databases.oracle.server Hi all, I am using 9r2 on Windows. I'd like to setup parallel query. What I am going to do is to set PARALLEL_AUTOMATIC_TUNING = TRUE. All my tables are creted with NOPARALLEL clause. Could I still use /*+ PARA... epipko (35)

Time diff 3 47 (5/3/2005 4:00:59 PM) comp.databases.oracle.server Hi all, I have two columns representing start_datetime and end_datetime. They look like 1085008980 and 1085009504 respectively. They are stored in UTC format (number of seconds from '15/12/1970'). How do I calc... epipko (35)

what made the difference? 4 37 (5/6/2005 5:44:29 PM) comp.databases.oracle.server Hi all I have the table with the following data (sample): 81 123 1 81 123 2 81 123 3 ..... 81 124 1 81 124 2 81 124 3 81 124 4 ..... So, first column is always the same, second col... epipko (35)

so, what is the right way to count tablespace free space 3 38 (5/20/2005 5:33:58 PM) comp.databases.oracle.server Hi all, You may say: There is tonn of stuff on the web and in Oracle docs, but the problem with that it that I get different results with each one(take SYSTEM ts as an example). Example 1: Result: SYSTEM 9... epipko (35)

log writer check 3 40 (5/23/2005 4:17:21 PM) comp.databases.oracle.server Hi all, I have noticed that REDO LOG WRITER is taking very long time. It took 150 ms to write to a datafile. I have 12 groups with 2 members in each. How do I go about it? What do I check? Is there a way to see... epipko (35)

ORA-00376 5 42 (6/27/2005 3:08:57 PM) comp.databases.oracle.server Hi all, I have an "unussual" problem here: ORA-00376: file 90 cannot be read at this time ORA-01110: data file 90: 'L:\ORACLE\ESST\DATA\ESST_CUSTOM_INDEX_7.DBF' I queried the v$datafiles and see that file bein... epipko (35)

flashback question 8 21 (8/8/2005 10:22:49 PM) comp.databases.oracle.server Hi all, I have a question about flashback. For some reason it doesn't work?! Here is what I do: show parameter undo_retention; NAME TYPE VALUE ---------------------------... epipko (35)

partitioning an exesting table 8 64 (8/10/2005 9:10:48 PM) comp.databases.oracle.server Hi all, I am using Oracle 9.2 enterprice addition on Win2003. I am looking a way to partition an existing (packaged application) table with 3M rows. It has 24 indexes and 2 triggers on it as well. Could you, pl... epipko (35)

need your help with Oracle 7.3.4, please 4 23 (8/15/2005 4:53:52 PM) comp.databases.oracle.server Hi all, I am getting: ERROR: ORA-01034: ORACLE not available ORA-09243: smsget: error attaching to SGA OSD-04101: invalid SGA: SGA not initialized How do I fix it? It is urgent, please. Eugene ... epipko (35)