Search Discussions

592 discussions - 2,708 posts

  • We have a query (please don't ask me why it is written this way) --Doesn't work: select ea1.ep_number, ea1.est_dt, veas.est_dt from (select a.ep_number, ea.est_dt from v_episode_avail_summary_break ...
    Jamadagni, RajendraJamadagni, Rajendra
    Oct 29, 2002 at 1:54 pm
    Oct 29, 2002 at 6:34 pm
  • when i do a count(*) an a 1.2GB table, just after an app finishes inserting 20 million records i can see from iostat that, that disk is being read as well as written to !!! the only reason i can ...
    Oct 19, 2002 at 8:48 am
    Oct 21, 2002 at 10:33 pm
  • Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will ...
    Paquette stephanePaquette stephane
    Oct 16, 2002 at 6:25 pm
    Oct 21, 2002 at 1:59 pm
  • Hi guys, I need a second opinion on the following Statspack output, I got my suspicions but my manager and the client is not buying what I am say, Not knowing anything of the system architecture ...
    Leonard, GeorgeLeonard, George
    Oct 18, 2002 at 8:53 am
    Oct 20, 2002 at 11:38 am
  • Hi list Can anyone explain me what exactly does the WAIT I/O column of the sar -u output mean? Does it represent the % of CPU used by the kernel processes to perform I/O? As far as I know the waiting ...
    Pablo RodriguezPablo Rodriguez
    Oct 10, 2002 at 8:15 pm
    Oct 15, 2002 at 9:33 pm
  • Dear Data Warehouse Experts, Could you please share you experience with snowflake and star data models. How do you choose between them? What problems may arise? Is star schema preferred for Oracle? ...
    Alexandre GorbatchevAlexandre Gorbatchev
    Oct 7, 2002 at 12:54 pm
    Oct 14, 2002 at 4:43 pm
  • I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA ...
    April WellsApril Wells
    Oct 9, 2002 at 2:54 pm
    Oct 10, 2002 at 11:33 pm
  • (just kidding) No more RBO as of 10i... http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=189702.1 "10i"? I haven't even upgraded to "9i" yet because none ...
    Jesse, RichJesse, Rich
    Oct 8, 2002 at 6:54 pm
    Oct 9, 2002 at 3:13 am
  • We're moving from RBO to CBO. For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS? And why? My thinking is if it's a database where most of the querying is done on small sets of ...
    Armstead, Michael AArmstead, Michael A
    Oct 29, 2002 at 9:13 pm
    Oct 31, 2002 at 5:54 pm
  • A quick question out to the masses.. How many of you out there are ACTUALLY USING 9i RAC technology? If not already using it - how many have plans to use it (or at least plan to investigate it)? ...
    Mark LeithMark Leith
    Oct 29, 2002 at 4:29 pm
    Oct 31, 2002 at 4:13 pm
  • Hi list, I need to do some testing in an Oracle 7.3.4 for linux (redhat), where can I download this Oracle version from? it doesn't appear to be online in OTN. thanks for your help. Greetings Diego ...
    Oct 23, 2002 at 8:38 pm
    Oct 28, 2002 at 10:29 pm
  • Hi All, I have 2 tables BIG - 100 million records SMALL - 1 million records. I want to delete all the records in BIG that are in small. There is a PK on field1. Which of the below methods would you ...
    Oct 18, 2002 at 6:31 pm
    Oct 20, 2002 at 2:03 pm
  • I am performing an export of a set of very large tables. I am not using CONSISTENT mode. The exports are failing due to snapshot too old errors. The application uses many small rollback segments, but ...
    Erik WilliamsErik Williams
    Oct 18, 2002 at 2:13 pm
    Oct 19, 2002 at 12:43 am
  • 11:54:32 SQL GRANT RESOURCE TO JNJDSS_STG_T; GRANT RESOURCE TO JNJDSS_STG_T * ERROR at line 1: ORA-01031: insufficient privileges 11:54:39 SQL sho user USER is "OPS$JNJDBA" 11:54:45 SQL select * from ...
    Grabowy, ChrisGrabowy, Chris
    Oct 17, 2002 at 5:28 pm
    Oct 18, 2002 at 10:19 pm
  • Okay ... so I have a query that works fine in RBO (8161). In CBO (9201) is returns wrong results (stats are recreated this AM). By adding a group by the CBO query returns the right data. Furthermore ...
    Jamadagni, RajendraJamadagni, Rajendra
    Oct 16, 2002 at 4:29 pm
    Oct 18, 2002 at 4:04 pm
  • Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this ...
    Arun ChakrapaniraoArun Chakrapanirao
    Oct 16, 2002 at 12:14 pm
    Oct 16, 2002 at 4:34 pm
  • Thanks Dennis! I'm sitting here dying because one of my stereo headphone speakers i do ng t is t m ri gt n w..... ARRRUUUGGGGHHHH..... Robert G. Freeman - Oracle OCP Oracle Database Architect CSX ...
    Freeman, RobertFreeman, Robert
    Oct 10, 2002 at 6:28 pm
    Oct 15, 2002 at 10:28 am
  • Listers: While I certainly appreciate the great range of experience and knowledge by the subscribers on this list, if my rudimentary knowledge is to be trusted, I think 95% of the postings are DBA ...
    Droogendyk, HarryDroogendyk, Harry
    Oct 10, 2002 at 10:43 pm
    Oct 11, 2002 at 3:13 pm
  • List, With all of the recent discussion and the forth coming books and the upgrade here to 8i I have a question. Where do you build your RMAN repository database? If you build it in the same server ...
    Ron RogersRon Rogers
    Oct 4, 2002 at 6:31 pm
    Oct 8, 2002 at 2:33 pm
  • Our developers are proposing a database design for an OLTP application in which each table has a PK of the same type and size. In addition, each possible PK value can belong to at most one table ...
    Brian P AndrewsBrian P Andrews
    Oct 31, 2002 at 1:33 pm
    Oct 31, 2002 at 11:04 pm
  • Hi, I just got forwarded a whitepaper from Hitachi and Oracle, that compairs raid 5+ and raid 1 using the TPC-C benchmark test suite. The claim is that raid 5 is as fast or faster. While I'm waiting ...
    Brooks, RussBrooks, Russ
    Oct 28, 2002 at 10:23 pm
    Oct 30, 2002 at 4:44 pm
  • -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: MIvanov_at_TDERA.RU Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing ...
    Oct 1, 2002 at 8:13 am
    Oct 29, 2002 at 12:13 pm
  • Hello, BACKGROUND: We've been planning a 300GB datawarehouse architecture for Oracle 9.2 on Solaris, and have proposed the following: 1) 2 separate instances of Oracle 9.2, Instance A will be the ...
    Oct 14, 2002 at 5:48 pm
    Oct 23, 2002 at 5:02 pm
  • To All, I'll admit this is somewhat off-topic, but since the project is going to handle all scheduled batch jobs that bang on our PeopleSoft Oracle database, I figured I'd ask if anyone has an ...
    Oct 18, 2002 at 3:49 pm
    Oct 23, 2002 at 3:45 pm
  • All Ive been scowering the web and metalink to find a finite list of supported /desupported versions Ive found one list on metalink bit couldn't bookmark the page and cant find it again. All the ...
    Bob MetelskyBob Metelsky
    Oct 21, 2002 at 2:04 pm
    Oct 22, 2002 at 10:14 pm
  • I haven't recieved anything from this list since friday evening. I know there usually isn't as much traffic on the weekend, but there is some. And there has been nothing at all this morning either ...
    Ball, TerryBall, Terry
    Oct 21, 2002 at 4:38 pm
    Oct 22, 2002 at 6:49 pm
  • Greetings Gurus Just wondering....... Our archive log's directory has grown substantially and space is becoming an issue. How do you know which archive files is safe to delete? In other words... Do ...
    Denham EvaDenham Eva
    Oct 18, 2002 at 10:28 am
    Oct 20, 2002 at 10:23 am
  • We have ORACLE running on NT. My questions are: What difference between public rollback segment and private segement? what is benefit on public segment than private segment? does public ...
    Dist cashDist cash
    Oct 17, 2002 at 3:18 pm
    Oct 17, 2002 at 7:37 pm
  • Hi, Can anybody please tell me the difference between - SQL execute DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR ALL INDEXES'); and SQL select 'ALTER INDEX ' || INDEX_NAME || ' REBUILD ...
    Marul MehtaMarul Mehta
    Oct 16, 2002 at 11:43 am
    Oct 17, 2002 at 9:24 am
  • Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was for the reason that it was latest. But some of my friends have advised Any opinions? Thanks, ...
    Rachna VaidyaRachna Vaidya
    Oct 11, 2002 at 6:14 pm
    Oct 11, 2002 at 11:03 pm
  • I am looking for a query that will allow me to find the SQL statements that are responsible for Full Table Scans. I understand that sometimes a full table scan is the best way to return data but I ...
    Jay Earle (DBA)Jay Earle (DBA)
    Oct 9, 2002 at 4:33 pm
    Oct 10, 2002 at 10:33 pm
  • As I was investigating more on this issue, I took a close look at the select statement which runs just before the drop. Isnt this select statement supposed to have a STAT with the execution plan in ...
    Oct 10, 2002 at 4:39 pm
    Oct 10, 2002 at 9:33 pm
  • Hi, Can anyone point me in the right direction. In my table I have a varchar2 column that contains a label that could be either text or numeric data. I need to update another column in the same table ...
    Robert MorrisonRobert Morrison
    Oct 7, 2002 at 9:13 am
    Oct 7, 2002 at 8:33 pm
  • Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) ...
    Oct 4, 2002 at 3:28 pm
    Oct 7, 2002 at 1:24 pm
  • I am reposting this. Has anyone tried to convert a dictionary managed table space containing lots of data to locally managed? We have tried this out successfully on empty table spaces or created a ...
    Oct 29, 2002 at 2:43 am
    Oct 31, 2002 at 5:13 pm
  • Has anyone installed iAS on Intel Linux? I have downloaded the reams of documentation and this is a beast, much different than OAS 4.0.8. It requires a 9i db, Oracle Single SignOn, OID, OEM ...
    Gene SaisGene Sais
    Oct 25, 2002 at 7:33 pm
    Oct 29, 2002 at 5:59 pm
  • hi all I have my listener.ora owned by the oracle owner with 600 permissions and admin_restrictions_listener set. On a machine in the DMZ. Is there any point in having a password as well? thanks ...
    Oct 17, 2002 at 9:38 am
    Oct 18, 2002 at 8:53 am
  • How do I stop users from accessing Oracle tables with Access? They have rights to the tables in Oracle and should have those rights, yet I do not want anyone to be able to pull the data off into an ...
    Burton, Laura L.Burton, Laura L.
    Oct 15, 2002 at 10:58 pm
    Oct 17, 2002 at 6:58 am
  • Hi, My agent asked me these couple of questions through email, can any one give me some idea? Thank you! Leslie What are a couple ways to detect block corruption within an oracle database? What is ...
    Leslie LuLeslie Lu
    Oct 14, 2002 at 9:43 pm
    Oct 15, 2002 at 4:18 am
  • Ok i've been thru all of the 817 docs multiple times, searched metalstink, read the chapters in backup/recovery 101 multiple times. Where in the heck is the "spool" command for rman? Can i only spool ...
    Oct 14, 2002 at 3:14 pm
    Oct 15, 2002 at 12:14 am
  • Hi Dick, I have to disagree with you here. Particularly in the case where this sequence will see any sort of concurrency, from multiple concurrent sessions accessing it. This is due to the ...
    Mark J. BobakMark J. Bobak
    Oct 11, 2002 at 12:33 am
    Oct 11, 2002 at 5:29 pm
  • Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a ...
    Deshpande, KirtiDeshpande, Kirti
    Oct 11, 2002 at 1:48 pm
    Oct 11, 2002 at 5:03 pm
  • Hi One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I have noticed after week again cache hit ratio became low. Can u please suggest what other things I can do to fix this ...
    Seema SinghSeema Singh
    Oct 9, 2002 at 9:13 pm
    Oct 10, 2002 at 2:53 am
  • Hi, You have to recreate the controlfile as "CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS ARCHIVELOG". The new database name will be TEST . Pl ensure that the old control files are deleted before ...
    Choudhary Rajendra (TTL_LKO)Choudhary Rajendra (TTL_LKO)
    Oct 9, 2002 at 8:08 am
    Oct 10, 2002 at 1:33 am
  • I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? ...
    Farnsworth, DaveFarnsworth, Dave
    Oct 9, 2002 at 1:54 pm
    Oct 9, 2002 at 6:30 pm
  • Hi All, We have a database running and implemented a procedure that renames the alert logs every day. When the databases are down we rename the alert logs with a date extension. Now we have ...
    Jack van ZanenJack van Zanen
    Oct 9, 2002 at 9:38 am
    Oct 9, 2002 at 5:13 pm
  • Listers: I've used SAS's version of SQL and it allows the coding of conditional logic in the SELECT statement: proc sql; select acct_no, case substr(acct_no,16,1) when '1' then 'one' when '2' then ...
    Droogendyk, HarryDroogendyk, Harry
    Oct 7, 2002 at 8:38 pm
    Oct 9, 2002 at 12:48 pm
  • Hello Folks, I carried out a test, whereby I had just one rollback segment online with a block size of 2K, and then running updates against the database thru different sessions without commiting any ...
    Oct 8, 2002 at 6:34 pm
    Oct 8, 2002 at 11:13 pm
  • Gurus, Solaris8/Oracle 8173-32bit. Shutdown abort works but Shutdown immediate hangs. Startup Normal is fine. No special entries in Alert log regarding smon/pmon activities-postStartup/During ...
    Ravi KulkarniRavi Kulkarni
    Oct 5, 2002 at 8:03 am
    Oct 7, 2002 at 5:38 pm
  • the subject line pretty much describes it., Solaris 2.8 We are using the ANYDATA datatype and while we have no problems with insert or select or delete, the process blows up (ora-7445, ...
    Rachel CarmichaelRachel Carmichael
    Oct 4, 2002 at 1:33 pm
    Oct 4, 2002 at 7:49 pm
Group Navigation
period‹ prev | Oct 2002 | next ›
Group Overview
grouporacle-l @

383 users for October 2002

DENNIS WILLIAMS: 106 posts Jared.Still_at_radisys.com: 95 posts Tim Gorman: 79 posts Rachel Carmichael: 70 posts Deshpande, Kirti: 65 posts Dgoulet_at_vicr.com: 53 posts Yechiel Adar: 50 posts Jamadagni, Rajendra: 49 posts Naveen Nahata: 47 posts Fink, Dan: 45 posts Mercadante, Thomas F: 44 posts Jesse, Rich: 43 posts Rajesh.Rao_at_jpmchase.com: 38 posts Igor Neyman: 37 posts Gogala, Mladen: 36 posts Ray Stell: 35 posts Connor McDonald: 33 posts Grabowy, Chris: 31 posts Paquette stephane: 31 posts Rick_Cale_at_teamhealth.com: 31 posts
show more