FAQ

Oracle > oracle-l > January 2005

Search Discussions

253 discussions - 1,176 posts

  • Hi list, I was reading and article, some "investigation" says windows will be the operating system of the future. The person who writes this article don't loves microsoft window anyway, but money ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jan 28, 2005 at 10:22 am
    Feb 1, 2005 at 5:06 pm
  • We just completed an external audit and one of the findings from the auditors is that DBAs should not have cron rights in Unix. The finding basically stated that a DBA could schedule something to run ...
    KATHERINE_KAYLOR_at_rsausa.comKATHERINE_KAYLOR_at_rsausa.com
    Jan 24, 2005 at 11:15 am
    Feb 21, 2005 at 1:10 pm
  • Hi By testing this new 10g feature I noticed that even if a nested loop is = used, the join condition is not used as access predicate on the inner = table! To test it I used queries like the ...
    Christian AntogniniChristian Antognini
    Jan 2, 2005 at 4:19 am
    Jan 5, 2005 at 3:12 am
  • Friends, when i have got two plans, how do i decide which one is the best ? just read in asktom, that COST of a plan, does not have any correspondence with response time of a query. i.e.,a query with ...
    Prem Khanna JPrem Khanna J
    Jan 13, 2005 at 2:50 am
    Jan 24, 2005 at 2:37 pm
  • Hi,all, at Tom's AskTom(http://asktom.oracle.com),I saw : [quote] Do you use Linux? then you need rlwrap http://www.dizwell.com/html/a_command_line_history.html . You won't know how you survived ...
    FenngFenng
    Jan 11, 2005 at 4:29 am
    Jan 30, 2005 at 11:45 pm
  • We are upgrading an application that uses an external database to set=20 initial table create parameters. =20 I would like to use Locally Manages tablespaces and Uniform extent=20 sizes, instead of ...
    Smith, Ron L.Smith, Ron L.
    Jan 20, 2005 at 3:05 pm
    Jan 21, 2005 at 3:59 am
  • I converted hpux 8.1.7.4 to Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production. Shared pool was originally around 80M and never had any problems for over a year. I got a memory error, ...
    Kline.MichaelKline.Michael
    Jan 20, 2005 at 6:54 am
    Jan 27, 2005 at 12:20 pm
  • I've been building my own intel/linux clusters for testing. I'm wondering if you have tested any commerical offerings for the whole 9 yards; processers, FC, and storage ...
    Ray StellRay Stell
    Jan 18, 2005 at 11:19 pm
    Jan 26, 2005 at 5:07 pm
  • Hi, I have to generate 16 digit random numbers.......any recommendations. I am using Oracle 9.2.x release. Thanks Muqthar Ahmed Oracle9i Certified DBA * * * * * * * * The information contained in ...
    Muqthar AhmedMuqthar Ahmed
    Jan 4, 2005 at 1:06 pm
    Jan 5, 2005 at 10:00 am
  • Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Group. Oracle 8.2 on Win2K There is no entry happening on alert log file for past 2 days. This is an retial ...
    Vinod Gopinath BMMI ISVinod Gopinath BMMI IS
    Jan 12, 2005 at 7:46 am
    Aug 4, 2005 at 12:27 pm
  • I just received this from my SA, Claus. Has anyone applied this patchset? Does anyone know the details. Inquiring minds what to know. Ruth -----Original Message----- From: Claus Lund Sent: Tuesday, ...
    Ruth GramoliniRuth Gramolini
    Jan 18, 2005 at 10:49 pm
    Jan 24, 2005 at 11:01 am
  • hello; We have a Oracle 8.1.7.0.0 Database on Solaris8. With a parallel insert, database slow down heavy suddently. I find lots of latch wait in database,from statspack(with 15 minutes elapse) list ...
    EygleEygle
    Jan 8, 2005 at 7:53 am
    Jan 12, 2005 at 8:33 pm
  • OK, so for whatever reason this thought just popped into my head and I think it would be a pretty cool feature for a database to have. # From a remote server you type... ftp server_name port # Then ...
    Post, EthanPost, Ethan
    Jan 27, 2005 at 10:21 pm
    Jan 30, 2005 at 11:32 am
  • I'm - not for the first time bemused - I wonder if anyone can (after fighting past the screwed up formatting that blogger gave me) shed light on the results that I have on my site for running ...
    Niall LitchfieldNiall Litchfield
    Jan 12, 2005 at 8:48 am
    Jan 14, 2005 at 1:33 pm
  • Win2000 9.2.0.6 (tested on 9.2.0.4/SPARC Solaris as well) FULL TEST text see at the end of letter. I just trying to understand what FILTER operation doing in case described below. I have ran the same ...
    J.Velikanovs_at_alise.lvJ.Velikanovs_at_alise.lv
    Jan 3, 2005 at 12:22 pm
    Jan 4, 2005 at 3:44 pm
  • List, OS Redhat AS 3.0 u3 memory 750 Meg swap 1.5 Gig Oracle 10.1.0.3 I have created the database and included the temporary temp tablespace. The sga is created using the sga_target and sga_max ...
    Ron RogersRon Rogers
    Jan 11, 2005 at 7:18 am
    Jan 12, 2005 at 7:34 am
  • Hi list, We are on Solaris 9/Oracle 9i with locally managed tablespace. There is a huge tablespace in our database with many huge tables. The biggest table has a size of 60 GB. (Indexes are in a ...
    Roger XuRoger Xu
    Jan 6, 2005 at 5:50 pm
    Jan 7, 2005 at 6:07 pm
  • i have 2 clients still running 8170 on w2k boxes and want to patch up to coincide with the 9205 server instances. are there any documents that could be reviewed for accomplishing this migration ...
    Bryan WellsBryan Wells
    Jan 25, 2005 at 2:29 pm
    Jan 27, 2005 at 3:27 pm
  • Hello I need some help here. I need to get a report of all the table that are empty on a schema. How shall i do that ? Thank In advance JK
    Kean JacintaKean Jacinta
    Jan 23, 2005 at 11:09 pm
    Jan 24, 2005 at 8:12 pm
  • ��We've got a table listing stored programs that need to execute after various application activity. My first thought is to just use "execute immediate" on the stored program. But this will allow ...
    Knight, JonKnight, Jon
    Jan 10, 2005 at 10:31 am
    Jan 10, 2005 at 4:43 pm
  • Hi Gurus, Firstly, I wish each and everyone of you a very happy, prosperous and a healthy New Year. I have a doubt regarding 2 Node RAC standby database. We have a 2 Node RAC database running 9.2.0.4 ...
    Sriram KumarSriram Kumar
    Jan 5, 2005 at 10:35 pm
    Jan 9, 2005 at 12:53 pm
  • ��While tuning a mammoth query, I noticed that one of the tables in the from clause is actually a view. It's defined as "select * from table_name_at_dblink". Is there any reason to believe I could ...
    Knight, JonKnight, Jon
    Jan 31, 2005 at 12:15 pm
    Jan 31, 2005 at 2:14 pm
  • Hi, I had seen a tendency to not use java for internet use, one example is enterprise manager in 10g is html. In the same oracle way small business suite in internet. I think java is still too heavy, ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jan 28, 2005 at 4:12 am
    Jan 28, 2005 at 10:00 pm
  • Hello everyone: I have a table where I have a date column with historic information in the same table, if date = '31-dec-2999' then is actual record if the date is different of 31-dec-2999 the is an ...
    Alfonso LeónAlfonso León
    Jan 19, 2005 at 1:35 pm
    Jan 24, 2005 at 4:27 am
  • allow me to comment on terminology here: both flavors of the join syntax are fully ANSI/ISO compliant. in other words, there is *no* reason at all to use one over the other for portability reasons -- ...
    Lex de HaanLex de Haan
    Jan 19, 2005 at 12:20 am
    Jan 19, 2005 at 5:22 am
  • Regarding RAC on Linux RHAS 3.0, are any of you running with asynch = enabled at the OS and db level or runing with an IO slaves implementation? Have = you any experience positive or negative in ...
    DavidDavid
    Jan 12, 2005 at 11:08 pm
    Jan 14, 2005 at 8:10 pm
  • I create 4 standby redo log groups, and use LGWR in primary site to transfer redo data, all are good. But when I query the V$STANDBY_LOG view, I found that only the status column of GROUP# 4(the ...
    KamusKamus
    Jan 5, 2005 at 8:29 am
    Jan 12, 2005 at 2:54 am
  • Hi all Got this query from a developer, or actually they are actually arguing with the DBA team. Table A - master, acc number field also only column in PK Table B - Child, acc Number Field acc number ...
    Leonard, GeorgeLeonard, George
    Jan 28, 2005 at 4:54 am
    Jan 28, 2005 at 6:07 pm
  • Guys, Over 5 years or better it has been drilled into my head not to analyze the system or sys objects. Imagine my surprise when in the readme for 9.2.0.6 patchset it says to run ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Jan 25, 2005 at 4:03 pm
    Jan 28, 2005 at 5:58 am
  • I've been trying to access OraPerf.com (Anjo Kolk's incredibly useful and, indeed, vital site) for the last day or so with no luck (get a gateway time out error). Does anyone know if it's actually ...
    Stephen boothStephen booth
    Jan 13, 2005 at 4:27 am
    Jan 13, 2005 at 11:05 am
  • I had Oracle 9i database and need to convert several reports to Excel Spreadsheet. Is there any procedure that can help. I am planning to use Orace 9iAS Mod Plsql to provide direct report to Excel ...
    Sanjay MishraSanjay Mishra
    Jan 10, 2005 at 1:50 pm
    Jan 11, 2005 at 8:21 am
  • Dear Experts I am encountering high swapping problem on Oracle database 9.2.0.4 with 16G RAM on Sun Sol 2.8 platform. Can anyone provide good UNIX commands/tips? I would also like to know how to find ...
    Chen, SarahChen, Sarah
    Jan 6, 2005 at 12:15 pm
    Jan 7, 2005 at 11:16 am
  • Funny. the website cited for lavarand doesn't exist.=20 Now THAT is some security.=20 (These NIST boys must be smoking Secure Hash)=20 -----Original Message----- From ...
    Mohan, RossMohan, Ross
    Jan 4, 2005 at 4:57 pm
    Jan 6, 2005 at 8:48 am
  • I have a corrupted block in the system tablespace. I used the standard query to identify the object that the block but it failed: SQL 1 SELECT segment_name 2, segment_type 3, owner 4, tablespace_name ...
    Vlado BarunVlado Barun
    Jan 6, 2005 at 8:19 pm
    Mar 8, 2005 at 11:10 pm
  • I'm supposed to be giving a demo of Oracle's Advanced Queueing feature next week and barely know how to spell queue. Besides the official documentation (which i am hitting up as soon as i get ...
    Chris StephensChris Stephens
    Jan 31, 2005 at 1:55 pm
    Jan 31, 2005 at 6:04 pm
  • Hi Guys, What is this problem of? Some says that is due to wrong oracle home and some says comment the entry in SQLNET.ORA? What is the route cause for that n what is the solution? Chirag -- ...
    Chirag DBAChirag DBA
    Jan 27, 2005 at 4:44 pm
    Jan 28, 2005 at 1:48 pm
  • I am looking for the Oracle client for Linux. Can any one point to the URL from where I can download the client? Thanks Raja Ph: (212) 210 1461 -- http://www.freelists.org/webpage/oracle-l
    Subbiah, NagarajanSubbiah, Nagarajan
    Jan 27, 2005 at 12:20 pm
    Jan 27, 2005 at 7:38 pm
  • We have had a practice at our site of creating development and staging databases by copying a cold backup to another system. We then edit the output from "backup controlfile to trace" to rename the = ...
    Schauss, PeterSchauss, Peter
    Jan 26, 2005 at 11:14 am
    Jan 26, 2005 at 4:52 pm
  • Other then use sort_area_size to sort in memory and parallel query what can be done to optimize a pull of 2 large tables joined together where most of the rows from both tables are selected??? -- ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Jan 21, 2005 at 9:24 am
    Jan 21, 2005 at 5:52 pm
  • Dear Experts I am trying to setup Streams and getting some weired Error. I tried to use OEM, but its wizard also fails with the same ORA-25238. I don't know where I need to reduce the Recepient. Any ...
    Sanjay MishraSanjay Mishra
    Jan 7, 2005 at 9:24 am
    Jan 19, 2005 at 12:23 pm
  • If I put a PK constraint on columns A and B, I don't need a separate not null constraint on those columns to prevent null values in those columns. With a unique constraint on columns A and B, I would ...
    Jacques KilchoerJacques Kilchoer
    Jan 18, 2005 at 10:19 pm
    Jan 19, 2005 at 10:37 am
  • I see this operation in plans occasionally when I'm using btree indexes and there are not any bitmaps. I also see: BITMAP OR when using 2 btree indexes in the plan. does oracle do some conversion to ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Jan 11, 2005 at 9:56 am
    Jan 14, 2005 at 4:29 pm
  • Hi all Hope you can help. As with all big projects our developers forgot to listen to us when we asked them to keep a dependency tree what calls what. Now we are busy going into pre-prod etc and get ...
    Leonard, GeorgeLeonard, George
    Jan 11, 2005 at 2:30 am
    Jan 13, 2005 at 2:29 pm
  • Okay... I want to improve some disk space by moving temporary tablespaces to another physical disk, however, im thinking I cant do this w/o dropping and recreating since i cant take a temporary ...
    Bryan WellsBryan Wells
    Jan 9, 2005 at 11:54 am
    Jan 10, 2005 at 11:01 am
  • We have been planning on implementing 9i RAC solution for the last few months. Since 10G R2 will probably be available within the next 6months, I think we should put our implementation on hold until ...
    Susan lamSusan lam
    Jan 26, 2005 at 11:38 am
    Jan 27, 2005 at 3:55 pm
  • Listers, Assuming a CLOB, for example, was defined with ENABLE STORAGE IN ROW. Is there an easy and *fast* way to determine how many of them are out of line? Applies to both 8.1.7 and 9.2.0.5. Ok, ...
    Larry ElkinsLarry Elkins
    Jan 26, 2005 at 1:20 pm
    Jan 26, 2005 at 8:39 pm
  • We are using a Cisco PIX firewall version 6.2. Database is running Oracle 9i with multithreaded server. If we move the web server inside the firewall, then sqlplus connects to the database server. If ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jan 25, 2005 at 3:33 pm
    Jan 25, 2005 at 7:23 pm
  • Hi ALL, Looks like off topic, but it can be useful for Oracle administration purposes on Linux (Unix) platform. I have need to kill one of my shell scripts in case of timeout is off. Not just single ...
    J.Velikanovs_at_alise.lvJ.Velikanovs_at_alise.lv
    Jan 21, 2005 at 4:17 pm
    Jan 24, 2005 at 5:36 pm
  • Has anyone done a good paper on what Sorbanes Oxley means for the DBA and that related group? Some of our "requirements" are quite large and usually based on "I THINK Sorbanes Oxley may require it ...
    Kline.MichaelKline.Michael
    Jan 13, 2005 at 9:06 am
    Jan 24, 2005 at 2:27 pm
  • I'm running into a problem on one of our systems where a query on dba-segments is running incredibly slow. The full query is: select 'alter index diamond'||segment_name||' rebuild tablespace ...
    Stephen boothStephen booth
    Jan 20, 2005 at 2:24 pm
    Jan 20, 2005 at 6:06 pm
Jan 2005
123456
Group Navigation
period‹ prev | Jan 2005 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions253
posts1,176
users228
websiteoracle.com

228 users for January 2005

Jared Still: 52 posts Mladen Gogala: 42 posts Marquez, Chris: 28 posts Christian Antognini: 26 posts Jonathan Lewis: 23 posts Stephen booth: 22 posts J.Velikanovs_at_alise.lv: 20 posts Niall Litchfield: 20 posts Leyi Zhang: 19 posts Mercadante, Thomas F: 18 posts Goulet, Dick: 17 posts Jesper Haure Norrevang: 17 posts Mladen Gogala: 17 posts Carel-Jan Engel: 16 posts Ruth Gramolini: 16 posts Wolfgang Breitling: 16 posts Lyndon Tiu: 15 posts Mark J. Bobak: 15 posts Reidy, Ron: 15 posts Ryan_gaffuri_at_comcast.net: 15 posts
show more
Archives