FAQ

Search Discussions

345 discussions - 2,223 posts

  • List - Does anyone know how to relate a database row to the datafile where it is stored? Here is the situation: we are going to test the recovery of a database, removing a few data files and then ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Aug 4, 2004 at 4:00 pm
    Aug 7, 2004 at 1:38 pm
  • I posed a question here last week wrt RAC and got one response. Is there a concentration of RAC users elsewhere? I find the metalink forum practically worthless, which is probably another strong ...
    Ray StellRay Stell
    Aug 16, 2004 at 10:12 am
    Aug 18, 2004 at 6:55 am
  • List, I am looking for some experienced consultants to perform the following task= s. Data Warehouse conceptual design OLAP implementation The candidates must have had hands-on experiences before ...
    Michael WuMichael Wu
    Aug 18, 2004 at 11:36 am
    Aug 30, 2004 at 9:16 am
  • I'm reading the Directory Service Integration and Deployment Guide right now. I think we want to move from 3000+ tnsnames files to centralized naming and integrating with Active Directory seems ...
    Niall LitchfieldNiall Litchfield
    Aug 11, 2004 at 5:47 am
    Aug 12, 2004 at 10:06 pm
  • Dear List, Effective immediately, there will be no moderation of the Oracle-L list. It has been pointed out to me that by being moderated, I become personally responsible and legally liable for the ...
    Jared StillJared Still
    Aug 29, 2004 at 4:53 pm
    Aug 31, 2004 at 10:27 am
  • While all tablespaces were in backup mode, Oracle reported corruption in the controlfiles and crashed.=20 A checksum of the controlfiles found them to be identical,=20 so I re-created them. Then I ...
    Adams, Matthew (GE Consumer & Industrial)Adams, Matthew (GE Consumer & Industrial)
    Aug 22, 2004 at 12:29 pm
    Sep 12, 2004 at 10:13 pm
  • I am trying to create a database manually in Oracle 9i. But getting this error, when I try to run the script for database creation. SQL @d:\prod\create_prod.sql create database prod * ERROR at line ...
    Fahd mirzaFahd mirza
    Aug 28, 2004 at 3:20 am
    Aug 31, 2004 at 9:49 am
  • Guys, I have this new request to accomplish this and I haven't done this = before. Would I need to setup oracle internet directory to active = service directory? If the user is using client-server ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Aug 24, 2004 at 2:29 pm
    Aug 31, 2004 at 11:51 am
  • I'm currently working on a datawarehouse project (~5 Tb) where the decision has been made to avoid performing outer joins. The reasons given for this seem to be - Simplifies user navigation of the ...
    Barr, StephenBarr, Stephen
    Aug 31, 2004 at 10:01 am
    Aug 31, 2004 at 7:34 pm
  • Or, you can use the same references in a different fashion as in: BEGIN UPDATE RESUME; SELECT * FROM MARKET_OPPORTUNITY; SUBMIT REFERENCES TO PROSPECTIVE EMPLOYER; EXCEPTION WHEN NO_DATA_FOUND THEN ...
    Gogala, MladenGogala, Mladen
    Aug 23, 2004 at 4:55 pm
    Aug 25, 2004 at 12:42 pm
  • Hi Gurus, When explaining to another person that I am going to do a 10046 trace what is the best why to say it? "For performance tuning I like to do a one, zero, zero, four, six trace." "For ...
    Lee LeeLee Lee
    Aug 11, 2004 at 8:47 am
    Aug 22, 2004 at 3:21 pm
  • I did a 10046 trace and verified that I can get up to 128 blocks/IO with db_file_multiblock_read_count. How do I metric this? I look at my total physical IOs when I did a tkprof report and my total ...
    Ryan.gaffuri_at_comcast.netRyan.gaffuri_at_comcast.net
    Aug 18, 2004 at 9:33 am
    Aug 19, 2004 at 9:09 pm
  • Oracle 9.2.0.3 solaris 5.8 raid 5 T3's I have a server which was created for adhoc purposes. What has happened is this. Instead of users running adhocs, they have created a package which creates ...
    Michael McMullenMichael McMullen
    Aug 12, 2004 at 1:21 pm
    Aug 16, 2004 at 5:43 pm
  • Oracle EE 8.1.7.4 on AIX 4.3.3 utilizing IBM Websphere - I can currently trace a SQL*Plus session and I receive the trace file. Here is what I am executing: exec ...
    Tracy RahmlowTracy Rahmlow
    Aug 17, 2004 at 9:21 am
    Aug 18, 2004 at 7:18 am
  • KATHY! So you feel like a database monkey too! We have two Clariion SANs. The servers I work on have the installs on the local disk. Part of the thinking behind it is if the server completely ...
    Koivu, LisaKoivu, Lisa
    Aug 26, 2004 at 4:45 pm
    Aug 27, 2004 at 5:16 pm
  • Google must have purchased more hardware. I have invites to give away too. Eventually everyone will have a gmail account, at this rate... : ) Patrice -----Original Message----- From: Stephane Faroult ...
    Boivin, Patrice JBoivin, Patrice J
    Aug 31, 2004 at 7:48 am
    Sep 1, 2004 at 11:55 pm
  • During the debacle this weekend, I did come across something interesting. Below I've attached a section of the alert log file from the instance that experienced difficulties. This is the first time ...
    Adams, Matthew (GE Consumer & Industrial)Adams, Matthew (GE Consumer & Industrial)
    Aug 23, 2004 at 12:07 pm
    Aug 26, 2004 at 6:07 am
  • Hello, Could use some help here. If database statspack report says that the event: "db file scattered read" is the top wait event and it uses up a large proportion of the time between each ...
    Lyndon TiuLyndon Tiu
    Aug 6, 2004 at 6:03 pm
    Aug 15, 2004 at 12:17 pm
  • Hello Folks, We have a legacy system on Oracle 7.3.4 on NT. I am dropping the user with cascade, but it is extremely slow??? About 2GB in 5hrs? and there are still 10GB to go. Can anyone tell me why? ...
    Denham EvaDenham Eva
    Aug 4, 2004 at 10:56 am
    Aug 9, 2004 at 10:13 am
  • I am finally getting to practice some of the tracing functionality that = is discussed here and ran into something I haven't seen dicussed here. = We had a complaint about a query that performs ...
    Freeman, DonaldFreeman, Donald
    Aug 3, 2004 at 9:22 am
    Aug 3, 2004 at 1:16 pm
  • Take a look at: http://www.dbazine.com/burleson25.shtml This is a must see, because I believe (me, my own belief, not any company, list, or other entity) there are folks on this list, umm, mentioned ...
    Darrell LandrumDarrell Landrum
    Aug 31, 2004 at 3:49 pm
    Sep 2, 2004 at 8:19 pm
  • Hi Listers, Its an emergency please. I am experiencing a strange and baffling situation.I am running Oracle 8.1.6 on WIN2K. When in shell, I write svrmgrl, I get an error. svrmgrl ORA-12560-TNS ...
    Fahd mirzaFahd mirza
    Aug 24, 2004 at 1:26 am
    Aug 24, 2004 at 7:46 pm
  • All, what kind of privilege new for creating a FK constraint which reference table belongs to another schema. ALTER TABLE PAM.table1 ADD CONSTRAINT FKCONS1 FOREIGN KEY (ID) REFERENCES schema1.table2 ...
    Hamid AlaviHamid Alavi
    Aug 23, 2004 at 4:31 pm
    Aug 24, 2004 at 5:26 pm
  • I'm finishing a Masters in Software Engineering in Spring 2005. Then I want to either do a masters in computer science or an MBA. I have met several technical people with MBAs. Do you find the ...
    Ryan.gaffuri_at_comcast.netRyan.gaffuri_at_comcast.net
    Aug 3, 2004 at 7:13 am
    Aug 9, 2004 at 10:04 am
  • Dear List, Having been the 'owner' and admin of this list for the past six years has been a (mostly) fun ride, and quite a learning experience. All good things come to and end, and the time has come ...
    Jared StillJared Still
    Aug 30, 2004 at 9:59 pm
    Sep 8, 2004 at 10:23 am
  • All, Can anyone point me to a good outline for a 'database health-check'. I.e. is it best to base it on statspack/bstat/estat, some form of response time breakdown (I'm reading Cary's book at the ...
    Lord DavidLord David
    Aug 25, 2004 at 7:28 am
    Aug 25, 2004 at 12:28 pm
  • Is there any problem with developers using Quest Software's TOAD on production databases? Regardless of the functionality in TOAD, a developer shouldn't be able to use the DBA functionality in TOAD, ...
    Potluri, Venu (IDS AIS SE)Potluri, Venu (IDS AIS SE)
    Aug 16, 2004 at 3:19 pm
    Aug 18, 2004 at 6:52 am
  • Hi all, Version:- 9.2.0.1 Enterprise Edition OS: Win2K Have RTFM, STFW, RTFAT etc. etc. without much luck. Here's the case: On gathering stats with different options of SIZE clause I am getting ...
    Charudatta JoshiCharudatta Joshi
    Aug 2, 2004 at 6:28 am
    Aug 7, 2004 at 7:41 am
  • Hello list members, I have a query that runs fast in SUN 8i and terrible in HP 9i.=20 This is the execution plan in 8i (8.1.7.2) INSERT STATEMENT CHOOSE Cost=3D20 Rows Expected=3D11 SORT GROUP BY ...
    Guerra, Abraham JGuerra, Abraham J
    Aug 11, 2004 at 9:58 am
    Aug 29, 2004 at 11:47 am
  • Hi All, Few queries are taking longer time (40 sec =10*normal time) to execute in intermittent manner.For example, 99 percent of the time it got executed within 3 to 4 secs and 1 percent of the time ...
    Jaysingh1_at_optonline.netJaysingh1_at_optonline.net
    Aug 5, 2004 at 8:06 am
    Aug 7, 2004 at 2:24 pm
  • My regards to all, At the moment I have impression that, 10046 event is useless in 9.2.0.4 version for response time measuring! I have tied to run loop.sql (see below for full text) with and without ...
    J.Velikanovs_at_alise.lvJ.Velikanovs_at_alise.lv
    Aug 2, 2004 at 8:28 am
    Aug 3, 2004 at 9:37 am
  • This seems like it should be easy: 1* alter system set = dispatchers=3D'(address=3D(HOST=3Dcary.biz.com)(port=3D3620))' SQL / alter system set = ...
    Mary BahramiMary Bahrami
    Aug 10, 2004 at 11:10 am
    Aug 11, 2004 at 9:20 am
  • 13

    test

    Please see the official ORACLE-L FAQ: http://www.orafaq.com To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at ...
    Jeffrey BeckstromJeffrey Beckstrom
    Aug 2, 2004 at 6:55 am
    Aug 23, 2004 at 9:36 am
  • Excellent post mark. However, I have the following 1 table query that does the following select col1, col2 from table where primary_key = The table has 56 rows 1 MB size. 128 blocks(so 8192 ...
    Ryan.gaffuri_at_comcast.netRyan.gaffuri_at_comcast.net
    Aug 13, 2004 at 10:58 am
    Aug 13, 2004 at 3:21 pm
  • I am a newbie at trying to use Perl. I wanted to get the DBI/DBD modules installed on a HP-UX 11i machine, but...well... I'm getting compile errors from the 'make' step, and I'm not a 'c' programmer, ...
    Vergara, Michael (TEM)Vergara, Michael (TEM)
    Aug 5, 2004 at 5:41 pm
    Aug 8, 2004 at 10:10 am
  • Dear All, We are having Oracle 8.1.6 Under HP UX 11.0. We are going to migrate Oracle 8.1.6 into Oracle 10g under Red Hat Enterprise Linux AS 3.0 (64 Bit Standard Edition). Please give some useful ...
    Computer Centre - NIIPLComputer Centre - NIIPL
    Aug 4, 2004 at 3:48 am
    Aug 5, 2004 at 8:12 am
  • Hello expert, I have a table with 40 millions records and the last update date is indexed. But when we use the following where clause, it takes forever to run the report. WHERE ...
    Wes BrooksWes Brooks
    Aug 2, 2004 at 5:08 am
    Aug 3, 2004 at 12:00 pm
  • Some of you might have read the article I recently posted on "Subquery Madness!": http://five.pairlist.net/pipermail/oracle-article/2004/000012.html Chris Date took an interest in the issue, and he ...
    Jonathan GennickJonathan Gennick
    Aug 27, 2004 at 4:23 pm
    Sep 2, 2004 at 3:42 pm
  • Hi, I have a database running in noarchivelog mode. Scenario: I have a test database running in noarchivelog mode. Database is 8i. Cold backup is performed weekly. It is a filecopy, NOT RMAN backup ...
    Srinivasa MedamSrinivasa Medam
    Aug 31, 2004 at 9:00 am
    Aug 31, 2004 at 11:09 am
  • Gurus, I am in the midst of living the examples given in several of your books. I spoke to a few of you at the Oracle-l dinner at Hotsos about this situation and the hypothesis has again proven true ...
    RobynRobyn
    Aug 24, 2004 at 9:30 am
    Aug 24, 2004 at 6:21 pm
  • Hi list, Just wondering. Imagine you have more than one valid parameter file in the system (not spfile), and someone else has started the database. How can you know which parameter file he/she used ...
    Diego CutroneDiego Cutrone
    Aug 20, 2004 at 2:49 pm
    Aug 22, 2004 at 5:32 am
  • HP-UX, Oracle 8.1.7. To refresh the test databases we drop all tables and then import. We have a request to not blow off or change all tables that start with "OPB_". I can NOT purge them, but purge ...
    Kline.MichaelKline.Michael
    Aug 17, 2004 at 10:55 am
    Aug 17, 2004 at 2:49 pm
  • Does anyone have a command that will grep for all files in a file system that contain a string like "sqlplus"? I can do it within a directory, but I want it to look at all the directories. Thanks! ...
    Smith, Ron L.Smith, Ron L.
    Aug 12, 2004 at 4:08 pm
    Aug 13, 2004 at 9:04 am
  • Cary, Thanks for your response. I ahve enclosed all the details here. Generated extended tarce with level12. SELECT DISTINCT P.PROFILEDUSERID PROFILEDUSERID, SEARCH_LAST_NAME, SEARCH_FIRST_NAME FROM ...
    Jaysingh1_at_optonline.netJaysingh1_at_optonline.net
    Aug 6, 2004 at 9:49 am
    Aug 6, 2004 at 1:07 pm
  • Hi All, The package BODY status became invalid because of the object modification(another package) refered in the package body. Now we are trying to compile the package and it hangs. Checked ...
    Jaysingh1_at_optonline.netJaysingh1_at_optonline.net
    Aug 31, 2004 at 2:45 pm
    Sep 1, 2004 at 6:48 pm
  • All I've always worked in a windows client server environment so I'd like to get some information from those working in UNIX and Linux. My questions are: These questions are based on file ...
    Bob MetelskyBob Metelsky
    Aug 22, 2004 at 8:56 pm
    Aug 29, 2004 at 7:12 pm
  • Guys, I have a database and packages/procs, I have recently inherited with = little info. It runs successfully in another 9.2.0.4 database I setup = on another host. Same database setup, version, ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Aug 23, 2004 at 8:11 am
    Aug 23, 2004 at 12:45 pm
  • Hello gurus, We upgraded Peoplesoft to Oracle9i over the weekend. So far everything work= s great except one batch job. Did an extended trace and the waits are on SQL*net message event. I got the ...
    Thomas BijuThomas Biju
    Aug 23, 2004 at 9:38 am
    Aug 23, 2004 at 10:49 am
  • AIM - To Set Row level security using VPD on a Centralized Database Qs What is the Affect on Database performance? Qs Any General Benchmarks on the Affect on performance due to implementation of VPD? ...
    VIVEK_SHARMAVIVEK_SHARMA
    Aug 18, 2004 at 12:34 pm
    Aug 22, 2004 at 4:41 pm
  • Guys, I hope you don't mind answering this - I am sure I answered this at one = time but now forgot the answer. I have some SQL generating SQL but there are skipped lines so the = commands do not ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Aug 19, 2004 at 11:06 am
    Aug 20, 2004 at 9:07 am
Group Navigation
period‹ prev | Aug 2004 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions345
posts2,223
users295
websiteoracle.com

295 users for August 2004

Gogala, Mladen: 87 posts Jared.Still_at_radisys.com: 69 posts Mark W. Farnham: 69 posts Niall Litchfield: 68 posts J.Velikanovs_at_alise.lv: 53 posts Mogens Nørgaard: 51 posts Jesse, Rich: 47 posts Mercadante, Thomas F: 47 posts Tanel Põder: 46 posts Carel-Jan Engel: 45 posts Raj Jamadagni: 44 posts Wolfgang Breitling: 43 posts Daniel W. Fink: 41 posts DENNIS WILLIAMS: 40 posts Cary Millsap: 39 posts Bobak, Mark: 37 posts Jaysingh1_at_optonline.net: 35 posts Ryan.gaffuri_at_comcast.net: 34 posts Jared Still: 33 posts Paul Drake: 33 posts
show more
Archives