Search Discussions

84 discussions - 524 posts

  • Hi all The question is probably a bit vaue but has anyone succesfully applied Queueing Theory in an Oracle Database using database metrics such as Logical Reads, User Calls, Executes? (Not ...
    Ls ChengLs Cheng
    Mar 11, 2014 at 1:58 pm
    Mar 14, 2014 at 7:21 pm
  • Hi list, We got an environment formed by one standalone 11g database (lets call it RW) with an active dataguard on another server (lets call it RO) We have provided to the users 2 tnsnames, one ...
    Ricard MartinezRicard Martinez
    Mar 31, 2014 at 3:56 pm
    Apr 3, 2014 at 12:11 am
  • Hi We are facing a performance problem but unable to identify where is the problem. We have a production database server where about 8 database instances of oracle is running. Daily we insert in each ...
    Abhishek GurungAbhishek Gurung
    Mar 13, 2014 at 11:52 am
    Mar 14, 2014 at 2:48 pm
  • Ok I think you guys have convinced me to use OMF. Now my next question is do you create your database manually using scripts or use DBCA. I have alway used DBCA, not really a big shop here. I like ...
    Jeff CJeff C
    Mar 24, 2014 at 4:45 pm
    Mar 25, 2014 at 8:50 pm
  • RHEL 5.10 / Oracle This seems to be one of those classic situations that everyone runs across at one time or another. We've been approached to assist in making an existing in-house ...
    Ryan JanuaryRyan January
    Mar 17, 2014 at 10:04 pm
    Mar 23, 2014 at 12:19 pm
  • Hi All, We have a database where we are upgraded to 11G from 9i. We have gone through the cycle of upgrading test first and doing testing before upgrading production and everything appeared fine ...
    Jack van ZanenJack van Zanen
    Mar 26, 2014 at 10:16 pm
    Mar 28, 2014 at 10:07 pm
  • Hi all, I'm having a slight disagreement with my developers, and hoping you guys can help me out (either confirm what I think or tell me I'm flat-out wrong, I can take either, I just need to get this ...
    Uzzell, StephanUzzell, Stephan
    Mar 15, 2014 at 2:11 am
    Mar 22, 2014 at 2:08 pm
  • Hi all~ We are in the process of upgrading our database from 9i to 11gR2 on Solaris SPARC 64-bit platform. I was wondering if anyone knows a list of oracle hints that will not work anymore in 11gR2 ...
    Bheemsen AithaBheemsen Aitha
    Mar 27, 2014 at 5:42 am
    Mar 31, 2014 at 2:02 pm
  • select count (*) from my_table where completion_time between to_date(:"SYS_B_0",:"SYS_B_1") and to_date(:"SYS_B_2",:"SYS_B_3") so does these variations of it ... select (my_col) where my_col is PK ...
    Fred HabashFred Habash
    Mar 5, 2014 at 5:57 pm
    Mar 20, 2014 at 11:13 pm
  • Hi All, Looking at an AWR report from a customer site where they have had some very slow performance. Server is 32 CPU and 26GB running Oracle AWR is over 1 hour and shows: Parses: 22.6 0.5 ...
    Fred TillyFred Tilly
    Mar 25, 2014 at 12:30 pm
    Mar 28, 2014 at 9:21 am
  • Hi experts, I have a query in which I am trying to get the CMV and EBV results for the patient's last transplant. I put in the following subquery code: (SELECT RECIPIENT_CMV_IGG FROM PAT_TRANSPLANT ...
    William ThrelfallWilliam Threlfall
    Mar 12, 2014 at 5:53 pm
    Mar 14, 2014 at 7:15 pm
  • OS - Solaris Sparc 10 Oracle - EE We upgraded a dev database from to One of our ETL jobs started failing with errors ORA-12012, ORA-04021, ORA-06512. We have identified ...
    Sandra BeckerSandra Becker
    Mar 7, 2014 at 3:31 pm
    Mar 10, 2014 at 2:07 pm
  • Hi all I am currently upgrading a few databases from to and running SQL regression tests using SQL Performance Analyzer, I have detected a few queries that is not performing well in ...
    Ls ChengLs Cheng
    Mar 4, 2014 at 12:01 pm
    Mar 5, 2014 at 10:51 am
  • I have never used OMF for my database file structure and I was wondering is this what everybody is doing now? I realize that if you are using ASM you have to go with OMF so I am really only talking ...
    Jeff CJeff C
    Mar 21, 2014 at 12:35 pm
    Mar 24, 2014 at 10:20 pm
  • I am getting the following error on RHEL 5.4 Oracle XE Any idea what the issue is? ERROR: ORA-01034: ORACLE not available ORA-27102: out of memory Linux-x86_64 Error: 12: Cannot allocate ...
    John DunnJohn Dunn
    Mar 12, 2014 at 10:52 am
    Mar 13, 2014 at 6:51 am
  • I'm considering a two-node RAC for a new production environment. For the DR, I'd hoped to use active data guard, but it's very expensive. I've avoided the architectural option of adding a third node, ...
    Chris KingChris King
    Mar 4, 2014 at 3:48 pm
    Apr 3, 2014 at 1:01 am
  • Hi Group, I have two DBs10.2.0.4 running on Solaris 10. And the output on these two databases are totally different from sqlplus: Select 'a' from dual; Output a: ' - a output b: 'A' ...
    Mar 25, 2014 at 1:31 pm
    Mar 27, 2014 at 11:02 am
  • This is Oracle running on 32 bit Windows. We have had an "ORA-1652 - Unable to extend temp segment ..." and I am trying to get an idea of how much larger the temp tablespace needs to be ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Mar 26, 2014 at 4:44 pm
    Mar 27, 2014 at 10:23 am
  • Can anyone tell me why an application would be compatible with oracle but not rac? I'm assuming it must have to do with connectivity, but not sure why that isn't transparent to all applications? ...
    Chris KingChris King
    Mar 26, 2014 at 6:17 pm
    Mar 26, 2014 at 8:25 pm
  • Hi all, We recently had an issue with an undersized shared pool. We've increase the size of the shared pool and think this should be resolved. Our customer, however, is freaking out and wants to ...
    Uzzell, StephanUzzell, Stephan
    Mar 11, 2014 at 1:46 pm
    Mar 11, 2014 at 5:45 pm
  • Hi, We've a 2-node RAC with oracle enterprise edition ver Now in order to fix the TNS Poison security breach, I'm applying the fix as per metalink note 1340831.1 and took following steps: 1) ...
    Saad KhanSaad Khan
    Mar 11, 2014 at 1:40 pm
    Mar 11, 2014 at 2:32 pm
  • We've tested and are starting to move some of our Data Guard physical standby's to storage with snapshot capabilities, specifically Netapp. Our plan is to use snapshots and transported log files in ...
    Kenny PaytonKenny Payton
    Mar 24, 2014 at 11:35 pm
    Jun 1, 2014 at 5:45 am
  • Hi experts, I just spent 2 hours searching online for a way to do this, without success. Why is this difficult? This was simple to do in FoxPro! Anyway, I have been given an Excel file containing a ...
    William ThrelfallWilliam Threlfall
    Mar 3, 2014 at 11:28 pm
    Mar 12, 2014 at 5:24 pm
  • Hi, Sorry for simple question but I looking for some way to do restore controlfile with RMAN SET UNTIL TIME. For example you have 100 controlfiles in tape device and don't want to look and find ...
    Mar 11, 2014 at 4:39 pm
    Mar 12, 2014 at 8:53 am
  • I don't know if this is a good question worth an answer or not; nevertheless I couldn't resist the temptation to ask it. I have a real life unique two columns composite *index ind_uk (a,b)*having the ...
    Mohamed HouriMohamed Houri
    Mar 28, 2014 at 9:54 am
    Mar 28, 2014 at 4:16 pm
  • After an incredibly long wait, Exadata is finally heading this way. Two X4-2 quarter racks. Management is thinking about using 1 exa for production disaster recovery + dev/test environments. My gut ...
    Stephens, ChrisStephens, Chris
    Mar 6, 2014 at 3:56 pm
    Mar 10, 2014 at 8:14 pm
  • Dear Experts, Any suggested books on data modeling? To learn and enhance knowledge in this area. Books covering design techniques for OLTP, Data Warehousing. Thanking you all for your help and time ...
    Vijay sehgalVijay sehgal
    Mar 7, 2014 at 5:36 pm
    Mar 10, 2014 at 4:29 pm
  • Hi guru of oracle-l =) what does Grouping column cardinality mean in 10053 trace ? example: Access path analysis for SEGMENT_ALL_1 *************************************** SINGLE TABLE ACCESS PATH ...
    Mar 3, 2014 at 3:34 pm
    Mar 6, 2014 at 2:35 am
  • We have a Solaris 10 server and I just noticed that the dates on newly created files aren't matching the SYSTEM date of the server. The filesystem in question is mounted on a Netapp device and the ...
    Chris TaylorChris Taylor
    Mar 12, 2014 at 1:37 pm
    Mar 13, 2014 at 2:14 am
  • All - Red Hat Enterprise Linux Server release 5.8 (Tikanga) Oracle 11.1 and 11.2 databases 252gb main memory Page_size = 4096 (bytes) Shmmax = 76800000000 (bytes) shmall = 4194304 (pages) I am sort ...
    Sweetser, JoeSweetser, Joe
    Mar 31, 2014 at 6:41 pm
    Apr 3, 2014 at 7:28 pm
  • We want to patch Oracle Database 11g Enterprise Edition Release - 64bit running on Windows Server 2008 R2 Enterprise. I've searched My Oracle and here's the best that I can come up with ...
    Thomas DayThomas Day
    Mar 19, 2014 at 12:57 pm
    Mar 19, 2014 at 6:32 pm
  • Happy PI Day, everyone! I'm going thru Grid/RAC setup for the first time. Finding the manual confusing when it explains how to set up storage. This is 11gR2 on linux. The install guide indicates I ...
    Chris KingChris King
    Mar 14, 2014 at 5:48 pm
    Mar 17, 2014 at 4:45 pm
  • I had a disk group on a node in a RAC cluster go in the intermediate state which prevented srvctl from starting the database because there was a dependency on the diskgroup. To resolve the issue I ...
    Mar 13, 2014 at 3:56 pm
    Mar 16, 2014 at 9:05 pm
  • How do I setup EM 12C so that it sends an email notification when a metric event alert clears? Jeffrey Beckstrom Database Administrator Information Systems Greater Cleveland Regional Transit ...
    Jeffrey BeckstromJeffrey Beckstrom
    Mar 14, 2014 at 1:23 pm
    Mar 14, 2014 at 3:42 pm
  • SQL select * from test where c1 like 'a1_%'; C1 ---------- a1_a2 a1_a3 a1_a4 SQL insert into test values('a1a4'); 1 row created. SQL select * from test where c1 like 'a1_%'; C1 ---------- a1_a2 a1_a3 ...
    Veerabasaiah CVeerabasaiah C
    Mar 13, 2014 at 9:47 pm
    Mar 14, 2014 at 12:17 am
  • I'd run up a few samples of the things you want to do, but you've picked a critical point. If you encrypt a tablespace, blocks are encrypted on disc, but not in memory. (Any attempt to dump an ...
    Jonathan LewisJonathan Lewis
    Mar 11, 2014 at 3:33 pm
    Mar 11, 2014 at 6:14 pm
  • Hey all, In, our ERP migration is adding 14 columns with default values to a populated table: ALTER TABLE erptbl ADD (newcol1 NCHAR(1) DEFAULT ' ',... -- This is running single-threaded, ...
    Rich JesseRich Jesse
    Mar 5, 2014 at 3:44 pm
    Mar 5, 2014 at 7:06 pm
  • I think I already know the answer to this one (No), but thought of taking your opinions. Suppose a shop wants to use different clusters for different purposes - RAC, RHCS, ServiceGuard, HACMP, ...
    Nadeem M. KhanNadeem M. Khan
    Mar 29, 2014 at 9:41 am
    Mar 29, 2014 at 1:15 pm
  • All, We recently made some changes to names server which hosts SCAN IPs for a RAC cluster. There is no change in domain name, SCAN Ips or anything, it's just we added another secondary DNS server and ...
    Stalin SubbiahStalin Subbiah
    Mar 11, 2014 at 9:48 pm
    Mar 20, 2014 at 2:06 am
  • We were being slightly silly and running a SQL*Plus script to truncate a load of tables and load them (insert into table select ... from other_table) in parallel over and over again, starting some ...
    Paul HoughtonPaul Houghton
    Mar 19, 2014 at 4:04 pm
    Mar 19, 2014 at 10:07 pm
  • My boss wants a single report that gives information about both our Oracle and SQL Server databases. Our expert in SSRS will be leaving in a week so we were wanting to create a report in Apex ...
    Sandra BeckerSandra Becker
    Mar 14, 2014 at 8:22 pm
    Mar 14, 2014 at 8:46 pm
  • I can identify a Global Temporary Tablespace consuming space in the Temp tablespace by querying V$SORT_USAGE / V$TEMPSEG_USAGE. It appears as a row with CONTENTS='TEMPORARY' SEGTYPE= 'DATA' If I have ...
    Chitale, Hemant KChitale, Hemant K
    Mar 13, 2014 at 6:23 am
    Mar 13, 2014 at 4:07 pm
  • I am running 2 versions of oracle on a server, one 10g(port 1521) and another 11g(port 1522). I added an entry to the tnsnames for a db link. That server uses 1521. Do I keep that entry at 1521 or ...
    Zelli, BrianZelli, Brian
    Mar 11, 2014 at 6:35 pm
    Mar 11, 2014 at 7:59 pm
  • I am exporting data from 10g to 11g and when we did it in test, the analyst said the sequences were out of whack. I would then play around until I could get it close. How do I deal with a sequence ...
    Zelli, BrianZelli, Brian
    Mar 11, 2014 at 2:06 pm
    Mar 11, 2014 at 2:59 pm
  • Hi List, Oracle on RHEL 6.3 w/ASM. We see 'write complete waits' from a single session with no SQLID from OEM... I see the definition for this wait is at ...
    Mar 10, 2014 at 10:29 pm
    Mar 11, 2014 at 2:25 pm
  • Hello, Does anyone have any good methods they use to automate the startup mount of a physical standby after a server reboot? Our server startup scripts want to startup the instance, which puts it in ...
    Michael SchmittMichael Schmitt
    Mar 10, 2014 at 7:54 pm
    Mar 10, 2014 at 10:49 pm
  • Hi List, Oracle on RHEL 6.3 w/ASM. We are full CTASing a table (27M rows with LOB - ~250GB) into another TS (to change chunk/block size) (please don't ask "why not move" - it's a long story ...
    Mar 10, 2014 at 4:20 am
    Mar 10, 2014 at 10:10 pm
  • Hey all, In, I'm trying to determine where a query over a dblink originated using: SELECT SYS_CONTEXT('USERENV','DBLINK_INFO') FROM DUAL@REMDB; ...but it always returns a NULL. This is ...
    Rich JesseRich Jesse
    Mar 3, 2014 at 5:23 pm
    Mar 5, 2014 at 5:37 am
  • Oracle DBMS v11.2.0.3 2-node RAC ASM on raw devices AIX v6.1 (a TEST environment !) Added a bunch of raw devices into ASM using the following: === SQL alter diskgroup data add disk ...
    Hubler, DanielHubler, Daniel
    Mar 19, 2014 at 1:04 pm
    Mar 19, 2014 at 2:19 pm
  • Hi All, I have a quick question about Oracle pipes sizes and the messages at the queue. Basically what I am looking for is a method to identify the size of the pipe in the the shared pool as well as ...
    Hanan HitHanan Hit
    Mar 17, 2014 at 9:14 pm
    Mar 18, 2014 at 5:00 am
Group Navigation
period‹ prev | Mar 2014 | next ›
Group Overview
grouporacle-l @

156 users for March 2014

Jonathan Lewis: 34 posts Ls Cheng: 25 posts Mark W. Farnham: 22 posts Hans Forbrich: 17 posts Rich Jesse: 17 posts David Fitzjarrell: 15 posts Mark Bobak: 14 posts Chitale, Hemant K: 11 posts Mohamed Houri: 9 posts Uzzell, Stephan: 9 posts Abhishek Gurung: 7 posts John Hurley: 7 posts Kenny Payton: 7 posts Chris King: 6 posts Dominic Brooks: 6 posts Jack van Zanen: 6 posts Obivan: 6 posts Powell, Mark: 6 posts Ruel, Chris: 6 posts Saad Khan: 6 posts
show more