FAQ

Search Discussions

280 discussions - 1,197 posts

  • We have an index that we need to keep rebuilding in order for the CBO to use it. What happens is that we build the index and queries use the index. Then, after a couple of days the CBO reverts to ...
    Steve JelfsSteve Jelfs
    Nov 12, 2004 at 4:41 am
    Nov 16, 2004 at 8:39 am
  • Situation: Early stages of development project; same small database runs on development PCs, early build is given to customer for "look and feel" and training purposes. Sad facts: "PC Vulgaris" (P4 @ ...
    Branimir PetrovicBranimir Petrovic
    Nov 20, 2004 at 5:30 pm
    Dec 30, 2004 at 10:22 pm
  • Folks Limitations of MSSQL Server Vs. Oracle OR simply otherwise General limitations of MSSQL Server. Need to give a presentation to Management on the same=20 Any Good Links, docs etc? Thanks in ...
    VIVEK_SHARMAVIVEK_SHARMA
    Nov 23, 2004 at 5:04 am
    Nov 28, 2004 at 10:07 am
  • We have a position open suddenly and I'll be participating in = interviewing my contract co-dba next week for a Oracle 9i data warehouse = position. One of the resumes I read mentioned the applicant ...
    Freeman, DonaldFreeman, Donald
    Nov 24, 2004 at 1:24 pm
    Nov 25, 2004 at 1:22 pm
  • Fyi, although OTN's link to patches (http://www.oracle.com/technology/support/patches.htm ) says the latest version for win32 is 9.2.0.5, Metalink has a 9.2.0.6. patch for win32, release Oct 31st ...
    Boivin, Patrice JBoivin, Patrice J
    Nov 8, 2004 at 6:08 am
    Nov 9, 2004 at 11:02 am
  • Ok, I'm probably missing something obvious. Environment: Server 1: RedHat 9.0 2.4.20-8 kernel Oracle 10.1.0.2 Server 2: White Box 3.0 Respin 1 2.4.21-15.EL kernel Oracle 10.1.0.2 I can succussfully ...
    Jared StillJared Still
    Nov 28, 2004 at 1:09 am
    Nov 29, 2004 at 10:53 am
  • Is there any need to multiplex redo logs with mirrored disks (e.g., RAID-1 or RAID-1+0)? Example- Oracle recommends multiplexing redo logs on separate disks, like redo01a.log on Disk1 and redo01b.log ...
    David WagonerDavid Wagoner
    Nov 23, 2004 at 10:39 am
    Nov 24, 2004 at 3:10 pm
  • Hi everyone, I'm pretty sure, many had run into this problem before and can provide some help. When I try to drop one of my user, I get the following: SQL drop user theuser cascade; ORA-00604: error ...
    Chadi KassanChadi Kassan
    Nov 16, 2004 at 9:12 am
    Nov 16, 2004 at 4:24 pm
  • Hi all, Please forgive my ignorance if the details provided by me are not sufficient, or I'm not doing proper analysis. 11.5.8 on 9.2.0.5 O/s HP-UX Risc 64 B.11.11 We are facing a unique problem ...
    New DBANew DBA
    Nov 23, 2004 at 4:54 am
    Nov 24, 2004 at 3:20 pm
  • Hi List, If I run "ps" on Solaris or on SuSE Linux 7.2 I see the Oracle background processes under the command heading containing the SID, eg. "ora_smon_MYSID" or "oracleMYSID (LOCAL=NO)". If I do ...
    Charlotte HammondCharlotte Hammond
    Nov 19, 2004 at 5:27 am
    Nov 22, 2004 at 1:33 pm
  • Hi all, I have a developer who is trying to use PL/SQL to update all of the CLOBS of a specific table (nightly basis). I am looking for advice on how to speed up the performance for this process. SQL ...
    Mike SchmittMike Schmitt
    Nov 3, 2004 at 1:24 pm
    Nov 8, 2004 at 10:55 am
  • Cpu average load. =20 Guys, I have started using big brother for monitoring our Unix/Oracle systems. I am getting alerts on the cpu utilization: dohsdb10.doh.ad.state.fl.us.cpu yellow Mon Nov 29 ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Nov 29, 2004 at 9:05 pm
    Dec 5, 2004 at 5:48 am
  • Just out of curiousity, no fires - does anyone know under what circumstanses it returns more than row for a single instance (no RAC) database? Thanks, Boris Dali. Post your free ad now! ...
    Boris DaliBoris Dali
    Nov 4, 2004 at 4:39 pm
    Nov 8, 2004 at 10:36 am
  • ummm does anyone use syntax highlighting for vi or vim? Id like to at least get .oracle- .sql and possible shell scripts. The black and white gets my eyes crossed in a few hours;-) The syntax ...
    Bob MetelskyBob Metelsky
    Nov 11, 2004 at 10:06 pm
    Nov 24, 2004 at 11:14 am
  • Folks, Please forgive me for this short, one time, interruption to celebrate my 8th book... Portable DBA: Oracle. The book is designed as a portable reference for the DBA. As such it has: A chapter ...
    Freeman Robert - ILFreeman Robert - IL
    Nov 23, 2004 at 3:00 pm
    Dec 9, 2004 at 11:28 am
  • I could have swarn I read that if you use bind variables oracle ignores histograms. We are noticing different query plans based on the number of buckets our histograms have while our queries are ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Nov 17, 2004 at 10:19 am
    Nov 18, 2004 at 7:06 am
  • Here is the situation, I have written a PL/SQL package that grabs source code for other packages from DBA_SOURCE, goes through each line, inserts instrumentation among other things, and then inserts ...
    Post, EthanPost, Ethan
    Nov 18, 2004 at 3:12 pm
    Nov 23, 2004 at 3:11 pm
  • Hi all, Please see the plan below. The estimated cardinality of the join between the two tables is 3274K. This doesn't seem to tally with the figure I have derived from the statistics in the ...
    Charu JoshiCharu Joshi
    Nov 1, 2004 at 9:18 am
    Nov 13, 2004 at 2:29 pm
  • Group, HOST MACHINE: HP-UX B.11.11 U 9000/800 ORACLE : Oracle9i Enterprise Edition Rel. 9.2.0.5.0 - 64 bit LISTENER: Version 10.1.0.2.0 TNSNAMES.ORA: ls -lai $ORACLE_HOME/network/admin/tnsnames.ora ...
    Rusnak, George A. (SEC-Lee) CTRRusnak, George A. (SEC-Lee) CTR
    Nov 4, 2004 at 9:56 am
    Nov 9, 2004 at 6:12 am
  • I have a group of users that should only see a subset of data in certain tables. They share a role. I will create a view that implements that, and add it to their role. Then, to allow them to use the ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Nov 1, 2004 at 2:12 pm
    Nov 3, 2004 at 2:58 am
  • List - Recently in response to an RMAN question, several listers mentioned how critical it is to perform a test recovery after configuring RMAN. I agree whole-heartedly. I was wondering if some ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Nov 22, 2004 at 9:20 am
    Nov 24, 2004 at 12:36 pm
  • We're getting a very strange problem with very few symptoms to work = from. It's our policy to take cold backups of our Oracle 9.2 database, which = runs on a Win2000 server. Consequently, the ...
    Paul VincentPaul Vincent
    Nov 2, 2004 at 4:54 am
    Nov 9, 2004 at 7:09 am
  • Might anyone care to wager why a developer at Oracle would use 3 iterations of flushing the shared_pool during execution of the jserver.sql script in creation of the JServer subsequent to database ...
    Paul DrakePaul Drake
    Nov 29, 2004 at 1:42 pm
    Nov 30, 2004 at 2:27 pm
  • Hi Rac gurus, is anybody working on Rac 9.2.0.5 on redhat linux advanced server 2.1 with firewire drive I have a rac lab here with 3 instances running on 2 nodes But the ocfs file system keep ...
    Arun chakrapani raoArun chakrapani rao
    Nov 28, 2004 at 9:19 pm
    Nov 29, 2004 at 10:25 pm
  • I recieved this error when I bumped up the processes to 500 from 250. There is one other database on the server with processes set a 200. The /etc/system parameters are: set ...
    Ignizio, RichardIgnizio, Richard
    Nov 23, 2004 at 10:55 am
    Nov 24, 2004 at 6:21 pm
  • yes I have a tar logged with Oracle and they aren't much help two database set up is EXACTLY the same (init.ora, files size etc) Query using two views in OLD 32 bit runs in 2 seonds and with the ...
    Duret, KathyDuret, Kathy
    Nov 19, 2004 at 12:11 pm
    Nov 24, 2004 at 5:12 pm
  • I am trying to move a 9.2.0.4 150 Gig database from NT to Linux AT UKOUG members of the Oak Table suggested upgrading to 10g then using RMAN. I dont have the disk space for a copy of the DB on NT so ...
    Howard LathamHoward Latham
    Nov 22, 2004 at 5:01 am
    Nov 23, 2004 at 4:14 am
  • We have a situation where we are generating a ref cursor based on a set of strings passed into a package. The problem is that one of those strings is a list of id's that could potentially be larger ...
    Stephens, ChrisStephens, Chris
    Nov 21, 2004 at 2:02 pm
    Nov 22, 2004 at 8:46 am
  • Hi All, Previous DBA did not set up any archived logs maintanance here si I am in the process of developing a process that will store old archived logs on DVD. We're on 9.2.0.5 on Win2K. Here is what ...
    AlexAlex
    Nov 19, 2004 at 1:58 pm
    Nov 19, 2004 at 3:14 pm
  • All,=20 I've got a large (4G.) datafile let's call him BIG.dbf on one of my = database servers that I'm not sure what's living in it. =20 I did run the following sql statement: SQL select ...
    Jaehne, Richard SJaehne, Richard S
    Nov 16, 2004 at 3:17 pm
    Nov 18, 2004 at 7:30 am
  • Greetings, This is with reference to the metalink note: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=223117.1 MISINTERPRETING THE IMPACT OF WAIT ...
    BNBN
    Nov 9, 2004 at 9:25 am
    Nov 10, 2004 at 9:55 am
  • Hi We have an IBM server (Intel based) with 2 CPUs and 8 GB of RAM for our 10g (9.0.4.1) Oracle Application Server. We have a choice of installing it either on Windows 2000 or Linux Red Hat. There ...
    Kresimir FabijanicKresimir Fabijanic
    Nov 3, 2004 at 2:26 pm
    Nov 5, 2004 at 12:24 pm
  • Hello All, We have an application which uses Oracle Forms 6i. One particular query takes very long time when it runs in the forms application. When I trace the user session to see what was going on, ...
    Prasada.Gunda_at_hartfordlife.comPrasada.Gunda_at_hartfordlife.com
    Nov 1, 2004 at 12:56 pm
    Nov 3, 2004 at 10:00 am
  • ��=20 Possible Oracle scam outed [eWEEK] A seller of Oracle training materials says his firm is legit, but some customers are complaining they are not receiving the goods=20 ...
    Goulet, DickGoulet, Dick
    Nov 22, 2004 at 12:40 pm
    Nov 23, 2004 at 6:43 pm
  • We plan to setup RMAN on out SUN Solaris server with ORACLE 9ir2 databases. We are NOT purchase ORACLE modules for Veritas NETBACKUP yet. The implementation only RMAN backup to hard disks. We ask ...
    Dba1 mccDba1 mcc
    Nov 17, 2004 at 10:55 am
    Nov 17, 2004 at 5:16 pm
  • We have some odd behavior here, and I'm trying to figure out the cause. I know I'm probably missing something semi-obvious, so I'm looking for further ideas. In a web application, data representing ...
    Terry SuttonTerry Sutton
    Nov 12, 2004 at 10:11 am
    Nov 12, 2004 at 12:41 pm
  • We are looking for a gui-based tool to let our users/developers run query and possibly dml on databases, but not allow ddl changes or other intrusive commands. I already know about Oracle ...
    Kurth, Michael J.Kurth, Michael J.
    Nov 4, 2004 at 12:29 pm
    Jan 20, 2005 at 7:34 am
  • Hi all! I's Oracle 9.2.0.4 on AIX 5.2 The problem is with gathering statistics. As workaround Oracle suggested to set NLS_SORT=3Dbinary in the session = before collecting statistics. I wanted to put ...
    Sonja �ehovi�Sonja �ehovi�
    Nov 26, 2004 at 5:47 am
    Dec 15, 2004 at 11:15 am
  • Hello all, Just wanted to let everyone know I installed this patch release and it went great. I'm on Win2K. Just make sure you stop all Distributed Server services along with Distributed Coordinator ...
    AlexAlex
    Nov 18, 2004 at 3:36 pm
    Dec 8, 2004 at 8:11 am
  • Listers, I have a question where I need a little clarification about fetching across commits. Can this happen if the table being committed to is not the same as the tables(s) in the cursors? For ...
    Z bZ b
    Nov 24, 2004 at 11:53 am
    Nov 30, 2004 at 11:43 am
  • Hi List, I have two Oracle databases and two SQL, all of them running in 4 = different windows boxes. Yesterday the network admin notified me that = they are going to move the domain to other one ...
    Aragon, Gabriel (GE Commercial Finance)Aragon, Gabriel (GE Commercial Finance)
    Nov 11, 2004 at 10:20 am
    Nov 26, 2004 at 4:41 am
  • I'm running a batch updates on my database and I've been getting the following messages in my alert file: "cannot allocate new log check point incomplete." My job hangs waiting on log file switch ...
    Susan lamSusan lam
    Nov 18, 2004 at 3:57 pm
    Nov 20, 2004 at 11:26 am
  • Using Activestate Perl 5.8 with DBI version 1.45 When I try a DBI connect to Oracle it fails with=20 "install_driver(Oracle) failed; Can't locate DBD/Oracle.pm in @INC A colleague suggests Oracle ...
    Hallas, John, Tech DevHallas, John, Tech Dev
    Nov 16, 2004 at 11:37 am
    Nov 17, 2004 at 2:33 am
  • We are running a third party application for which the users are granted a role. The role allows the users to update the table applications tables. The problem is that I do not want a user being able ...
    Jeffrey BeckstromJeffrey Beckstrom
    Nov 1, 2004 at 12:43 pm
    Nov 2, 2004 at 5:43 pm
  • I am having problems with a hierarchial query and I am hoping someone can point me in the right direction. I am running Oracle 9i and I am trying to create a hierarchial query with a join to get a ...
    Mike SpraggMike Spragg
    Nov 17, 2004 at 10:05 am
    Nov 17, 2004 at 3:10 pm
  • Hello Folks, Has anyone any idea what this issue could be. We have two servers a 9.2.0.3 and 8.1.7.4.1 both on Windows 2000 Servers Both these servers' listeners have started an odd behavior, for no ...
    Denham EvaDenham Eva
    Nov 12, 2004 at 6:13 am
    Nov 13, 2004 at 1:49 am
  • I believe I read somewhere that you should only take 1 full backup ever. I can't remember where. I just took an RMAN class from Oracle. The instructor said that she does not agree with this. If you ...
    RyanRyan
    Nov 10, 2004 at 2:04 pm
    Nov 11, 2004 at 7:50 am
  • Hi, Does any one have any good scripts to capture top 5 sql statement which is hurting to database? The selection of those top 5 sql would be either more IO/more CPU usgae/spining sql etc. thanks ...
    Seema SinghSeema Singh
    Nov 9, 2004 at 2:42 pm
    Nov 10, 2004 at 1:39 pm
  • List, I have read that freelist must be a n even number like 1,2,3,5,7 etc my question is what happen if you define freelist = 4, some thing wrong or what? any idea? Thanks, -- ...
    Hamid alaviHamid alavi
    Nov 3, 2004 at 11:19 am
    Nov 7, 2004 at 7:21 pm
  • Hi Last week, while creating a new datafile for an expanding tablespace I received the ORA-00059 (max number of db_file exceeded). The DB is used in a 24/24 env. So I can't easily plan a bounce to ...
    Daniel GarantDaniel Garant
    Nov 2, 2004 at 3:52 pm
    Nov 2, 2004 at 5:46 pm
Group Navigation
period‹ prev | Nov 2004 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions280
posts1,197
users271
websiteoracle.com

271 users for November 2004

Jared Still: 53 posts Goulet, Dick: 31 posts Gogala, Mladen: 25 posts Mhthomas: 25 posts Niall Litchfield: 25 posts Jesse, Rich: 22 posts Alex: 21 posts Mladen Gogala: 21 posts Post, Ethan: 20 posts Ryan_gaffuri_at_comcast.net: 20 posts Chadi Kassan: 18 posts Mercadante, Thomas F: 17 posts Paul Drake: 17 posts Stephane Faroult: 17 posts Mark W. Farnham: 16 posts Stephens, Chris: 16 posts Carel-Jan Engel: 15 posts Freeman, Donald: 15 posts Hallas, John, Tech Dev: 15 posts David Sharples: 14 posts
show more
Archives