Search Discussions

292 discussions - 1,201 posts

  • anyway to write whatever i want to the oracle alert log? -- http://www.freelists.org/webpage/oracle-l
    Oct 21, 2004 at 8:24 am
    Dec 8, 2004 at 6:34 pm
  • Hi, I searched but I didn't find it, please do you know some parameter like _disable_logging (disables logging), to disable undo. SELECT KSPPINM, KSPPSTVL FROM X$KSPPI A, X$KSPPSV B WHERE ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Oct 5, 2004 at 6:13 pm
    Oct 7, 2004 at 12:43 pm
  • Can someone tell me why I keep running out of shared pool space? If old SQL statements are supposed to be aged out or written over automatically, how can I run out of space? This is happening from ...
    Smith, Ron L.Smith, Ron L.
    Oct 14, 2004 at 7:50 am
    Oct 15, 2004 at 7:56 am
  • I had one FOrms application running using Oracle 9iAS Releas1 and 9i Rel 1DB. I got user complaining that one forms is very slow and after tracing I got the following kind of TKPROF output for lot of ...
    Sanjay MishraSanjay Mishra
    Oct 12, 2004 at 1:38 pm
    Oct 14, 2004 at 7:47 am
  • Hello all, I was wondering if someone can help out with a alert log error checking batch file for Windows. I'd like to do daily checks of alert log and send an email if any errors are found. As ...
    Oct 15, 2004 at 2:37 pm
    Oct 18, 2004 at 2:10 pm
  • When using RMAN and Netbackup without a RMAN Catalog database, how do you set retention for 5 years -- eg if the controlfile is backed-up as autobackup. How do you restore a database as of a specific ...
    Hemant K ChitaleHemant K Chitale
    Oct 12, 2004 at 10:07 am
    Oct 15, 2004 at 6:38 am
  • Rman fails with: I notice that=20 A. A number of batch processes were added to database and likely using a good deal of "sort" area as large batch processes often do B. Volume of data added last ...
    Oct 5, 2004 at 3:38 am
    Oct 6, 2004 at 12:15 pm
  • I am upgrading my databases from 8i to Currently, most of my databases are using the character set US7ASCII. What character set do most people in the USA use (WE8ISO8859P1)? Thanks, Gene -- ...
    Gene SaisGene Sais
    Oct 26, 2004 at 9:29 am
    Oct 29, 2004 at 11:02 am
  • Hi, Is any performance problem if we go with TEMPORARY table? any thoughtS? thx Express yourself instantly with MSN Messenger! Download today - it's FREE! ...
    Seema SinghSeema Singh
    Oct 27, 2004 at 12:29 pm
    Oct 28, 2004 at 12:08 am
  • Dear List, Tracing one of the user sessions I get a lot of waits on "local write wait". We are using 10.0.3, I've searched metalink and in the book about OWI events, but couldn't find any information ...
    Edgar ChupitEdgar Chupit
    Oct 11, 2004 at 1:53 am
    Oct 21, 2004 at 8:13 am
  • Hi all, Check this out. Sorta a better version of MetaLink if you ask me.;-) http://answers.google.com/answers/main?sourceid=tipn Paid answers! OMG! I wonder if they have a patent on it, I didn't ...
    Oct 8, 2004 at 5:04 pm
    Oct 12, 2004 at 8:54 am
  • Hello, I want to setup scripton linux whenever alert log 1GB we have to get alert.Does anyone send similar kidn of script ? when I'm executing following command its show error frees1=`du -sk /alert ...
    Seema SinghSeema Singh
    Oct 4, 2004 at 11:41 am
    Oct 4, 2004 at 4:22 pm
  • Hi friends: We have to migrate a database on windows 2000 to Solaris, and to another location. So we want to reduce the size of the dump file via gzip. As windows does not support pipe like we do in ...
    Zhu chaoZhu chao
    Oct 21, 2004 at 9:12 am
    Oct 24, 2004 at 4:34 pm
  • I'm not a hardware guy or sys admin person so forgive me if this is a stupid question. Leaving out all other variables(such as IO), should I expect performance to be the same in a databse if the ...
    Oct 22, 2004 at 2:51 pm
    Oct 28, 2004 at 5:35 pm
  • Other than SELECT sid from v$mystat where rownum = 1; what are other ways in V9.2 to get your own session SID programatically? -- http://www.freelists.org/webpage/oracle-l
    Sol beachSol beach
    Oct 15, 2004 at 1:44 pm
    Oct 25, 2004 at 5:44 am
  • Hi, I just appeared in an interview. When I was asked which filese I will copy for hot backup, I said redo too. Cause I think they can help us always to recover database upto point of time. I was ...
    Chirag DBAChirag DBA
    Oct 2, 2004 at 3:35 am
    Oct 5, 2004 at 7:42 pm
  • I would like to create a query that runs nightly (maybe a procedure, kicked off from oracle jobs?) that runs a query, and if the query results in rows returned, then to have it email to a specified ...
    Michael Cupp, Jr.Michael Cupp, Jr.
    Oct 27, 2004 at 10:08 am
    Oct 31, 2004 at 11:59 pm
  • One of my frnd is trying to generate development DB from production. Production machine is 8.1.7 and development DB where he want to upload a DB is 9.2. He is taking export from his machine n getting ...
    Chirag DBAChirag DBA
    Oct 7, 2004 at 5:08 am
    Oct 7, 2004 at 9:56 am
  • Hi, One of my database is 7.34 on hp-ux.Somehow one of our developer disable one of constraints.When I have tried to enable i noticed ora-02298 because of data inconsistent. When I run ALTER TABLE ...
    Seema SinghSeema Singh
    Oct 19, 2004 at 11:17 am
    Nov 11, 2004 at 10:11 pm
  • Hi, We are running Solaris 9 with UFS on Oracle We switched to direct I/O and did not see a better performance as far as updating statistics concerned. Why? It used to take us 22 hours to ...
    Roger XuRoger Xu
    Oct 19, 2004 at 2:12 pm
    Oct 26, 2004 at 10:23 am
  • Dear List, I'am researching different types of SORT ORDER BY step elimination. This particular problem bothers me for a few days, but I still can't find a correct way to eliminate SORT ORDER BY ...
    Edgar ChupitEdgar Chupit
    Oct 22, 2004 at 8:33 am
    Oct 22, 2004 at 3:59 pm
  • Could anybody tell me under which circunstances different inputs to dbms_utility.get_hash_value can lead to the same output. The reason is that I work with a database and need to use PLSQL ...
    Jose Manuel QuesadaJose Manuel Quesada
    Oct 20, 2004 at 9:29 am
    Oct 22, 2004 at 5:01 am
  • Hi All, I have 4 tables join query(all tables statistics are upto date) that is working fine if it goes for HASH_JOIN. But without HINT it is always doing NL_JOIN and takes about 50 secs to execute ...
    Sami SeeranganSami Seerangan
    Oct 20, 2004 at 2:44 pm
    Oct 21, 2004 at 8:37 am
  • Oracle 9204, AIX 5.2, RAC system. I am trying to write a script that will show all the blocking locks in the system and the SQL beign executed by the sessions. So, here is how I tested ... create ...
    Oct 15, 2004 at 10:16 am
    Oct 15, 2004 at 11:32 am
  • Hi, one question please, if you have some comment about this. I think if you have a databaselink to a database in the same server you should be using ipc conection or there is something saying it is ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Oct 5, 2004 at 3:55 pm
    Oct 12, 2004 at 2:29 pm
  • Suppose we have four tables A, B, C, and D that are all used in a SELECT statement. Let's further suppose that we know that the best way to join these tables (best meaning fastest RT, and fewest ...
    Smiley John - ILSmiley John - IL
    Oct 1, 2004 at 10:04 am
    Oct 4, 2004 at 5:11 pm
  • on HP-UX 11 64bit I recently created a standby for one of our production databases. Got it in Managed Recovery mode, no problem. A couple of days later, the standby's Alert log started ...
    Oct 28, 2004 at 9:48 am
    Oct 30, 2004 at 8:54 am
  • I am having a senior moment today ..... sI want to get only those varchar2 fields back with a length of 4 that are numeric select field from table where length(field) = 4 and between '0001' and ...
    Duret, KathyDuret, Kathy
    Oct 26, 2004 at 10:44 am
    Oct 27, 2004 at 12:33 am
  • All. Has any one of you configured a workable solution using Hitachi shadow image and 9205 for duplicate database creation? I am looking for some reference on doing it without putting the source ...
    Manish MehraManish Mehra
    Oct 7, 2004 at 9:55 pm
    Oct 11, 2004 at 5:12 pm
  • Hi all, Why Oracle said that to increase the FREELISTS you MUST RECREATE THE OBJECTS? How about just ALTER object_type object_name STORAGE (FREELISTS higher_value); or ALTER object_type object_name ...
    Sinardy XingSinardy Xing
    Oct 2, 2004 at 2:01 am
    Oct 4, 2004 at 8:41 am
  • A source within Oracle informed me that they are negotiating for Bill Gates to present a keynote at OracleWorld. Has anyone else heard this??? And that Microsoft will have a rather large vendor booth ...
    Grabowy, ChrisGrabowy, Chris
    Oct 29, 2004 at 11:28 am
    Oct 29, 2004 at 9:01 pm
  • Ok, I'm a bit at a loss to explain this..... I have two tables, ADDS_USERS, which has AUSR_ID as the primary key, and AUTHORIZED_IP_ADDRESSES. Now, my original query looks like this: SELECT ...
    Bobak, MarkBobak, Mark
    Oct 27, 2004 at 3:36 pm
    Oct 29, 2004 at 12:31 pm
  • Does anyone have any ideas why this is not working ??? pweb:acedmgr select QID from login; QID 1 1 pweb:acedmgr select qid from question; QID 2 3 1 pweb:acedmgr SELECT qid FROM question 2 WHERE qid ...
    Rusnak, George A. (SEC-Lee) CTRRusnak, George A. (SEC-Lee) CTR
    Oct 26, 2004 at 1:07 pm
    Oct 26, 2004 at 9:01 pm
  • I'm seeing large numbers of CBC latch waits when many sessions (20-40) run the same SELECT statement simultaneously (I can peek at v$session_wait and catch this many sessions waiting on latch free ...
    Smiley John - ILSmiley John - IL
    Oct 19, 2004 at 3:27 pm
    Oct 21, 2004 at 1:22 pm
  • Hi, I m getting error ' ORA-03113: end-of-file on communication channel ' while creating a procedure which uses database link to populate data. Can anyone tell me what can be the problem ? Chirag ...
    Chirag DBAChirag DBA
    Oct 15, 2004 at 10:38 am
    Oct 18, 2004 at 11:26 am
  • Hi Friends, Is any one using the SHAREPLEX of Quest Software ? Is that a good idea to get good command of DATABASE REPLICATION TECHNOLOGY n mainly work in that side? Hw is the market demands for the ...
    Chirag DBAChirag DBA
    Oct 9, 2004 at 2:16 am
    Oct 12, 2004 at 12:45 pm
  • Dear List, I'm facing strange oddity when tracing MERGE statements. For each MERGE statement I get one parse error of the "strange" query from dual. I would like to know why does Oracle needs to ...
    Edgar ChupitEdgar Chupit
    Oct 8, 2004 at 2:21 pm
    Oct 11, 2004 at 8:08 pm
  • Slightly off-topic, but relevant to anyone who uses bespoke scripts on Unix. I've got a bunch of SQL, ksh and perl scripts that I want to organise, archive and delete where obsolete. I'd like to get ...
    Feighery, Raymond (RBS Insurance)Feighery, Raymond (RBS Insurance)
    Oct 8, 2004 at 9:00 am
    Oct 11, 2004 at 1:25 pm
  • We are trying to install ASM and following the guides of installation from = otn, but we get an error message saying: kernel-smp =3D 2.4.21-15.EL is needed by oracleasm-2.4.21-EL-smp-1.0.0-1 We ...
    Nestor FlorezNestor Florez
    Oct 6, 2004 at 2:57 pm
    Oct 7, 2004 at 2:45 pm
  • Hi friends, I have a Database in which few tables are for Transaction. As the number of transactions will be more than 10000 per day, I need to decide the tuning strategy for the tables having more ...
    Chirag DBAChirag DBA
    Oct 1, 2004 at 1:05 am
    Oct 4, 2004 at 2:37 am
  • Hi All, I want to search something based on search_condition. Since search_condition column is LONG data type I could not use "like" or "=" operator. Any idea? SELECT * FROM dba_constraints ...
    Sami SeeranganSami Seerangan
    Oct 26, 2004 at 1:37 pm
    Oct 27, 2004 at 11:15 am
  • Sorry for the OT, but it is relevant to this list and gmail. Every post to this list from a gmail account comes with the warning "This message may not be from the person it claims to be from. Do not ...
    Jared StillJared Still
    Oct 22, 2004 at 12:11 pm
    Oct 22, 2004 at 7:17 pm
  • Hi, Are there any known 'gotchas' for moving from 32-bit Oracle to 64-bit on Solaris 5.8? (Yes, we will RTFM :-) Thanks, Gudmundur Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- ...
    Gudmundur JosepssonGudmundur Josepsson
    Oct 20, 2004 at 2:59 pm
    Oct 22, 2004 at 2:09 pm
  • I have a bit of a dilemma here. We have a production table that has a long datatype on it and for reasons I won't get into cannot be converted to a clob for several more months. I have a work table ...
    Oct 18, 2004 at 4:37 pm
    Oct 20, 2004 at 9:57 am
  • Hi Friends, I wanna update values of SP_TYPE_CD in PROFILE_CUSTOMERS which has a VALUES and I wanna put the SP_TYPE_CD from PROFILE_SP_TYPE_CD. PROFILE_SP_TYPE_CD is a master table and ...
    Chirag DBAChirag DBA
    Oct 13, 2004 at 6:12 am
    Oct 14, 2004 at 2:34 am
  • I recently accepted a position with a company that strictly runs Oracle on Windows. I've been working in an HP-UX environment for the last 4 years. I need to come up to speed quickly. I know next to ...
    Chris StephensChris Stephens
    Oct 5, 2004 at 3:04 pm
    Oct 8, 2004 at 6:57 pm
  • In the back of my mind I recall that it is possible to write to the alert.log from procedure, but can not recall how. What do I execute to do this? Jeffrey Beckstrom Database Administrator Greater ...
    Jeffrey BeckstromJeffrey Beckstrom
    Oct 28, 2004 at 11:24 am
    Nov 1, 2004 at 11:14 am
  • This has probably been hashed numerous times already, but I can't find = it. I have a table (names) with the following structure: dep_id number(12) -- FK to main table line number(4) -- PK when ...
    William B FergusonWilliam B Ferguson
    Oct 27, 2004 at 7:39 am
    Oct 27, 2004 at 9:28 am
  • I have the same target database, the same OS, the same RMAN catalog the same RMAN script that backups to disk. Every so often (not regularly) I get the following error. I checked catalog table for ...
    Oct 21, 2004 at 9:12 am
    Oct 22, 2004 at 10:01 am
  • Hi all, in AIX5.2L : can i disable a command for one particular OS user alone ? i.e., say TOM (only) should not able to use the command 'cd' (only). i want him to stay in his home directory without ...
    Prem Khanna JPrem Khanna J
    Oct 22, 2004 at 4:41 am
    Oct 22, 2004 at 8:44 am
Group Navigation
period‹ prev | Oct 2004 | next ›
Group Overview
grouporacle-l @

280 users for October 2004

Jared Still: 43 posts Mercadante, Thomas F: 43 posts Bobak, Mark: 32 posts Juan Carlos Reyes Pacheco: 29 posts Carel-Jan Engel: 28 posts Gogala, Mladen: 25 posts Mark W. Farnham: 25 posts Ryan_gaffuri_at_comcast.net: 23 posts Natural Join B.V.: 22 posts Chirag DBA: 21 posts Paul Drake: 20 posts Rjamya: 20 posts Goulet, Dick: 19 posts Jonathan Lewis: 17 posts Mark Strickland: 17 posts Smiley John - IL: 16 posts Ganesh Raja: 15 posts Prem Khanna J: 15 posts Mhthomas: 14 posts Niall Litchfield: 14 posts
show more