FAQ

Search Discussions

76 discussions - 427 posts

  • Anyone know which banks are big users of Oracle? I know Citibank used to be. -- Howard A. Latham -- http://www.freelists.org/webpage/oracle-l
    Howard LathamHoward Latham
    Jun 25, 2012 at 9:49 am
    Jul 3, 2012 at 3:42 pm
  • I'm curious how many of you measure I/O performance ( IOPS, service times and MB/s ) regularly on your databases? And for those in SAN environments if you have access to ballpark figures for what you ...
    Niall LitchfieldNiall Litchfield
    Jun 8, 2012 at 6:09 am
    Jun 27, 2012 at 2:38 pm
  • Hi all, Apart from my various meanderings as a DBA and programmer, I am also in College by night and thus want to get at the fundamentals of CS and databases. I don't profess to being an expert (I ...
    Paul LinehanPaul Linehan
    Jun 12, 2012 at 11:31 am
    Jun 14, 2012 at 6:44 am
  • A friend pointed me to Virtualbox and an excellent "Developer Days" image (includes Oracle 11gR2 running Oracle Linux 5) as a quick way to build a sandbox for experimenting with features, options, ...
    DnrgDnrg
    Jun 14, 2012 at 10:12 am
    Jun 20, 2012 at 3:07 pm
  • A colleague wants to change a column type from numeric to alpha-numeric. Can he change it with data in it? ciao, Brian Brian Zelli Senior Database Administrator Enterprise Applications/Systems ...
    Zelli, BrianZelli, Brian
    Jun 1, 2012 at 5:52 pm
    Jun 4, 2012 at 12:31 pm
  • Hi All, Please share/guide me the best practices to be used for sizing redo log files. Thank you. Regards, Prasad. **************** CAUTION - Disclaimer ***************** This e-mail contains ...
    Prasad Reddy SubbellaPrasad Reddy Subbella
    Jun 21, 2012 at 5:50 am
    Jul 2, 2012 at 9:13 am
  • Server: Windows 2000 service pack 4 Oracle database version: 10.2.0.3.0 Enterprise Edition RMAN version: 10.2.0.3.0 Database type: development When I bounce the database this issue is resolved. But ...
    Joel SlowikJoel Slowik
    Jun 26, 2012 at 8:17 pm
    Jul 30, 2012 at 7:59 pm
  • Hello List I'm preparing to build a new 11.2.0.3.2 RAC cluster on OEL 5.4 (the latter isn't something I can change at the moment). The shared storage is a NetApp filer via NFS. Prior to Oracle ...
    Austin HackettAustin Hackett
    Jun 18, 2012 at 7:50 pm
    Jun 20, 2012 at 6:53 pm
  • I use the following two merge statements to load data into a dimension table nightly. Every night the process runs the sequence (seq_procedure_key) gets incremented by approximetly 57,000 values even ...
    Kenneth NaimKenneth Naim
    Jun 13, 2012 at 7:33 pm
    Jun 14, 2012 at 6:11 am
  • Question from a newbie DBA... For cost savings, we're looking at purchasing a cheaper, alternative product to the OEM Diagnostic/Tuning packs. So far I've found the below products that look like they ...
    D KenlD Kenl
    Jun 28, 2012 at 11:34 pm
    Jul 12, 2012 at 1:24 am
  • When first starting a database I get very high USER IO: I used db optimizer to see what stands out. user 'Unknown', is shown to be consuming IO - it is connected to Non-SQL Activity with an SQL_ID of ...
    Joel PattersonJoel Patterson
    Jun 21, 2012 at 12:55 pm
    Jun 22, 2012 at 5:35 pm
  • Good Morning list , We have our production databases ( most 11.2.0.2 RAC on Solaris 10) pro -actively monitored by BMC performance manager. We are not really satisfied with this tool. We also have ...
    Sreejith S NairSreejith S Nair
    Jun 3, 2012 at 2:47 am
    Jun 3, 2012 at 8:11 pm
  • Hi friends, The question is about the planned maintenance activities you do on a server level or database level. The activity I am referring to is rebooting the node and restarting database instances ...
    Sreejith S NairSreejith S Nair
    Jun 22, 2012 at 4:39 pm
    Jun 22, 2012 at 8:03 pm
  • To list:: I'm configuring rman backups for our first RAC deployment, hopefully to be live in September. In the past, with single-instance Oracle, I have used cron to schedule daily backups from the ...
    Don MorseDon Morse
    Jun 13, 2012 at 6:44 pm
    Jun 15, 2012 at 12:56 pm
  • I am curious if anyone on this list has worked on disk striping at the SAN layer and then at the ASM layer? Specifically, I want to know if you drilled all the way down to the physical devices on the ...
    Taylor, Chris DavidTaylor, Chris David
    Jun 6, 2012 at 12:23 pm
    Jun 8, 2012 at 11:03 pm
  • Hi I am performing regression tests on index creation on Oracle Standard Edition10.2.0.4 in RHEL 5.3. The first time I created the 450 indexes it took 16 hours. A few days later I dropped them and ...
    Gerry MillerGerry Miller
    Jun 13, 2012 at 4:11 am
    Jun 19, 2012 at 8:08 am
  • )b²ßÖzYH¶§’Ø^²æãyËl¥æ¤±ú+ŠÛ•ÿà¡©b²ÚÆ™ZŠw^½éh¥êì­².•Ûa{&Þ{^rاƒ^žØ^Š¸§²Ö§që­é¨½çm¡þf²mèhÂØ^±Æ§ÂŠä³øh¶œÂŠä³÷­søhÂØ^Šº®z¸ž±ªÞ{œº×ÿóhµ¤@ ÚÚŠx§‚f²mèî²Öªº'$Š{k¡ÛœŠx ...
    Aragon, Gabriel (GE, Corporate, consultant)Aragon, Gabriel (GE, Corporate, consultant)
    Jun 12, 2012 at 4:10 pm
    Jun 13, 2012 at 1:27 pm
  • Is it just me (perhaps I'm missing something) but having to download 7 files to get the latest patchset (11.2.0.3 Linux x86-64 in this case) one by one seems inane. Give me 1 (maybe 2) files to ...
    Taylor, Chris DavidTaylor, Chris David
    Jun 12, 2012 at 2:35 pm
    Jun 12, 2012 at 2:59 pm
  • Hello List, Why does a datafile extend a very large amount at very infrequent intervals? This is 11.2.0.2.0-5 on RHEL 5.6 x86_64 w/ASM. We are using ASSM. After migration from 10.2.0.4, we see larger ...
    RichRich
    Jun 29, 2012 at 3:59 pm
    Oct 12, 2012 at 1:51 am
  • Wow, that's a pretty specific requirement. If this is the case, it is a requirement of NetApp, as it is not required by Oracle. iSCSI works fine without ASMLIB. I will supply the caveat that I have ...
    Jared StillJared Still
    Jun 26, 2012 at 9:09 pm
    Jun 28, 2012 at 11:39 pm
  • This may seem a naive exercise - but I'm trying to determine the actual risk of this exploit vs the implementation risks required for our 11gR2 RAC environments. My understanding is that this exploit ...
    Jeff ThomasJeff Thomas
    Jun 13, 2012 at 6:56 pm
    Jun 26, 2012 at 6:29 pm
  • I'm a bit fuzzy at the moment due to pain meds after a minor surgery so I'm hoping someone can spot my error (if I have an error) Table has months, years and 'x' number of rows for each The table has ...
    Taylor, Chris DavidTaylor, Chris David
    Jun 29, 2012 at 2:36 am
    Jul 2, 2012 at 7:52 am
  • It was my own fault, but in case it proves even slightly useful.... I was upgrading from 11202 to 11203 Enterprise using the DB Upgrade Assistant utility. When I said "go do it" it went off, chugged ...
    Norman DunbarNorman Dunbar
    Jun 21, 2012 at 8:44 am
    Jun 27, 2012 at 3:51 pm
  • Has anyone had experience implementing ASO, in particular Transparent Data Encryption (TDE), network encryption, integrity checking, encrypted rman backups & encrypted datapump export? We are on ...
    Sciuto, MarySciuto, Mary
    Jun 22, 2012 at 6:47 pm
    Jun 26, 2012 at 4:21 am
  • We are in the process of laying out a baseline of what and how the databases and software should be set - as it pertains to security. Of course this encompasses everything from file permissions to ...
    Joel PattersonJoel Patterson
    Jun 15, 2012 at 3:04 pm
    Jun 19, 2012 at 3:25 pm
  • Was reading this white paper from Virident today: Accelerating Oracle Databases and Reducing Storage Complexity and Costs. Virident FlashMAX SCM as Primary Storage. Offered at ...
    Anthony BalloAnthony Ballo
    Jun 5, 2012 at 6:59 pm
    Jun 6, 2012 at 4:54 pm
  • Starting last Thursday, Grid Control 11G was reporting an error on one of our databases. This is NOT a newly monitored database. Grid has NOT been patched in over 6 months. The following appears in ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jun 4, 2012 at 1:46 pm
    Jun 4, 2012 at 3:48 pm
  • I'm running Virtualbox on my Windows Enterprise desktop with 2 VMs (Oracle Linux 5.8 - RAC demo) and I'm having difficulty getting the internal networking between the guests setup the way "I want ...
    Taylor, Chris DavidTaylor, Chris David
    Jun 20, 2012 at 12:43 pm
    Jun 20, 2012 at 10:41 pm
  • Can anyone tell me how to use TOAD to check user's system and object privileges? Thanks. -- http://www.freelists.org/webpage/oracle-l
    Dba1 mccDba1 mcc
    Jun 13, 2012 at 3:15 pm
    Jun 13, 2012 at 3:43 pm
  • I've just inherited an Oracle 8.1.7 database on Windows 2000. No one has the SYS / SYSTEM passwords. I've logged onto the server as an local administrator, domain admin and I'm also a member of the ...
    Steve WalesSteve Wales
    Jun 10, 2012 at 3:51 am
    Jun 10, 2012 at 7:38 pm
  • Just wondering if anyone on the list who has worked with a concurrent peak user load in the thousands (1000 - 5000) would mind sharing some nuggets on the hardware they used to support such a load ...
    DaveDave
    Jun 8, 2012 at 4:58 pm
    Jun 8, 2012 at 6:32 pm
  • Currently: OS: SLES10 Oracle: 10.2.0.5 Moving to: OS: SLES11 Oracle: 11.2.0.2 (the latest version for zLinux when we began migrating) We purchased a new IBM mainframe and faster storage. I now have ...
    Sandra BeckerSandra Becker
    Jun 6, 2012 at 2:34 pm
    Jun 8, 2012 at 12:06 am
  • **Gurus, any ideas to install 10.2.0.5 Oracle Client on Windows 7 ( 64 Bit) ? Is it going to be 10.2.0.1 patch plus upgrade it with 10.2.0.5 64 bit patch ? -- I dont have it available on Oracle ...
    BalaBala
    Jun 1, 2012 at 2:17 pm
    Jun 1, 2012 at 3:15 pm
  • Hey all, I've copied RMAN backup files from our production 10.1.0.5 DB (AIX 5.3 TL8) to our dev box (AIX 5.3 TL12). I've been restoring and destroying this particular DB on a dev box dozens of times ...
    Rich JesseRich Jesse
    Jun 29, 2012 at 4:14 pm
    Jun 29, 2012 at 8:37 pm
  • Urgent notification from Steven Chan via Mark Farnham: URGENT BULLETIN: Disable Java JRE Auto-Update for All E-Business Suite End-Users Immediately For full details, please see Steven Chan's blog ...
    Bobak, MarkBobak, Mark
    Jun 14, 2012 at 3:26 am
    Jun 15, 2012 at 5:59 pm
  • There are alot of posts on the web about this, but I have not seen what I am looking for. I have a 10 digit field that is populated with a sequence. We are running out of numbers. Since we interface ...
    Dba DBADba DBA
    Jun 12, 2012 at 2:11 pm
    Jun 13, 2012 at 10:05 am
  • Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Dear All, I am very happy to share the news that I have passed Oracle 11g OCM (Oracle Certified Master) too ...
    MikeyMikey
    Jun 11, 2012 at 2:38 pm
    Jun 12, 2012 at 7:10 am
  • Hi, We have a stored procedure with a cursor. This cursor has the result_cache hint. When the stored proc is called from SQLPlus the execution plan uses the result cache. However when the stored proc ...
    Chris DunscombeChris Dunscombe
    Jun 8, 2012 at 3:13 pm
    Jun 11, 2012 at 10:45 am
  • Hi, I've opened an SR with Oracle, but perhaps someone here has any experience with this... We are attempting to use RMAN duplicate to set up a standby database, we have a shared NFS for the backup ...
    Guillermo Alan BortGuillermo Alan Bort
    Jun 1, 2012 at 9:08 pm
    Jun 1, 2012 at 9:58 pm
  • Hi, I observed that when applying PSU via "opatch auto", the patch is first applied to DB home and then to GI home. Because GI should always be at a higher version, shouldn't the patching order have ...
    Purav ChovatiaPurav Chovatia
    Jun 26, 2012 at 1:05 pm
    Nov 30, 2012 at 2:44 pm
  • One of the apps I support is has an 11.2 DB that uses VPD for data segregation between clients. We have a contractual requirement to provide a staging database with only 1 client's data in it ...
    David MannDavid Mann
    Jun 26, 2012 at 2:32 pm
    Jun 29, 2012 at 1:45 am
  • Hi, today I have a strange one. We�re seeing requests (can be any, but we�re seeing it from the �select 1 from dual� jdbc validation request as well as from the application). It appears the initial ...
    Guillermo Alan BortGuillermo Alan Bort
    Jun 19, 2012 at 7:35 pm
    Jun 19, 2012 at 9:37 pm
  • I am configuring rules and rulesets in Cloud Control for our targets that include databases, listeners and linux hosts. I am interested in how folks in this group have set up their Cloud Control ...
    Ramadoss, KarthikRamadoss, Karthik
    Jun 18, 2012 at 8:27 pm
    Jun 18, 2012 at 8:44 pm
  • I am just curious whether there are any folks on this list that have a split life. (Yeah - I am sure there are plenty of ways to interpret that comment...) My question is pretty simple. Have any of ...
    Johnson, William L (TEIS)Johnson, William L (TEIS)
    Jun 8, 2012 at 1:21 pm
    Jun 14, 2012 at 8:23 pm
  • We archive documents Monday-Friday using the merge statement. Sometimes the data is copied back to production but not deleted from the archive database and re-archived later, hence the use of the ...
    Sandra BeckerSandra Becker
    Jun 13, 2012 at 5:22 pm
    Jun 13, 2012 at 7:13 pm
  • I had a very large query that was going off the rails in terms of performance and unexpected results. After dissection, I zeroed in on a flawed inline view, but it was flawed in a way that (a) looked ...
    Tornblad, JohnTornblad, John
    Jun 12, 2012 at 6:04 pm
    Jun 12, 2012 at 8:53 pm
  • Hello All, Hope Everyone is doing great!! Could anyone please share the steps of upgrading the database from 10g to 11g on unix in dataguard environment. I have upgraded only standalone instances, ...
    Nilesh kumarNilesh kumar
    Jun 7, 2012 at 6:26 pm
    Jun 8, 2012 at 1:16 pm
  • Hi everybody, I was wondering how to check the DB in Rac 11gr2 (HP-UX) is in auto-startup mode. As I was searching for info, during the installation phase it is already setup to be in auto-startup ...
    Alex CwbAlex Cwb
    Jun 7, 2012 at 7:48 pm
    Jun 7, 2012 at 8:45 pm
  • Oracle 10.2.0.5. I know about application testing in 11g. I have not used. We are not going to 11g until next year. We have a large database with a vast number of queries. The application is over 15 ...
    Dba DBADba DBA
    Jun 5, 2012 at 2:39 pm
    Jun 5, 2012 at 4:27 pm
  • I have a full RMAN backup of a database. I am trying to do a point in time recovery to another server from the backup (and then change db name/db id with nid). However, the controlfile autobackup was ...
    Ramadoss, KarthikRamadoss, Karthik
    Jun 5, 2012 at 2:41 pm
    Jun 5, 2012 at 3:49 pm
Group Navigation
period‹ prev | Jun 2012 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions76
posts427
users149
websiteoracle.com

149 users for June 2012

Taylor, Chris David: 24 posts Niall Litchfield: 20 posts Oracle: 13 posts Joel Patterson: 10 posts Hans Forbrich: 10 posts Allen, Brandon: 9 posts Lange, Kevin G: 9 posts Andy Gmail: 8 posts CRISLER, JON A: 8 posts Dnrg: 8 posts Matthew Zito: 8 posts Sreejith S Nair: 8 posts Howard Latham: 7 posts Tim Gorman: 7 posts David Fitzjarrell: 6 posts Guillermo Alan Bort: 6 posts Jared Still: 6 posts Michael Dinh: 6 posts Pete Sharman: 6 posts Rich Jesse: 6 posts
show more
Archives