FAQ

Oracle > oracle-l > June 2004

Search Discussions

359 discussions - 2,462 posts

  • Hi, I want to create automatic killing process for an application. The idea is to get the pid of that process and then kill -9 that pid. How to get the pid of a specific program ( let's say ...
    Rivaldi BaharRivaldi Bahar
    Jun 23, 2004 at 1:08 am
    Jun 29, 2004 at 1:44 pm
  • The CBO has been nothing short of a pain in the butt to me. Going from Development to QA to a live environment achieves unexpected results. It seems that you never know what you are going to get when ...
    Rick StephensonRick Stephenson
    Jun 7, 2004 at 2:32 pm
    Jun 9, 2004 at 11:08 am
  • ('binary' encoding is not supported, stored as-is) Is it possible to restore from a backup set where the set is in a different disk location from where it was originally created. For example: replace ...
    Keith MooreKeith Moore
    Jun 2, 2004 at 10:23 am
    Jun 7, 2004 at 9:50 am
  • Regarding #1: (9.2.0.4 Solaris 9) We have a recommendation from the sw vendor to compute with histograms using exec dbms_stats.gather_schema_stats(ownname = 'SCOTT', estimate_percent = ...
    Barbara BakerBarbara Baker
    Jun 16, 2004 at 5:08 pm
    Jul 6, 2004 at 9:56 am
  • Mark, Thanks for you help. The log file has definitely been switched. I am deliberately using 'ALTER SYSTEM ARCHIVE LOG CURRENT' because the script will wait to it completes before continuing. (what ...
    Hodgkinson, StephenHodgkinson, Stephen
    Jun 24, 2004 at 10:05 pm
    Jun 29, 2004 at 1:03 pm
  • Please excuse me for the basic question, but I can’t find any information source which can give me significant answer to my question (if you know one, please just point me). I have 2 similar (by ...
    J.Velikanovs_at_alise.lvJ.Velikanovs_at_alise.lv
    Jun 21, 2004 at 7:50 am
    Jul 2, 2004 at 5:55 pm
  • Back in olden times when you got the latest Oracle release, you also got printed documentation with it. One little book I have held onto was "Oracle7 Server SQL Language Quick Reference". It has ...
    DENISE_at_wvnvaxa.wvnet.eduDENISE_at_wvnvaxa.wvnet.edu
    Jun 9, 2004 at 2:12 pm
    Jun 24, 2004 at 4:23 pm
  • **********************************************************= ****************** This e-mail and any attachments may contain confidential and privileged inf= ormation. If you are not the intended ...
    Kumar, DharminderKumar, Dharminder
    Jun 21, 2004 at 4:18 pm
    Jun 25, 2004 at 11:57 am
  • List - The author of this article has some provocative ideas about Oracle's grid initiative. http://www.devx.com/opinion/Article/21387 Dennis Williams DBA Lifetouch, Inc. dwilliams_at_lifetouch.com ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Jun 23, 2004 at 1:42 pm
    Jun 25, 2004 at 9:51 am
  • This is from the Bureau of Labor Statistics. Long but interesting... http://www.bls.gov/oco/ocos042.htm -- Dwayne Cox Corporate DBA Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL ...
    Dwayne CoxDwayne Cox
    Jun 9, 2004 at 11:55 am
    Jun 10, 2004 at 9:53 am
  • Original Message -------- Subject: Re: IDE for Oracle database From: Date: Tue, June 22, 2004 9:19 am To: use it on the laptop but can't count on it on the various unix servers;) joe original message ...
    Jtesta_at_dmc-it.comJtesta_at_dmc-it.com
    Jun 22, 2004 at 8:28 am
    Jul 28, 2004 at 12:17 pm
  • Hello, Can someone tell me when uniform extent sizing became a recommended practice? The 'Stop defragmenting and Start Living' paper has a copyright date of 1998, and I remember implementing it on ...
    RobynRobyn
    Jun 10, 2004 at 10:18 am
    Jun 14, 2004 at 7:32 am
  • Hello, A fellow DBA tells me that the total SGA size of all instances on the serve= r (HP, Sun) should not exceed 30% of the server's total memory. I could not find any documentation supporting this ...
    Thomas BijuThomas Biju
    Jun 23, 2004 at 3:56 pm
    Jul 1, 2004 at 6:02 am
  • Hello All, Have any of you taken OCM ? Could you please share your experience ? I would like to know the example scenarios and the pattern of exam, things to remember etc. I appreciate your ...
    Dharmaiahgari, JaganDharmaiahgari, Jagan
    Jun 17, 2004 at 6:23 pm
    Jun 21, 2004 at 8:47 am
  • We are getting ready to start using RMAN on several new 9i Linux databases. I guess the first question would be is RMAN really that much better then using home grown dynamic hot backup scripts? We ...
    Smith, Ron L.Smith, Ron L.
    Jun 9, 2004 at 8:25 am
    Jun 11, 2004 at 7:39 am
  • I am working on a proposal for a DBA hacks book and was wondering if the Gurus on the list might be willing to share... Does anyone have anything they would be willing to share (off line so we don't ...
    April WellsApril Wells
    Jun 17, 2004 at 9:08 am
    Jun 21, 2004 at 6:53 pm
  • Dear List, Those of you with stringent change control standards, or are currently going through Sarbanes Oxley, may be familiar with pre-approved changes. Essentially, all changes will be logged to ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Jun 17, 2004 at 4:24 pm
    Jun 19, 2004 at 10:39 am
  • Hi, It will be great if u can point me to some white papers/articles = explaining how to choose the database block size for different kind of = tablespaces : index,data,temp, undo etc... Env: 10g on ...
    Harvinder SinghHarvinder Singh
    Jun 20, 2004 at 7:06 pm
    Jun 23, 2004 at 2:50 am
  • Something important to note... When I took the 8i beta certfication, I was charged "only" $25.00, but the test was much longer and they solicited feedback on each question. When I didn't receive my ...
    Tim_at_sagelogix.comTim_at_sagelogix.com
    Jun 25, 2004 at 1:23 pm
    Jun 28, 2004 at 6:36 pm
  • Hi, Scenario overview We are testing an application prototype and inserting 1000 rows at a time from 1 table and populating into 2nd table in a loop and inserting 1M rows. 2nd table have primary key ...
    Harvinder SinghHarvinder Singh
    Jun 23, 2004 at 9:22 am
    Jun 23, 2004 at 3:12 pm
  • Hi, We are testing insert performance in one of out tables and we are selecting from 1 table 1000 rows at a time and inserting in 2nd table. So we were getting tps of about 17000 for 1 million ...
    Harvinder SinghHarvinder Singh
    Jun 18, 2004 at 1:39 pm
    Jun 23, 2004 at 4:56 am
  • Dear All, Talking about systemstate,errorstack etc dumps. Are there some documents that will help others understand what they are reading . Yannis Hatzistavrou Please see the official ORACLE-L FAQ ...
    Hatzistavrou JohnHatzistavrou John
    Jun 2, 2004 at 9:05 am
    Jun 4, 2004 at 5:33 pm
  • Some of you may know that I work I work for O'Reilly Media, editing some of their Oracle titles. We've been batting around the idea of publishing an Oracle Utilities Pocket Reference. On the one ...
    Jonathan GennickJonathan Gennick
    Jun 25, 2004 at 10:22 am
    Jun 25, 2004 at 11:17 pm
  • I've been looking around for a good script to monitor next extent = failure conditions (i.e. the next extent an object is going to want is = bigger than the biggest segment of freespace in that ...
    Wales, Stephen (RTSI)Wales, Stephen (RTSI)
    Jun 21, 2004 at 3:02 pm
    Jun 24, 2004 at 9:13 pm
  • Hi everybody, I've just installed Oracle 9.2.0.1.0 onto a Windows 2000 server which was currently running Oracle 8.0.6 with a single instance on it. I noticed that during the installation, I wasn't ...
    Paul VincentPaul Vincent
    Jun 17, 2004 at 9:35 am
    Jun 23, 2004 at 1:49 pm
  • A new client has a serious corruption error. During a hot backup (not RMAN) Thursday morning it was discovered that a datafile was corrupted on the disk. When the database is started up, the ...
    Terry SuttonTerry Sutton
    Jun 12, 2004 at 3:18 pm
    Jun 15, 2004 at 8:13 am
  • Hi, I once saw Jonathan said at metalink that huge SGA does not help in many case, But no further discuss at that topic later. Last night we added 1Gb to oracle sga and we see fewer disk read but ...
    Zhu chaoZhu chao
    Jun 9, 2004 at 8:28 am
    Jun 12, 2004 at 5:46 am
  • Hey all, I lost my C: drive on my desktop this weekend (right during an 8i- 9i migration!), but I installed Oracle 9.2.0.4 (server, I think) on another HD. Obviously, the registry entries are gone ...
    Jesse, RichJesse, Rich
    Jun 8, 2004 at 11:38 am
    Jun 10, 2004 at 3:49 am
  • First off, I'm an Oracle newbie for sure. My main question now is more DR policy/intent Oriented than technical. I'm still in the discovery process of all the ways an Oracle instance can be ...
    Wolfe Stephen S GS-11 6 MDSS/SGSIWolfe Stephen S GS-11 6 MDSS/SGSI
    Jun 29, 2004 at 10:56 am
    Jun 30, 2004 at 7:10 am
  • Sometimes when trying to perform DDL on really hot objects (heavy read/DML), I get: ORA-00054: resource busy and acquire with NOWAIT specified. I guess this is because you need to obtain a library ...
    Jeremiah WiltonJeremiah Wilton
    Jun 25, 2004 at 1:52 pm
    Jun 28, 2004 at 7:46 pm
  • Hi List, just a little question about read only tbs : We have big tables that are loaded once and never updated during the month, so I think it's a good thing to switch their tbs to read only mode ...
    NGUYEN Philippe (Cetelem)NGUYEN Philippe (Cetelem)
    Jun 11, 2004 at 5:07 am
    Jun 19, 2004 at 12:26 pm
  • How can I import a dump file from 9.2.0.5 to a 9.1.0.1 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 ...
    Hamid AlaviHamid Alavi
    Jun 17, 2004 at 2:25 pm
    Jun 18, 2004 at 2:56 am
  • We're working on an ArcSde migration from sqlserver to oracle. i believe the version is 8.2 i was wondering if anyone had any gotchas or any information that we shoudl know. mind you the consultant ...
    Fuad ArshadFuad Arshad
    Jun 4, 2004 at 10:38 am
    Jun 7, 2004 at 9:27 am
  • Odd question time: RTFM'd until we're blue, but we can't get the listener services to register when specified in the init.ora vs a listener.ora file. HR Apps 11.5.7 on Oracle 9.2.0.5, HPUX 11.11 ...
    Scott.Shafer_at_dcpds.cpms.osd.milScott.Shafer_at_dcpds.cpms.osd.mil
    Jun 28, 2004 at 12:24 pm
    Jun 29, 2004 at 5:37 am
  • Hi. I wonder what is the most standar IDE for enviroments running oracle database. I want to buy an IDE from oracle store. I saw in oracle magazine many pl/sql editors ads but I need an interface ...
    Fabio Miranda HamburgerFabio Miranda Hamburger
    Jun 21, 2004 at 12:21 pm
    Jun 22, 2004 at 1:36 pm
  • Dear All, We are getting the following error during database export. ORA-1555 :- snapshot too old. How to assign a big RBS to the export session. Thanks in Advance, Balu, Oracle DBA This mail is ...
    Computer Centre - NIIPLComputer Centre - NIIPL
    Jun 2, 2004 at 3:30 am
    Jun 4, 2004 at 12:01 pm
  • 9.2.0.4 Solaris 5.8 Is it unheard of to have redo logs sized at 500M, 750M or even 1G? Reading the oracle documentation on redo log sizes it mentions that redo logs in the gigabyte size is not ...
    Mark MoynahanMark Moynahan
    Jun 30, 2004 at 2:21 pm
    Jul 1, 2004 at 1:35 pm
  • All - I have not done tuning a great deal so bear with me. I currently have a table that consists of 10 million rows - warehouse. The largest table I have. A few months ago a query took around 30 ...
    Leroy KemnitzLeroy Kemnitz
    Jun 29, 2004 at 1:48 pm
    Jun 30, 2004 at 9:57 am
  • If you don't mind me asking - does Oracle generally charge full price = for a disaster recovery site even if you only use it in a disaster = recovery scenario??? =20 Please see the official ORACLE-L ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Jun 25, 2004 at 10:04 am
    Jun 26, 2004 at 2:27 am
  • I don't know any unix listservs... so I hope this is ok. I am trying to do the following: if [ 1.2 -gt 1.0 ]; then echo yes else echo no fi It alwys comes out no? Anyway to get around this? Also when ...
    Ryan.gaffuri_at_comcast.netRyan.gaffuri_at_comcast.net
    Jun 22, 2004 at 12:03 pm
    Jun 24, 2004 at 3:07 pm
  • My regards to all members, Just would like to know your opinion. Since 9i (suppose 9.2) we have CPU_TIME column in the V$SQL view. I wonder which figure is the best measurement of CPU usage ...
    J.Velikanovs_at_alise.lvJ.Velikanovs_at_alise.lv
    Jun 18, 2004 at 2:51 am
    Jun 21, 2004 at 10:10 am
  • http://www.oracle.com/education/certification/news/index.html?beta_040.h tml -----Original Message----- From: oracle-l-bounce_at_freelists.org On Behalf Of Fuad Arshad Sent: Tuesday, June 01, 2004 ...
    Yen, EricYen, Eric
    Jun 2, 2004 at 12:57 am
    Jun 2, 2004 at 1:10 pm
  • Hi List, I regularly have to change the structure of some fairly large tables (~200m rows). Often we use the opportunity to do a full table rebuild if we want to change other settings (such as index ...
    Mark RichardMark Richard
    Jun 29, 2004 at 1:06 am
    Jul 2, 2004 at 2:47 am
  • Hi, We have a view which is usually accessed like: select * from vu_xan_comp_agrmt_single where doc_id =3D :some_doc_id; In 8i (8.1.7.4 on Solaris 8), the 'doc_id=3D ' predicate is pushed into the ...
    Bobak, MarkBobak, Mark
    Jun 24, 2004 at 3:36 pm
    Jun 24, 2004 at 5:44 pm
  • Hi Design Experts, I am in the process of designing a datamodel for a new application and I need some advice regarding that. I have a table with almost 130 columns in it. This table gets updated with ...
    Pallav KalvaPallav Kalva
    Jun 18, 2004 at 8:47 am
    Jun 19, 2004 at 2:23 pm
  • Got a Questions for all the folks using rman out there. We are using rman with a legato networker solution. Now after tuning rman like stting up maxopenfiles, setting the filesperset doingg work on ...
    Fuad ArshadFuad Arshad
    Jun 10, 2004 at 10:09 am
    Jun 14, 2004 at 10:30 am
  • Hi, I'm trying to figure out a problem with "SQL*Net message from client" smfc wait event albeit, they are considered a idle event. We have a batch script running from a machine different than the ...
    Subbiah, StalinSubbiah, Stalin
    Jun 2, 2004 at 9:12 pm
    Jun 4, 2004 at 12:58 pm
  • Hi all, I certainly appreciated all the traffic on my question about doing reorgs in an SAP database environment=2E I totally understand both sides of the issues and do remember that the client is ...
    Dhotka_at_earthlink.netDhotka_at_earthlink.net
    Jun 21, 2004 at 7:42 am
    Jul 8, 2004 at 11:33 am
  • Dear All, One table is having more than 5000 duplicate record. We would like to remove all the duplicate records. Using rowid method, it takes much time to execute. Is there any other way to remove ...
    Computer Centre - NIIPLComputer Centre - NIIPL
    Jun 2, 2004 at 4:58 am
    Jun 30, 2004 at 9:25 pm
  • All, I have the following query in a stored package: select 1 into loc_variables from dual_at_databaselink; What I am doing is checking the availabilty of the remote database periodically. The bad ...
    Mercadante, Thomas FMercadante, Thomas F
    Jun 24, 2004 at 7:05 am
    Jun 24, 2004 at 5:02 pm
Jun 2004
12345…8
Group Navigation
period‹ prev | Jun 2004 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions359
posts2,462
users319
websiteoracle.com

319 users for June 2004

Jared.Still_at_radisys.com: 79 posts Jonathan Lewis: 71 posts DENNIS WILLIAMS: 70 posts Mark W. Farnham: 59 posts Niall Litchfield: 57 posts Mercadante, Thomas F: 49 posts Goulet, Dick: 48 posts Mladen Gogala: 48 posts Bobak, Mark: 44 posts Jacques Kilchoer: 41 posts J.Velikanovs_at_alise.lv: 40 posts Juan Carlos Reyes Pacheco: 39 posts Jtesta_at_dmc-it.com: 38 posts Daniel Fink: 36 posts Cary Millsap: 32 posts Paul Drake: 31 posts Mladen Gogala: 30 posts Nuno Souto: 30 posts Harvinder Singh: 29 posts Natural Join B.V.: 29 posts
show more
Archives