Search Discussions

93 discussions - 170 posts

  • Janine, The undo_retention parameter is the amount of time in seconds that oracle will try to maintain undo to rebuild queries. You can still run out of space. What does this query show: select * ...
    Jared StillJared Still
    May 25, 2010 at 10:30 pm
    May 26, 2010 at 1:36 pm
  • we do have our own structure wich will not be changed anytime (hopefully) cu Jörg Jost -- http://www.freelists.org/webpage/oracle-l
    May 11, 2010 at 12:53 pm
    May 12, 2010 at 4:36 am
  • And did you notice the Red ORACLE on the outside of the place where the final fight took place? It was an oblique shot, so it wasn't easy to see, but I'm sure that was O-R-A-C-L-E on the out side of ...
    Ric Van DykeRic Van Dyke
    May 10, 2010 at 7:54 pm
    May 11, 2010 at 3:55 pm
  • WHY do you want an SGA that's 50G in size??? What is the purpose of this exercise? David Fitzjarrell From: Sanjay Mishra To: oracle-l@freelists.org Sent: Tue, May 4, 2010 7:02:11 PM Subject: SGA ...
    David FitzjarrellDavid Fitzjarrell
    May 4, 2010 at 11:33 pm
    May 7, 2010 at 2:54 pm
  • Hi Keith Don't post HTML formatted mails. Use plain text Don't post your SPAM here. There are enough job sites for hiring Oracle guys. This is a technical list. cheers Sven -- ...
    Sven AluoorSven Aluoor
    May 31, 2010 at 2:36 pm
    Jun 2, 2010 at 12:00 pm
  • Hi William, The books by David Knoxx are awesome.. the "Effective Oracle Database 10g Security by Design" will give you foundation on Oracle security.. I like the part where he applied the proxy ...
    Karl AraoKarl Arao
    May 23, 2010 at 12:28 am
    May 24, 2010 at 4:05 pm
  • Solaris 9, veritas 3.5, hitachi san. Mount points look like: /u01 on /dev/vx/dsk/rootdg/u01 read/write/setuid/delaylog/largefiles/qio/ioerror=mwdisable/dev=3d40005 on Thu Mar 18 23:25:59 2010 /u02 on ...
    Neil KodnerNeil Kodner
    May 4, 2010 at 8:17 pm
    May 24, 2010 at 1:36 pm
  • Try to restart the listener. Harel Safra (Sent from my phone, excuse the terseness) ב-11/05/2010, בשעה 00:43, Saad Khan כתב/×”: Hi fellows, We have a oracle environment with 64-bit oracle ...
    Harel SafraHarel Safra
    May 11, 2010 at 4:33 am
    May 11, 2010 at 7:37 pm
  • You're attempting to connect twice, so the error is from the default connect of sqlplus. Use sqplus -S /nolog in the command line to prevent this. Ron Crisco On Mon, May 10, 2010 at 8:37 AM, Ojha, ...
    Ron CriscoRon Crisco
    May 10, 2010 at 1:50 pm
    May 10, 2010 at 2:36 pm
  • Hi Subodh, Sorry, but I think you have it backwards - the OS block size must be equal to or smaller than the DB block size: From http://public.dhe.ibm.com/partnerworld/pub/whitepaper/162b6.pdf: "put ...
    Allen, BrandonAllen, Brandon
    May 25, 2010 at 6:57 pm
    May 27, 2010 at 6:11 pm
  • Your understanding is correct. I strongly suggest that you actually do turn off the packs in GC and then review whether or not the product is still useful. You should also be aware that notifications ...
    Niall LitchfieldNiall Litchfield
    May 24, 2010 at 3:59 pm
    May 25, 2010 at 7:57 pm
  • OK, so I'm looking for some help with this one again- I've found a compromise that has been quite successful for both groups so far: sorted hash cluster. I've been able to easily sort 1.4 billion ...
    Kellyn PedersenKellyn Pedersen
    May 12, 2010 at 2:33 pm
    May 12, 2010 at 10:15 pm
  • Here's a shell script that I have used and have had to recover tablespace a few times because of crashed drives. I elected to receive email on successful backup because at one time, the mail daemon ...
    Michael DinhMichael Dinh
    May 4, 2010 at 9:55 pm
    May 7, 2010 at 2:17 pm
  • Hi all, do you use any query or method to discover how much space you can save on a datafile? I want to say...suppose to shrink your datafile, which is the minimum size, according to the highest HWM ...
    Stefano CislaghiStefano Cislaghi
    May 3, 2010 at 7:49 am
    May 3, 2010 at 3:36 pm
  • Hi Claudia, It *is* possible to have a toy database running natively on a Mac, with the caveat that it's only. You also have the option of running other versions in a virtualized ...
    John PiwowarJohn Piwowar
    May 31, 2010 at 5:36 pm
    May 31, 2010 at 9:16 pm
  • A client made this comment. "One off patches are not regression tested by Oracle. " Is this true? TIA The information contained in this communication is confidential, is intended only for the use of ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    May 29, 2010 at 12:32 pm
    May 29, 2010 at 2:41 pm
  • "For all the logs it thought it backed up. It was RMAN that deleted the logs, so the fact that they are missing does not concern it. Is there some way to tell it to forget it ever saw those logs and ...
    Harel SafraHarel Safra
    May 27, 2010 at 2:19 pm
    May 28, 2010 at 10:18 pm
  • It is possible. Specify the version of the database 2010/5/26 Nagaraj S -- http://www.freelists.org/webpage/oracle-l
    Andrey khudyakovAndrey khudyakov
    May 26, 2010 at 12:53 pm
    May 27, 2010 at 10:56 am
  • Hi All, How to decide on the values of the parameter PARALLEL_SERVER_TARGET. As per the documentation it says the PARALLEL_SERVER_TARGET should be less than PARALLE_MAX_SERVER. I have enabled the ...
    Anupam PandeyAnupam Pandey
    May 26, 2010 at 6:38 am
    May 26, 2010 at 6:51 am
  • I am installing Oracle 11 database release 2 on a server where 10G is already installed. I am specifying different paths for the Oracle 11 install...but when the install starts it tries to write to ...
    John DunnJohn Dunn
    May 24, 2010 at 7:56 am
    May 25, 2010 at 1:54 am
  • It depends on what you are doing. But if you have resources and doing FTS of large table then parallel can be very helpful. On Mon, May 24, 2010 at 1:14 PM, Charlotte Hammond < ...
    Taral DesaiTaral Desai
    May 24, 2010 at 9:55 pm
    May 24, 2010 at 10:29 pm
  • <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" Vamshi, You have a partitioned fact table which is (evidently) range partitioned on a DATE column, though you don't indicate which of ...
    Tim GormanTim Gorman
    May 22, 2010 at 5:16 pm
    May 23, 2010 at 4:42 am
  • Hi, We have several environments with 10g ( in prod and non-prod,and we get advantage of AWR reports to get the top sqls that are run within any particular period. We've run into a situation ...
    Saad KhanSaad Khan
    May 21, 2010 at 7:17 pm
    May 22, 2010 at 6:57 am
  • Any of the instant clients should work. Depends if you are running with the 32 or 64bit version of Windows 7 you may have to jig things around a little to get your client to work. What is your end ...
    John ScolesJohn Scoles
    May 20, 2010 at 12:38 pm
    May 20, 2010 at 3:58 pm
  • To avoid guessing I'd want the alert.log and the output of the rman session. I have a guess and a question all the same.. Guess: Because RMAN knows it doesn't need to because the archivelog itself is ...
    Niall LitchfieldNiall Litchfield
    May 20, 2010 at 11:06 am
    May 20, 2010 at 11:11 am
  • Anyone else having trouble downloading from otn? -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-l
    Andrew KerberAndrew Kerber
    May 18, 2010 at 1:54 am
    May 18, 2010 at 3:15 am
  • There is a readme with each CPU that contains the view application instructions and does indeed tell you that you don't need to reapply the fix to databases that have already been fixed. I definitely ...
    Niall LitchfieldNiall Litchfield
    May 13, 2010 at 2:57 pm
    May 18, 2010 at 2:33 am
  • Hi I have a query which runs against 64 external tables, the query uses union all to return the results. The query is really slow even with high parallel degree and I noticed that it is because in ...
    LS ChengLS Cheng
    May 15, 2010 at 12:52 pm
    May 17, 2010 at 5:35 am
  • Hi all, just a question to discuss. I've a table want to be partitioned. Partition key should be a date field. This table will retain data for last 40 days from sysdate, i.e. delete * from mytable ...
    Stefano CislaghiStefano Cislaghi
    May 14, 2010 at 10:05 am
    May 14, 2010 at 10:17 am
  • Hello everyone, I am facing a strange issue in oracle 11g. It may not be a database issue, can be related to network also. In brief, Not able to execute sql statements from my workstation (oracle 11g ...
    gidhin K. joygidhin K. joy
    May 12, 2010 at 1:17 pm
    May 14, 2010 at 6:13 am
  • Check out steven chan's blog, he will have the relevant certification information (eg http://blogs.oracle.com/stevenChan/2009/09/internet_explorer_8_certified_ebs12.html) together with the tech stack ...
    Niall LitchfieldNiall Litchfield
    May 13, 2010 at 6:57 pm
    May 13, 2010 at 9:37 pm
  • I can't answer from the EBS but there is a performance penalty to forced logging but its a requirement for standby to place nice :) joe Joe Testa, Oracle Certified Professional Senior Engineering & ...
    May 13, 2010 at 5:56 pm
    May 13, 2010 at 6:54 pm
  • Hi, What database version ? Did you try change gathering statistic from estimating to calculating and use histograms ? -- Marcin Przepiorowski http://oracleprof.blogspot.com -- ...
    Marcin PrzepiorowskiMarcin Przepiorowski
    May 12, 2010 at 7:58 pm
    May 12, 2010 at 9:34 pm
  • (sending again - over quoting) Freek, The OP stated that he's using synchronous replication. In such a replication a bit is not acknowledged as written to the storage array until it was written to ...
    (unknown charset) Harel Safra(unknown charset) Harel Safra
    May 8, 2010 at 5:57 pm
    May 11, 2010 at 2:49 am
  • According to Oracle, materialized views in a refresh group are guaranteed to be transactionally consistent when they are refreshed. This not only means that there's no commit in the middle of a ...
    Yong HuangYong Huang
    May 1, 2010 at 2:40 am
    May 10, 2010 at 4:16 pm
  • Could you give us some more details about your DR solution? How do you replicate the data (data guard, storage replication,...)? What servers do you have in the DR site? etc. Harel Safra (Sent from ...
    Harel SafraHarel Safra
    May 7, 2010 at 9:16 pm
    May 8, 2010 at 8:56 am
  • Hi all, Anyone have any issues with SQL script names in Unix (AIX specifically). This is in relation to S. Feuerstein's fine PL/SQL error handling library Quest Error Manager ...
    Tony SequeiraTony Sequeira
    May 6, 2010 at 6:57 pm
    May 6, 2010 at 8:35 pm
  • You can find the asktom queries in the following link : http://www.oracle.com/technology/oramag/oracle/04-sep/o54asktom.html Go to the last paragraph. You also have a query to know what at the end of ...
    Bertrand GuillauminBertrand Guillaumin
    May 3, 2010 at 8:03 am
    May 3, 2010 at 8:15 am
  • I am doing ORACLE 11G Data Guard testing. I set up following entry on init.ora : standby_archive_dest='LOCATION=/Archive/DBSBY/arch/arch' when database startup it show "parameter depresate". since ...
    Dba1 mccDba1 mcc
    May 3, 2010 at 1:26 am
    May 3, 2010 at 1:54 am
  • Jared, Not directly related to this subject. But I find that a connection string entry (stanza) can be flattened into one line, no space at line beginning, and this entry still works. In fact, this ...
    Yong HuangYong Huang
    May 1, 2010 at 5:47 pm
    May 1, 2010 at 6:06 pm
  • dear lists, 2 RAC nodes on linux rhel5.4 itanium interconnect I configure: - bonding lacp mode - mtu 9000 - 2 switches, trunk configuration for failover got this error..... even very rare, ...
    Ujang JaenudinUjang Jaenudin
    May 30, 2010 at 2:37 pm
    May 30, 2010 at 2:37 pm
  • Is the ETL code doing INSERT /*+ APPEND */ ? That will always insert above the high water mark, never using existing empty space. From: oracle-l-bounce_at_freelists.org On Behalf Of Vamshi Damidi ...
    Warren PuziewiczWarren Puziewicz
    May 28, 2010 at 3:14 pm
    May 28, 2010 at 3:14 pm
  • you are correct... this is one of the groses flaws of standby/dataguard in Oracle... it's even worse when you are using RAC on ASM, since the job NEEDS to be an RMAN job and it cannot be a regular ...
    Guillermo Alan BortGuillermo Alan Bort
    May 28, 2010 at 2:53 pm
    May 28, 2010 at 2:53 pm
  • Oracle 32bit Linux P_A_T set to 2G We have a particular SQL operation where we need to add values from two different tables and insert them into a target table. (Thus, for every "key ...
    Hemant K ChitaleHemant K Chitale
    May 27, 2010 at 3:36 pm
    May 27, 2010 at 3:36 pm
  • Sorry Stefano, in this moment I'm not able to attach the log file. The behaviour is that after the 2nd command I write in 1st e-mail the system simply don't reply. It seems not ending loop. So my ...
    Alessandro LiaAlessandro Lia
    May 27, 2010 at 8:17 am
    May 27, 2010 at 8:17 am
  • Hi Ram, Both actually. If you set up the observer with DGMGRL, you can only put it in one location. However, if you set it up with OEM (one of the few worthwhile features of OEM that doesn't cost ...
    Kathryn axelrodKathryn axelrod
    May 27, 2010 at 6:29 am
    May 27, 2010 at 6:29 am
  • Right, I just do a basic SELECT from dba_outstanding_alerts, and repeat via cron every X minutes. -----Original Message----- From: oracle-l-bounce_at_freelists.org On Behalf Of Rich Jesse I'm ...
    Allen, BrandonAllen, Brandon
    May 26, 2010 at 9:16 pm
    May 26, 2010 at 9:16 pm
  • However, the OP's asking specifically about *archived* redos. If SETALL is used, redo log files are automagially attempted to be opened CIO on AIX. At least on my 5.3 system they are as shown the ...
    Rich JesseRich Jesse
    May 25, 2010 at 9:17 pm
    May 25, 2010 at 9:17 pm
  • You need to create the dependency with the ASM disk groups you use. To check if you have set the dependency you use this command: [oracle_at_server ~]$ srvctl config database -d dev Database unique ...
    Martin BachMartin Bach
    May 25, 2010 at 8:31 am
    May 25, 2010 at 8:31 am
  • Niall, It's not surprising, I've seen it happen many times. When the data files are in backup mode the SCNs in their headers are frozen. If the database crashes (server reboot/shutdown abort/instance ...
    Harel SafraHarel Safra
    May 25, 2010 at 6:19 am
    May 25, 2010 at 6:19 am
Group Navigation
period‹ prev | May 2010 | next ›
Group Overview
grouporacle-l @

102 users for May 2010

(unknown charset) Harel Safra: 9 posts Jared Still: 8 posts Niall Litchfield: 6 posts Yong Huang: 6 posts Greg Rahn: 5 posts Kellyn Pedersen: 5 posts Allen, Brandon: 4 posts Guillermo Alan Bort: 3 posts John Piwowar: 3 posts Neil Kodner: 3 posts Saad Khan: 3 posts Subodh Deshpande: 3 posts Sven Aluoor: 3 posts Andrew Kerber: 2 posts Anupam Pandey: 2 posts Cary Millsap: 2 posts Crisler, Jon: 2 posts Don Seiler: 2 posts gidhin K. joy: 2 posts Jack van Zanen: 2 posts
show more