FAQ

Search Discussions

117 discussions - 744 posts

  • Hi, backups of EM are failing suddenly. It shows "Initialization failure" in status and error log shows "Step aborted because agent went down". The error comes after many hours, I see that it doesn't ...
    OliverOliver
    Aug 29, 2011 at 9:31 am
    Aug 31, 2011 at 4:01 pm
  • Hi I am looking to see what is the best option to have DR solution that can be Primary with no loss or downtime. Looking for best practices even it is expensive solution. Appreciate for any document ...
    Sanjay MishraSanjay Mishra
    Aug 30, 2011 at 10:27 pm
    Sep 6, 2011 at 8:00 am
  • Listers, I am looking at a table in our system and it has 12 indexes, we are planning on adding another one. I am aware of the effects of having too many indexes, but in this case adding an extra ...
    Ram RamanRam Raman
    Aug 11, 2011 at 8:45 pm
    Aug 15, 2011 at 2:28 pm
  • 25

    Hints

    Hello all, Are hints in queries considered bad, if so why. Orlando. -- http://www.freelists.org/webpage/oracle-l
    Orlando LOrlando L
    Aug 15, 2011 at 5:43 am
    Aug 18, 2011 at 8:17 am
  • 21

    ouch

    Found a gem in one of my databases today: FUNCTION "SUBSTRING" (INSTRING IN varchar2, STARTPOS IN number, LENGTH IN number) RETURN varchar2 IS RESULT varchar2(8000); BEGIN select substr(INSTRING, ...
    Uzzell, StephanUzzell, Stephan
    Aug 31, 2011 at 8:31 pm
    Sep 2, 2011 at 3:51 pm
  • Just wondering... does anyone out there have a snippit of code that will load a 10046 trace file from bdump or udump into a LOB? Just looking for a quick and dirty way to give some developers access ...
    Jeremy SchneiderJeremy Schneider
    Aug 16, 2011 at 10:39 pm
    Aug 27, 2011 at 6:22 pm
  • What is everybody using as a source control for your packages/procedures/functions etc...? And how do you have it configure/setup? We are currently using Microsoft Visual Source Safe and it works ok ...
    Jeff ChircoJeff Chirco
    Aug 1, 2011 at 9:08 pm
    Aug 10, 2011 at 4:02 am
  • I've got a query that uses a UNION statement to join 2 large data sets. When I run the statement it takes 20 minutes to execute (using UNION), returns 89,887 rows and consumes 5GB of TEMP ...
    Taylor, Chris DavidTaylor, Chris David
    Aug 5, 2011 at 6:35 pm
    Aug 9, 2011 at 1:15 pm
  • we have a database original on ORACLE 10.2.0.4 and we upgrade it to 11.1.0.7. after that we create standby database and tried to use "real time apply" feature. Primary database can transfer log files ...
    Dba1 mccDba1 mcc
    Aug 16, 2011 at 6:15 pm
    Aug 19, 2011 at 3:22 pm
  • I was going to see what OCM has to offer and install it on one of our development servers. The install appears to be very easy. However, after entering the information prompted after executing ...
    Stephens, ChrisStephens, Chris
    Aug 5, 2011 at 6:25 pm
    Aug 16, 2011 at 10:20 pm
  • Hi, I'm new to RAC, but have a question. We have a 5 node RAC that supports multiple markets each of which has its own schema. Due to each market having its own schema, there is no sharing of blocks ...
    Walker, Jed SWalker, Jed S
    Aug 5, 2011 at 10:49 pm
    Aug 17, 2011 at 8:34 am
  • Hi Does anyone know what is best way to identify as what CPU/PSU patch is applied to the existing Oracle Software. We have 100's of database servers and some new are added on regular basis. In order ...
    Sanjay MishraSanjay Mishra
    Aug 31, 2011 at 4:09 pm
    Sep 5, 2011 at 3:42 pm
  • 12

    RMAN

    Hello, Database : 11gR2 I was recently provided an access to a new database, because users are complaining of poor perfromance. During my monitoring of this database, and using statspack report ...
    Mek sMek s
    Aug 26, 2011 at 8:10 am
    Aug 28, 2011 at 3:06 pm
  • those of you out there running multiple oracle homes, potentially with multiple oracle software owners and certainly with multiple listeners on Linux. How do you control db and listener startup at ...
    Niall LitchfieldNiall Litchfield
    Aug 9, 2011 at 1:06 pm
    Aug 10, 2011 at 1:57 pm
  • 10 + 11 RH Linux The upgrade from 10 to 11 doc seems to imply that you have to change some timezone files. Can I Ignore this is If have'nt used the TIMESTAMP Datatype- And .. Why do I get ORa-00723 ...
    Howard LathamHoward Latham
    Aug 24, 2011 at 11:32 am
    Aug 25, 2011 at 11:01 am
  • �Hi, I'm new to RAC, and have a basic question. I'll appreciate if someone can help. We have got a requirement from a customer to have support for Oracle RAC. I need some help on this. In our product ...
    Saad KhanSaad Khan
    Aug 23, 2011 at 4:38 pm
    Aug 24, 2011 at 8:06 pm
  • All, my online redo logs are 3G . This is a batch intensive datawarehouse application. What should i be keeping my log_buffer . currently it is set at 29425664 and it just seems too low . thanks Kart ...
    K RK R
    Aug 15, 2011 at 7:22 pm
    Aug 16, 2011 at 5:20 am
  • What's the fastest way to create an XML file on disk with a SQL query as input? We're on Oracle 10.2 and currently we're using the Java getXMLSAX() function with an output stream and an ...
    Jeremy SchneiderJeremy Schneider
    Aug 2, 2011 at 5:07 pm
    Aug 3, 2011 at 7:13 am
  • Hello Friends: I would like to know if there is a datatype to store only time in oracle, like HH24:MI I can use VARCHAR2(5) and save like that : 01:50, 22:35, ... Also, I can use DATE and store only ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Aug 14, 2011 at 1:08 am
    Aug 15, 2011 at 12:36 pm
  • First, disregard the part about the large TEMP tablespace usage. I think that was coming from the query _before_ I rewrote it to use WITH statements. I'm not seeing the large TEMP usage now. For each ...
    Taylor, Chris DavidTaylor, Chris David
    Aug 12, 2011 at 6:32 pm
    Aug 13, 2011 at 12:56 am
  • All, I'm trying to figure out high memory usage on one of the DB servers we have and wondering if pga_aggregate_target could ever exceed from what's allocated. We have sga_target set to 16G and ...
    StalinStalin
    Aug 26, 2011 at 8:02 am
    Aug 31, 2011 at 4:39 pm
  • So who knows the meaning of ACID (not the Timothy Leary kind) ? http://tonyhasler.wordpress.com/2011/08/22/why-is-acid-important/ http://jonathanlewis.wordpress.com/2011/08/19/redo-2/ Regards ...
    Jonathan LewisJonathan Lewis
    Aug 23, 2011 at 8:54 am
    Aug 25, 2011 at 1:30 pm
  • Hi Friends, We have memory free very less in one of our Solaris 10 server running Oracle 11g R2. The memory free will be sometimes 2 GB out of 24 GB. I was looking at the memory consumption. ps -efo ...
    Sreejith S NairSreejith S Nair
    Aug 23, 2011 at 9:21 am
    Aug 24, 2011 at 1:24 am
  • We have a requirement to automate or provide control to developers to rollback all schema changes. For example: starting from a base line - test A performed - rollback to baseline - test B performed ...
    Michael DinhMichael Dinh
    Aug 10, 2011 at 9:52 pm
    Aug 12, 2011 at 7:22 pm
  • Hello all, I have a problem with diagnosing "CRS-1615 voting device hang" error. OS: OEL 5.6 (64-bit) DB: Oracle 11.1.0.7 Storage: IBM XIV HW: Blade server 8 cores with Hyper-Threading enabled (64 GB ...
    Marko SuticMarko Sutic
    Aug 25, 2011 at 7:07 am
    Aug 26, 2011 at 4:05 pm
  • Hi All, Good day. I set up a logical standby but real time apply does not work. If i switch the logfile, then the redo log file gets archive and get applied over. I looked at the various sql commands ...
    Sundar mahadevanSundar mahadevan
    Aug 9, 2011 at 6:48 pm
    Aug 11, 2011 at 3:20 pm
  • Hi The other day while I was troubleshooting with 10046 some RMAN resync issues with the catalog (was taking very long time) I noticed that insert and update statements were taking extremely long ...
    LS ChengLS Cheng
    Aug 5, 2011 at 5:38 am
    Aug 9, 2011 at 9:28 pm
  • I am in the process of configuring 11gR2 RAC on Solaris. We are going to use ASM for shared storage for database files. For Archive log files, we are going to put them in filesystem. So in order to ...
    Anurag VermaAnurag Verma
    Aug 31, 2011 at 8:47 pm
    Sep 6, 2011 at 4:02 pm
  • Hi Yesterday I've got a situation. Data Guard performed a failover just as advertized. Btw, it proved once and again that active-semiactive environment is preferable to active-passive and alikes. It ...
    Laimutis.Nedzinskas_at_seb.ltLaimutis.Nedzinskas_at_seb.lt
    Aug 25, 2011 at 1:30 pm
    Aug 30, 2011 at 8:45 am
  • List Guru's, I'm trying to create a 10g database on an upgraded 11g grid using DBCA (to replicate the steps done previously when both DB and Grid were 10g) and on Step 7, after selecting "Automatic ...
    Langston, ChrisLangston, Chris
    Aug 23, 2011 at 8:51 pm
    Aug 26, 2011 at 4:48 pm
  • Hi Guys, I haven't been around for a while but have been given a new project to set up and I thought I would ask all you good folks on here for some guidance. :-) Basically, what I need to do (or at ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Aug 18, 2011 at 12:58 pm
    Aug 18, 2011 at 4:16 pm
  • I've always heard that this is not possible but I have to ask because it's our last resort. Is there any way to restore a db from a backup taken when the db was open? The backup in question is an os ...
    Armstrong-Champ, Joseph WilliamArmstrong-Champ, Joseph William
    Aug 5, 2011 at 1:58 pm
    Aug 16, 2011 at 8:08 pm
  • We have a table for which one of the columns is going to have its type changed from varchar2(1000) to nvarchar2(1000). This column is part of an index which will be created using the ONLINE keyword ...
    Kudryk, MarkKudryk, Mark
    Aug 29, 2011 at 4:05 pm
    Aug 30, 2011 at 5:51 pm
  • I am wondering how often Oracle is run on that platform. Wouldn't Oracle mostly be written first for linux / solaris / win32, then ported to the other platforms? -- ...
    Patrice sur GMailPatrice sur GMail
    Aug 26, 2011 at 4:52 pm
    Aug 29, 2011 at 12:19 pm
  • In all our 11.2 databases we are seeing a very frequent situation where the SCAN listener (sometimes even the local listener) has a tnsping time of over 4000ms. After the alert is triggered it is ...
    Guillermo Alan BortGuillermo Alan Bort
    Aug 15, 2011 at 7:12 pm
    Aug 25, 2011 at 5:13 pm
  • Hi, List, Has anyone on the list applied the July CPU? We just installed it on one of our non-production RAC nodes and now we can't even do a 'startup nomount' successfully. Logs show the following ...
    Li LiLi Li
    Aug 19, 2011 at 10:14 pm
    Aug 21, 2011 at 9:24 am
  • Hi, Looking for some advice here on installing into a 64 bit Suse environment: SUSE Linux Enterprise Server 11 (x86_64) VERSION = 11 PATCHLEVEL = 1 Oracle EE 11.2 I have been stuck not being able to ...
    Peter HitchmanPeter Hitchman
    Aug 5, 2011 at 7:18 pm
    Aug 8, 2011 at 1:47 pm
  • We have been asked by our security division to run these specific statements on a database for auditing purposes. They don’t work. These are 11.1.0.7 databases on Standard Edition. Are there some ...
    P DP D
    Aug 3, 2011 at 7:28 pm
    Aug 4, 2011 at 7:20 pm
  • Environment: 2 node RAC on OEL 5 Grid Home : 11.2.0.2 RDBMS Home: 11.1.0.7.7 On our database, Session was waiting most of the time on 'library cache pin' wait - for a decent amount like a minute or ...
    Sanjeev MSanjeev M
    Aug 2, 2011 at 6:19 pm
    Aug 3, 2011 at 3:51 pm
  • I need to give access to grid control to some testers. I know how to set up a user where they only get access to certain databases and limit privileges. They need access to the performance tab and ...
    Dba DBADba DBA
    Aug 31, 2011 at 2:47 pm
    Sep 1, 2011 at 6:29 am
  • Hi everybody. I have a particular job created using dbms_scheduler that currently runs once a day at 7am. But now I would like to run this same job at 7, 930, and 12. Is it possible to configure this ...
    Jeff ChircoJeff Chirco
    Aug 19, 2011 at 5:42 pm
    Aug 26, 2011 at 6:19 pm
  • Hello, in 11gR2 and Solaris. We are facing deadlock ORA-00060 errors; here the deadlock graph, any idea? Deadlock graph: ---------Blocker(s)-------- ---------Waiter(s)--------- Resource Name process ...
    Mek sMek s
    Aug 24, 2011 at 12:21 pm
    Aug 24, 2011 at 9:09 pm
  • List, We are moving our stuff from old hardware to a new hardware. I am observing these results in our new test hardware env: we run a query in the new test env, it runs slow first time it is run. It ...
    Ram KRam K
    Aug 22, 2011 at 7:13 pm
    Aug 23, 2011 at 3:36 am
  • This is somewhat of a puzzler where I can't find the right combination of Oracle functions to deliver the correct result. Oracle 10.2.0.4 on RHEL 5.7 Claims coming into our system can be rejected for ...
    David BarbourDavid Barbour
    Aug 18, 2011 at 9:47 pm
    Aug 19, 2011 at 6:51 am
  • Hi List, We are planning our DR solution at a client. The distance between the production and DR site will be ~ 266miles. Based on your experiences what is the best solution (if we can say that) ...
    Thiago MacielThiago Maciel
    Aug 18, 2011 at 12:34 am
    Aug 18, 2011 at 11:14 am
  • Did anyone else just notice that you can now block domains with google search? I have been using greasemonkey in firefox to block a few domains which i generally don't find helpful but tend to fill ...
    Jeremy SchneiderJeremy Schneider
    Aug 16, 2011 at 6:41 pm
    Aug 16, 2011 at 7:20 pm
  • Hi, I am trying to do a software only GUI install, I filled out the grid_install.rsp, but when I try it I get: [FATAL] [INS-30504] Missing ASM disk group name. Since I am not using ASM, I have no ...
    Peter HitchmanPeter Hitchman
    Aug 8, 2011 at 4:04 pm
    Aug 9, 2011 at 7:33 pm
  • Hi Can some one explain why the diag dest parameter has a different value when asm is getting started through srvctl/crscl vs sqlplus. Details below GI version 11.2.0.2 Diagnostic dest value is not ...
    Kumar MadduriKumar Madduri
    Aug 5, 2011 at 12:28 pm
    Aug 5, 2011 at 3:02 pm
  • Can anyone help me out here? I cannot find anything online, nor have I've ever seen this before.. RHEL 5 64-Bit Oracle 10.2.0.5 2 Node RAC I'm trying to remove and re add the TAF service on my ...
    Scott StefickScott Stefick
    Aug 3, 2011 at 6:30 pm
    Aug 4, 2011 at 7:17 pm
  • Hi, I been looking at some (10.2.0.4) on AIX 64 bit Awr report File IO Stats and can see that the Av Rd(ms) for some of the files are consistently above 50 to 60 ms over a 15min interval but when I ...
    JoshuasinghamJoshuasingham
    Aug 3, 2011 at 2:59 pm
    Aug 3, 2011 at 7:23 pm
Group Navigation
period‹ prev | Aug 2011 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions117
posts744
users186
websiteoracle.com

186 users for August 2011

: 34 posts Niall Litchfield: 33 posts Jeremy Schneider: 30 posts Greg Rahn: 22 posts Taylor, Chris David: 22 posts Oliver: 19 posts Robert Hanuschke: 16 posts D'Hooge Freek: 15 posts Guillermo Alan Bort: 15 posts Mek s: 12 posts Sanjay Mishra: 12 posts Tim Gorman: 12 posts David Fitzjarrell: 10 posts Laimutis.Nedzinskas_at_seb.lt: 10 posts Mark W. Farnham: 10 posts Peter Hitchman: 10 posts Walker, Jed S: 10 posts LS Cheng: 9 posts Marcin Przepiorowski: 9 posts Fuad Arshad: 8 posts
show more
Archives