Search Discussions

247 discussions - 1,336 posts

  • I know some of you folks have large SMPs as the result of consolidating from a lot of little SMPs into one large one for managability sake. What about distaster recovery? If you have, say, 20 ...
    Kevin ClossonKevin Closson
    Sep 17, 2006 at 3:16 pm
    Sep 21, 2006 at 10:27 am
  • Many moons ago, way back in the 32-bit era when Y2K was a looming nightmare, I had instituted a policy that no Oracle datafile would be setup to grow larger than 2GB. This was due to some known bugs ...
    Jesse, RichJesse, Rich
    Sep 8, 2006 at 2:16 pm
    Sep 27, 2006 at 5:12 pm
  • From an SR I currently have out with Oracle. 2. Although the documentation does not explicitly state this, it is necessary to create a new user that owns the $O_H created by the OMS install. Please ...
    Niall LitchfieldNiall Litchfield
    Sep 27, 2006 at 10:21 am
    Oct 2, 2006 at 5:14 pm
  • I have a document processing system on Oracle 10.2 Linux. It stores document as blob in the database. We store 1 Million docs a month and current table size is 5 million. Database size is 50 GB out ...
    Sandeep DubeySandeep Dubey
    Sep 28, 2006 at 6:39 pm
    Oct 3, 2006 at 11:41 pm
  • Right, but if the machine name isn't one of the allowed machines, what action does the trigger take? Paul Baumgartel CREDIT SUISSE Information Technology DBA & Admin - NY, KIGA 1 11 Madison Avenue ...
    Baumgartel, PaulBaumgartel, Paul
    Sep 13, 2006 at 4:30 pm
    Sep 15, 2006 at 5:50 pm
  • Hi, I want to give read privelege to "others", for newly created trace files in bdump directory automatically. Is there a way of doing that in AIX5L? Thanks. Regards, Derya. -- ...
    Derya OktayDerya Oktay
    Sep 18, 2006 at 11:12 am
    Sep 26, 2006 at 1:42 am
  • Hi all, I have a very complicated view, NASTY_VIEW. SELECT * FROM NASTY_VIEW WHERE ID = :bind This is fast (< 1 second). CBO cost = 400. Fantastic. However if I try SELECT * FROM NASTY_VIEW WHERE ID ...
    Charlotte HammondCharlotte Hammond
    Sep 12, 2006 at 4:10 pm
    Sep 14, 2006 at 11:30 am
  • All, I proposed a plan to make a good working Oracle home(with all the patches installed) and making an image and using the same image for all other nodes with the same platform and hardware. The ...
    Sep 28, 2006 at 7:45 pm
    Oct 3, 2006 at 5:04 pm
  • Hello everyone, Can someone tell me an alter system kill session 'sid,serial#'; will kill runaway processes or long running queries as efficiently as doing a shutdown abort, startup, shutdown ...
    Queen Roo RooQueen Roo Roo
    Sep 13, 2006 at 6:39 pm
    Sep 18, 2006 at 8:58 am
  • Greetings, Oracle I have taken a Block dump, Where do I look for missing commit? -- Regards & Thanks BN -- http://www.freelists.org/webpage/oracle-l
    Sep 18, 2006 at 9:36 pm
    Sep 21, 2006 at 3:35 pm
  • Hi I have been suggested by some Oracle Consultant to set 20 Database Writer in a 12 CPU HP-UX Server. Does anyone know what are the side effects of having excessive DBWR? I detected a higher CPU ...
    Sep 6, 2006 at 8:39 am
    Sep 10, 2006 at 1:24 pm
  • Currently we run Oracle standard edition (32 bit) on RHEL release 4 on an IBM 345 (x86) with 6GB of memory. Here's what I am trying to accomplish: Trying to figure out whether 64 bit Oracle will ...
    Nirmalya DasNirmalya Das
    Sep 6, 2006 at 6:38 pm
    Sep 8, 2006 at 2:28 pm
  • Hi We will buy an new server. SO will be RHEL 4 AS/ES Alternatives: HP 585 4x AMD Opteron HP 580 4x Xeon Any reference, idea, experience about these 2 alternatives ??? What about SGA limit ? I think ...
    Juan MirandaJuan Miranda
    Sep 5, 2006 at 12:51 pm
    Sep 14, 2006 at 11:03 pm
  • Hi all, The unix administrators at client site require to use unix sudo to log in as oracle software owner. They are currently at 9i and plan to migrate to 10g. Does anyone have some experience ...
    Goran bogdanovicGoran bogdanovic
    Sep 7, 2006 at 11:29 am
    Sep 11, 2006 at 12:56 pm
  • Hi all, I am trying to import a file from one SID to another one, on Solaris. I made a full export for a specific user and prior importing, I created the user and all of its tablespaces, datafiles ...
    Sep 8, 2006 at 2:59 pm
    Sep 8, 2006 at 7:07 pm
  • Funny topic, eh? I am practicing backup and recovery procedures and finding that recovery is quite easy since I never have corrupted blocks to worry about. So, how do I practice for a "worse case" ...
    Charles SchultzCharles Schultz
    Sep 2, 2006 at 3:07 pm
    Sep 5, 2006 at 11:25 pm
  • We have certain Users running queries that frequently fill-up the TEMP tablespace. Is there a way to specify quota on TEMP. We are on 10gR2 and I already found that this stopped working in 10gR2 (it ...
    Deepak SharmaDeepak Sharma
    Sep 20, 2006 at 4:32 pm
    Nov 1, 2006 at 1:10 am
  • Hi All, Does anyone have some information of expected IO rate (IOPS and/or MBPS) for U320 SCSI 15K RPM Hard Drive (HP 146GB U320 15K Universal HDD)? Thanks! Lale -- ...
    Lale obradovicLale obradovic
    Sep 28, 2006 at 4:19 pm
    Oct 14, 2006 at 8:51 pm
  • So, last week, one of my instances starts getting ORA-4031s, and after a few minutes, comes crashing down when a background process (lmd0, I think it was) catches an ORA-4031. So, with the instance ...
    Bobak, MarkBobak, Mark
    Sep 19, 2006 at 2:37 pm
    Sep 21, 2006 at 12:04 pm
  • insert into SRHCXN1.empleado select * from userid.empleado_at_PRUEBAS.US.ORACLE.COM where emp_fecha_ingreso =to_date('20060901','yyyymmdd') / Isabel Bedoya Gómez Centro de Gestión y Control Tel ...
    Sep 11, 2006 at 9:49 pm
    Sep 11, 2006 at 11:04 pm
  • Would you use dbms_application_info for every single pl/sql procedure? Even ones that just run a single query? I was thinking about floating this idea at work. This is how I would do it. Module ...
    Sep 26, 2006 at 3:37 am
    Feb 19, 2007 at 10:50 am
  • All, Platform: V440, Solaris 8, 9206 Enterprise Edition. Related parameters: Cursor_sharing=similar Cursor_space_for_time=true Query_rewrite_enabled=true Shared_pool_size=800M I'm on a site whereby ...
    Sep 25, 2006 at 7:22 pm
    Sep 27, 2006 at 5:44 am
  • Hi, what is maximum number of directories can be specified under utl_file_dir? is this unlimited? or say 100 or 200 files are son on? i have searched metalink but no where it is specified! Thanks, ...
    Edwin devadanamEdwin devadanam
    Sep 28, 2006 at 4:43 am
    Oct 5, 2006 at 1:50 am
  • Currently our production/test/development databases all reside on the same 2 cpu RH4 machine. Our database environment is growing at a steady pace. Over the last month we have encountered several ...
    Stephens, ChrisStephens, Chris
    Sep 28, 2006 at 1:41 pm
    Sep 29, 2006 at 5:53 pm
  • I frequently run into situations where production support folks (basically former developers converted to support their code now in production) would like to find more information out about what's ...
    Herring Dave - dherriHerring Dave - dherri
    Sep 2, 2006 at 3:42 pm
    Sep 18, 2006 at 2:37 pm
  • Hi All, can any of you suggest best practices for partitioning in a Datawarehousing environment. for example, how to implement partitioning on fact tables My table has 150 million rows in it. Any ...
    Anurag VermaAnurag Verma
    Sep 1, 2006 at 6:50 pm
    Sep 6, 2006 at 5:47 am
  • By using df -k, how can I tell whether a system is using a SAN device versus having everything on local drives? If it is all logical drives, wouldn't all of the mount points start out with something ...
    J. DexJ. Dex
    Sep 29, 2006 at 9:02 pm
    Oct 5, 2006 at 3:18 pm
  • Hi I want to share this because I didn't fully understood it, Tom Kyte clarifyme the risk of using asynchronous commit ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Sep 26, 2006 at 1:12 pm
    Sep 27, 2006 at 9:05 am
  • Does anyone know why there's a big performance difference when using != vs. < ? I was just looking at a query that was written both ways and there is a big difference in how long it takes to return ...
    Scott CanaanScott Canaan
    Sep 22, 2006 at 8:20 pm
    Sep 26, 2006 at 8:04 pm
  • Hi all, I am trying to run a query with sub-queries in Oracle 10G Release 2 and it is taking ages, I divided the query into parts and I have no problems running the first and third subqueries ...
    Isabel BedoyaIsabel Bedoya
    Sep 21, 2006 at 9:13 pm
    Sep 22, 2006 at 5:53 am
  • create or replace function t1 return number is v_exists number(5):=0; begin select 1 into v_exists from dual where 1 = 0; return v_exists; --exception when others then v_exists := '999'; return 999 ...
    Amihay GonenAmihay Gonen
    Sep 20, 2006 at 5:22 am
    Sep 20, 2006 at 8:49 pm
  • OpenVMS 7.3-1 Oracle Hi, all. Does anyone know how to spool to a symbol in vms? Here's my dcl. I want to spool to the file identified by the symbol tmp. $ val_sid = f$trnlnm("ora_sid") $! $ ...
    Barbara BakerBarbara Baker
    Sep 7, 2006 at 4:06 pm
    Sep 19, 2006 at 12:15 am
  • All, I am finally trying to get 10g Grid up and running. I am trying to get our 10g agents ( to discover and connect to our 9i databases ( I have successfully connected to our ...
    Mercadante, Thomas F \(LABOR\)Mercadante, Thomas F \(LABOR\)
    Sep 11, 2006 at 11:48 am
    Sep 13, 2006 at 1:01 pm
  • Hi I want to run one Stored procedure every 6 hourly on Week days between 9am EST to 10pm EST. Can somebody give me some idea as how it will work with 10g Sceduler. Here is what is been done I had ...
    Sanjay MishraSanjay Mishra
    Sep 5, 2006 at 5:03 pm
    Sep 6, 2006 at 10:32 pm
  • Hi Does anyone know how to obtain the number of USER transactions per hour? Or per minute? I know from user commits and user tollbacks we can get roughly the number of Updates/Inserts/Deletes ...
    Sep 14, 2006 at 4:03 pm
    Sep 15, 2006 at 3:16 pm
  • 8


    so I'm having a bad day. The Grid control thing rumbles along. Now we have a J2EE app upgrade supplied to us by a third party. In debug mode for live use. bye bye 18gb of disk per day... No doubt ...
    Niall LitchfieldNiall Litchfield
    Sep 27, 2006 at 2:17 pm
    Sep 28, 2006 at 4:33 pm
  • I have a table with 368 blocks, no free blocks, and the clustering factor of the primary key is 345. how is it possible? I thought that CF will give you the amount of table blocks that an index will ...
    Polarski, BernardPolarski, Bernard
    Sep 27, 2006 at 8:47 am
    Sep 27, 2006 at 11:09 am
  • Hi List, To start up a physical standby database, you use "startup nomount" and "alter database mount standby database;" .... What if someone just types in "startup" and hits Enter? Does the standby ...
    Roger XuRoger Xu
    Sep 21, 2006 at 7:45 pm
    Sep 21, 2006 at 8:46 pm
  • Hi, We are porting the application from SQL Server to Oracle, we have lot of queries in the xml file and the application read the queries from the file. In some scenarios we have following construct ...
    Harvinder SinghHarvinder Singh
    Sep 14, 2006 at 6:49 pm
    Sep 16, 2006 at 7:35 am
  • How do I get the definition of a view? I used the following SQL but not getting all definition text - I know something needs to be done on the format of long type. 1 select TEXT_LENGTH,TEXT 2 from ...
    Roger XuRoger Xu
    Sep 8, 2006 at 3:42 pm
    Sep 8, 2006 at 4:00 pm
  • Hello I am getting the *User equivalence unavailable on all the nodes* while running cluvfy verification. (10gR2 RAC) ssh on both nodes are working correctly without needing password. I also enabled ...
    Oracle sosOracle sos
    Sep 6, 2006 at 4:30 pm
    Sep 7, 2006 at 10:00 am
  • Hi I was wondering if anyone know how is spin_count measured? In CPU CYCLES? I havea doubt with CPU usage as well, I undersstand that in v$sysstat it is using centiseconds to measure CPU usage. I ...
    Sep 3, 2006 at 8:01 pm
    Sep 5, 2006 at 3:56 pm
  • Hi I am sizing a server for a database which will be used for disaster purposes. It should support 25% of production load. Right now I have a production server with 12 CPU and 48Gb memory, in peak ...
    Sep 22, 2006 at 10:02 am
    Oct 3, 2006 at 1:14 pm
  • Hi Guys, I'm trying to calculate the hash value of statements as oracle does in the v$sqlarea. I tried to use the dbms_utility.get_hash_value yet it seems that oracle doesn't use this for its own ...
    Adi HirschteinAdi Hirschtein
    Sep 21, 2006 at 9:29 am
    Sep 21, 2006 at 3:35 pm
  • Hi List, I am following <http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm to create ...
    Roger XuRoger Xu
    Sep 19, 2006 at 7:09 pm
    Sep 20, 2006 at 3:19 pm
  • Folks, Just trying to get a feel for community comfort w/9207 in prod. We're looking to get off 9204 and now have approval to proceed through the dev/uat/svt and prod envs. I say 9207 as our initial ...
    Sep 14, 2006 at 12:52 am
    Sep 19, 2006 at 2:08 pm
  • Folks On login by a User into our Hybrid Banking Application certain session information e.g. role of user, operational authority of user etc is INSERTED into a few Tables which needs to be preserved ...
    Sep 15, 2006 at 10:10 am
    Sep 15, 2006 at 6:41 pm
  • Hi, I have a 250 GB database and need to replicate it with almost all the tables. I am thinking of doing MV replication. Other options are advanced replication and logical standby. What are pros and ...
    A JoshiA Joshi
    Sep 5, 2006 at 5:38 pm
    Sep 7, 2006 at 10:39 am
  • With a helpful nod towards Wolfgang Breitling's and Jonathan Lewis's works, I am trying to analyze a particular scenario where a "select distinct" is being outfitted with a Full Table Scan (FTS) and ...
    Charles SchultzCharles Schultz
    Sep 5, 2006 at 4:19 pm
    Sep 5, 2006 at 7:16 pm
  • G'day all, I know how to turn on data guard and also switch between primary and secondary. Now, how do you go about turning off data guard altogether? What if I don't want the database to be ...
    Leng KaingLeng Kaing
    Sep 28, 2006 at 4:23 am
    Sep 30, 2006 at 2:21 am
Group Navigation
period‹ prev | Sep 2006 | next ›
Group Overview
grouporacle-l @

250 users for September 2006

Kevin Closson: 58 posts Niall Litchfield: 38 posts Jared Still: 36 posts Bobak, Mark: 31 posts Allen, Brandon: 27 posts Christian Antognini: 26 posts Polarski, Bernard: 26 posts Jesse, Rich: 23 posts Mercadante, Thomas F \(LABOR\): 23 posts Rjamya: 23 posts VIVEK_SHARMA: 22 posts Mladen Gogala: 21 posts Carel-Jan Engel: 18 posts Anjo Kolk: 17 posts Charles Schultz: 17 posts David Sharples: 17 posts Hemant K Chitale: 17 posts Roger Xu: 16 posts Sanjay Mishra: 16 posts Amonte: 15 posts
show more