FAQ

Oracle > oracle-l > January 2012

Search Discussions

103 discussions - 441 posts

  • infoworld say this bug is really ugly. "Apparently, the Oracle System Change Number (SCN), a sort of time stamp applied to every database transaction, could be raised artificially -- either through a ...
    Ray StellRay Stell
    Jan 17, 2012 at 3:34 pm
    Jan 24, 2012 at 8:47 pm
  • Does anyone know if there's a way to track the version of sqlplus that is connecting to the database? I looked at sys_context and system events but haven't found anything. WGB The information ...
    Blanchard, William GBlanchard, William G
    Jan 19, 2012 at 7:21 pm
    Oct 12, 2012 at 8:38 pm
  • Currently we are running 10g EE on SUSE10 on an IBM mainframe. Early February we will be getting a new mainframe. The storage for all databases will be unplugged from the old mainframe and plugged ...
    Sandra BeckerSandra Becker
    Jan 16, 2012 at 8:03 pm
    Feb 7, 2012 at 10:13 pm
  • Hi everyone, I have an 11.2.0.3.0 RAC cluster. We have a table (in 12 schemas) that gets a decent amount of rows (depending on schema up to ~1m per day) and that we need to clean. Currently this is ...
    Walker, Jed SWalker, Jed S
    Jan 31, 2012 at 3:05 pm
    Feb 6, 2012 at 5:38 pm
  • I've been contacted by a recruiter via LinkedIn about an Oracle DBA position that is 60% travel, full benefits, and good pay. Says 'Assignments change every few months'. The company website for the ...
    Taylor, Chris DavidTaylor, Chris David
    Jan 5, 2012 at 8:06 pm
    Jan 12, 2012 at 10:01 pm
  • Oracle 11.2.0.2 with 2 node RAC The batch job always runs on the first node. The job uses three staging tables(Closer to 20 million,non-partitioned) to process interface jobs. The sequence of events ...
    Antony RajAntony Raj
    Jan 31, 2012 at 6:26 pm
    Feb 13, 2012 at 6:32 pm
  • Anyone have any info on what exactly "Disk file operations I/O" is? A customer upgraded from 10.2.0.4 where things were running fine to 11.2.0.3 and now they are hitting high contention on buffer ...
    kyle Haileykyle Hailey
    Jan 18, 2012 at 12:40 am
    Jan 20, 2012 at 6:49 pm
  • I need some advice. I seem to be asked more and more the dreaded "why does my query run faster on InstanceA and slower on InstanceB?" I provide all kinds of query tuning help to our developers, ...
    David MannDavid Mann
    Jan 6, 2012 at 2:43 pm
    Jan 11, 2012 at 3:59 pm
  • I've run into a situation I can't explain and it may just be I'm unfamiliar with a VALID reason this would occur. (Though, I can't see how this would be valid) We have a query: Select btd.trip_id, ...
    Taylor, Chris DavidTaylor, Chris David
    Jan 31, 2012 at 3:37 pm
    Jan 31, 2012 at 9:20 pm
  • Hi all: There is a proposal to consolidate all hardware platform and we are looking at converting the database from IBM/AIX to Windows. What would be the best method to do this? Datapump or ...
    Manjula KrishnanManjula Krishnan
    Jan 18, 2012 at 7:53 pm
    Jan 20, 2012 at 2:53 pm
  • Hi Anyone installed Grid Infrastructure 11.2.0.3 in Oracle Linux 5.7 and Unbreakable Enterprise Kernel (UEK) loaded? I am trying to install, all goes fine but ACFS doesnt seem supported with this ...
    LS ChengLS Cheng
    Jan 20, 2012 at 12:14 pm
    Jan 20, 2012 at 1:59 pm
  • I need to run a script on a client machine that calls the sqlldr on the server and load a file on the local client box in unix. I know I can load sqlldr on the client box but can't really do that in ...
    Dustin HaydenDustin Hayden
    Jan 12, 2012 at 12:05 pm
    Jan 12, 2012 at 4:14 pm
  • Hi all, I am having spermatic (Oracle 9.2 on Win2K3) during cold backup. I can see in the rman log file that database goes down completely, but when it comes back up it reports the error: Errors in ...
    Eugene PipkoEugene Pipko
    Jan 9, 2012 at 5:49 pm
    Jan 10, 2012 at 4:42 am
  • Our developers are working on a large project that is going to require a lot of scripts to convert data and due to an error in one of the scripts one of our tables was fubar. So the question came up ...
    Taylor, Chris DavidTaylor, Chris David
    Jan 27, 2012 at 8:14 pm
    Jan 27, 2012 at 9:02 pm
  • Hello, We are designing a DR solution using Oracle Data Guard 11gR2. 1- Physical Oracle Data Guard with Primary / Standby database. 2- Use Maximum Availability Mode. 3- Use the Observer for automatic ...
    Mek sMek s
    Jan 19, 2012 at 8:53 am
    Jan 20, 2012 at 12:16 pm
  • Hi Folks, although this topic was already widely discussed in the blogosphere, I'd like to discuss it again. It is said that from 10g on COALESCE uses short-circuit evaluation. But what happens in ...
    Uwe KüchlerUwe Küchler
    Jan 19, 2012 at 3:01 pm
    Jan 19, 2012 at 5:25 pm
  • Hi all, Any Perl hackers/mongers out there? Is there a way to do a savepoint natively in DBI/DBD::Oracle? Currently, we have implemented a savepoint via call to PL/SQL stored object. Problem is, this ...
    Bobak, MarkBobak, Mark
    Jan 26, 2012 at 6:28 pm
    Feb 1, 2012 at 5:28 pm
  • Hi Folks, Good day. yesterday i dropped a table accidentally on staging database (11gSE1 Rel 2 on SLES 10 on no archive log mode and no flash recovery enabled) and we do not have any backups to ...
    Sundar mahadevanSundar mahadevan
    Jan 25, 2012 at 5:58 pm
    Jan 25, 2012 at 9:41 pm
  • We are working on an application that will store images, well actualy pdf's in our database. We are debating on storing the blobs in our main production database or creating a separate database just ...
    Jeff ChircoJeff Chirco
    Jan 17, 2012 at 6:48 pm
    Jan 18, 2012 at 3:49 pm
  • I ran into an issue today where I have 2 databases running the same query. Both databases are **nearly identical in data** and **are identical in parameters** (except for string specific parameters ...
    Taylor, Chris DavidTaylor, Chris David
    Jan 16, 2012 at 10:05 pm
    Jan 17, 2012 at 6:47 pm
  • Does anyone have opinions/experience/preferences on bigfile tablespaces? I had someone ask recently, but I have always used smallfile tablespaces. Sent from my iPhone-- ...
    GG
    Jan 10, 2012 at 2:10 am
    Jan 12, 2012 at 12:04 pm
  • Hi all, I need to be able to parse list of customers by first/last names. The problems is that each name can come in many different ways. For instance: 'Eugene Pipko' 'Eugene Pipko' -- many blanks in ...
    Eugene PipkoEugene Pipko
    Jan 10, 2012 at 7:01 pm
    Jan 10, 2012 at 7:09 pm
  • 9.2.0.8. I have a table partitioned daily and subpartitioned by list on which there are two local indexes and two global unique indexes. The maintenance job for this table runs at the weekend getting ...
    Dominic BrooksDominic Brooks
    Jan 26, 2012 at 9:21 pm
    Jan 27, 2012 at 6:05 pm
  • 1. is it possible to get the bind variable from a query, if you start the trace after the query has started? I have been using 10046 trace. Any other traces that might get this? 2. When I look in ...
    Dba DBADba DBA
    Jan 26, 2012 at 3:30 pm
    Jan 26, 2012 at 5:49 pm
  • Grid Control : 10.2.0.5 I could upgrade to a newer release if it works in those versions. can the OEM send a page? Or a text message? can the OEM call a shell script? We have a shell script that will ...
    Dba DBADba DBA
    Jan 23, 2012 at 6:01 pm
    Jan 24, 2012 at 2:07 pm
  • Hi lists Maybe this is the question you do not think it should be the question. for FAL_SERVER and FAL_CLIENT parameter in Data Guard (PRIMARY and STANDBY): 1. As all we know: in Primary site ...
    KamusKamus
    Jan 17, 2012 at 9:41 am
    Jan 18, 2012 at 6:16 pm
  • Hi, I would like to know how to identify who has DBA privilege. If I do : SELECT * FROM user_ROLE_PRIVS I can see my privileges. There is no ALL_ROLE_PRIVS and DBA_ROLE_PRIVS . Is there another view ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Jan 12, 2012 at 8:40 pm
    Jan 14, 2012 at 12:05 am
  • Gurus, Any way to segregate vendors or external groups that when defined in Active directory prevents an Oracle R12 EBS user account from getting created ? Thank you for any ideas Best regards, -- ...
    BalaBala
    Jan 31, 2012 at 11:01 pm
    Feb 3, 2012 at 3:20 am
  • RHEL 5 Oracle EE 11.2.0.2 Is it possible to have a second observer so that if the first one fails, the redundant one takes over automatically? I'm not sure if I would trust it even if possible, but ...
    Armstrong-Champ, Joseph WilliamArmstrong-Champ, Joseph William
    Jan 24, 2012 at 4:38 pm
    Jan 26, 2012 at 4:17 am
  • Anyone know a good way to estimate the overall progress of a constraint creation/validation? We're in the process of adding a number of NOT NULL constraints that were inadvertently dropped from a ...
    Adric NorrisAdric Norris
    Jan 24, 2012 at 5:33 pm
    Jan 24, 2012 at 9:31 pm
  • Oracle-l readers, Does anyone have an idea how to decode this strace entry? Or where to look for more info? 0.000222 read(11, "\1w\0\0\6\0\0\0\0\0\20\27\0\0\0\307+\337\201\340\37\314\300\177p\334f\1 ...
    Steve GardinerSteve Gardiner
    Jan 12, 2012 at 2:41 pm
    Jan 13, 2012 at 6:30 am
  • I am working on a pet project that aims to ease my job a lot, but it requires getting information from Active Directory. Using my own DN (which was easy enough to find out) I was able to log on to ...
    Guillermo Alan BortGuillermo Alan Bort
    Jan 11, 2012 at 6:52 pm
    Jan 12, 2012 at 3:28 pm
  • Hi, experts, Recently I need to think about replication (Golden Gate, or Shareplex or Streams) vs Dataguard. I understand they can be used for different purpose. Specifically Dataguard is a DR ...
    DenisDenis
    Jan 11, 2012 at 3:07 pm
    Jan 12, 2012 at 6:01 am
  • My ADR information is filling up my root directory instead of where I thought it should be going. I have this set in my listener.ora file: ADR_BASE_LISTENER=/oracle/SND/saptrace In my spfile I have ...
    Laurent, VincentLaurent, Vincent
    Jan 9, 2012 at 4:30 pm
    Jan 10, 2012 at 5:50 pm
  • All, I'm getting the following error when trying to add a 3 Tb ASM disk under 11.2.0.3 ASM on REL 5.3: ORA-15099 disk <disk-name is larger than the maximum size of 2097152 bytes Looks like it may be ...
    Gerald CunninghamGerald Cunningham
    Jan 9, 2012 at 11:36 pm
    Jan 10, 2012 at 3:49 pm
  • We had a problem with our PGA growing larger than physical memory, dragging the system down until we were forced to restart the database. We recently upgraded from 9i to 11gR2 on Solaris with 16Gb ...
    Robert LavertyRobert Laverty
    Jan 30, 2012 at 11:14 pm
    Jan 31, 2012 at 7:19 pm
  • Hi: I created IOT secondary index using parallel 4 online option on two databases. One database is 10203 version and another one is 11202 version. On 10203 version, the SQL finished in 20 minutes, ...
    Eagle FanEagle Fan
    Jan 18, 2012 at 1:23 pm
    Jan 23, 2012 at 5:10 am
  • I am trying to restore a single tablespace in rman. Restoring from asm to file system. I am comfortable with the set newname command below, but I am not sure about the syntax for the restore database ...
    Andrew KerberAndrew Kerber
    Jan 19, 2012 at 3:39 pm
    Jan 19, 2012 at 5:41 pm
  • I tried to check new user tablespace quota but can NOT find? any ideal? create user user1 identified by user1 default tablespace USERS temporary tablespace temp; grant connect, resource to user1 ...
    Dba1 mccDba1 mcc
    Jan 18, 2012 at 4:46 pm
    Jan 18, 2012 at 5:12 pm
  • Hi friends, I am in trouble to do the following update: update eri set texto = 'CONDUTOD MC'S 12234' ; How can I do it ? Regards Eriovaldo -- http://www.freelists.org/webpage/oracle-l
    Eriovaldo AndriettaEriovaldo Andrietta
    Jan 16, 2012 at 5:42 pm
    Jan 16, 2012 at 5:58 pm
  • Hi, I have a rac database on 11gr2 for study purposes, and I would like to put this db on archivelog mode in order to study backup with Rman. However, my doubt is related to the location of those ...
    Alex CwbAlex Cwb
    Jan 14, 2012 at 3:11 pm
    Jan 14, 2012 at 4:28 pm
  • I ran a google search for a topic I started here today and, as I expected, the first result was the oracle-l history www.freelists.org/post/oracle-l/*OEM*-*Repository*-*DataGuard*-Possible but then I ...
    Guillermo Alan BortGuillermo Alan Bort
    Jan 12, 2012 at 6:26 pm
    Jan 12, 2012 at 7:45 pm
  • Hello everyone, We see the DB console down and looking into the emoms.trc file below errors intermittently in our Oracle 11gR2 RAC (2 node) production database (Redhat Linux 5): * * * [XMLLoader0] ...
    Mek sMek s
    Jan 12, 2012 at 11:10 am
    Jan 12, 2012 at 1:00 pm
  • Hello, We are getting 100% waits for "Others' event class for instance 1 and instance 2 at times in RAC 11.2.0.2.3, 7 nodes environment (Redhat Linux 5). The ADDM report showing these findings; (see ...
    Mek sMek s
    Jan 4, 2012 at 12:05 pm
    Jan 4, 2012 at 1:31 pm
  • Hi to you all, is there anyone using Grid Control 11g to monitor Databases Instances 8i ? I'm using agent 10.2.0.5 with the lastest PSU (October 2011) applied to it, but I'm still facing some ...
    Ricardo SantosRicardo Santos
    Jan 2, 2012 at 1:10 pm
    Jan 2, 2012 at 3:10 pm
  • Mark, I was unfamiliar with Cray's stance until you mentioned it and I'm curious where this leads us when discussing big data? Specifically, "sets" of big data. Since we (as humans) are storing more ...
    Taylor, Chris DavidTaylor, Chris David
    Jan 31, 2012 at 2:55 pm
    Jan 31, 2012 at 7:00 pm
  • Good evening listers, out of (historical) interest, does anyone have the list of platforms supported with Oracle 7.x and 8.x? The download sites are long closed and I can't check those. So for ...
    Martin BachMartin Bach
    Jan 29, 2012 at 9:04 pm
    Jan 30, 2012 at 4:52 am
  • Saw this in one of our server logs this past week. I have edited out the dups: ------------------------------------------ Fri Jan 20 16:06:43 2012 Archived Log entry 43943 added for thread 1 sequence ...
    Laurent, VincentLaurent, Vincent
    Jan 27, 2012 at 8:10 pm
    Jan 27, 2012 at 8:34 pm
  • hi, do You know where I may find a detailed version of description of BIND section in 10046 traces? I am especially interested in the meaning of csi field - did not find any description on metalink ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jan 4, 2012 at 7:35 am
    Jan 24, 2012 at 11:29 am
  • Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority Information Systems 1240 W. 6th Street Cleveland, Ohio 44113 -- http://www.freelists.org/webpage/oracle-l
    Jeffrey BeckstromJeffrey Beckstrom
    Jan 23, 2012 at 1:48 pm
    Jan 23, 2012 at 5:02 pm
Jan 2012
123
Group Navigation
period‹ prev | Jan 2012 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions103
posts441
users153
websiteoracle.com

153 users for January 2012

Taylor, Chris David: 31 posts Andy Klock: 15 posts Guillermo Alan Bort: 10 posts Rjamya: 10 posts Jonathan Lewis: 8 posts Niall Litchfield: 8 posts Bobak, Mark: 7 posts Eugene Pipko: 7 posts kyle Hailey: 7 posts LS Cheng: 7 posts Yong Huang: 7 posts Allen, Brandon: 6 posts Denis: 6 posts G: 6 posts Kellyn Pot'vin: 6 posts Laurent, Vincent: 6 posts Michael Moore: 6 posts Radoulov, Dimitre: 6 posts Subodh Deshpande: 6 posts Laimutis Nedzinskas: 5 posts
show more
Archives