FAQ

Oracle > oracle-l > April 2002

Search Discussions

692 discussions - 3,066 posts

  • I did two statspack snapshots, one hour and forty minutes apart. Then I generated a report and loaded it into oraperf.com. In the report I saw that the two SQL statements that where executed the most ...
    Yechiel AdarYechiel Adar
    Apr 21, 2002 at 5:23 pm
    Apr 24, 2002 at 9:53 pm
  • What is different between MySQL and Oracle database? Someone says they are the same as they are just database. From DBA or developer point of view, what do you say? Thanks, David -- Please see the ...
    Nguyen, David MNguyen, David M
    Apr 17, 2002 at 3:33 pm
    Apr 23, 2002 at 2:53 pm
  • Anyone whom can tell me how to delete a job that is created by crontab. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET ...
    Roland.Skoldblom_at_ica.seRoland.Skoldblom_at_ica.se
    Apr 24, 2002 at 2:28 pm
    Apr 25, 2002 at 5:08 pm
  • Hi Lisa, RMAN easy? ROTFL ksh scripts, 5 minutes to adjust environment variables done RMAN, let see create a seperate database, set up RMAN, oh, then I have to set up RMAN in the production db to ...
    Dave MorganDave Morgan
    Apr 3, 2002 at 5:41 pm
    Apr 6, 2002 at 12:28 pm
  • Hi, I have a customer who runs an ERP application written using ORACLE. Almost all code is written using PL/SQL packages. There are about 80-100 users at any given point of time(6 AM - 11 PM). Oracle ...
    Raghu BanajiRaghu Banaji
    Apr 26, 2002 at 6:24 pm
    Apr 30, 2002 at 7:21 pm
  • We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS, AIX, HP-UX for performance and other ...
    Bunyamin K. KaradenizBunyamin K. Karadeniz
    Apr 4, 2002 at 4:36 pm
    Apr 6, 2002 at 1:58 am
  • Hi everyone. I'm currently working at a client where the OFA standard has been (as they put it) "taken to the next level". I disagree with their approach, and I'd be interested to see what list ...
    Paul BaumgartelPaul Baumgartel
    Apr 1, 2002 at 10:48 pm
    Apr 8, 2002 at 6:48 pm
  • well now you'll have to let us know what the solution turns out to be.... Larry Elkins wrote:
    Rachel CarmichaelRachel Carmichael
    Apr 1, 2002 at 12:48 am
    Apr 4, 2002 at 1:28 am
  • Ok life has slowed down some and i've got some free time to potentially pickup the 9i new features saga i did about 6 months ago. Anyone still interested? The next on the list was 9i data guard. joe ...
    JOE TESTAJOE TESTA
    Apr 25, 2002 at 1:13 pm
    Apr 27, 2002 at 9:03 pm
  • Mark, This is from a first-timer at IOUG, so I may be way off here. A lot of marketing blurb was thrown out at IOUG (probably a lot less than usual, and *much* less than Oracle OpenWorld in any ...
    John KanagarajJohn Kanagaraj
    Apr 22, 2002 at 10:23 pm
    Apr 25, 2002 at 6:03 pm
  • We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: "Back when I we were using an AS400, ...
    Jay HostetterJay Hostetter
    Apr 11, 2002 at 1:54 pm
    Apr 12, 2002 at 9:38 pm
  • Company located in Spartanburg, South Carolina with a small IT shop needs an Oracle Financials System Adminsitrator to join its IT team. Relocation Assistance is provided. PLEASE Do Not send your ...
    OraStaffOraStaff
    Apr 29, 2002 at 4:33 pm
    Apr 30, 2002 at 2:49 pm
  • I see a couple of folks who want to know how to flush the pool or are looking for a script to do it automatically. Shouldn't we be asking what is causing the behavior that got us to this quandry in ...
    Johnson, MichaelJohnson, Michael
    Apr 24, 2002 at 11:53 pm
    Apr 26, 2002 at 2:43 pm
  • Hello all, Someone posted a link to a page describing what was going on at ioug-a. This link spoke of a presentation (by Gaja?) that addressed tuning without ever looking at a ratio. Are these papers ...
    Koivu, LisaKoivu, Lisa
    Apr 21, 2002 at 11:43 am
    Apr 22, 2002 at 10:07 pm
  • The DBA needs root privileges on the server This is one of my interview questions. Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ ...
    Dave MorganDave Morgan
    Apr 4, 2002 at 4:18 pm
    Apr 11, 2002 at 3:13 pm
  • This just in from comp.databases.oracle.server. See metalink bug 2121935. Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) allows you to view data from tables on which you have no privilege. For ...
    Jonathan LewisJonathan Lewis
    Apr 16, 2002 at 11:33 am
    Apr 22, 2002 at 7:33 pm
  • We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, ...
    Scott CanaanScott Canaan
    Apr 15, 2002 at 3:33 pm
    Apr 19, 2002 at 11:23 pm
  • Dear gurus ! May i ask for your opinions regarding the value of the Brainbench Oracle 8i Administration certifications. I understand that it can not be compared t othe OCP, but is there any value at ...
    Andrey BronfinAndrey Bronfin
    Apr 11, 2002 at 9:23 pm
    Apr 15, 2002 at 3:39 pm
  • We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want ...
    YTTRI LisaYTTRI Lisa
    Apr 18, 2002 at 3:58 pm
    Apr 20, 2002 at 1:08 am
  • Hi all, Just for my own info, Is Oracle written in C ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: SinardyXing_at_bcs-ach.com.sg Fat City ...
    Sinardy XingSinardy Xing
    Apr 17, 2002 at 6:48 am
    Apr 19, 2002 at 5:53 am
  • I am working on a database optimization project. My Shared pool is filled with SQL like select 0 from dual; select 1/1 from dual; select 1 - 1/(2 + 2) from dual; I tried to use the bind variables to ...
    Mohammed ShakirMohammed Shakir
    Apr 2, 2002 at 7:03 pm
    Apr 5, 2002 at 5:08 am
  • Hi, I have segments (Tables and indexes) which go into 500 MB -- 1 GB . I intend to do a rebuild since they are fragmented. Is it beneficial to have a single extent of 500 Mb or multiple extents are ...
    Shreepad.Vaidya_at_alltel.comShreepad.Vaidya_at_alltel.com
    Apr 29, 2002 at 12:43 pm
    Apr 30, 2002 at 12:14 pm
  • Hi All, we are in the process of upgrading to 8.1.7.3 some of our databases (now 8.0.5) According to the Doc's thsi has to be done in two steps Upgrade to 8.1.7.0.0 followed by and upgrade to ...
    Jack van ZanenJack van Zanen
    Apr 17, 2002 at 2:43 pm
    Apr 18, 2002 at 4:03 pm
  • I am looking into locally managed tablespaces, have done some research, and have a basic understanding of how they work, but I am unsure about the benefits if any for my environment. I have multiple ...
    Browett, DarrenBrowett, Darren
    Apr 15, 2002 at 9:33 pm
    Apr 18, 2002 at 12:29 am
  • I've got the following SQL statement that is running very long on a nightly data load. The problem is the TO_CHAR function which is preventing me from using the index on this small (20,000-row ...
    Cherie_Machler_at_gelco.comCherie_Machler_at_gelco.com
    Apr 8, 2002 at 5:56 pm
    Apr 9, 2002 at 11:08 pm
  • Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this ...
    Mark LeithMark Leith
    Apr 4, 2002 at 10:38 am
    Apr 5, 2002 at 5:47 pm
  • i cant connect as sysdba. ORA-01031 - insuffecient privileges. can anybody help me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET ...
    paPIpapupapePOpaPIpapupapePO
    Apr 3, 2002 at 5:18 am
    Apr 5, 2002 at 5:38 am
  • Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see this on Connor's website ...
    Koivu, LisaKoivu, Lisa
    Apr 29, 2002 at 10:52 pm
    Apr 30, 2002 at 7:38 pm
  • Hi all, We are running a kind of hybrid mode, mainly RBO with some tables analyzed (mainly for intermedia). Last week we had an interesting situation, when tuning a huge SQL, we created an index and ...
    Jamadagni, RajendraJamadagni, Rajendra
    Apr 12, 2002 at 2:03 pm
    Apr 13, 2002 at 2:08 am
  • Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to configure seperate listener for each database. I used different port, listener name (1521 and ...
    Janet LinsyJanet Linsy
    Apr 6, 2002 at 6:08 am
    Apr 8, 2002 at 10:18 pm
  • I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the Alert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error ...
    Farnsworth, DaveFarnsworth, Dave
    Apr 2, 2002 at 7:03 pm
    Apr 3, 2002 at 2:48 pm
  • I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - ...
    Freeman, RobertFreeman, Robert
    Apr 9, 2002 at 5:53 pm
    Apr 10, 2002 at 7:38 am
  • Hi How to install hp-ux patch before installing oracle on HP9000 server(based on PA Risk)? Thx -Seema Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ...
    Seema SinghSeema Singh
    Apr 29, 2002 at 6:58 pm
    Apr 30, 2002 at 1:44 pm
  • My boss (one of those scarey-smart people) was taking some certification test, when someone mused, "I wonder how many questions he will answer 'incorrectly' in order to get a higher score?" This is ...
    Ray StellRay Stell
    Apr 22, 2002 at 9:38 pm
    Apr 23, 2002 at 2:38 pm
  • Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 ...
    Seema SinghSeema Singh
    Apr 19, 2002 at 5:39 pm
    Apr 20, 2002 at 6:08 pm
  • In our test databases, I have always granted select,insert,update,delete any table to the developers. While yesterday, one updated a "sys" table. Be non-production, I always felt if it is destroyed ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 12, 2002 at 12:38 pm
    Apr 14, 2002 at 7:53 pm
  • Hi all, We are running both a Hitachi 7700E and a 9960 disk subsystem here and we are getting ready to move our production DBs from the old(7700E) to the new(9960) Hitachi. We have had trouble in the ...
    John.Dailey_at_ing-fsi-na.comJohn.Dailey_at_ing-fsi-na.com
    Apr 10, 2002 at 3:38 pm
    Apr 11, 2002 at 10:38 pm
  • I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server ...
    Smith, Ron L.Smith, Ron L.
    Apr 9, 2002 at 2:28 pm
    Apr 9, 2002 at 5:53 pm
  • Dear All, I am totally out of my depth here and this is a production db which needs to be restored urgently. I shall explain my scenario first. Our application team had lost some data after last ...
    SARKAR, SamirSARKAR, Samir
    Apr 8, 2002 at 1:43 pm
    Apr 9, 2002 at 12:03 pm
  • One of our teams started programming in SQLServer, but now we are live in a production ORACLE environment. Due to several issues, such as licensing,skills, etc., the development must stay on ...
    Ray GordonRay Gordon
    Apr 18, 2002 at 5:28 pm
    Apr 27, 2002 at 12:53 am
  • We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2. While testing our nightly load job that runs in two simultaneous streams (ascending and descending), we have been getting deadlock ...
    Cherie_Machler_at_gelco.comCherie_Machler_at_gelco.com
    Apr 25, 2002 at 3:18 pm
    Apr 26, 2002 at 12:33 pm
  • Four years ago the only hardware striping available on EMC I was aware of was RAID-S. Recently researching striping ideas on EMC and was told that we can achieve raid0+1 hardware striping on EMC. I ...
    Khedr, WaleedKhedr, Waleed
    Apr 1, 2002 at 6:33 pm
    Apr 4, 2002 at 3:53 pm
  • I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When ...
    Nguyen, David MNguyen, David M
    Apr 2, 2002 at 7:38 pm
    Apr 3, 2002 at 9:48 pm
  • HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the ...
    Rakesh banerjeeRakesh banerjee
    Apr 3, 2002 at 2:18 pm
    Apr 3, 2002 at 8:53 pm
  • I have opened a TAR with Oracle and am waiting a resolution. In the meantime, I am wondering if anybody else has any ideas while I wait. Specifics: IBM AIX 4.3 Rdms 8.1.7.3 Database ~75g OLTP ...
    Tracy RahmlowTracy Rahmlow
    Apr 30, 2002 at 7:21 pm
    Apr 30, 2002 at 9:35 pm
  • I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that ...
    Jesse, RichJesse, Rich
    Apr 11, 2002 at 7:13 pm
    Apr 15, 2002 at 2:28 pm
  • FYI, I just went to MetaLink and clicked on the Login to MetaLink link, and got this: Authorization Required This server could not verify that you are authorized to access the document requested ...
    Boivin, Patrice JBoivin, Patrice J
    Apr 10, 2002 at 3:23 pm
    Apr 10, 2002 at 6:58 pm
  • http://story.news.yahoo.com/news?tmpl=story&cid=581&ncid=738&e=2&u=/nm/20020409/tc_nm/tech_oracle_dc_7 Cheers, JoJo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo ...
    JoJo ZawawiJoJo Zawawi
    Apr 9, 2002 at 7:28 am
    Apr 10, 2002 at 4:38 pm
  • WOW, is the certification market that bad? Their books were useful, I wonder what happened. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et ...
    Boivin, Patrice JBoivin, Patrice J
    Apr 1, 2002 at 1:23 am
    Apr 4, 2002 at 4:36 pm
  • Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Apr 2, 2002 at 4:29 pm
    Apr 4, 2002 at 2:58 pm
Apr 2002
12345…14
Group Navigation
period‹ prev | Apr 2002 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions692
posts3,066
users412
websiteoracle.com

412 users for April 2002

DENNIS WILLIAMS: 78 posts Koivu, Lisa: 68 posts Khedr, Waleed: 62 posts Jared Still: 52 posts Ron Rogers: 49 posts Dgoulet_at_vicr.com: 46 posts Igor Neyman: 46 posts Jonathan Lewis: 46 posts Mercadante, Thomas F: 45 posts Freeman, Robert: 43 posts Boivin, Patrice J: 42 posts Jamadagni, Rajendra: 41 posts Jared.Still_at_radisys.com: 40 posts Yechiel Adar: 40 posts Tim Gorman: 39 posts Connor McDonald: 37 posts Rachel Carmichael: 37 posts Anjo Kolk: 35 posts Kimberly Smith: 35 posts Mark Leith: 35 posts
show more
Archives