Search Discussions

92 discussions - 260 posts

  • All, Looking for any information on how much does a oracle DBA makes in the US Universities thanks Kart -- http://www.freelists.org/webpage/oracle-l
    K RK R
    Oct 27, 2010 at 12:55 am
    Nov 1, 2010 at 7:53 pm
  • Be very careful - A collegue once ran an Oracle upgrade script twice and ended up with a bricked database. -- Howard A. Latham Sent from my Nokia N97 -- http://www.freelists.org/webpage/oracle-l
    Howard LathamHoward Latham
    Oct 21, 2010 at 12:37 pm
    Oct 21, 2010 at 5:35 pm
  • Has anyone checked into the accuracy and reliability of AWR SQL stats? From checks I've done it appears that a lot of SQL statements are not getting captured in AWR snapshots. Here's our config ...
    Herring Dave - dherriHerring Dave - dherri
    Oct 25, 2010 at 10:07 pm
    Nov 2, 2010 at 8:05 pm
  • By the way, I'd forgotten this information could be found in v$sql_bind_capture. It's amazing how much detail is captured by oracle these days! From: oracle-l-bounce_at_freelists.org On Behalf Of ...
    Stephens, ChrisStephens, Chris
    Oct 19, 2010 at 2:36 pm
    Oct 21, 2010 at 9:18 pm
  • Wing, prayer, rabbit's foot, four leaf clover... Sorry, couldn't resist.... :D Dataguard and logical standbys for Oracle, replication in SQL Server and "a poor man's RAC" for MySQL. Kellyn Pedersen ...
    Kellyn PedersenKellyn Pedersen
    Oct 21, 2010 at 12:41 am
    Oct 28, 2010 at 3:37 pm
  • It might be a clunky way of resizing the UNDO space, but I generally create a new undo tablespace, set that one to be the default, drop the current and be done with it. You can also use this query to ...
    Sheehan, JeremySheehan, Jeremy
    Oct 19, 2010 at 2:53 pm
    Oct 21, 2010 at 3:51 am
  • Hi, two possibile solution: Open SQLPlus and even with instance in idle execute: create pfile='/tmp/pfilename' from spfile='+ASM/path/to/spfile'; Modify the pfile and then following the same ...
    Stefano CislaghiStefano Cislaghi
    Oct 11, 2010 at 6:17 pm
    Oct 12, 2010 at 8:46 am
  • "Why should you expect to be able to do more processing for the same money?" Because that is the path other vendors have chosen. We run MS SQL Server here along with Oracle and MS only counts ...
    David MitchellDavid Mitchell
    Oct 1, 2010 at 2:40 pm
    Oct 1, 2010 at 5:16 pm
  • Hi all, I want to know..in our environment we have backup retention policy set in terms of days and also we do not take more than one copy of backup..and I think this is what is generally followed. I ...
    Subodh DeshpandeSubodh Deshpande
    Oct 30, 2010 at 8:29 am
    Oct 30, 2010 at 9:45 pm
  • You can also get overall system memory info from /proc/meminfo. Linux wants to suck up most available (free) memory for file system cache, so the free command always reports a pretty low value ...
    Kerry OsborneKerry Osborne
    Oct 21, 2010 at 12:47 pm
    Oct 22, 2010 at 4:56 am
  • If this is RAC then also check gv$session. -- Thanks & Regards, Taral Desai -- http://www.freelists.org/webpage/oracle-l
    Taral DesaiTaral Desai
    Oct 4, 2010 at 1:15 pm
    Oct 6, 2010 at 2:57 pm
  • Nope. Of course it could send in every possible value to the function at least twice and verify that it gets the same results every time... Maybe when we have Star Trek type computers they will be ...
    Ric Van DykeRic Van Dyke
    Oct 29, 2010 at 7:52 pm
    Oct 30, 2010 at 5:14 pm
  • Avadhani, What your client is asking for is completely impossible. For starters your direct upgrade part is 8.1.7 (or lower) - - - 11.2 and your moving os platforms which means a ...
    Goulet, RichardGoulet, Richard
    Oct 13, 2010 at 2:10 pm
    Oct 14, 2010 at 2:36 pm
  • Anyone point me in the right direction for an 11g Linux Script to monitor Dataguard lag? I have googled and looked on oracle Support. -- Howard A. Latham Sent from my Nokia N97 -- ...
    Howard LathamHoward Latham
    Oct 5, 2010 at 1:09 pm
    Oct 6, 2010 at 3:37 pm
  • Hi. Oracle fully support and certifiy against both the new Oracle kernel and the RHEL kernel, so there is no pressing need to switch. Should you switch? As Jared said previously, there aren't any ...
    Tim HallTim Hall
    Oct 1, 2010 at 2:47 pm
    Oct 4, 2010 at 1:29 pm
  • I am seeking information on VMWAREs virtualization software and how it impacts processor licensing for Oracle. Any information would be appreciated. Jeffrey Beckstrom Database Administrator Greater ...
    Jeffrey BeckstromJeffrey Beckstrom
    Oct 26, 2010 at 11:55 am
    Oct 29, 2010 at 1:06 pm
  • Possibly- there are issues with MTS and they want enough headroom so that they can run without MTS and possibly connection pooling tuned very conservatively on the app host side. On the current, ...
    Crisler, JonCrisler, Jon
    Oct 13, 2010 at 3:32 pm
    Oct 14, 2010 at 10:36 pm
  • I did it and is working perfectly well. My configuration : Not Using AMM with ASM and database /etc/sysctl.conf : vm.nr_hugepages= 12288 -- page size 2MB = 24 GB vm.hugetlb_shm_group=1300 --id dba, ...
    Oct 12, 2010 at 7:47 am
    Oct 14, 2010 at 3:03 am
  • I do a Grep on all the rman logs - for ORA- and RMAN and email if I Find any - A whenever would be good. -- Howard A. Latham Sent from my Nokia N97 -- http://www.freelists.org/webpage/oracle-l
    Howard LathamHoward Latham
    Oct 11, 2010 at 12:25 pm
    Oct 12, 2010 at 4:11 pm
  • I’ve seen that happen before – if you shut it down with the //, and then start it back up with the /, all should be well, iirc. The issue is that with the extra // it still knows how to find the ...
    Matthew ZitoMatthew Zito
    Oct 12, 2010 at 1:53 pm
    Oct 12, 2010 at 3:11 pm
  • I just tested this - filled up my archive destination on the standby server - and the primary is continuing to hum along with no problems. I did get ORA-19504 errors in the alert log on the standby ...
    Allen, BrandonAllen, Brandon
    Oct 8, 2010 at 4:36 pm
    Oct 11, 2010 at 3:24 pm
  • I need to be able to call a unix program or script from PL/SQL, particularly from a trigger. There must be a way to do this, but I can't find anything in the Oracle documentation, other than running ...
    Scott CanaanScott Canaan
    Oct 7, 2010 at 1:28 pm
    Oct 7, 2010 at 1:55 pm
  • Has anyone figured out how Oracle is using the dynamic endpoints, which seems to be a new concept in 11gR2? Documentation seems to be notably lacking on the files called endpoints_listener.ora, as ...
    Andrew KerberAndrew Kerber
    Oct 4, 2010 at 3:06 pm
    Oct 4, 2010 at 3:56 pm
  • I would like to pull all the userids AND current passwords from a particular database and create them in another database so they are exactly the same. Does anybody have a script or sql that grabs ...
    J. DexJ. Dex
    Oct 6, 2010 at 1:33 pm
    Feb 16, 2011 at 12:07 pm
  • 50 words would have looked better to me. I admit that some of them are in the "obvious" or "unavoidable" category, but they are still too many: abort advise after algorithm all allocate allow alter ...
    Stephane FaroultStephane Faroult
    Oct 27, 2010 at 8:55 pm
    Oct 29, 2010 at 2:32 am
  • Hi, The -bugs_fixed flag is available on 10g, it just depends on your opatch version. Don't know in which version it became available. [oracle_at_xxxxxxx ~]$ opatch lsinventory -bugs_fixed Invoking ...
    D'Hooge FreekD'Hooge Freek
    Oct 27, 2010 at 12:24 am
    Oct 27, 2010 at 11:38 am
  • No the info does not get stored in the database. However, this path looks suspect: /opt/PRODDB/oracle/product/ Is there anything else between the "" and ...
    Taylor, Chris DavidTaylor, Chris David
    Oct 26, 2010 at 5:12 pm
    Oct 27, 2010 at 11:33 am
  • Can someone please tell me what I'm missing here ... SQL select sessiontimezone from dual; SESSIONTIMEZONE +11:00 SQL select sysdate, systimestamp, systimestamp - sysdate diff from dual; SYSDATE ...
    Steve BaldwinSteve Baldwin
    Oct 24, 2010 at 11:23 pm
    Oct 26, 2010 at 8:15 pm
  • Mates, one last question I hope.... I've followed all the steps required to change a database name. The procedure is exausting and after all the effort I cannot startup the database and this is the ...
    Guilherme Raymo LongoGuilherme Raymo Longo
    Oct 24, 2010 at 5:12 pm
    Oct 24, 2010 at 6:49 pm
  • A client of mine has a dev database (10g on linux) that was never backed up and due to a controller issue has a corrupted system tablespace. DBV shows 8 corrupted blocks. Is there a way to open the ...
    Kenneth NaimKenneth Naim
    Oct 21, 2010 at 6:12 pm
    Oct 23, 2010 at 3:58 am
  • Anyone seen this before, and have any idea what causes it? It gave us a little heartache Tuesday night. We managed to recover it using a backup ocr, but this is the 3rd time this has happened ...
    Andrew KerberAndrew Kerber
    Oct 21, 2010 at 12:51 pm
    Oct 22, 2010 at 12:19 pm
  • Hi, Listers, I had a problem and appreicate you help me to understand: Problem : suboptimal execution plan using index SMC_IDX4 selected by Oracle CBO good index: SMC_MAP_CURRSTAT_NUK(MAP_ID, ...
    Oct 20, 2010 at 1:22 pm
    Oct 20, 2010 at 3:40 pm
  • I have a "mental note" that I believe is based from conversations here in the past that has made me decide to wait on any upgrade for the OEMGC to 11g. There are a number of  *quirks*, (I won't ...
    Kellyn PedersenKellyn Pedersen
    Oct 18, 2010 at 11:13 pm
    Oct 19, 2010 at 2:15 pm
  • RMAN is a (special) database application which has *sessions* like any other database application... So either trace the session if you want to know the answer in minutes, or run snapper on RMAN ...
    Tanel PoderTanel Poder
    Oct 15, 2010 at 6:57 am
    Oct 19, 2010 at 1:09 pm
  • All, I've seen how to specify or ignore tables in the data pump API, which I prefer to the command line utility. But does anyone know of how to ignore an entire tablespace?? Dick Goulet Senior Oracle ...
    Goulet, RichardGoulet, Richard
    Oct 12, 2010 at 3:44 pm
    Oct 12, 2010 at 4:07 pm
  • How to restrict schema A from schema B. I have a db with schema B. Our applications are written in C++ and they use schema B. We have to support a 3rd party product that will require us to install ...
    Joe SmithJoe Smith
    Oct 11, 2010 at 11:36 pm
    Oct 12, 2010 at 12:37 am
  • Is the idea to backup archivelogs generated from standby database when doing LGWR apply from primary to standby? I am thinking there is no use in backing them up but just remove them (or use the rman ...
    Oct 11, 2010 at 12:43 pm
    Oct 11, 2010 at 1:00 pm
  • Is there something else to say that is not in documentation? http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/optimops.htm#BABFCIAI -- Rafu http://rafudb.blogspot.com/ -- ...
    Timo RaitalaaksoTimo Raitalaakso
    Oct 10, 2010 at 6:12 pm
    Oct 11, 2010 at 12:54 pm
  • Hi, What does the statistic_name='space used' column in v$segment_statistics show? I get results i don't understand at all, e.g. SQL select owner, object_name, statistic_name, value from ...
    Baziel de LeeuwBaziel de Leeuw
    Oct 6, 2010 at 9:51 am
    Oct 6, 2010 at 2:04 pm
  • I'll second the book recommendation. It's a great book and the best I've seen on the subject. Chris From: kyle Hailey To: bdbafh_at_gmail.com Cc: shastry17_at_gmail.com; oracle-l Sent: Tue, 5 ...
    Chris DunscombeChris Dunscombe
    Oct 5, 2010 at 9:34 am
    Oct 6, 2010 at 4:54 am
  • Back in my utl_file_dir/Windows days I remember having issues with accessing mapped drives (typically resolved with lots of rebooting). You may be better off with Oracle Directories. Or another ...
    Andy KlockAndy Klock
    Oct 1, 2010 at 1:27 pm
    Oct 2, 2010 at 6:17 pm
  • While not open source, Oracle APEX is included with your Oracle License, whether it be a paid version or XE. And it can use FOSS like Apache FOP for report printing. At least that's how I have mine ...
    Rich JesseRich Jesse
    Oct 29, 2010 at 3:31 pm
    Oct 29, 2010 at 5:24 pm
  • Just do it in html5 :) Sent from my Verizon Wireless BlackBerry -----Original Message----- From: Yong Huang Sender: oracle-l-bounce_at_freelists.org Date: Thu, 28 Oct 2010 11:10:27 To: Reply-To ...
    Oct 28, 2010 at 6:58 pm
    Oct 29, 2010 at 3:05 pm
  • Hi, All We are in the progress of POC migrate from Sun Niagara platform to X86 platform for some of our database; Previously our database platform purely run on top of : Sun HW+Solaris Veritas as ...
    Oct 27, 2010 at 1:52 am
    Oct 27, 2010 at 2:53 am
  • Hello, We have all oracle database running on AIX 5.3. Unix team planned to upgrade AIX servers from 5.3 to 6.1 version. Please let me know what are the things I need to do from oracle side.. in ...
    Nagaraj SNagaraj S
    Oct 26, 2010 at 4:52 pm
    Oct 27, 2010 at 1:52 am
  • Hi Niall, There is no particular technical reason, especially considering it is for remote support. I am not familiar with how the law would work across countries though, so I just thought it would ...
    Michael SchmittMichael Schmitt
    Oct 25, 2010 at 8:07 pm
    Oct 25, 2010 at 8:36 pm
  • How about nohup rman cmdfile scrript.cmd & then tail nohup.out Brent On Oct 24, 2010 6:32 PM, "Ray Stell" wrote: I use the screen command to solve this problem. It is not what you are asking for, ...
    Brent DayBrent Day
    Oct 25, 2010 at 3:26 am
    Oct 25, 2010 at 3:15 pm
  • Good morning.... I trying to accomplish a task that is killing me... seriously! I am trying to adapt an application that runs on windows to work on an Ubuntu Server box. The thing is that during the ...
    Guilherme Raymo LongoGuilherme Raymo Longo
    Oct 23, 2010 at 9:44 am
    Oct 23, 2010 at 7:01 pm
  • [...] Which Portal version are you trying to install? Which Oracle Application Server version? Regards Dimitre -- http://www.freelists.org/webpage/oracle-l
    Radoulov, DimitreRadoulov, Dimitre
    Oct 21, 2010 at 2:37 pm
    Oct 21, 2010 at 2:54 pm
  • We have this client with 30-50GB database on Peoplesoft.. and amazingly when it does batch processing it produces archivelogs (when compounded) way bigger than the database.. this is around 150GB ...
    Karl AraoKarl Arao
    Oct 20, 2010 at 5:50 am
    Oct 20, 2010 at 12:48 pm
Group Navigation
period‹ prev | Oct 2010 | next ›
Group Overview
grouporacle-l @

134 users for October 2010

: 12 posts Andrew Kerber: 11 posts Yong Huang: 9 posts Crisler, Jon: 8 posts Goulet, Richard: 7 posts Allen, Brandon: 5 posts Karl Arao: 5 posts TESTAJ3_at_nationwide.com: 5 posts Tim Hall: 5 posts Darren Darnell: 4 posts Don Granaman: 4 posts Howard Latham: 4 posts Kellyn Pedersen: 4 posts Mayur nagarsheth: 4 posts Stefan Knecht: 4 posts Amaral, Rui: 3 posts Andy Klock: 3 posts Greg Rahn: 3 posts Guilherme Raymo Longo: 3 posts Jared Still: 3 posts
show more