need your help with Oracle 7.3.4, please423 (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 added047 (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 table864 (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 question821 (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 delete328 (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-00376542 (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 sorting432 (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 check340 (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
bulk binding443 (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
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)
parallel query636 (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 diff347 (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?437 (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)
log writer check340 (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-00376542 (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 question821 (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 table864 (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, please423 (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)