FAQ

Oracle > oracle-l > May 2004

Search Discussions

356 discussions - 2,074 posts

  • Interested in the ones you like the most, can't live without, etc., those that most help you either learn something new or get your job done better. Here are a few I like a lot: -Advanced Programming ...
    Michael MilliganMichael Milligan
    May 27, 2004 at 12:28 pm
    May 31, 2004 at 10:08 pm
  • Hi=20 We are currently running 9.2.0.4 on Solaris, and intend to move to RAC = on Redhat Linux AS. We are now evaluating whether to move to 9i rac or 10g rac.=20 Does 10g rac have significant ...
    Singh, Ratnesh (GEI, GEFA, Contractor)Singh, Ratnesh (GEI, GEFA, Contractor)
    May 10, 2004 at 4:17 pm
    May 25, 2004 at 10:18 am
  • A while back we had a conversation about the advisability or not of using spfiles. IIRC what I suggested was sensible if you were going to use them was that you create a backup first using the create ...
    Niall LitchfieldNiall Litchfield
    May 5, 2004 at 4:31 am
    May 24, 2004 at 7:09 pm
  • I've got a table in an Oracle7.3 database (that I'm finally getting to upgrade and I'm trying to figure out how to get the data from the old DB over to the new DB on the new server. table is too big ...
    Adams, Matthew (GE Consumer & Industrial)Adams, Matthew (GE Consumer & Industrial)
    May 7, 2004 at 2:35 pm
    May 16, 2004 at 7:13 pm
  • Hi List, Does anybody know how to derivate the rollback number and the slot number within the rollback transaction table from v$session_wait id1 and id2 on an enqueue TX wait? SID ID1 ID2 112 enqueue ...
    Diego CutroneDiego Cutrone
    May 3, 2004 at 6:20 pm
    May 10, 2004 at 7:11 pm
  • I am working on moving a productional database from 8.0.6 to 9i. I have = a question: if I have 10 rbs at 128K (initial and next extent) and one = "large" on at 10,485,760 bytes how does that ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    May 18, 2004 at 3:31 pm
    May 25, 2004 at 2:27 pm
  • One of our clients is getting the following error occasionally on a 9.2.0.3 DB: ORA-04031: unable to allocate 8704 bytes of shared memory ("large pool","unknown object","hash-join ...
    Terry SuttonTerry Sutton
    May 18, 2004 at 2:51 pm
    May 24, 2004 at 9:56 pm
  • Hello all,=20 I'm currently installing 10g on Windows 2003. Anyone using Automatic Storage Management? =20 I read this in the ASM documentation (below), and I'm concerned because a LUN is a logical ...
    Koivu, LisaKoivu, Lisa
    May 10, 2004 at 12:45 pm
    May 11, 2004 at 3:48 pm
  • 8.1.7.2 on HP 11 Two days ago we had a problem with our san that crashed a few of our databases. I was told failed drives but I don't know how to validate that and communication on the issue has been ...
    Chris StephensChris Stephens
    May 21, 2004 at 9:36 am
    May 24, 2004 at 8:38 am
  • Harrison's book is 'ok'. Doesn't teach you how to tune and has a huge and pretty pathetic error in it. It says you can improve performance of some updates by using a cursor and updating inside the ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    May 27, 2004 at 1:07 pm
    Jun 1, 2004 at 11:23 am
  • from slashdot.org An anonymous reader writes /"According to a CNET News article: 'Oracle will finish switching its 9,000-person in-house programming staff to Linux by the end of 2004 ...
    Joseph S. TestaJoseph S. Testa
    May 27, 2004 at 6:53 am
    Jun 2, 2004 at 8:23 am
  • The Oracle website has release documentation for Oracle 9.2 on x86 based Linux and on the next line they have the same documentation for Oracle 9.2 on Intel based Linux. I thought Intel and x86 were ...
    Smith, Ron L.Smith, Ron L.
    May 26, 2004 at 4:20 pm
    May 27, 2004 at 10:08 am
  • I upgraded a dev db from 9202 to 9205 and one query with a DECODE statement is giving wrong results. The whole query is big, but decode statement looks like ... "and decode('C8','C8',237,0) = 237" If ...
    Jamadagni, RajendraJamadagni, Rajendra
    May 5, 2004 at 10:23 am
    May 10, 2004 at 1:45 pm
  • I'm truncating a table with around 14,000 extents on a 7.3.4 database on a slow machine. (Please don't ask how this happened, it's too=20 painful to re-live.) Is there anyway to determine how far the ...
    Adams, Matthew (GE Consumer & Industrial)Adams, Matthew (GE Consumer & Industrial)
    May 5, 2004 at 4:25 pm
    May 13, 2004 at 7:46 am
  • Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello group, =20 Has any of you moved a 250+ database from SUN into HPUX? I have a window of 36 hours to do ...
    Guerra, Abraham JGuerra, Abraham J
    May 25, 2004 at 3:08 pm
    May 26, 2004 at 8:02 am
  • i have a few serious questions. as the last part of a major upgrade of hardware/OS/software in our production hosted environment, we're getting to upgrade the database cluster. now we have a couple ...
    Bill thaterBill thater
    May 25, 2004 at 7:12 am
    May 26, 2004 at 2:46 pm
  • Hi, I work on a team with one sysadmin, and 3 dba. For the last while, we have been managerless. However, this is about to change, today we are going to be interviewing someone who will become the ...
    Josh CollierJosh Collier
    May 5, 2004 at 10:45 am
    May 17, 2004 at 8:37 am
  • Hie All, I would like to find out from you what should be created first between the database and the tablespace? The book I managed to lay my hands on does not say, and I'm lost as what should I ...
    Software SoftwareSoftware Software
    May 27, 2004 at 6:45 am
    Jun 5, 2004 at 12:08 am
  • Hi, guys! I I've got a number of servers to create multiple 9i databases. Is it possible to just create one system tablespace and just copy it multiple times? I'd just use the controlfile to rename ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    May 5, 2004 at 11:36 pm
    May 6, 2004 at 1:53 pm
  • List, I wanted to simulate corruption in a block. I know using hex editor we can do that. Is there any other way? I think using 'dd' command we can do that. If so how. If any other way please provide ...
    Satheesh.Babu_at_iflexsolutions.comSatheesh.Babu_at_iflexsolutions.com
    May 31, 2004 at 6:30 am
    Jun 2, 2004 at 6:54 am
  • Dear All, Does anyone have documents/presentations that explain the reasons for moving from 8.1.7 to 9iR2 except oracle desupport. (coz my company got an extended support for the next one year). The ...
    Jaysingh1_at_optonline.netJaysingh1_at_optonline.net
    May 5, 2004 at 11:09 am
    May 6, 2004 at 4:46 pm
  • Had a strange problems on Friday afternoon. We are on 8.1.7.4 Solaris Had a ton of Bam - ora_04031 errors. Tried to flush the shared pool and it would release some space but a large chuck was not ...
    Duret, KathyDuret, Kathy
    May 26, 2004 at 2:50 pm
    May 28, 2004 at 8:18 pm
  • Hi list, I'm currently evaluating/playing with a monitoring tool, not just to monitor the database side but the OS, network, etc as well. It's called SITE ALIVE from Creation Point. I was wondering ...
    Diego CutroneDiego Cutrone
    May 14, 2004 at 8:08 am
    May 18, 2004 at 2:59 am
  • If I open a non-critical tar(one where they want you at your desk 24x7), it is assigned to one analyst correct? What happens if I update the TAR when this analyst is not in the office? Please see the ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    May 19, 2004 at 11:46 am
    May 19, 2004 at 2:29 pm
  • We have a process that selects from one table in a cursor loop and updates two tables within the loop. These two tables are nearly identical in structure but have different primary keys. The first ...
    Thomas JeffThomas Jeff
    May 16, 2004 at 9:05 pm
    May 17, 2004 at 4:21 pm
  • All, Given some of the recent postings on RAC, we are probably crazy to continue looking at it. Still, we have an app that we can see scaling to 40+ CPUs in the next year and want some way to avoid ...
    John P WeathermanJohn P Weatherman
    May 13, 2004 at 10:45 am
    May 25, 2004 at 9:39 pm
  • Here is a recursive function that I wrote to find the grand-grand parent value for the input I pass in the function. However, when I call this function, it returns null all the time. What is strange ...
    SRIDHARAN, SAN (SBCSI)SRIDHARAN, SAN (SBCSI)
    May 6, 2004 at 6:17 pm
    May 9, 2004 at 3:04 pm
  • Slightly OT ... This is a rant of course ... although the new 'Knowledge Browser' at Metalink replaced 'Top Tech Docs' ... it looks nice, but it is a navigation nightmare. This is because of ...
    Jamadagni, RajendraJamadagni, Rajendra
    May 17, 2004 at 10:48 am
    May 18, 2004 at 4:27 am
  • I am trying to investigate why a large number of buffers are being used by a certain index. At the present time, the heavily inserted/deleted table has 10 rows, but according to V$BH the index is ...
    Binyamin DissenBinyamin Dissen
    May 12, 2004 at 7:08 am
    May 12, 2004 at 3:19 pm
  • I am trying to FTP a 12G Oracle export dump file from Unix to my desktop. I have tried several FTP tools and none of them will show me any files over 999999999 in size. Does anyone have an FTP ...
    Smith, Ron L.Smith, Ron L.
    May 5, 2004 at 3:18 pm
    May 11, 2004 at 2:11 pm
  • Hi all, we are currently running Oracle 9.2.0.1.0 on AIX 4.3. I am trying to join two tables on a varchar2(50) field and a CHAR(30) field where both are defined as NOT NULL. Although these two fields ...
    Warren HomerWarren Homer
    May 4, 2004 at 7:48 pm
    May 10, 2004 at 1:00 pm
  • Hi, We are using the Standard edition, so no DataGuard and we would like to have a standby database. To simulate a standby, I would like to - take my daily backup with RMAN duplicate a new database ...
    Luc.Demanche_at_astrazeneca.comLuc.Demanche_at_astrazeneca.com
    May 18, 2004 at 3:46 pm
    May 25, 2004 at 11:38 am
  • I need help understanding the time difference between the to "tim=3D" = values. I calculated the difference to be (1007496616 - 1007492040) = 4576. But the time clocked in "SQL*Net message from ...
    Aponte, TonyAponte, Tony
    May 6, 2004 at 6:18 pm
    May 25, 2004 at 9:26 am
  • Anyone have any tips on setting up a logon trigger for initiating a = 10046 event. I tried the following but although it shows no errors it = does not start the session tracing. execute immediate ...
    Ken PaytonKen Payton
    May 13, 2004 at 8:41 am
    May 14, 2004 at 4:50 am
  • Hi, i installed the Oracle Mac OS X Developer Release 9.2.0.1.0 on my PowerBook G3/400 without a problem, like it is described in the install intructions. I can connect to the database via sqlplus, ...
    Carlos Jose GuerrieriCarlos Jose Guerrieri
    May 11, 2004 at 4:07 pm
    May 12, 2004 at 8:22 am
  • Hi everybody, I have a question on TX enqueues. I'm seeing a lot of TX enqueues level 4 on a table. I have also found that the statement that was waiting on this wait was an ***INSERT*** operation ...
    Diego CutroneDiego Cutrone
    May 3, 2004 at 11:31 am
    May 6, 2004 at 9:05 am
  • May be it's not the right time to mention this, but I previously = wondered about the need of those tips. We all know the source, know where to find them and I guess we now how = to use browsers. For ...
    Khedr, WaleedKhedr, Waleed
    May 3, 2004 at 10:22 am
    May 5, 2004 at 7:29 am
  • I met a guy about 2 months ago who used this design concept. Its basically object oriented abstraction in the database. Each table has a package. Each package has all the methods that operate on the ...
    RyanRyan
    May 2, 2004 at 10:31 am
    May 3, 2004 at 11:30 am
  • Hi, can we replicate indexes and sequences in advanced replication with Oracle 8163? If not any suggestions how to bring those indexes? I wanted to replicate db1 to db2 with all indexes how to do ...
    Seema SinghSeema Singh
    May 26, 2004 at 11:25 am
    Jul 27, 2004 at 9:03 am
  • I just ran some tests and I was shocked at the results. I assume I am missing something very obvious. Exporting data 2 million row table: EMC disk on UFS filesystem: 50 sec EMC disk raw space: 3 min ...
    Rick StephensonRick Stephenson
    May 27, 2004 at 12:21 pm
    Jun 1, 2004 at 4:03 am
  • We are using the dbms_obfuscation toolkit to encrypt sensitive data per VISA's requirements. Has anyone gone through the VISA audit before? They are not clear on their expectations for encryption.. ...
    Lane, LawrenceLane, Lawrence
    May 26, 2004 at 12:04 pm
    May 27, 2004 at 8:17 am
  • We have an Informatica job that is crawling along attempting to update about 400K rows. There's nothing else running in the database. The job takes over 17 hours to update all 400K records. The ...
    Thomas JeffThomas Jeff
    May 15, 2004 at 9:50 am
    May 18, 2004 at 11:22 am
  • On 9205 database, load $OH/admin/utlsampl.sql run following query ... and observe ... set feedback on prompt Step 1 select deptno, job, min(sal) from scott.emp group by deptno, job / prompt Step 2 ...
    Jamadagni, RajendraJamadagni, Rajendra
    May 16, 2004 at 4:53 pm
    May 18, 2004 at 10:21 am
  • Hi all, How I test given password? (test connect) example the logic is something like this username=system; password=manager; if ORACLE_TEST_CONNECT(username, password) < 0 then echo Wrong id or(and) ...
    Sinardy XingSinardy Xing
    May 10, 2004 at 9:55 pm
    May 12, 2004 at 9:11 am
  • We have this QA database which I can mostly ignore but Mr. QA dude found a bug caused by the compatible init.ora parameter not being properly set. Since they kind of admin their own database and know ...
    Orr, SteveOrr, Steve
    May 26, 2004 at 10:21 am
    May 26, 2004 at 3:45 pm
  • Hi all. I'm doing some performance testing--the purpose is to see how the response time of our interactive Web application changes when a batch-mode data load process runs concurrently. The response ...
    Paul BaumgartelPaul Baumgartel
    May 5, 2004 at 10:36 am
    May 7, 2004 at 10:21 am
  • I've been thinking about implementing this for some of our resource intensive databases. One of our DBAs came back from a class where the instructor said DRM was very resource intensive itself. I'm ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    May 3, 2004 at 12:50 pm
    May 4, 2004 at 7:07 pm
  • I have alot of batch loading processes that run over night. A few them use 2GB or more of sort space in my temp tablespace. I know I can increase my pga_aggregate_target dynamically, however, I ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    May 13, 2004 at 9:02 am
    Apr 6, 2005 at 2:53 pm
  • I have a field with an upside down question mark chr(191). When we do a select on it, the character shows up as a normal question mark chr(63). I found this out by doing SELECT fld1 ascii(fld1) and ...
    Steiner, RandySteiner, Randy
    May 28, 2004 at 8:52 am
    May 28, 2004 at 11:10 am
  • Hi All, Could I ask people's experience with DBMS_STATS with regard to performance. When I run this: DBMS_STATS.GATHER_SCHEMA_STATS( OWNNAME= 'myschema', ESTIMATE_PERCENT= '< ', CASCADE= TRUE); It is ...
    Charlotte HammondCharlotte Hammond
    May 19, 2004 at 12:16 pm
    May 24, 2004 at 4:37 am
May 2004
12345…8
Group Navigation
period‹ prev | May 2004 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions356
posts2,074
users301
websiteoracle.com

301 users for May 2004

Mladen Gogala: 104 posts Ryan.gaffuri_at_cox.net: 61 posts Jared.Still_at_radisys.com: 55 posts Jamadagni, Rajendra: 45 posts Jesse, Rich: 45 posts Jonathan Lewis: 45 posts Juan Carlos Reyes Pacheco: 38 posts Khedr, Waleed: 38 posts Nuno Souto: 34 posts Tim Gorman: 34 posts DENNIS WILLIAMS: 32 posts Bobak, Mark: 31 posts Daniel Fink: 29 posts Powell, Mark D: 28 posts Stephen.Lee_at_DTAG.Com: 28 posts Goulet, Dick: 27 posts Pete Sharman: 27 posts Wolfson Larry - lwolfs: 27 posts Natural Join B.V.: 25 posts Tanel Põder: 22 posts
show more
Archives