Search Discussions

94 discussions - 525 posts

  • List, We have a 10.2 db with the ASMM enabled. Here are some of the SGA components currently: COMPONENT CURRENT_SIZE MAX_SIZE OPER_COUNT ---------- ---------- shared pool 12,029,263,872 0 4289 large ...
    Ram RamanRam Raman
    Sep 26, 2011 at 10:30 pm
    Oct 11, 2011 at 1:49 pm
  • i had one big OLTP environment running on Solaris 10 with 256G RAM and 30+ CPU. There are sometime in a day when all OS command are totally freezed. Even ls command take several minute. CPU was ...
    Sanjay MishraSanjay Mishra
    Sep 13, 2011 at 7:56 pm
    Sep 26, 2011 at 5:08 am
  • Ok, we just got hit with a "Are you testing your backups?" from senior administration. We sometimes use copies to replace test or dev but they want a scheduled plan. The first thing I mentioned was ...
    Zelli, BrianZelli, Brian
    Sep 6, 2011 at 6:23 pm
    Sep 15, 2011 at 9:27 pm
  • Anyone have a link to salary info for a combination for combo Oracle and SQL Server DBA? Or, might be willing to share a salary range (with me, not the list) if you are responsible for both? :) Looks ...
    Taylor, Chris DavidTaylor, Chris David
    Sep 20, 2011 at 3:25 pm
    Sep 20, 2011 at 10:14 pm
  • I am just curious if its common for an Explain Plan of a view to have a totally different response than an explain plan of the SQL behind the view. Reason being, we have a very simple view made of of ...
    Lange, Kevin GLange, Kevin G
    Sep 1, 2011 at 10:11 pm
    Sep 7, 2011 at 8:41 pm
  • I have a 2-node RAC running on 64-bit Red Hat Linux. Documentation says we can't do in-place upgrade of the grid infrastructure, and we don't want to do out-of-place upgrade. So the only ...
    Yong HuangYong Huang
    Sep 29, 2011 at 6:28 pm
    Oct 6, 2011 at 8:25 am
  • Trying to understand what is affecting the performance of some INSERTs that we have going on. Database is a 3 node RAC database. Table is a range-hash partitioned table (date range, 128 ...
    Wayne AdamsWayne Adams
    Sep 26, 2011 at 7:58 pm
    Sep 29, 2011 at 6:04 pm
  • I'm reproducing a short entry I wrote at the behest of Oracle below. I, and I'm sure others, have been known to whinge from time to time about the OCP. Oracle Ed is at least asking practicing DBAs ...
    Niall LitchfieldNiall Litchfield
    Sep 10, 2011 at 9:24 am
    Sep 13, 2011 at 11:38 pm
  • Hi, I'm trying to install RAC 11.2.0 - Linux-x86-64, RedHat 5.3, oracle (fyi - I also tried with and got the same result) Has anyone seen this before, and have a solution? ...
    Walker, Jed SWalker, Jed S
    Sep 28, 2011 at 3:51 pm
    Dec 15, 2011 at 8:32 pm
  • Hey Listers, Any cool tricks for monitoring a bunch of physical standby environments? We have 20 or so physical standby databases, and are having trouble figuring the best strategy to monitor them ...
    Uzzell, StephanUzzell, Stephan
    Sep 20, 2011 at 5:51 pm
    Oct 3, 2011 at 2:05 am
  • Hello List, Is it possible to take an RMAN backup (full or incremental level 0) and rewind it, rollback to a SCN or point-in-time within the controlfile's CONTROL_FILE_RECORD_KEEP_TIME window? ...
    Alan StergerAlan Sterger
    Sep 27, 2011 at 10:02 pm
    Sep 28, 2011 at 6:40 pm
  • I pulled an awr this morning for a period and the top wait events add up to almost 200%. I was curious if anyone saw this before. I've seen it slightly over 100% that I wrote off for rounding but ...
    Kenneth NaimKenneth Naim
    Sep 28, 2011 at 2:55 pm
    Oct 26, 2011 at 9:00 pm
  • Hi, We changed the timezone of a machine to Chinese Central time, but the alert log timestamps are still US EST/EDT, the original timezone. If this is controlled by the NLS settings according to ...
    Peter HitchmanPeter Hitchman
    Sep 18, 2011 at 7:19 pm
    Oct 6, 2011 at 4:23 pm
  • 10


    I may be explaining this wrong so bear with me. We throw around the title of Senior DBA just because somebody says they want it and mgt doesn't really know what the title should imply. We have a few ...
    Zelli, BrianZelli, Brian
    Sep 30, 2011 at 5:23 pm
    Oct 2, 2011 at 3:00 pm
  • I am currently using Oracle on HP-UX 11.31 I have a script that does this: # Get the path to the trace files DUMP=`/oracle/$ORACLE_SID/112_64/bin/sqlplus -s / as sysdba <<EOF set head off ...
    Laurent, VincentLaurent, Vincent
    Sep 22, 2011 at 8:44 pm
    Sep 26, 2011 at 11:15 am
  • Z‰Ýz¸§‚0šç!²çzËŸ*'z¬ §pŠØm†+5×ýÿÓýˆž×¥–(žÐÚµ£åiǦz{ÿw]¡ë"· +“¥–ŠÚµ©eÂ+ajÖ¬ÊË^šÏÅ®‰¨­§%yÚü‰ízYbéí «Z Vœzg§µéÚnW¬Ê‹­¢Ê^r'òv+$­è"¢{(œêÚrW€HÇb²K¢¶Þ²Ú^­ú+™©Ü{õ,Šx- ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Sep 30, 2011 at 4:29 pm
    Jan 16, 2012 at 9:33 am
  • I've just been given some trace files, to examine as to why a piece of sql is taking a long time to run in one evironment and not taking so much time in another environment. Both the databases are ...
    Zabair AhmedZabair Ahmed
    Sep 6, 2011 at 12:59 pm
    Sep 6, 2011 at 8:34 pm
  • Hi all We have some batch processes which need to meet some SLA, the execution time should exceed certaint threshold of time. The processes are mainly insert.... select sequence, ... from table. In ...
    LS ChengLS Cheng
    Sep 29, 2011 at 5:17 am
    Oct 11, 2011 at 3:13 pm
  • I have to issue this command for some auditing: alter system set audit_trailÛ scope=spfile; My question is that I still use a pfile. So do I use both or memory or nothing for scope? ciao, Brian Brian ...
    Zelli, BrianZelli, Brian
    Sep 21, 2011 at 6:19 pm
    Sep 21, 2011 at 6:47 pm
  • Hey all, I've got a schema in a 10.1 DB that gets a full copy of our 10.1 prod ERP schema on a monthly basis. To help reduce storage, I've dropped the PCTFREE on the largest tables to increase the ...
    Rich JesseRich Jesse
    Sep 14, 2011 at 4:56 pm
    Sep 15, 2011 at 6:09 pm
  • Does anyone here know if the habit of various oracle products to require the hosts file format to be in the form XXX.XXX.XXX.XXX HOSTNAME.DOMAINNAME HOSTNAME reflects an industry standard anywhere ...
    Niall LitchfieldNiall Litchfield
    Sep 8, 2011 at 2:45 pm
    Sep 10, 2011 at 7:42 am
  • SQL gurus, I have a developer who came to me and asked me to make a certain sql statement 'as fast as possible'. Said statement was running against a view that was sort of nasty with sub-queries and ...
    Sweetser, JoeSweetser, Joe
    Sep 8, 2011 at 9:53 pm
    Sep 9, 2011 at 8:20 pm
  • Hi why no native Oracle XE 11g for Mac OS X? Anyone has more info or speculation about this? cheers Sven -- http://www.freelists.org/webpage/oracle-l
    Sven AluoorSven Aluoor
    Sep 17, 2011 at 11:40 am
    Sep 17, 2011 at 5:38 pm
  • Hi all, could anyone clarify the following sentence: Oracle® Database Quick Installation Guide 11g Release 2 (11.2) for Linux x86-64 E16768-06 June 2011 4.1 Operating System Requirements The ...
    Radoulov, DimitreRadoulov, Dimitre
    Sep 2, 2011 at 9:21 am
    Sep 2, 2011 at 8:57 pm
  • Content-Type: text/plain; charset="US-ASCII" Well i opened an SR w/oracle and they said "that's an enhancement request, we'll get back to you", yea right. Anyways in the world of backup/recovery, i ...
    Sep 9, 2011 at 1:03 pm
    Jan 20, 2012 at 8:58 am
  • hi, let's assume we have a schema MIDDLE within the DEST database on which we defined a private remote link to remote database SRC. I am able to create in the MIDDLE schema materialized views and ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Sep 27, 2011 at 8:16 am
    Sep 29, 2011 at 8:37 am
  • Friends , I have a question (sorry if I sound too naive) . 11gR2 manuals say : "The standby redo log must have at least one more redo log group than the redo log at the redo source database, for each ...
    Sep 24, 2011 at 7:28 am
    Sep 28, 2011 at 5:39 am
  • Hello, is it possible to use ASM without root access under AIX ? We are testing this configuration but in production it would be good to not use root account to maintain ASM configuration. Regards ...
    Przemyslaw BakPrzemyslaw Bak
    Sep 22, 2011 at 10:37 am
    Sep 26, 2011 at 2:29 pm
  • Hi All, I have a 2-node test 11gR2 RAC which was running on CentOS 5.4. I recently upgraded to CentOS 5.6 and things started going south. I couldn't start crsd or cssd or even evmd after the ...
    Mohammed bhattiMohammed bhatti
    Sep 22, 2011 at 1:45 pm
    Sep 26, 2011 at 3:47 am
  • I know their are vendors (like hotsos), that have products you can buy. The company I work for is not going to buy a product. Anyone have anything more advanced than tkrpof? Preferably one that will ...
    Dba DBADba DBA
    Sep 20, 2011 at 3:50 pm
    Sep 21, 2011 at 8:07 am
  • I have numerous sql statements in the library cache where the value for executions is equal to 0. These statements have been loaded at various times over the last few days. I would assume that the ...
    Jay HostetterJay Hostetter
    Sep 19, 2011 at 3:33 pm
    Sep 20, 2011 at 12:10 pm
  • Every time I open an SR, the idea of using OCM very much appeals to me. Especially the ability for Oracle to perform health checks and recommend patches. However according to the documentation the ...
    MacGregor, Ian A.MacGregor, Ian A.
    Sep 15, 2011 at 7:52 pm
    Sep 19, 2011 at 9:07 am
  • I was just informed I'm to attend OpenWorld this year. Since I haven't done this in 10 yrs I so, I'm curious if anyone has recommendations on lodging. The last time I attended I stayed up in the ...
    Herring Dave - dherriHerring Dave - dherri
    Sep 15, 2011 at 4:52 pm
    Sep 16, 2011 at 12:20 am
  • Hello, I would like to test the configure of SNMP traps via ENterprise Manager database control (Not grid control); Fo this, I have setup a notification rule and added recieve "Generic Alert Log ...
    Mek sMek s
    Sep 8, 2011 at 9:58 am
    Sep 8, 2011 at 2:02 pm
  • Hello, We use an Oracle Standard Edition so we are not able to use Diagnostic Pack. Do you know any graphic tool to use with statspack reports ?. I knew already some like Mumbai and spviewer. Thank ...
    Thierry gascardThierry gascard
    Sep 1, 2011 at 8:09 am
    Sep 2, 2011 at 6:22 am
  • Hello; I try to understand why so much elapsed times with a stored procedure 124,037 s elapsed time against 968 s of Cpu time. There isn't very much SQL activity, but with Time Model Statistics this ...
    Thierry gascardThierry gascard
    Sep 29, 2011 at 7:41 am
    Sep 29, 2011 at 8:48 am
  • Hello Friends, I would like to know, what is the best strategy to identify and provide performance in a big system that is running in the production. Imagine a system written in java, C, perl, ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Sep 24, 2011 at 3:47 pm
    Sep 25, 2011 at 10:38 am
  • Hello, I'm planning to upgrade our clusterware from to ASM, and the database are also at Because of time constraints, I'll be upgrading the clusteware first, and then ...
    Ed lewisEd lewis
    Sep 20, 2011 at 5:57 pm
    Sep 23, 2011 at 7:30 pm
  • PLEASE, need help... Oracle version 10.2.5 on HP-UX B.11.11 User called about 2 hours ago. They cannot connect to their test instance. We found all instances were affected with the ORA-12699, tried ...
    Rusnak, Al A CTR (US) DeCA HQ CIRusnak, Al A CTR (US) DeCA HQ CI
    Sep 20, 2011 at 5:34 pm
    Sep 20, 2011 at 6:32 pm
  • I had one Replication Setup which is Multimaster setup done earlier in 11g R1. Now we consolidated three Server part of the Database into one and so one of the Master Site is final consolidated one ...
    Sanjay MishraSanjay Mishra
    Sep 8, 2011 at 3:32 pm
    Sep 8, 2011 at 5:08 pm
  • Oracle note 1151394.1 says "The 32-bit Oracle client does not contain any 64-bit components. You must install a 64-bit client, which can be found on Technet under "Microsoft Windows (x64)"." Is that ...
    Taylor, Chris DavidTaylor, Chris David
    Sep 1, 2011 at 8:24 pm
    Sep 4, 2011 at 3:32 am
  • Content-Type: text/plain; charset="US-ASCII" In 11.1, as software owner(ie: oracle) on linux, i could read the ocr backups and am writing a script to capture those AND dump ASM metadata to file and ...
    Sep 1, 2011 at 5:43 pm
    Sep 2, 2011 at 5:41 pm
  • Hi All, We are looking for a best configuration for IBM P7 server on which we are planning to install Oracle 11g as a database. We need to have best recommended configuration which should provide ...
    Subharaj ChakrabortySubharaj Chakraborty
    Sep 24, 2011 at 5:59 am
    Oct 4, 2011 at 4:38 am
  • Hi Experts, One quick question, I have a 5 RAC nodes 11gR2 on Redhat Linux. To backup my cluster, I would like to prapare my nodes for cloning, just in case of totally losing the whole cluster. My ...
    Mek sMek s
    Sep 16, 2011 at 7:55 am
    Sep 19, 2011 at 9:25 am
  • Ok, I asked earlier in the week what everyone was doing for testing recoveries. So now we are going to build a separate playground area for these to occur. So if I need oracle 9, 10 and 11 on this ...
    Zelli, BrianZelli, Brian
    Sep 8, 2011 at 7:20 pm
    Sep 10, 2011 at 4:21 am
  • we have ORACLE 11G ( on LINUX server. What we use is "active data guard". Our problem is when we switch to "active data guard", standby database always on "wait_for_gap". We need switch log ...
    Dba1 mccDba1 mcc
    Sep 7, 2011 at 2:29 pm
    Sep 7, 2011 at 3:33 pm
  • Hi all - I have a generic question that hopefully some of you have experience at. What do you think the IT requirements would be for a project that wants to take an existing Oracle 11 database ...
    Bill FergusonBill Ferguson
    Sep 1, 2011 at 1:12 pm
    Sep 1, 2011 at 2:23 pm
  • Hello, I am adding a new to the cluster RAC 11gR2 (6 nodes) on Redhat Linux; ssh connectivity are ok on all nodes and also on the node 7 to be added. When running the addnode.sh from node 1 as a grid ...
    Mek sMek s
    Sep 30, 2011 at 10:56 am
    Oct 2, 2011 at 3:12 pm
  • Hi, When reading the Topic of M/M/m Module in the book <<Optimizing Oracle Performance by Gary Millsap, I have the idea to verify if our I/O subsystem can fit the M/M/m module. The db is IO intense, ...
    Sidney ChenSidney Chen
    Sep 27, 2011 at 3:18 am
    Sep 27, 2011 at 2:39 pm
  • Hey List-ers, Without buying the Provisioning Pack, is it possible to create a kickstart image of a box that has the grid infrastructure installed and ready to configure? The results from the ...
    Z bZ b
    Sep 27, 2011 at 12:07 pm
    Sep 27, 2011 at 12:27 pm
Group Navigation
period‹ prev | Sep 2011 | next ›
Group Overview
grouporacle-l @

157 users for September 2011

Taylor, Chris David: 21 posts Niall Litchfield: 20 posts Chitale, Hemant Krishnarao: 18 posts Sanjay Mishra: 13 posts D'Hooge Freek: 11 posts Jeremy Schneider: 11 posts Zelli, Brian: 11 posts Michael Dinh: 9 posts Remigiusz Sokolowski: 9 posts Subodh Deshpande: 9 posts Bobak, Mark: 8 posts Marcus Mönnig: 8 posts Mek s: 8 posts Robert Freeman: 8 posts Stephane Faroult: 8 posts Upendra N: 8 posts Greg Rahn: 7 posts Jared Still: 7 posts LS Cheng: 7 posts Peter Hitchman: 7 posts
show more