FAQ

Oracle > oracle-l > March 2003

Search Discussions

562 discussions - 2,334 posts

  • I'm trying to build a case for management that we need additional DBAs so I'd like to take a quick poll if I may. What is the ratio of Oracle databases to DBAs in your shop? This includes development ...
    Chuck HamiltonChuck Hamilton
    Mar 11, 2003 at 2:59 pm
    Mar 13, 2003 at 2:44 pm
  • Hi, Does Oracle have an official position on hints ? Will they go away as the optimiser is becoming bettre or they are there to stay ? TIA Stephane Paquette Administrateur de bases de donnees ...
    Stephane PaquetteStephane Paquette
    Mar 7, 2003 at 4:04 pm
    Mar 12, 2003 at 11:48 am
  • Hi all, I am configuring a system for use with Oracle and am confused on the concepts of RAID and OFA, specifically how they work together. I inherited a system that is a RAID 5 utilizing 5 disks ...
    Dwayne CoxDwayne Cox
    Mar 27, 2003 at 12:58 pm
    Mar 31, 2003 at 1:48 am
  • I have been reading some docs on free space etc., but I have not yet found any conclusive document on how to monitors tables/indexes in LMT environment so that we could *predict* when a segment would ...
    Jamadagni, RajendraJamadagni, Rajendra
    Mar 10, 2003 at 2:28 pm
    Mar 21, 2003 at 9:15 pm
  • I am finding tons of "log buffer space" waits in 10046 output . Does it necessarily means I should look for resizing log_buffer ? What else can be done or looked at to reduce these waits . Thanks, ak ...
    AKAK
    Mar 13, 2003 at 10:49 pm
    Mar 17, 2003 at 6:44 pm
  • RE: LMT monitoringcan't create a database with oracle 8.1.7. the installation went fine, but when i start dbassist on the 2% of the database creation it tels me: "not connected to oracle". any ideas? ...
    Milen PankovMilen Pankov
    Mar 11, 2003 at 5:00 pm
    Mar 24, 2003 at 4:55 pm
  • All - I am having a problem with the datafiles in a temporary tablespace. I need to move and rename three different datafiles in the tablespace. I am able to take them offline - no problem. I cna ...
    LeRoy KemnitzLeRoy Kemnitz
    Mar 11, 2003 at 1:39 pm
    Mar 13, 2003 at 1:08 pm
  • I usually track our HP-UX 11.0 system with the 'top' command so I can notice when the system is under slow performance. If that happens, I use Toad to look for any active Oracle SQL query which may ...
    Fermin Bernaus BerraondoFermin Bernaus Berraondo
    Mar 27, 2003 at 3:14 pm
    Mar 31, 2003 at 7:53 pm
  • Foote Partners surveys the value of certifications. They support that over the past two years, the OCP pay premium increased by nearly 40%. In the same period, the value of Microsoft MCP declined by ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Mar 19, 2003 at 5:50 pm
    Mar 21, 2003 at 8:57 pm
  • hey folks.. Hoping for a little feedback and opinion please. Having a discussion with the development group ... The development group is thinking that a VERY LARGE SGA would solve some of their I/O ...
    Loughmiller, GregLoughmiller, Greg
    Mar 3, 2003 at 5:59 pm
    Mar 6, 2003 at 7:19 pm
  • Okay, let me do this right this time,... (Now that I have my hot tea going;) Here is the test data: SQL select c1,c2 from cp; C1 C2 --- --- AUS DAL AUS HOU DAL AUS DAL HOU DAL LIT DAL XYZ HOU AUS HOU ...
    Deshpande, KirtiDeshpande, Kirti
    Mar 13, 2003 at 2:30 pm
    Mar 14, 2003 at 12:38 am
  • Hi SQL Developers, I have a table as follows: Col1 Col2 A B C D E F G H B A E F C D H G With a PK on (Col1, Col2). How do I write a SQL script to get following result? Col1 Col2 A B B A C D D C E F F ...
    Deshpande, KirtiDeshpande, Kirti
    Mar 13, 2003 at 1:23 pm
    Mar 13, 2003 at 4:14 pm
  • Hi all - I have an interesting problem at hand - we have a request from a developer that ask to access some tables owned by a user generated by third party app. Since I don't have the password for ...
    Meng, DennisMeng, Dennis
    Mar 4, 2003 at 9:05 pm
    Mar 5, 2003 at 10:49 pm
  • We have a new manager, and at his last employer the DBAs reorganize Oracle tables on a regular basis. I don't reorg tables on a regular basis. He is lobbying us to investigate this and test whether ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Mar 24, 2003 at 5:40 pm
    Mar 26, 2003 at 2:58 pm
  • list, one of our clietns are going to by SAN, the current oracle databases take around 36GB of storage.... i dnt understand there reason to go for SAN, i sugguested to buy an external storage box ...
    RahulRahul
    Mar 12, 2003 at 8:33 am
    Mar 21, 2003 at 8:52 pm
  • Hello, env: Oracle 9.2.0.2 on Solaris 9. Does anyone know of a way to use the "/ as sysdba" logon remotely? (to a separate Oracle instance on a separate machine) Other remote user logons work OK. I ...
    Becker.bill_at_marshfieldclinic.orgBecker.bill_at_marshfieldclinic.org
    Mar 6, 2003 at 7:08 pm
    Mar 10, 2003 at 4:03 pm
  • Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are ...
    Post, EthanPost, Ethan
    Mar 5, 2003 at 4:35 pm
    Mar 6, 2003 at 5:09 pm
  • I need to duplicate online database Oracle 8.1.7. It is not possible to shutdown the primary database. Can I do online backup this primary database by RMAN, and + using archivelogs create duplicate ...
    Edouard DormidontovEdouard Dormidontov
    Mar 4, 2003 at 10:38 am
    Mar 6, 2003 at 12:43 pm
  • 13

    PGA

    hello all, how does increasing the value of SORT_AREA_SIZE affect the unix system perfomance. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar ...
    Arvind KumarArvind Kumar
    Mar 31, 2003 at 10:03 am
    Mar 31, 2003 at 9:04 pm
  • Hi All, I've got a situation where I've collected trace data and am seeing 90% of total response time is accounted for with the SQL*Net Message From Client event. Individual queries within the trace ...
    Karen MortonKaren Morton
    Mar 13, 2003 at 2:18 am
    Mar 17, 2003 at 3:44 pm
  • Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the ...
    Adrian CiocildauAdrian Ciocildau
    Mar 5, 2003 at 1:34 pm
    Mar 6, 2003 at 1:03 pm
  • I think it was only a few weeks ago that I posted a list of errors in an article about statspack that Oracle Magazine published in January. You may be interested to see that another reader sent a ...
    Jonathan LewisJonathan Lewis
    Mar 1, 2003 at 7:29 am
    Mar 4, 2003 at 8:49 pm
  • Guys, The paper "How to stop defragmenting and start living" has some SAFE rules for extent management in dictionary managed tablespaces (in oracle 8 and 8i) as below: Segments smaller than 128M ...
    Prem Khanna JPrem Khanna J
    Mar 19, 2003 at 8:01 am
    Mar 26, 2003 at 10:43 pm
  • How about UNDO tablespace in 9.2? It gets created with "autoallocate", and there is no way to change it or specify any parameters for undo segments. Each segment extended as needed, and when shrinked ...
    Alex FeinsteinAlex Feinstein
    Mar 17, 2003 at 4:58 am
    Mar 18, 2003 at 7:28 pm
  • All... A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires a nightly backup (by simply copying them to a backup directory) of the datafiles of an active instance. I explain that ...
    Gary ChambersGary Chambers
    Mar 14, 2003 at 3:44 pm
    Mar 14, 2003 at 8:09 pm
  • I am running tkprof on event 10046 output and I see at the end . elapsed time of 18 secs in recursive calls thats what surprises me . Do you know what I should look at next and what can be done to ...
    AKAK
    Mar 11, 2003 at 7:29 pm
    Mar 13, 2003 at 5:19 pm
  • List, OS RedHat 7.3 Oeacle 8.1.7 rel3 I have had a disk failure on my test box and a datafile needs to be recovered from my tape backup. The tape contains 6 large datafiles and I get errors after ...
    Ron RogersRon Rogers
    Mar 12, 2003 at 12:48 pm
    Mar 13, 2003 at 2:19 pm
  • Hi Dear list; I don't have experience on NT scripting. but I have an urgent need for nt script. Someone's help would be appreciated. Here is the question; How to convert this script to nt script? I ...
    Joan HsiehJoan Hsieh
    Mar 7, 2003 at 4:24 pm
    Mar 12, 2003 at 9:24 pm
  • Guys, Sorry to post this again. However, finished OCP 8i and wish to study for 9i OCP. What is good materials - books, self-test exams? References. Don't have time or money to travel - going to IOUG ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Mar 3, 2003 at 4:04 pm
    Mar 4, 2003 at 8:35 pm
  • Hi Listers, Oracle 8174, HP 11.00 I got the following error when starting up the database thru crontab job at 2 am in the morning. It happened after we shutdown the unix machine. Errors in file ...
    Bahar, Rivaldi (BBASSI-CHQ)Bahar, Rivaldi (BBASSI-CHQ)
    Mar 28, 2003 at 2:38 pm
    Mar 31, 2003 at 6:34 pm
  • For those not interested in marketing news, I would suggest skipping this message. http://www.computerworld.com/softwaretopics/os/linux/story/0,10801,79730,00. html Oracle ups Linux efforts with ISV ...
    Jacques KilchoerJacques Kilchoer
    Mar 27, 2003 at 1:43 am
    Mar 28, 2003 at 10:53 pm
  • Hello, Heres a question to ponder. While tuning a SQL statment for a user I noticed that the explain plan from SQL Analyze was not the same plan that was found when I used OEM Top Sessions (9.2.0.1) ...
    Odland, BradOdland, Brad
    Mar 20, 2003 at 8:22 pm
    Mar 26, 2003 at 1:19 pm
  • thanks in case I happen to work on a 7.3 database.... what kind of pctincrease should I set? What about the other settings? Just curious. Ryan
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Mar 21, 2003 at 6:12 pm
    Mar 23, 2003 at 1:28 pm
  • Ive noticed that in consulting these things matter more. Makes it easier to sell you. Ive been on projects where people have said so and so has an OCP so they know what they are doing. Ive also seen ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Mar 19, 2003 at 7:48 pm
    Mar 21, 2003 at 1:18 am
  • One of the teams here is planning to run anything from 8 to 16 database instances [no indication on sizing yet, but gut-feel SGAs are 200MB to 1GB and DB sizes 500MB to 40GB] on a "large" server, ...
    Hemant K ChitaleHemant K Chitale
    Mar 11, 2003 at 8:48 am
    Mar 16, 2003 at 10:28 am
  • Hello, We are currently spec'ing out hardware for our new ERP system. It is either going to be Peoplesoft or Oracle. We are also debating on using a SAN rather than attached storage. I'm just looking ...
    Scott StefickScott Stefick
    Mar 6, 2003 at 9:39 pm
    Mar 15, 2003 at 12:24 am
  • I'm suffering from a senior moment. The question is at the every bottom. SQL select sql_text from v$sqlarea sa where buffer_gets 100000000 SQL_TEXT SELECT RP.RELPART FROM OERELPART RP, PARTOFFERING ...
    Charlie_Mengler_at_HomeDepot.comCharlie_Mengler_at_HomeDepot.com
    Mar 12, 2003 at 5:18 pm
    Mar 12, 2003 at 11:33 pm
  • List, System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent Management. I thought all tablespaces defaulted to Local in this release. Thu Mar 6 15:29:43 2003 create tablespace SYSTEM ...
    Godlewski, MelissaGodlewski, Melissa
    Mar 6, 2003 at 8:48 pm
    Mar 7, 2003 at 4:49 pm
  • I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Mar 12, 2003 at 1:29 pm
    Mar 13, 2003 at 12:48 pm
  • Hi All, As we have this Oracle user group(ORACLE-L_at_fatcity.com), I was wondering if there is any such group for SQL Server also. Thanks, Ashoke -- Please see the official ORACLE-L FAQ ...
    Mandal, AshokeMandal, Ashoke
    Mar 3, 2003 at 2:09 pm
    Mar 3, 2003 at 9:14 pm
  • for one of the db over here alert log is biggggggg .Looks like its never been truncated or backup . Is it a problem if i just move this alert log file to another directory, will oracle create a new ...
    AKAK
    Mar 31, 2003 at 3:53 pm
    Mar 31, 2003 at 5:08 pm
  • In 8i we set utl_file_dir = "*" because otherwise we have to specify lots of individual directories. It was not possible to just specify a top level directory. Has this changed in 9i? Is it possible ...
    John DunnJohn Dunn
    Mar 14, 2003 at 9:43 am
    Mar 27, 2003 at 8:38 am
  • (see comments below) Answering your question: if you import a schema with IGNORE=Y after dropping only one package, I would think it should work (meaning only import the missing package and show ...
    Jacques KilchoerJacques Kilchoer
    Mar 26, 2003 at 2:18 am
    Mar 27, 2003 at 12:28 am
  • Hi, I am wondering if there is any way to achieve horizontal partitioning in Oracle. Assuming that I have about 8 partitions for a table.When there is INSERT onto this table I want one record to be ...
    Basavaraja, RavindraBasavaraja, Ravindra
    Mar 19, 2003 at 7:00 pm
    Mar 25, 2003 at 3:11 am
  • Hi. I'm trying to get a feel of the number of the queries executed at the same time against a database. I have been using the following script (actually this is a part of a script) Select a.type, ...
    GureleiGurelei
    Mar 21, 2003 at 2:22 pm
    Mar 24, 2003 at 3:52 pm
  • Any opinions on which patchset of 9.2 is most stable: 9.2.0.1, 9.2.0.2, 9.2.0.3? We're running HP Tru64. Thanks! Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA **DISCLAIMER This ...
    Jay HostetterJay Hostetter
    Mar 18, 2003 at 2:58 pm
    Mar 18, 2003 at 6:43 pm
  • Here is a part of trace file . I am finding that oracle is trying to read 8 or 3 or 7 blocks at a time . But block numbers are all sequential i.e. it will read 3 blocks starting from 14706 and then 8 ...
    AKAK
    Mar 14, 2003 at 5:04 pm
    Mar 17, 2003 at 6:41 pm
  • Hi Listers, I'm simulating the date in future with fixed_date. I wrote procedure to be called every seconde through dbms_job to increment the fixed_date. I did that dbms_job.submit(:job_num, ...
    Kader BenKader Ben
    Mar 13, 2003 at 11:18 pm
    Mar 14, 2003 at 7:59 pm
  • Hi List, I have the below query which is very long and it contains an UNION clause as the query has to select ac_type from op_ac_type table if op_fl_plan.op-ac_type = 'JET' while it should select ...
    Krishnaswamy, RanganathKrishnaswamy, Ranganath
    Mar 10, 2003 at 11:33 am
    Mar 10, 2003 at 8:18 pm
  • Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan ...
    SultanSultan
    Mar 5, 2003 at 11:49 am
    Mar 6, 2003 at 2:08 pm
Mar 2003
12345…12
Group Navigation
period‹ prev | Mar 2003 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions562
posts2,334
users370
websiteoracle.com

370 users for March 2003

DENNIS WILLIAMS: 121 posts Jamadagni, Rajendra: 70 posts Jared.Still_at_radisys.com: 68 posts Jonathan Lewis: 68 posts Jacques Kilchoer: 59 posts Goulet, Dick: 50 posts Darrell Landrum: 48 posts Kirti.deshpande_at_verizon.com: 43 posts AK: 37 posts Hkchital_at_singnet.com.sg: 36 posts Chuck Hamilton: 31 posts Pete Sharman: 30 posts Paula_Stankus_at_doh.state.fl.us: 29 posts Tim Gorman: 28 posts Mercadante, Thomas F: 27 posts Rachel Carmichael: 27 posts Arup Nanda: 26 posts Gogala, Mladen: 26 posts Jared Still: 26 posts Rich.Jesse_at_qtiworld.com: 25 posts
show more
Archives