FAQ

Search Discussions

91 discussions - 222 posts

  • Good idea, in the Boston Ma area that's at least a 6 figure number, low 6 figures though, like just north of 5 full figures. Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL International From ...
    Goulet, RichardGoulet, Richard
    Jun 15, 2010 at 1:56 pm
    Jun 17, 2010 at 1:13 pm
  • Hello List, A friend (report developer) has asked for help, and I have not been able to give him a satisfactory answer. I'm hoping someone on Oracle-L can help out. Basically, he wants to run a Top N ...
    Dave PaciaDave Pacia
    Jun 23, 2010 at 2:57 pm
    Nov 14, 2011 at 9:39 pm
  • Hi, So I have an idle system, where I run a sql report. The report takes an hour to run. I look at the awr report (30 min interval), and see the io wait events for sequential and scattered reads. The ...
    Oracle Dba WannabeOracle Dba Wannabe
    Jun 13, 2010 at 10:31 pm
    Jun 15, 2010 at 5:09 am
  • Hi I have a customer hit this nasty bug this morning. Really really nasty which affects 9.2.0.5 and 9.2.0.6. It turns out customer was trying to import a few thousands rows to the applicacion main ...
    LS ChengLS Cheng
    Jun 22, 2010 at 9:17 pm
    Jun 24, 2010 at 3:57 pm
  • Hi Which monitoring software are you using? I need a cheap, simple to implement and powerfull software to monitor Oracle instance, CPU, free disk, etc. I like "Hostmonitor" but I wish to know it ...
    Juan MirandaJuan Miranda
    Jun 21, 2010 at 12:13 pm
    Jun 22, 2010 at 10:31 pm
  • I think I might be the only one who does this and it works well for me, but other techies are kind of surprised when they hear me describe my mobile work solution- I like to have access via a laptop ...
    Kellyn PedersenKellyn Pedersen
    Jun 1, 2010 at 3:02 am
    Jun 2, 2010 at 3:45 am
  • The install doc is at http://www.oracle.com/pls/db102/to_pdf?pathname=install.102/b31288.pdf&remark=portal+(Enterprise+Manager) Skimming the document, I didn't see anything about install groups ...
    William BlanchardWilliam Blanchard
    Jun 22, 2010 at 4:08 pm
    Jun 23, 2010 at 1:19 pm
  • Hello All, We have a requirement to schedule multiple jobs in Oracle 11g (11.1.0.7) on windows. We have multiple jobs which needs to be executed in a specific order serial and parallel. Below is the ...
    Ravi MadabhushanamRavi Madabhushanam
    Jun 17, 2010 at 4:51 am
    Jun 30, 2010 at 10:35 pm
  • I may be missing something, but since you're querying the il.loc column, shouldn't your index be on that column? -Craig From: Alex Octan To: Oracle I List Sent: Fri, June 25, 2010 1:28:39 PM ...
    Craig DickmanCraig Dickman
    Jun 25, 2010 at 8:57 pm
    Jun 28, 2010 at 2:18 am
  • Java interface (works fine on any platform). See *Apache POI* - the *Java*API for Microsoft Documents.<http://poi.apache.org/ I'm using it at the moment, both for reading and writing Excel ...
    Nigel ThomasNigel Thomas
    Jun 22, 2010 at 5:41 pm
    Jun 23, 2010 at 9:51 am
  • Hi all, At last we were able to recover the database. Here are the details for anyone who,hopefully not, can run into any problem like this: We have realized the problem at Friday just before the ...
    Ozgur OzdemirciliOzgur Ozdemircili
    Jun 3, 2010 at 7:58 am
    Jun 15, 2010 at 1:36 pm
  • Hello list, To my great dismay I just found out that VMWare Server 2.0 I have used in the past for desktop virtualisation of Windows stopped working. Actually, it's not the virtualisation layer, but ...
    Martin BachMartin Bach
    Jun 23, 2010 at 1:05 pm
    Jun 23, 2010 at 1:51 pm
  • Any attempts so far/errors, please? Version? Platform? From: oracle-l-bounce_at_freelists.org On Behalf Of Shastry(DBA) Sent: Tuesday, June 15, 2010 10:22 AM To: oracle-l ...
    Sweetser, JoeSweetser, Joe
    Jun 15, 2010 at 4:33 pm
    Jun 16, 2010 at 5:07 pm
  • Hi folks, I have a system that one table has million of rows and many sessions doing operations, and because of this many locks are happening. So I was thinking what kind of initiative I can take on ...
    Alex OctanAlex Octan
    Jun 15, 2010 at 2:43 am
    Jun 15, 2010 at 11:19 am
  • Listers, I've been working as a physical DBA for a long time and have developed my instance tuning skills rather well. However, I want to direct my career to a more comprehensive type of DBA and was ...
    Guillermo Alan BortGuillermo Alan Bort
    Jun 7, 2010 at 2:19 am
    Jun 7, 2010 at 8:36 pm
  • Hey Dan, That would seem to be your issue. I seriously doubt that running anything but GC from your OMS home is supported nor recommended. I'm using a separately installed 10g version (10.1.3.1) of ...
    Rich JesseRich Jesse
    Jun 2, 2010 at 9:15 pm
    Jun 3, 2010 at 6:51 am
  • I was trying to find out some sql in sys.dba_hist_sql_plan but was unable to. I had seen the sql running, captured the sql_id and then waited until the next hour and still not in the table. What ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jun 2, 2010 at 4:21 pm
    Jun 2, 2010 at 5:17 pm
  • Hi, Is it possible to install Oracle in command line mode in an SSH console? Thanks. -- Octavian Information from ESET NOD32 Antivirus, version of virus signature database 5239 (20100630) The message ...
    Octavian RasnitaOctavian Rasnita
    Jun 30, 2010 at 11:36 am
    Jun 30, 2010 at 8:37 pm
  • Oracle Version: 11.1.0.7 OS: Windows 2003 I have a production database that has the retention policy set to REDUNDANCY 2 and the ARCHIVELOG DELETION POLICY BACKED UP 2 TIMES TO DISK. When I issue ...
    Jay HostetterJay Hostetter
    Jun 25, 2010 at 12:55 pm
    Jun 30, 2010 at 1:51 am
  • Hi, I have been facing issues with MOS where when I type the content, I am unable to see anything. Only after refreshing the browser 2-3 times, I can see content. Has anybody else encountered this ...
    Amit bansalAmit bansal
    Jun 25, 2010 at 3:54 am
    Jun 28, 2010 at 1:54 pm
  • Or Cygwin. William Blanchard On Jun 21, 2010, at 7:27 AM, Juan Miranda wrote: Hi I highly recomend it: http://sourceforge.net/projects/unxutils/ There are 120 unix commands like: grep find test less ...
    William BlanchardWilliam Blanchard
    Jun 21, 2010 at 3:57 pm
    Jun 22, 2010 at 7:33 am
  • All Oracle 10.2.0.4 Red Hat 4 x86_64 We have an application that runs standard SQL as a reporting tool. The amount of rows that can be returned is limited by a variable. The application manages this ...
    Ray FeigheryRay Feighery
    Jun 4, 2010 at 12:24 am
    Jun 7, 2010 at 2:35 pm
  • Hello All, I'm trying to install 11gR2 and Application server on CentOS 5.2 server. During 11gR2 installation OUI complained about pdksh not being installed. This rpm is not present in the default ...
    Ravi MadabhushanamRavi Madabhushanam
    Jun 4, 2010 at 10:16 am
    Jun 5, 2010 at 8:36 pm
  • Sentrigo had a nice introductory presentation on the cloud by Jeremiah Wilson last week: Best Practices When Deploying Databases in the Cloud (go to http://www.sentrigo.com/resources/events-webcasts, ...
    Satterthwaite, SarahSatterthwaite, Sarah
    Jun 3, 2010 at 9:28 am
    Jun 5, 2010 at 2:35 am
  • I would never be one to point fingers- I'm a DBA and do not understand the network infrastructure as well as the Network admin, but as a DBA, I do have to deal with the errors and the database is ...
    Kellyn PedersenKellyn Pedersen
    Jun 4, 2010 at 9:54 pm
    Jun 5, 2010 at 1:29 am
  • Is anyone else experiencing the same issue? The download started with the welcoming news that the 11gR1 software download was going to take 8 hours. Before we were kicked out it indicated that it ...
    Carol DackoCarol Dacko
    Jun 3, 2010 at 8:57 pm
    Jun 4, 2010 at 2:13 pm
  • For all the redolog and control files we use 128K. All the datafile volumes are configured with 8K recordsize except one. That volume was meant for archive logs, until someone accidentally started ...
    Upendra NUpendra N
    Jun 30, 2010 at 6:15 pm
    Jul 1, 2010 at 1:37 pm
  • I'm trying to install 11.2.0.1 on 64-bit Red Hat Linux. In doing the install, I get five pop-up errors stating that the 32-bit libraries can't be built. In checking with the SAs, they told me that we ...
    Scott CanaanScott Canaan
    Jun 30, 2010 at 7:38 pm
    Jun 30, 2010 at 7:56 pm
  • Hey David, Nice tool, looks very interesting. Does it work on archived redolg files? I'll try it in my toy DBs this week... :-) I'd love to do it in productive ones, as it works on redo, I'm guessing ...
    Guillermo Alan BortGuillermo Alan Bort
    Jun 29, 2010 at 1:37 am
    Jun 29, 2010 at 10:34 am
  • I'm having a heck of a time getting even a small test case to work. capture 9.2.0.8, patched for RAT, got capture files, ok replay, preprocess works fine, but then i try replay, it shows in the debug ...
    TESTAJ3_at_nationwide.comTESTAJ3_at_nationwide.com
    Jun 25, 2010 at 11:18 pm
    Jun 26, 2010 at 12:07 am
  • Hello All, Recently I've requested the list to suggest me possible options for job scheduling and as per the recommendations by peers, I was able to configure Job Chains successfully and it worked ...
    Ravi MadabhushanamRavi Madabhushanam
    Jun 25, 2010 at 2:55 am
    Jun 25, 2010 at 8:15 am
  • Sorry for late reply, but please send me 1) version of your script (and attach it to the email), i don't have access to 10.2.0.4 currently 2) network diagram of your RAC cluster with ip addresses for ...
    Jakub WartakJakub Wartak
    Jun 12, 2010 at 11:42 am
    Jun 23, 2010 at 7:12 am
  • Hi. Just found in SAP brochure: http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f0576c6f-8303-2d10-4592-ae755ae7f6e4?QuickLink=ora&overridelayout=true Improved Oracle Net ...
    Dennis YurichevDennis Yurichev
    Jun 22, 2010 at 4:55 am
    Jun 22, 2010 at 6:12 pm
  • I have a 10g database with pl_sql_compiler_flags set to NATIVE, NON_DEBUG and plsql_debug set to FALSE but the procedures, functions and packages are still being compiled in debug mode. I have tried ...
    William BlanchardWilliam Blanchard
    Jun 22, 2010 at 2:38 pm
    Jun 22, 2010 at 3:13 pm
  • I've got a query that ran this morning that for some reason decided to jump ship off its normal plan and use a different plan. This is a very straightforward single table query. When the query runs ...
    LBLB
    Jun 21, 2010 at 4:53 pm
    Jun 21, 2010 at 11:09 pm
  • Lists, Our management is thinking to implement Oracle streams for an ROD (Replication Online Database) instance. We heard one of our DBA saying Oracle is planned to de-support Streams in the future ...
    Prabhu KrishnaswamyPrabhu Krishnaswamy
    Jun 20, 2010 at 6:37 pm
    Jun 21, 2010 at 2:37 am
  • Have installed Oracle 11g r 2 and I see directories created in home directories with names of oradiag_ e. oradisg_john What are these directories and how can I stop this? John Dunn Product Consultant ...
    John DunnJohn Dunn
    Jun 1, 2010 at 11:34 am
    Jun 16, 2010 at 4:58 am
  • Could you please help me by providing a SQL that list schema tables in parent/child tree. Example: TableName Level TAB1 1 TAB2 2 TAB3 2 TAB4 3 Thanks, Mohamed Seliem -- ...
    Mohammad SeliemMohammad Seliem
    Jun 15, 2010 at 3:26 pm
    Jun 15, 2010 at 3:54 pm
  • [...] If you use a recovery catalog with the report schema command ( = 9i?): RMAN report schema at time 'sysdate - 30'; RMAN report schema at time 'sysdate - 61'; Of course, it will not show you how ...
    Radoulov, DimitreRadoulov, Dimitre
    Jun 5, 2010 at 5:37 pm
    Jun 15, 2010 at 3:54 pm
  • Hi, I am on OEL V4 64 bit, 2 node RAC, trying to upgrade to 11.2. So I have started with upgrading the CRS and ASM. All goes OK up until the netca runs, it fails with: "CRS-0210: Could not find ...
    Peter HitchmanPeter Hitchman
    Jun 14, 2010 at 3:32 pm
    Jun 15, 2010 at 3:27 pm
  • Dear list, Just wanted to pass this on to everyone who was a good citizen and applied PSU 11.2.0.1.1 to Grid Infrastructure. You did it in vain, Karl Arao was the first I saw to mention this on ...
    Martin BachMartin Bach
    Jun 15, 2010 at 8:03 am
    Jun 15, 2010 at 11:54 am
  • William, You may set to remote_os_authent to FALSE (default value) to prevent any one from logging in as OPS$ account or you may change value of os_authent_prefix to any string other than OPS$. HTH ...
    Mayen.Shah_at_lazard.comMayen.Shah_at_lazard.com
    Jun 11, 2010 at 5:56 pm
    Jun 13, 2010 at 7:19 am
  • For a partition table, what is the difference when creating index if global is specified or not. Example: ALTER TABLE fct ADD CONSTRAINT fct_pk PRIMARY KEY (key) USING INDEX; ALTER TABLE fct ADD ...
    Michael DinhMichael Dinh
    Jun 10, 2010 at 11:17 pm
    Jun 10, 2010 at 11:31 pm
  • I totally agree with Kellyn, opening a tar is 99% useless, and we end up solving the issue by ourselves. In 1% cases when it is sev 1, and Management is involved, we use SR only to buy some time ...
    Pankaj JainPankaj Jain
    Jun 9, 2010 at 10:16 pm
    Jun 10, 2010 at 4:26 am
  • And if. (meaning I agree completely with what is written so far.) If you consider the partitioned object a live production object and the preparatory table loaded nologging to be a "staging" object, ...
    Mark W. FarnhamMark W. Farnham
    Jun 4, 2010 at 3:15 pm
    Jun 10, 2010 at 3:06 am
  • I am not allowed to change some long data types to clobs. I asked and was told no. This is pretty old, so when I google it I don't see much. I have a table with a long and I need to update that field ...
    Dba DBADba DBA
    Jun 3, 2010 at 2:36 pm
    Jun 3, 2010 at 2:54 pm
  • Depending on how many hosts you are talking about I probably wouldn't use the installer, but the agent patching functionality. The upgrade itself should be fine. Niall Litchfield On Jun 1, 2010 10:28 ...
    Niall LitchfieldNiall Litchfield
    Jun 2, 2010 at 6:43 am
    Jun 2, 2010 at 4:33 pm
  • Have just installed Oracle 11 R2 on 64-bit RHEL and am experiencing slow JDBC connections. Having googled the issue it seems this may be an issue with Oracle 11 on 64-bit platforms Has anyone else ...
    John DunnJohn Dunn
    Jun 2, 2010 at 11:28 am
    Jun 2, 2010 at 2:53 pm
  • Unfortunately cycling the database is your only option since there is no parent session nor any O/S process to kill. David Fitzjarrell From: Kellyn Pedersen To: oracle Freelists Sent: Tue, June 1, ...
    David FitzjarrellDavid Fitzjarrell
    Jun 2, 2010 at 11:27 am
    Jun 2, 2010 at 1:02 pm
  • Jack, it will be 2 step process either way. You might be better off writing a script using dbms_datapump which will give you most flexibility. first to load data on pre-created table and then again ...
    RjamyaRjamya
    Jun 2, 2010 at 12:55 am
    Jun 2, 2010 at 9:01 am
Group Navigation
period‹ prev | Jun 2010 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions91
posts222
users122
websiteoracle.com

122 users for June 2010

Kellyn Pedersen: 10 posts Dunbar, Norman: 9 posts Niall Litchfield: 9 posts De DBA: 7 posts : 6 posts Jared Still: 6 posts Martin Bach: 6 posts Guillermo Alan Bort: 5 posts Mark W. Farnham: 5 posts Ravi Madabhushanam: 5 posts Blanchard, William: 4 posts Michael Dinh: 4 posts William Blanchard: 4 posts Ethan Post: 3 posts Goulet, Richard: 3 posts Jeffrey Beckstrom: 3 posts John Dunn: 3 posts LS Cheng: 3 posts Ozgur Ozdemircili: 3 posts Peter Hitchman: 3 posts
show more
Archives