Search Discussions

99 discussions - 464 posts

  • I installed 64-bit AIX software on my Unix test server and upgraded my databases. Now my backups don't work since they are going to an NFS mounted file system. This is a 'feature' of 10.2 ...
    LeRoy KemnitzLeRoy Kemnitz
    Jan 31, 2006 at 9:19 pm
    Feb 6, 2006 at 5:45 pm
  • We are having trouble with slow exports on Oracle 8.1.7 running on a Sun server. Exports that used to take 30 minutes are now running 9 hours. If I do a file system copy, it runs very fast. So I ...
    Smith, RonSmith, Ron
    Jan 31, 2006 at 8:01 pm
    Jan 31, 2006 at 11:52 pm
  • Hi, Oracle 9.2 We are looking to use the index compression. We have a table of 18Gigs of data, contening 42 millions of rows. One of the index is 19Gig, another one 17 Gigs, and so on .... We are ...
    Luc DemancheLuc Demanche
    Jan 31, 2006 at 3:14 pm
    Feb 5, 2006 at 10:40 pm
  • Hello all! I'd like to get some suggestions from experienced minds. So we'v developed an application and our client will soon make a load test. Load test will be performed in a very real manner i.e ...
    Gints PlivnaGints Plivna
    Jan 18, 2006 at 9:31 am
    Jan 24, 2006 at 6:13 pm
  • Hi, could you give an advice on this please? What is better to se sample size to 20 or use dbms_stats.auto_sample_size Reading on asktom I found that some times used a 100 sample size, when using ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jan 25, 2006 at 6:37 pm
    Feb 1, 2006 at 1:19 am
  • List, Here is a significant media article that I haven't seen posted here. It describes a nightmarish future of Oracle security problems. But then maybe I was napping. Hey maybe this article is a ...
    Dennis WilliamsDennis Williams
    Jan 25, 2006 at 2:44 pm
    Jan 30, 2006 at 10:18 pm
  • Greetings, Oracle 9iRel2: I am looking for a script to report the following info for the (given) table and its indexes OWNER TYPE TABLESPACE SEGMENT_NAME IEXT_KB EXTENTS MB -------- -------- ...
    Jan 27, 2006 at 7:03 pm
    Jan 28, 2006 at 5:11 pm
  • User A is schema owner. User B has select on user A's objects, and is subject to row-level security policy on user A's objects. (Row-level security predicate function returns empty string if user ...
    Paul BaumgartelPaul Baumgartel
    Jan 17, 2006 at 3:26 pm
    Jan 18, 2006 at 10:49 am
  • My trace file does not contain details...i.e. TABLE ACCESS BY INDEX ROWID OTAPA_REQUEST_QUEUE (cr=2 pr=0 pw=0 time=91 us) Instead shows TABLE ACCESS BY INDEX ROWID OTAPA_REQUEST_QUEUE What am I ...
    Jan 27, 2006 at 10:31 pm
    Jan 31, 2006 at 3:21 pm
  • Hi Team, when the below is run i am getting the error. can someone help me : begin execute immediate ' select sysdate from dual;' end; * ERROR at line 3: ORA-06550: line 3, column 1: PLS-00103 ...
    Raja raoRaja rao
    Jan 24, 2006 at 1:22 pm
    Jan 24, 2006 at 6:57 pm
  • SQL alter index "SAPR3"."VBFA~0" rebuild online parallel 3 tablespace PSAPREROGI; * ERROR at line 1: ORA-12801: error signaled in parallel query server P001 ORA-01652: unable to extend temp segment ...
    Roger XuRoger Xu
    Jan 23, 2006 at 7:31 pm
    Jan 24, 2006 at 3:48 pm
  • Hi, We need to implement physical standby database. Primary and standby will be in two separate networks behind their own firewalls. Security guys dont allow to ping from one server to other server ...
    Sandeep DubeySandeep Dubey
    Jan 25, 2006 at 3:11 pm
    Jan 26, 2006 at 7:18 pm
  • The question "How do I make a table read only" has appeared more than once in this forum. The answer has always been "you can't". That answer appears to have been incorrect. This site has an ...
    Jared StillJared Still
    Jan 16, 2006 at 1:09 pm
    Jan 18, 2006 at 4:27 am
  • 343382.1 says, "One vulnerability (DBC02) is in a utility that can be forced to terminate if given long arguments, potentially allowing code of an attacker's choice to be executed. However, this ...
    Ray StellRay Stell
    Jan 31, 2006 at 1:57 pm
    Feb 8, 2006 at 6:20 am
  • Anyone else seen anything like this? Oracle, AIX 5.2 ML7 Recently migrated to new server, from Oracle 8.1.7 & AIX 5.1, and since moving to the new server we've had a few instances of horrible ...
    Allen, BrandonAllen, Brandon
    Jan 26, 2006 at 8:22 pm
    Jan 28, 2006 at 3:10 pm
  • Hello, I have a general issue with loading data into a Oracle database on solaris 8. I reduced it down to a simple statement which takes 1 second on my PC (oracle but takes 20 ...
    Jaco PoletJaco Polet
    Jan 31, 2006 at 10:11 am
    Feb 1, 2006 at 10:11 am
  • From one of the other DBAs here: "Have any of you ever seen a Select (just a select no select for update) take out a Table Exclusive lock (TX) ? we had one in SAP this morning on ZPICK01 and the ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Jan 26, 2006 at 9:22 pm
    Jan 27, 2006 at 11:30 am
  • What is the terminal release of 9iRel2 on Solaris 8 64bit now? For a while I thought it was Now I see a patchset Does oracle plan any more patchsets? What is the groups ...
    Joe SmithJoe Smith
    Jan 16, 2006 at 1:10 pm
    Jan 17, 2006 at 9:17 pm
  • Hi List, Which SQL function can help me get the file name from a string like this "C:\program files\my apps\2005\reports_New.doc".?Do We have any split function in Oracle? We are at Oracle ...
    Subbiah, NagarajanSubbiah, Nagarajan
    Jan 30, 2006 at 4:14 pm
    Mar 2, 2006 at 8:00 pm
  • Hi please if you can, I'm getting an library cache lock on an import, it seems to be related to the compilation of some procedures using database links, directed to the same database (this is because ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jan 25, 2006 at 7:21 pm
    Feb 1, 2006 at 1:36 am
  • Hey all, I'm upgrading some Oracle DBs from 8i to 9iR2 and as luck would have it, they're on (or will be) on Winders Server 2K3. So my custom POSIX script for monitoring the alert log and trace files ...
    Jesse, RichJesse, Rich
    Jan 24, 2006 at 7:33 pm
    Jan 24, 2006 at 9:37 pm
  • Another Awkward question   Can I create mine DR DB on Linux while mine Prod is on Solaris   TIA   Sanjay Yahoo! Photos – Showcase holiday pictures in hardcover  Photo Books. You design it ...
    Sanjay MishraSanjay Mishra
    Jan 16, 2006 at 2:08 pm
    Jan 16, 2006 at 4:58 pm
  • ��What is the easiest (don't care about speed/efficiency) way of moving data between sql server and oracle on linux? ...this is a process that will have to be repeated on a regular basis and the list ...
    Chris StephensChris Stephens
    Jan 26, 2006 at 2:41 pm
    Jan 26, 2006 at 5:04 pm
  • Been racking my brain to see if there is a more... elegant architecture for the following: Largish Oracle-based web app... fairly heavy traffic, up to 200GB of application data. 10g, pretty fast ...
    Murching, BobMurching, Bob
    Jan 25, 2006 at 12:47 am
    Jan 26, 2006 at 12:09 pm
  • All, I am getting a strange error with the code below. Does anyone have an explanation? thanks, Michael SQL select unique market_cd, churn_dt 2 from eisweb.eis_ret_cmbd_rpt 3 where ( churn_dt = ...
    Jan 24, 2006 at 8:20 pm
    Jan 25, 2006 at 6:33 am
  • Hi, I just wanted to know the mode of the database if its a dedicated or shared server mode. which data dictionary shall i use????? -- Thanks & Regards, T. Onkar Nath OneAPPS Enterprise Technology ...
    Onkar N TiwaryOnkar N Tiwary
    Jan 17, 2006 at 1:12 am
    Jan 17, 2006 at 8:34 am
  • Hi Team, Can som,eone help me in HTML DB setups. 9203 oracle s/w can be used to install HTML DB software patch. can someone give the patch number to be applied (any metalink doc that helps to ...
    Raja raoRaja rao
    Jan 31, 2006 at 10:09 am
    Jan 31, 2006 at 1:21 pm
  • I am having a tough time finding the right command to give me the CPU Usage on our Solaris box. If there are 100 processes currently on the system, I want something that shows 100 lines, each having ...
    Deepak SharmaDeepak Sharma
    Jan 30, 2006 at 4:21 am
    Jan 30, 2006 at 5:37 pm
  • Hi, We want to migrate 400GB data from one data center to another data center.Please suggest what are the bext way to migrate without downtime or minimize downtime. With regards -Dinesh Don�t just ...
    Seema SinghSeema Singh
    Jan 26, 2006 at 5:02 pm
    Jan 26, 2006 at 10:18 pm
  • I have a requirement to run some scripts on Windows from Oracle 9 stored procedures. The stored procedures are written in PL/SQL although Java is an option. The scripts will be .bat files or perl or ...
    John DunnJohn Dunn
    Jan 26, 2006 at 9:41 am
    Jan 26, 2006 at 1:37 pm
  • Hi Team, when i am trying to execute the following pl/sql, i am getting the below error: DECLARE CURSOR c1hs IS SELECT table_name FROM dba_tables WHERE table_name like '%ADT_ACT_TRXMST' AND owner = ...
    Raja raoRaja rao
    Jan 24, 2006 at 10:33 am
    Jan 24, 2006 at 10:14 pm
  • hi all, I have one small problem. Below is my query which is running on the sql prompt: *select username||'('||sid||','||serial#||') ospid = ' || process ||' program = ' || program ...
    Onkar N TiwaryOnkar N Tiwary
    Jan 23, 2006 at 7:22 am
    Jan 23, 2006 at 8:32 pm
  • Sigh..... Ok, I've got OID and Multi-Master Replication working. Now, I'm trying to get the Oracle client to use DNS to look up an SRV record to locate the directory server(s). With a static ...
    Bobak, MarkBobak, Mark
    Jan 16, 2006 at 2:06 pm
    Jan 17, 2006 at 12:01 pm
  • I am running 10g2 on 4 hp bp20 blades, with rhe3. I am getting many of the following: Metrics "Global Cache Average Current Get Time" is at 1.46667 Metrics "Global Cache Blocks Lost" is at 4 Metrics ...
    Steiner, RandySteiner, Randy
    Jan 30, 2006 at 2:04 pm
    Jan 31, 2006 at 11:54 pm
  • I have a requirement for some sort of messaging between oracle databases over a WAN. Basically I want an event in one database to trigger some code (PL/SQL or Java) to run on the remote database What ...
    John DunnJohn Dunn
    Jan 25, 2006 at 9:09 am
    Jan 28, 2006 at 2:28 pm
  • I am looking thru the Oracle install docs for on EL 4 on Linux86. I see no mention of the env variables: LD_ASSUME_KERNEL LD_LIBRARY_PATH did Oracle drop these vars for 10gRel2? Is ...
    Joe SmithJoe Smith
    Jan 25, 2006 at 2:40 pm
    Jan 27, 2006 at 3:27 pm
  • For those of you who have had security audits, I am wondering about a couple of things..... Does it matter if standard Oracle roles are NOT password protected? Does it only need to be non-standard ...
    J. DexJ. Dex
    Jan 24, 2006 at 3:25 pm
    Jan 24, 2006 at 10:49 pm
  • Env: Oracle 9205 RHEL3 I have situation (another post on this list) where we have severe spikes server load and db ACTIVE sessions (waits) spikes. When left alone the db and server spiral out of ...
    Chris MarquezChris Marquez
    Jan 16, 2006 at 6:38 pm
    Jan 17, 2006 at 5:03 am
  • Agreed. Getting licensing information out of Oracle is almost like pulling teeth. Getting *accurate* licensing information is *much* harder. It has been my experience that I need to ask the same ...
    Jan 31, 2006 at 11:13 pm
    Feb 1, 2006 at 9:38 am
  • Thanks. I really do understand this and that Oracle is now embracing this as the gospel. Is this a recent change as I am 99.99% sure that it did'nt always used to be this way and that under EE one ...
    Jan 31, 2006 at 9:24 pm
    Jan 31, 2006 at 10:48 pm
  • Any other differences besides: 1) does not lock the table; 2) does a full table scan instead of full index scan; ? -----Original Message----- From: oracle-l-bounce_at_freelists.org On Behalf Of ...
    Roger XuRoger Xu
    Jan 25, 2006 at 8:05 pm
    Jan 30, 2006 at 8:06 pm
  • Hi, please How secure is to use on 10gr2 sqlplus and enteprise manager on the web, I heard there are remote support. Is there some requeriments (without using oracle security option) to guarantee a ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jan 27, 2006 at 3:50 pm
    Jan 27, 2006 at 4:00 pm
  • Hi please, I create a new listener on oracle 10g, but enterprise manager still is looking for the previous listener:1521, instead the new I created listener10g:1522 Thanks -- Oracle Certified ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jan 26, 2006 at 4:10 pm
    Jan 26, 2006 at 6:43 pm
  • Hi list: Is it possible to identify stale statistic without turning on tab monitoring? Regards, Jos
    Jan 23, 2006 at 12:08 pm
    Jan 23, 2006 at 7:28 pm
  • And pay is good to ( sad smile ): $ 54 /hour. I was making $105/hour in 2000. -- http://www.freelists.org/webpage/oracle-l
    Ranko MosicRanko Mosic
    Jan 21, 2006 at 7:43 pm
    Jan 23, 2006 at 1:05 am
  • 10gR2, RHEL4, OCFS2, DL585 AMD Opteron 64bit Im running a benchmark on the above hardware using hammerora (GPL TPC like tool I saw a presention on at UK OUG 2005). All runs very fast to begin with ...
    Tim OnionsTim Onions
    Jan 17, 2006 at 9:18 am
    Jan 18, 2006 at 6:09 am
  • Hi DBAs We would like to upgrade our Windows server from 2000 to 2003. We have a Oracle database version 9.2 running on that server. Can you give me your good/bad stories about that ? Thank you Luc ...
    Luc DemancheLuc Demanche
    Jan 30, 2006 at 7:27 pm
    Feb 6, 2006 at 7:51 pm
  • We are planning a switch from Windows to Linux for our systems. As a result, we can no longer use Veritas Backupexec and must now switch to RMAN. Since we are NOT going to connect a tape drive to ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jan 31, 2006 at 7:36 pm
    Jan 31, 2006 at 10:05 pm
  • I thought "fast full index scan" was just another name for "index full scan"? -----Original Message----- From: Jonathan Lewis Sent: Monday, January 30, 2006 2:06 PM To: tanel.poder.003_at_mail.ee ...
    Roger XuRoger Xu
    Jan 30, 2006 at 9:20 pm
    Jan 30, 2006 at 9:43 pm
  • I am running 10g with asm and currently 1 control file. If I want to multiplex the control file, I know I have to shutdown the database and make a copy of the control file, but since the control file ...
    Steiner, RandySteiner, Randy
    Jan 25, 2006 at 3:49 pm
    Jan 26, 2006 at 11:01 pm
Group Navigation
period‹ prev | Jan 2006 | next ›
Group Overview
grouporacle-l @

133 users for January 2006

Bobak, Mark: 23 posts Jared Still: 23 posts MARK BRINSMEAD: 18 posts Juan Carlos Reyes Pacheco: 16 posts Tanel Põder: 14 posts Ray Stell: 13 posts Kevin Closson: 11 posts Mladen Gogala: 11 posts Paul Baumgartel: 11 posts Paul Drake: 9 posts Raja rao: 9 posts Alex Gorbachev: 8 posts Edgar Chupit: 8 posts Reidy, Ron: 8 posts Smith, Ron: 8 posts Carel-Jan Engel: 7 posts Christo Kutrovsky: 6 posts David Sharples: 6 posts JayMiller_at_TDWaterhouse.com: 6 posts Jesse, Rich: 6 posts
show more