Search Discussions

129 discussions - 577 posts

  • Does anyone know when is oracle 11gR2 (11.2) getting released. I am sure moment that comes out 11.1 will become obsolete as was the case with 10g and 9i. I asked Tom Kyte in one of key note in UKOUG ...
    Vishal GuptaVishal Gupta
    Jan 7, 2009 at 8:14 pm
    Aug 25, 2009 at 5:08 pm
  • Hi there, In Oracle 10 I use a script to export my users and import in another database. We now installed oracle 11 and when I query the dba_users view, the password isn't shown. Is there a parameter ...
    Jan 19, 2009 at 11:45 am
    Jan 28, 2009 at 6:43 pm
  • Hi all, I have a 9i on Windows2003 with no backup. Database was open while drive where redo logs resided was gone. So I lost all redo logs. I shutdown d/b, mounted it, backed up controlfile to ...
    Eugene PipkoEugene Pipko
    Jan 23, 2009 at 8:31 pm
    Jan 26, 2009 at 6:56 pm
  • All, we have a 170G db on 9) . and I see that it currently is taking nearly 10 hour+ to do a rman backup . when I see this in grid control I see the rman session keeps waiting on this ...
    Jan 30, 2009 at 7:10 am
    Feb 2, 2009 at 6:12 pm
  • Hi Jon, Could you please provide more details on the bad performance you've seen with Oracle on VMWare? I've tested performance with 64-bit Oracle on OEL 4 & 5 both running on VMWare ESX 3.5 ...
    Allen, BrandonAllen, Brandon
    Jan 2, 2009 at 5:41 pm
    Jan 2, 2009 at 11:04 pm
  • Hi all Anyone's using data guard fast-start failover ? What are the experiences ? What about split brain? Does it interfere heavily with normal database activities? Any other comments? Thank you in ...
    Jan 16, 2009 at 7:27 am
    Jan 22, 2009 at 11:50 am
  • Hello all, We have 6 databases that could be classified as smaller data warehouses - each of them is 2-7 terabytes in size. These were running RDBMS and are now being upgraded by the vendor ...
    Lou AvramiLou Avrami
    Jan 23, 2009 at 9:53 pm
    Jan 26, 2009 at 8:24 am
  • I've got a backup script that runs fine on AIX. I copied it over to Linux, but it doesn't work and I get the following when trying to execute it which looks like something related to the shell ...
    J. DexJ. Dex
    Jan 5, 2009 at 11:45 pm
    Jan 6, 2009 at 7:11 pm
  • Anyone using Oracle's version of Linux from their web site?? Dick Goulet Senior Oracle DBA PAREXEL International 2 Federal St Billerica, MA 01821 978.313.3426 Richard.Goulet_at_PAREXEL.COM The ...
    Goulet, RichardGoulet, Richard
    Jan 2, 2009 at 8:24 pm
    Jan 5, 2009 at 7:14 pm
  • Is there a sesstat which I can look at to monitor the number of active autonomous transactions in a session. I would like to monitor this in trace or my debug package to resolve an issue. -- ...
    Ethan PostEthan Post
    Jan 20, 2009 at 9:33 pm
    Jan 31, 2009 at 4:07 am
  • Alan, I think that the best way to address such issues is to place the ball back into their camp and ask them to tell you why they think a reboot will solve the problem. If they can provide a ...
    D'Hooge FreekD'Hooge Freek
    Jan 19, 2009 at 9:55 am
    Jan 19, 2009 at 7:59 pm
  • I was under the impression that the only way to integrate windows accounts with Oracle database authentication was to purchase the Advanced Security options and make use of the Kerberos stuff. The ...
    Stephens, ChrisStephens, Chris
    Jan 12, 2009 at 8:56 pm
    Jan 19, 2009 at 5:45 am
  • Listers, When I kill a session and the status shows as "KILLED" in v$session, I assumed that the rollback is taking place. I am not sure what is happening here: SYS_at_PROD select sid,saddr, serial#, ...
    Ram RamanRam Raman
    Jan 29, 2009 at 10:31 pm
    Jan 30, 2009 at 6:24 pm
  • Anyone know how to determine when system statistics were gathered? IE, the last time? Thanks! - Chris -- http://www.freelists.org/webpage/oracle-l
    Newman, ChristopherNewman, Christopher
    Jan 23, 2009 at 9:55 pm
    Jan 24, 2009 at 1:30 am
  • Okay, I need to know if there exists a best practices document that I can't find anywhere yet. I need to find a way to justify (or change my way of thinking). I have a data warehouse I have heavily ...
    April WellsApril Wells
    Jan 13, 2009 at 3:31 pm
    Jul 7, 2009 at 3:15 pm
  • Hi, Oracle EE - I know Win 2003 Server SE SP1 I've been asked to look at converting the the 2 node RAC, to a single instance database, running on node 1 of the old RAC system. SAN hardware ...
    Tony SequeiraTony Sequeira
    Jan 31, 2009 at 7:09 pm
    Feb 4, 2009 at 3:59 pm
  • What questions do you think are the most important to ask someone related to backup and recovery? -- http://www.freelists.org/webpage/oracle-l
    Dba DBADba DBA
    Jan 31, 2009 at 6:29 pm
    Feb 4, 2009 at 3:36 pm
  • What's the DB version? If it's 9i+, are you using bind variable peeking? If so, then the plan with the literal should be the same as the plan with the bind variable unless the bind statement is ...
    Allen, BrandonAllen, Brandon
    Jan 9, 2009 at 10:47 pm
    Jan 13, 2009 at 7:55 pm
  • Greetings, One of my databases is Oracle SE running on 32-bit RHEL4. I am building a new server running 64-bit RHEL4 and I will install Oracle EE on this server. My goal is to ...
    William WagmanWilliam Wagman
    Jan 9, 2009 at 11:28 pm
    Jan 12, 2009 at 6:39 pm
  • Have an ongoing SR for this. For clusters ( as well as on Solaris 10, where we had retained css diagwait at the default value of 0.5, experienced crashes.Nothing in the CRS logs ...
    Jan 2, 2009 at 2:00 pm
    Jan 8, 2009 at 2:22 pm
  • Hi, I am trying awk to get the first word from each line in a file : I am doing : BEGIN { FS=":" } {print $1} For the first line : it prints the first work. For other lines it prints other words ...
    A JoshiA Joshi
    Jan 28, 2009 at 12:25 am
    Feb 7, 2009 at 8:27 pm
  • I am working on a system that uses oracle con-text. If I conduct the following search from sql using the contains clause, my results are not consistent. If anyone has any ideas on what may be wrong, ...
    Robert BudaRobert Buda
    Jan 26, 2009 at 3:43 pm
    Jan 27, 2009 at 12:19 pm
  • Alter table .... modify default attributes tablespace if this table has partitions, use: Alter table ... modify default attributes for partition tablespace HTH D. -- ...
    David BallesterDavid Ballester
    Jan 29, 2009 at 3:31 pm
    Feb 9, 2009 at 4:49 pm
  • We have few very large export dmp files, which fill up the disk, I am looking to send these dmp files directly to tsm(tape). Can someone guide me how i can do that? an example would be helpful ...
    Arif GulzarArif Gulzar
    Jan 30, 2009 at 9:13 pm
    Feb 5, 2009 at 8:59 am
  • Hi, is it possible to install an EM Grid Control Agent ( on Debian 4? runInstaller complains about an uncertified operating system and exits, but maybe there is a workaround? We'd like to ...
    Ingrid VoigtIngrid Voigt
    Jan 28, 2009 at 11:30 am
    Jan 28, 2009 at 7:41 pm
  • Dear list, does the index build order matter in any way? There's rumor that the order in which indexes are built does affect query performance. We are using 10gR2, but the "problem" is interesting in ...
    Martin KlierMartin Klier
    Jan 27, 2009 at 8:13 am
    Jan 28, 2009 at 5:18 pm
  • Hi, For : OLTP database Oracle version : 10G OS : SunSolaris For a procedure taking a long time : I have taken a 10046 trace. From that I can do tkprof and get the times for individual sql. Now : How ...
    A JoshiA Joshi
    Jan 22, 2009 at 4:02 pm
    Jan 28, 2009 at 2:08 am
  • So I'm revisiting the MAA whitepapers http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10g_RACPrimaryRACPhysicalStandby.pdf with a view to getting my old notes on how to setup ...
    Niall LitchfieldNiall Litchfield
    Jan 22, 2009 at 5:48 pm
    Jan 24, 2009 at 2:57 pm
  • Greetings, If you are running RMAN on the primary RMAN will not delete archive logs on the primary if they are still needed on the standby, see Metalink note 374421.1 and other RMAN/Dataguard ...
    William WagmanWilliam Wagman
    Jan 13, 2009 at 5:06 pm
    Jan 14, 2009 at 3:54 pm
  • From the 9i SQL manual: MONITORING Clause Specify MONITORING if you want Oracle to collect modification statistics on *table*. These statistics are estimates of the number of rows affected by DML ...
    Jared StillJared Still
    Jan 8, 2009 at 7:53 pm
    Jan 9, 2009 at 6:13 pm
  • I turned on audit_sys_operations in a dev database but nothing seems to be being added to the sys.aud$ table. SQL show parameter audit_sys_operations; NAME TYPE VALUE ...
    Douglas CowlesDouglas Cowles
    Jan 7, 2009 at 6:34 pm
    Jan 8, 2009 at 9:06 am
  • Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi List, once again I'm coming up with a behaviour of Oracle rdbms which I can not explain to ...
    Martin BergerMartin Berger
    Jan 2, 2009 at 11:15 am
    Jan 7, 2009 at 10:33 am
  • Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Gurus... Good Morning. I need help on the below issue. I did an refresh of production data ...
    Nagaraj SNagaraj S
    Jan 2, 2009 at 12:24 pm
    Jan 5, 2009 at 6:03 pm
  • Hi, Has anyone on this list had experience removing a node from an Oracle RAC cluster when that node is down/gone? In other words, does the node you are trying to remove have to be up for you to ...
    A EbadiA Ebadi
    Jan 14, 2009 at 5:55 pm
    Apr 27, 2009 at 10:27 pm
  • Hi I am trying to troubleshoot a deadlock issue in oracle10g RAC environment using weblogic server. I tried searching metalink but did not receive any hits for a document that can explain me how to ...
    Jan 30, 2009 at 12:22 pm
    Feb 14, 2009 at 8:07 pm
  • Hi I have inherited a database where the indexes alone are in the 32k block tablespaces. Now without any documentation or anything for a hint i am just wundering why did the original designers design ...
    Jan 29, 2009 at 7:03 am
    Jan 30, 2009 at 12:06 am
  • Hi all.., This may be very simple but I guess I need experts help for the following in oracle 10g database :- select * from xx_case; pos_id case_id 2 C1 2 C2 select * from xx_box; pos_id box_id 2 B1 ...
    Krishan GuptaKrishan Gupta
    Jan 20, 2009 at 5:28 pm
    Jan 21, 2009 at 4:37 pm
  • Oracle EE Logical standby database w/dataguard I'm working with Oracle support on a performance issue, and they want me to run the sqlt scripts to gather some information. However, when I ...
    Jason HeinrichJason Heinrich
    Jan 8, 2009 at 10:36 pm
    Jan 13, 2009 at 8:36 pm
  • I realize Oracle has some significant Intellectual Property Rights tied up with the SQL Tuning package. However, I am trying to tune a particular query by hand and finding the SQL Tuning package to ...
    Charles SchultzCharles Schultz
    Jan 8, 2009 at 4:02 pm
    Jan 8, 2009 at 10:11 pm
  • This is a 10g database (10.2) monitored through Grid Control. Every once in a while we get a TNS timeout on the EM side, and at the same time we get something like this in the listener log ...
    Guillermo Alan BortGuillermo Alan Bort
    Jan 29, 2009 at 4:07 pm
    Jan 31, 2009 at 9:01 pm
  • Oracle 11 - Redhat Linux 64bit How do you failover over in dataguard/(AKA Log shipping) to another site with a completely different IP range.? Where does a users url get redirected ? and what about ...
    Howard LathamHoward Latham
    Jan 29, 2009 at 9:39 am
    Jan 29, 2009 at 9:48 pm
  • Hey all, Yes, I'm traveling down the dark path of Oracle traffic over a WAN. Naturally, I want to test changing the SDU to optimize it. Client is 32-bit WinXP, server is AIX 5.3TL8 and both are using ...
    Rich JesseRich Jesse
    Jan 28, 2009 at 9:50 pm
    Jan 29, 2009 at 7:40 pm
  • All, and on AIX 5.2 I'm trying to use ODCIAggregate and Tom Kyte's stringAgg function to concatenate a number in multiple rows into a string. Below is the output of the select ...
    Stauffer, Robert GStauffer, Robert G
    Jan 23, 2009 at 9:57 pm
    Jan 28, 2009 at 2:38 pm
  • Hello all, I got the following error in alert log and instance crashed, Has any experienced such ORA-00600 : [kcbzfb_3] ? Errors in file /u300/app/oracle/admin/SIYPROD/bdump/siyprod_j000_5157.trc ...
    Arvind KumarArvind Kumar
    Jan 27, 2009 at 7:55 pm
    Jan 27, 2009 at 8:54 pm
  • Has anyone worked with the DBD:Oracle Perl module? If so, can you link this into the regular Oracle client or does it have to use the Oracle Instant client? Also, any good links to websites that can ...
    Arnold, SandraArnold, Sandra
    Jan 22, 2009 at 9:35 pm
    Jan 22, 2009 at 11:29 pm
  • Hi We have a script that has connection issues and one of the things we see is that around the time it tries to connect we have several files with names like ".blocked.00d5c" (last 5 characters ...
    Jack van ZanenJack van Zanen
    Jan 21, 2009 at 11:15 pm
    Jan 22, 2009 at 9:53 am
  • RMAN will not allow you to register 11g databases in repository built in a 10g database. The repository must be at least as high a version of Oracle as the databases to be registered. You can't ...
    Jared StillJared Still
    Jan 20, 2009 at 10:07 pm
    Jan 21, 2009 at 5:34 pm
  • Hi List, After a migration from 9i to I was asked about a strange increasing of AVG_ROW_LEN on a table with a LOB. Can anyone give me a hint what happens? I tried to simplify the case and ...
    Martin BergerMartin Berger
    Jan 17, 2009 at 8:21 pm
    Jan 19, 2009 at 8:05 pm
  • Hey all, I'm doing some IO testing on new hardware from an Oracle on AIX. One of my tests involves FTSing a 45GB table with our buffer cache set to 3.3GB. My testing with done with minimal ...
    Rich JesseRich Jesse
    Jan 12, 2009 at 5:06 pm
    Jan 14, 2009 at 2:28 am
  • our company plan to use ORACLE ERP and we are new to this area. Does there has ant ORACLE ERP mail list ot Forurms which we can get help? Thanks. -- http://www.freelists.org/webpage/oracle-l
    Dba1 mccDba1 mcc
    Jan 11, 2009 at 11:56 pm
    Jan 12, 2009 at 4:07 pm
Group Navigation
period‹ prev | Jan 2009 | next ›
Group Overview
grouporacle-l @

177 users for January 2009

Jared Still: 41 posts Allen, Brandon: 22 posts : 18 posts Martin Berger: 18 posts Niall Litchfield: 15 posts Rich Jesse: 14 posts Yong Huang: 13 posts Alex Fatkulin: 12 posts Goulet, Richard(B: 11 posts Robert Freeman: 11 posts Tim Gorman: 11 posts Greg Rahn: 10 posts Mark W. Farnham: 9 posts Michael Fontana: 9 posts A Joshi: 8 posts Guillermo Alan Bort: 8 posts Matthew Zito: 8 posts William Wagman: 8 posts Bobak, Mark: 7 posts Dan Norris: 7 posts
show more