Search Discussions

266 discussions - 1,453 posts

  • Hi, I just wanted to get people's opinions on the cost justification for RAC. The following are list prices. $40K per processor for Oracle EE license + $20K per processor for RAC. If I want to have a ...
    Khemmanivanh, SomckitKhemmanivanh, Somckit
    Jun 1, 2005 at 2:35 pm
    Jun 23, 2005 at 11:59 am
  • http://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_dlg_id=4070697&src=4050521&Act=5 Oracle – Sun Grid Computing While IBM's fastest computer costs you $5,041,771, for a Grid of 64 Sun Opteron ...
    Marquez, ChrisMarquez, Chris
    Jun 20, 2005 at 5:07 pm
    Jun 23, 2005 at 9:39 pm
  • What would you call that moment in time after you do "rm *.dbf" on all your database files, where you suddenly panic about whther you're on the right server or not? This happens to me all the time, ...
    Jun 15, 2005 at 2:26 pm
    Jun 17, 2005 at 4:36 pm
  • In galaxy Milky Way, a long, long time ago, Metalink forums were actually useful. There was a guarantee that an Oracle person will take a look at your question within 24 hours and respond to it ...
    Mladen GogalaMladen Gogala
    Jun 22, 2005 at 3:31 pm
    Jun 24, 2005 at 4:57 pm
  • hi all, I have created one trigger on LOGON event which is storing the ip of the machine making the connection,current date n time and oracle username in a table with the following structure ...
    Onkar N TiwaryOnkar N Tiwary
    Jun 9, 2005 at 6:51 am
    Jun 10, 2005 at 10:03 am
  • Hello all Someone I know has a graduate interview with Oracle. Has anyone else had the same, and if so, what sort of questions do they ask you? Is it any different than your normal interview? -- ...
    Jun 30, 2005 at 4:04 pm
    Jul 11, 2005 at 7:57 pm
  • I owe this post to Mr. Lex de Haan with whom I was bantering when he recommended the book. The book should be entitled "An Introduction to Relational Theory for an obnoxious know-it-all Oracle DBA" ...
    Mladen GogalaMladen Gogala
    Jun 13, 2005 at 2:03 pm
    Jun 15, 2005 at 7:52 pm
  • Friends -- You know, it's not something that comes up everyday, but, back in v5, you used to be able to do column level grants... that is to say: grant select on tabl(col1, col3, col5) to userX; I ...
    Bellows, BambiBellows, Bambi
    Jun 24, 2005 at 2:30 pm
    Jun 27, 2005 at 8:15 am
  • Hi, could anyone provide guidelines for the log archive destination filesystem's/IO type choice (both MS and *nix solutions would be interesting)? Thanks, Dimitre -- ...
    Radoulov, DimitreRadoulov, Dimitre
    Jun 23, 2005 at 11:19 am
    Jun 24, 2005 at 12:00 pm
  • Hello all I need some advice on Oracle version to implement on a new system. We are going with PeopleSoft CRM software and I need to recommend the database version. This will be heavy duty system ...
    Yechiel AdarYechiel Adar
    Jun 29, 2005 at 4:10 am
    Jul 1, 2005 at 12:04 pm
  • Tim Gorman's "The Search for Intelligent Life in the Cost-Based Optimizer.doc" In 11 pages Tim Gorman gives a 200+ page book worth of information about the history of Oracle SQL processing decisions ...
    Marquez, ChrisMarquez, Chris
    Jun 16, 2005 at 11:11 am
    Jun 17, 2005 at 5:41 pm
  • I convinced that my slow "shutdown" time is directly related to the number of connected or live connections (ACTIVE *or* INACTIVE) to the database at the time of shutdown. I can see the correlation ...
    Marquez, ChrisMarquez, Chris
    Jun 8, 2005 at 10:24 am
    Jun 9, 2005 at 12:38 am
  • I am trying to find out if a missing index on a foreign key would cause a deadlock. I always thought is would only cause a share lock and hold up other DML, not deadlock it. This asktom link ...
    Post, EthanPost, Ethan
    Jun 30, 2005 at 2:37 pm
    Jun 30, 2005 at 6:39 pm
  • Oracle it seemd have released a new note<http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=309475.1 on Database Tuning including CBO. I already solved ...
    Jun 12, 2005 at 3:15 pm
    Jun 13, 2005 at 7:52 am
  • All- Is there such a thing as online tablespace reorg? All, I've been tasked to perform an "online reorg of our tablespaces" From my research I come to these findings. 1 - tablespace reorg is not a ...
    Jun 28, 2005 at 5:59 pm
    Jun 30, 2005 at 6:01 pm
  • I have a table, say T1, having 3 partitions P1, P2 and P3. There exists a PL/SQL procedure that declares variables as : col1 T1.col1%TYPE When I drop a partition P1 of table T1, the PL/SQL procedure ...
    Deepak SharmaDeepak Sharma
    Jun 27, 2005 at 5:06 pm
    Jun 29, 2005 at 1:27 pm
  • Hi all,=20 I need password for account with select dictionary privileges - client is= =20 not too cooperative.=20 Regards, Ranko. -- http://www.freelists.org/webpage/oracle-l
    Ranko MosicRanko Mosic
    Jun 9, 2005 at 10:32 am
    Jun 9, 2005 at 3:52 pm
  • hi all, I have one simple but interesting question: How to reset the modified date of an object in oracle database to its original date irrespective of the date it has been modified? -- Thanks & ...
    Onkar N TiwaryOnkar N Tiwary
    Jun 15, 2005 at 2:20 am
    Jun 19, 2005 at 8:00 am
  • I am just now getting around to implementing system statistics in my database that runs on an IBM P650 under AIX 5L. I have found a handful of explain plan differences with and without system ...
    Jun 17, 2005 at 8:35 am
    Jun 17, 2005 at 1:38 pm
  • For those of you who don't get DM Review magazine, there's an excellent article in the June 2005 issue by Joe Celko (still here Joe?) called "It's the Code, Stupid!". It's sad when our third-party ...
    Jesse, RichJesse, Rich
    Jun 2, 2005 at 11:33 am
    Jun 3, 2005 at 12:37 am
  • Hi, I believe few days back there was a discussion of changing the sysdate value to the desired date with out changing the date value on the server and someone had given the procedure to do it. Can ...
    Subbiah, NagarajanSubbiah, Nagarajan
    Jun 27, 2005 at 3:45 pm
    Jul 2, 2005 at 5:43 pm
  • DISCLAIMER:=20 I would be willing to bet this type of question is poorly regarded in this group, so I apologize in advance for any distress it brings.;-)=20 Also, since this may be frowned upon, ...
    Z bZ b
    Jun 9, 2005 at 2:02 pm
    Jun 14, 2005 at 11:17 pm
  • Hi all, I have got one problem. I am running a script in which my first statement is " SET TRANSACTION USE ROLLBACK SEGMENT RBS01;" but the script is throwing error as " ora-01555: snapshot too old ...
    Onkar N TiwaryOnkar N Tiwary
    Jun 3, 2005 at 8:06 am
    Jun 10, 2005 at 2:45 pm
  • One thing I would like to see is the ability to spool output from SQL*Plus to more than one file at a time. I am writing a script in which I am spooling the results of each command to "foo" and then ...
    Post, EthanPost, Ethan
    Jun 6, 2005 at 12:51 pm
    Jun 9, 2005 at 12:51 pm
  • Hi gurus, Normally oracle says we can not create tables using the keywords but when one issues CREATE TABLE "INSERT" (col datatype);", it gets created. It can always be referenced and other tasks can ...
    Onkar N TiwaryOnkar N Tiwary
    Jun 28, 2005 at 8:55 am
    Jun 29, 2005 at 4:49 am
  • When I create a user is it possible to specify a default tablespace for indexes that is different from the default tablespace for tables?. Or can I only specify a different tablespace for indexes ...
    John DunnJohn Dunn
    Jun 15, 2005 at 3:59 am
    Jun 20, 2005 at 1:49 pm
  • Forwarded message ---------- From: Chris Hoover Date: Jun 13, 2005 4:08 PM Subject: How to shutdown 9i? To: Oracle-L_at_freelists.org We are having a very strange problem. Our AIX server is having ...
    Chris HooverChris Hoover
    Jun 13, 2005 at 7:26 pm
    Jun 14, 2005 at 8:16 am
  • List,=20 I have files an ITAR for this but hoped it is a problem that already has = been discovered and fixed. OS REDHAT AS 2.1 up to date. Oracle patched up to using rman on ...
    Ron RogersRon Rogers
    Jun 9, 2005 at 9:40 am
    Jun 13, 2005 at 2:30 am
  • OK folks - please help me out with this old chestnut: When the listener log, and the database alert log, start to reach unwieldy sizes, it's time to either delete the log, or - better - rename it, so ...
    Paul VincentPaul Vincent
    Jun 10, 2005 at 3:41 am
    Jun 10, 2005 at 10:07 am
  • Hi, I have a export taken with direct=y. This is done setting a high recordlengh = 64K. When importing using this export sould I set recordlength or buffer? How high is Ok for buffer? I am on 817 on ...
    A JoshiA Joshi
    Jun 6, 2005 at 10:13 am
    Jun 9, 2005 at 2:08 am
  • I have a process that sends data through a dblink to an intermediate database and then on to another database. The first database is blocked at 4096, the second is at 8192, the third at 8192 ...
    Smith, Ron L.Smith, Ron L.
    Jun 8, 2005 at 9:22 am
    Jun 9, 2005 at 12:22 am
  • Hi, Would it be possible to execute my procedure in trigger ? I have created a test procedure name : testproc I can execute this testproc in sql/plus by issue this command sql: exec testproc('abc') ...
    Kean JacintaKean Jacinta
    Jun 29, 2005 at 4:58 am
    Jul 1, 2005 at 1:58 pm
  • I am trying to install Oracle 8.1.7 on Linux. I keep getting this message: The Java RunTime Environment was not found at bin/jre. What am I doing wrong? Thanks! Ron Important Notice!! If you are not ...
    Smith, Ron L.Smith, Ron L.
    Jun 28, 2005 at 11:57 am
    Jun 28, 2005 at 7:20 pm
  • Since it is a week end, I thought I would share this non technical stuff with you: In a far away land rich with natural resources, there is a big bank with branches all over the country. They have ...
    Ramesh FLRamesh FL
    Jun 25, 2005 at 6:25 pm
    Jun 28, 2005 at 3:48 pm
  • Has anybody installed on RHEL ES4 (x86_64)? According to Note303859.1 (9iR2 on RHEL4) I need to apply patch 4198954. This is the compat-oracle-rhel4-1.0-3 and compat-libcwait-2.0-1 rpms. As ...
    Joe SmithJoe Smith
    Jun 21, 2005 at 5:23 pm
    Jun 22, 2005 at 4:15 pm
  • What ithis means is someone is executing a process that is executing get_utl_dir package. Raj -- ------------------------------ select standard_disclaimer from company_requirements where category = ...
    Jun 9, 2005 at 10:32 am
    Jun 10, 2005 at 3:40 am
  • Oracle Solaris 9 Blocksize 8192 I'm attempting to move (alter table .. move tablespace) several tables from DMT to autoallocate LMT for a database migrated from to (Agonized ...
    Barbara BakerBarbara Baker
    Jun 6, 2005 at 12:24 pm
    Jun 8, 2005 at 10:55 am
  • � sorry, folks, but I though as many production DBAs as are on this list, I might be able to get an answer to this question. What I need to know is how Oracle licensing works on a hot-standby (e.g., ...
    Kevin ClossonKevin Closson
    Jun 21, 2005 at 1:49 pm
    Jun 21, 2005 at 8:41 pm
  • Hello all, The recent news about lost backup tapes has got me wondering about backup safety and encrypted backups in particular. Does anybody on the list have an interesting method for protecting the ...
    Jun 20, 2005 at 4:02 pm
    Jun 21, 2005 at 4:13 pm
  • I am doing research on taking backups with RMAN vs. Sync/split then backup to tape. We currently use sync/split, copy to tape for all of our production database backups and direct to tape backups for ...
    Ignizio, RichardIgnizio, Richard
    Jun 17, 2005 at 3:10 pm
    Jun 21, 2005 at 3:25 pm
  • Hi,=20 I have a package and it is invalid. In the package code, package = references itself . When I tried to compile, I receive following error. Do you have any idea. Rgds. Arslan. SQL alter package ...
    Jun 13, 2005 at 8:57 am
    Jun 18, 2005 at 6:37 pm
  • Hello. asktom is busy I guess, Let me try my luck here. Can you please explain=20 Why CBO considers semi-join on a collection in "IN-LIST". Such course of= =20 actions propagates incorrect ...
    Vlad SadilovskiyVlad Sadilovskiy
    Jun 9, 2005 at 5:20 pm
    Jun 12, 2005 at 6:14 pm
  • hi, Trying to query a select statement to check if return record existed or not existed. select employeeid from employee_tbl where employeeid=5; If i type this in SQL*PLus, or sql worksheet, i can ...
    Kean JacintaKean Jacinta
    Jun 8, 2005 at 11:51 pm
    Jun 9, 2005 at 3:52 pm
  • greetings, a client is planning on implementing 10g RAC and is looking into hardware and filesystems to use for the implementation. they have settled on linux on ibm servers and are still deciding ...
    Haroon A. QureshiHaroon A. Qureshi
    Jun 5, 2005 at 4:03 am
    Jun 8, 2005 at 11:27 pm
  • All - I am having problems with our Java app and hope someone here can help. We are using Oracle dedicated connections. We tried the Connection pooling with Oracle Impl but had no luck. The problems ...
    LeRoy KemnitzLeRoy Kemnitz
    Jun 1, 2005 at 11:57 am
    Jun 1, 2005 at 2:15 pm
  • We want to move application data from one database to another. However, in the new database we want to change the tablespace names so that they follow a new naming convention. What is the ...
    J. DexJ. Dex
    Jun 30, 2005 at 10:22 am
    Jun 30, 2005 at 12:41 pm
  • hi gurus, Can we stop accessibility of OEM through a particular machine? If yes then how? -- Thanks & Regards, T. Onkar Nath Ph : +91-9826728111(Cell) to_onkar_at_yahoo.com ...
    Onkar N TiwaryOnkar N Tiwary
    Jun 27, 2005 at 3:10 am
    Jun 28, 2005 at 4:00 pm
  • Hello List, Where can I get the data dictionary poster for oracle 9i. TIA -- http://www.freelists.org/webpage/oracle-l
    Gupta, KrishanGupta, Krishan
    Jun 17, 2005 at 9:09 am
    Jun 28, 2005 at 8:51 am
  • Wanting to do our backups to disk as tape media and hware so unreliable and system admin group wants us to have them run our backups and restores which would just slow down the whole process Any way ...
    Jun 17, 2005 at 2:34 pm
    Jun 17, 2005 at 3:23 pm
  • Hi, i have declare a cursor in my trigger called cur1. I am trying to refer :OLD. :NEW. from the cursor. I got an error PLS-00049 bad-bind variable. I am not sure if oracle support this. If this way ...
    Kean JacintaKean Jacinta
    Jun 16, 2005 at 8:53 am
    Jun 17, 2005 at 9:58 am
Group Navigation
period‹ prev | Jun 2005 | next ›
Group Overview
grouporacle-l @

242 users for June 2005

Jared Still: 60 posts Mladen Gogala: 40 posts Mercadante, Thomas F (LABOR): 36 posts Mladen Gogala: 36 posts Radoulov, Dimitre: 34 posts Marquez, Chris: 31 posts Kevin Closson: 30 posts Rjamya: 28 posts David Sharples: 25 posts Paul Drake: 25 posts Goulet, Dick: 24 posts John Smiley: 24 posts Niall Litchfield: 23 posts Carel-Jan Engel: 22 posts Jesse, Rich: 22 posts Onkar N Tiwary: 21 posts Khemmanivanh, Somckit: 19 posts Powell, Mark D: 18 posts Connor McDonald: 17 posts Oracle-l-bounce_at_freelists.org: 17 posts
show more