Search Discussions

339 discussions - 1,893 posts

  • 74


    I know it's controversial, and I'm sorry to take up bandwidth, but I just passed my last 9i exam and received my OCP. For some it may be easy but for me it wasn't. Anyway, feeling good and wanted to ...
    Michael MilliganMichael Milligan
    Apr 21, 2004 at 3:04 pm
    Jun 7, 2004 at 9:17 am
  • Hi Does any one kwnows please, Why "Separating Data and Indexes improves performance" is a myth? If they are both accesed at the same time, it will improve performance or not, I don't understand ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Apr 23, 2004 at 11:14 am
    Apr 28, 2004 at 12:15 pm
  • I have an Oracle 8i database that I'm trying to create a standby copy of for testing / possible future DR use. The database is in ARCHIVELOG mode. On the master database, I have placed each ...
    Matthew J. BrownMatthew J. Brown
    Apr 14, 2004 at 1:50 pm
    Aug 4, 2004 at 8:19 pm
  • Hi, I have one instance on SUN box. # of users connecting to box =max 25 Oracle version = Sytem rebooted yesterday. When I am trying to connect sqlplus internal,its taking longer ...
    Seema SinghSeema Singh
    Apr 28, 2004 at 10:35 am
    May 4, 2004 at 6:49 pm
  • the plan_table was just an example. it came up as part of another tar. I've had a few of these type things. also, what does oracle support have to work with? Most of the time they seem to use the OTN ...
    Apr 6, 2004 at 9:19 am
    Apr 8, 2004 at 1:44 am
  • Somehow, a user has created a file called '-v' in a production directory. How in ******* do I remove it? I've tried all the 'rm' variants I know, to no avail. Wah! Thanks, Mike --- ...
    Vergara, Michael (TEM)Vergara, Michael (TEM)
    Apr 16, 2004 at 11:18 am
    Apr 19, 2004 at 1:46 pm
  • Has already paid for itself! Once again, Robert Freeman has done an excellent job on a New Features book. I really like the "Jonathan Says" tidbits by Jonathan Lewis. I've read the official 10g new ...
    Daniel FinkDaniel Fink
    Apr 26, 2004 at 11:40 am
    Apr 28, 2004 at 10:37 am
  • Hi All, We are planning to buy oracle edition to run on a Solaris box ( dual CPU). ( Its going to be OLTP and the no. of concurrent users will be 10.) Solaris box configuration: Sun Fire V240 2x1 GHz ...
    Kommareddy, Srinivas (MED, Wissen Infotech)Kommareddy, Srinivas (MED, Wissen Infotech)
    Apr 1, 2004 at 8:52 am
    Apr 13, 2004 at 4:08 am
  • Several months ago, I saw ORACLE paper said SQLPLUS will NOT support on 10g. Last week, I installed ORACLE 10g client and found SQLPLUS still there. Does ORACLE change mind?
    Dba1 mccDba1 mcc
    Apr 13, 2004 at 8:38 am
    Apr 15, 2004 at 12:19 pm
  • Hi all, Can anyone please point me to any resources about "best practices" for DBMS_STATS in a production environment. I've RTFM'd and know about all the possible options (BLOCK_SAMPLE, METHOD_OPT) ...
    Charlotte HammondCharlotte Hammond
    Apr 28, 2004 at 4:37 am
    Jun 16, 2004 at 4:04 pm
  • Hi All, I am trying to trace another users session (10046 trace) by using DBMS_SYSTEM as mentioned in Cary's book my problem is though everything runs out fine the resulting trace file only shows the ...
    Arghadeep ChatterjeeArghadeep Chatterjee
    Apr 26, 2004 at 5:24 am
    May 4, 2004 at 10:36 am
  • List, Is anyone familiar with how Informatica's bulk mode works? We have a situation where I created a 4GB tablespace for a new and simple truncate/load operation from Informatica, around 7 million ...
    Thomas JeffThomas Jeff
    Apr 22, 2004 at 10:22 am
    Apr 29, 2004 at 7:58 am
  • ( the reason to change the name is because mladlen asked not to do weekly tips, so from now I do no weekly tips) Hi, to create triggers for ddl auditing, to know who was the responsible to create the ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Apr 30, 2004 at 3:00 pm
    May 3, 2004 at 2:24 pm
  • Hi All, OS: Solaris. Earlier we used to perform database migration/upgradation as below: (32 bit 8i to 64 bit 9i) Install 8174 (64 bit) software Convert the db from 32 bit to 64 (8174) migrate the db ...
    Kommareddy, Srinivas (MED, Wissen Infotech)Kommareddy, Srinivas (MED, Wissen Infotech)
    Apr 1, 2004 at 3:42 pm
    Apr 6, 2004 at 10:12 am
  • 19


    DB - 8174 Does the CBO choose always the path based solely on lowest cost of all plans? We have noticed that best plan is not always of lowest cost, which is why I ask. If that is the case, is that ...
    Apr 5, 2004 at 9:27 am
    Apr 6, 2004 at 5:13 am
  • I need to move only the data from the production db to dev on a nightly basis. The best I can come up with is a perl script that does this Export Drop tables Import tables= If I drop the user the ...
    Steiner, RandySteiner, Randy
    Apr 3, 2004 at 7:28 am
    Apr 8, 2004 at 5:53 am
  • Hey all, I'm trying to help our folks get an procedure down from 18 hours without a complete redesign (which it desperately needs), so I run a 10046 trace on it from the test system. It ...
    Jesse, RichJesse, Rich
    Apr 29, 2004 at 11:23 am
    Apr 30, 2004 at 10:04 am
  • Any reason not to do CPU COSTING as described by Jonathan Lewis? "You can enable cpu_costing simply by collecting system_statistics for an appropriate period of time with the dbms_stats package. This ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Apr 21, 2004 at 10:45 pm
    Apr 23, 2004 at 11:11 am
  • Hi, please there is another reason than simple know perl, to use perl instead of Java. I always heard Java had more advantages than perl, including the fact that Oracle include it in the database ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Apr 2, 2004 at 9:04 am
    Apr 2, 2004 at 3:10 pm
  • All Goodbye cruel IT world! It sure has been interesting (now, what's that old Chinese(?) curse, "May you live in interesting times" or something like that) April 16 is my last day in the IT world. I ...
    Kevin ToepkeKevin Toepke
    Apr 1, 2004 at 10:54 am
    Apr 2, 2004 at 8:31 am
  • Hello All, NOTE : This is Recover a databse on ANOTHER node using RMAN WITHOUT Recovery Catalog. I am trying to recover and create a database from Host A to Host B Here are the steps.. I found in ...
    H elp_meH elp_me
    Apr 14, 2004 at 7:36 pm
    Apr 17, 2004 at 4:59 pm
  • Hey All, We are a mid-size software house with an OPN agreement. I currently have 60 databases running on 5 platforms using 25 plus servers. We are running out of space in the data center and the ...
    Todd CarlsonTodd Carlson
    Apr 9, 2004 at 12:37 pm
    Apr 9, 2004 at 4:17 pm
  • Hi, I have a RAC system of 3 nodes with 7 webservers (clients). I would like to configure SDU/TDU parameters at client level to improve the performance. Reference: Note:69591.1 "SQL*Net Performance ...
    Muqthar AhmedMuqthar Ahmed
    Apr 29, 2004 at 10:10 am
    May 6, 2004 at 9:53 am
  • Got this simple proc SQL create or replace procedure dave_test (p_user_id IN varchar2) as begin dbms_resource_manager_privs.grant_switch_consumer_group(p_user_id,'users 1',TRUE) ...
    David SharplesDavid Sharples
    Apr 21, 2004 at 11:00 am
    Apr 22, 2004 at 12:10 pm
  • Hi, can someone assist me with formulating a query to retrieve all distinct records. I need to retrieve all three columns a,b &c based on the distinct of the two columns a & b. SQL select * from ...
    Alison BarakAlison Barak
    Apr 15, 2004 at 8:36 am
    Apr 15, 2004 at 5:43 pm
  • I typically get a copy and paste when I open a non-trivial TAR. I then have to push them to get real support. The latest thing they told me is that the PLAN_TABLE needs to be in each user that wants ...
    Apr 6, 2004 at 8:51 am
    Apr 6, 2004 at 5:29 pm
  • Hi I have a serious problem I can't do two append insret to a table in a same transaction, and I can join in only one. because some times the same process( a function) must be runs more than once and ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Apr 1, 2004 at 3:29 pm
    Apr 2, 2004 at 1:18 pm
  • Hi: I have the following pl/sql function code that gets called a lot in our application. I have looked all the querys and they are running fine (have proper indexes, etc). I am now trying to see if I ...
    Guang MeiGuang Mei
    Apr 29, 2004 at 2:58 pm
    Apr 30, 2004 at 12:12 pm
  • Hello List, Just bare me, test.. ignore Best Regards, Syed Jaffar Hussain Please see the official ORACLE-L FAQ: http://www.orafaq.com To unsubscribe send email to: oracle-l-request_at_freelists.org ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Apr 10, 2004 at 2:13 am
    Apr 30, 2004 at 6:50 am
  • Hi, I am installing 9iR2 over exceed on windows and the really annoying thing is that the next exit and previous buttons are hidden, I am having a great time trying to tab to the next button but t is ...
    David SharplesDavid Sharples
    Apr 6, 2004 at 10:07 am
    Apr 12, 2004 at 12:57 am
  • I read document it mention logical standby DB use "sql statements apply" and physical standby use "redo log apply". I got confuse. "redo log aplly" should same like "sql statements apply", due to ...
    Dba1 mccDba1 mcc
    Apr 8, 2004 at 7:28 am
    Apr 9, 2004 at 10:41 am
  • For those interested: Bookpool got it in stock now. Oracle Database 10g New Features 1 Copy, ISBN 0072229470, $18.95 Subtotal $ 18.95 US Postal Media Mail $ 2.39 Total $ 21.34 ...
    Apr 1, 2004 at 8:26 pm
    Jul 22, 2005 at 8:15 pm
  • Hi, list friends: We did a server upgrade this month. And we hit something we cannot understand. So we refer to you guys for help, hoping you have similar experienceJ We did a server upgrade this ...
    Zhu chaoZhu chao
    Apr 30, 2004 at 4:38 am
    Apr 30, 2004 at 11:46 pm
  • We are looking to implement IOTs for a couple of intersection entities in a 10g db. I would like to hear from those brave enough to actually use IOTs what is the good, the bad and the ugly. example ...
    Daniel FinkDaniel Fink
    Apr 28, 2004 at 9:12 am
    Apr 28, 2004 at 4:08 pm
  • wELCOME TO THE DARK SIDE! Man you guys, lighten up, go out have a few brews, get laid, something! Yes, while I agree homework is needed but let's face it there are so much misinformation that it is ...
    Duret, KathyDuret, Kathy
    Apr 27, 2004 at 8:36 am
    Apr 28, 2004 at 12:48 am
  • Hi Friends, Before I used to have default settings of below params, But I changed to = 40(oica) and 90. But my 1/2hour batch job taking 2 1/2hrs extra time = because of these params!! Is there any ...
    Raghu Kota (WBTQ)Raghu Kota (WBTQ)
    Apr 19, 2004 at 11:18 am
    Apr 20, 2004 at 8:39 am
  • We have alot of many to many relationships. IOTs sound like a good option. However, our many to many relationships are in a high transaction database. I remember reading that Oracle has to 'guess' ...
    Apr 28, 2004 at 12:13 pm
    Apr 28, 2004 at 8:18 pm
  • I am trying to analyze a Oracle Perf problem for a client all my low level 10046 trace shows predominantly SQL*Message to client and from client waits,I am of the opinion that Network is to be blamed ...
    Arghadeep ChatterjeeArghadeep Chatterjee
    Apr 26, 2004 at 9:07 am
    Apr 26, 2004 at 10:25 am
  • I have a child table with a formal foreign key relationship to its parent. I have noticed that in alot of cases inserting into them is much slower than inserting into the parent. I didn't design the ...
    Apr 21, 2004 at 11:46 am
    Apr 22, 2004 at 2:29 am
  • I know how it works. I know that it works. I can't find 'why'? I'm taking a university database class and my professor says the optimal way to recover is with undo before redo and so does my book ...
    Apr 19, 2004 at 4:27 pm
    Apr 20, 2004 at 11:47 am
  • Earlier this week I attempted to install 9i on a production HP server = (after doing this a number of times elsewhere). The installer initially = wasn't able to launch due to lack of tmp space. So I ...
    Chris StephensChris Stephens
    Apr 16, 2004 at 10:49 am
    Apr 20, 2004 at 5:32 am
  • All: We're having a situation with Oracle and PHP that I am hoping someone may have encountered and can provide some guidance on. We have an Oracle 8.1.6 database instance running on a RedHat 7.2 ...
    Byron PearceByron Pearce
    Apr 15, 2004 at 11:33 am
    Apr 16, 2004 at 1:39 pm
  • First off, this is not about archive logs. It is about archiving data. ie. moving data from your database to an offline system or moving it to nearline storage (HSM, etc) I was reading an article in ...
    Apr 12, 2004 at 4:36 pm
    Apr 13, 2004 at 5:32 pm
  • We have a legacy instance that is in RBO mode. My group does not own it, so we cannot change it to CBO. When I hint anything from an index to ordered, etc... it switches to the CBO and since ...
    Apr 1, 2004 at 2:10 pm
    Apr 1, 2004 at 10:55 pm
  • Okay, I've rtfmed, ctnomed, googled and I'm still not finding anything close. I want to use dbms_metadata to extract all the objects associated with a specific schema. Every article I find that says ...
    Daniel FinkDaniel Fink
    Apr 30, 2004 at 12:40 pm
    Apr 30, 2004 at 10:05 pm
  • I am remote TELNET from PC into ORACLE server (, SUN SOlaris 9) and tried to startup Apache server. There have error message come out: HOST1::/u0/9.2/Apache/Apache/bin[40]%./apachectl start ...
    Dba1 mccDba1 mcc
    Apr 13, 2004 at 8:57 pm
    Apr 14, 2004 at 11:08 am
  • Okay folks...Hopefully someone can help and provide some pointers... DB is 8174 I have gathered a great deal of outlines in order to identify index usage. I would like to document the indices in the ...
    Apr 1, 2004 at 3:26 pm
    Apr 4, 2004 at 10:01 am
  • Hi, I'm trying to implement google type of searches using Oracle Text but I could not figure out an easy way of doing it. I could not find an relevant information in the documentation. When a user ...
    Ivan ChowIvan Chow
    Apr 18, 2004 at 8:59 pm
    Jun 9, 2004 at 4:21 pm
  • Is anyone actually using this product in a Solaris server environment with Oracle 9i, connecting to Windows and internet explorer? I am having a hard time figuring out how to make isqlplus actually ...
    Michael FontanaMichael Fontana
    Apr 8, 2004 at 2:07 pm
    May 5, 2004 at 8:39 am
  • Hi all, I am currently working on a consolidation project. Within this project we want to consolidate Oracle schemas within Oracle 10g instances and Oracle instances on AIX 5.2 servers. We ...
    Apr 20, 2004 at 3:17 am
    Apr 21, 2004 at 12:39 pm
Group Navigation
period‹ prev | Apr 2004 | next ›
Group Overview
grouporacle-l @

291 users for April 2004

Mladen Gogala: 82 posts Jared.Still_at_radisys.com: 61 posts Tanel Põder: 56 posts Juan Cachito Reyes Pacheco: 52 posts Jonathan Lewis: 46 posts DENNIS WILLIAMS: 41 posts Jamadagni, Rajendra: 41 posts Ryan.gaffuri_at_cox.net: 38 posts Jesse, Rich: 31 posts Khedr, Waleed: 31 posts Mladen Gogala: 31 posts Tim Gorman: 30 posts Goulet, Dick: 27 posts Daniel W. Fink: 26 posts Fengchunpei: 24 posts Cary Millsap: 23 posts Freeman, Donald: 23 posts Justin Cave (DDBC): 22 posts Bobak, Mark: 21 posts Zhu chao: 21 posts
show more