Search Discussions

97 discussions - 569 posts

  • Hi Im trying to do a resize of SYSAUX datafile, but all the info and metalink notes im reading, make me think it is impossible for the moment. That the only real options is to clean space and put ...
    Ricard MartínezRicard Martínez
    Apr 6, 2011 at 5:25 pm
    Apr 16, 2011 at 3:05 pm
  • Hi all, RAC on Linux 2.6.18-92.el5 #1 SMP x86_64 x86_64 x86_64 GNU/Linux Oracle Database 10g Enterprise Edition Release - 64bit Production ASMLib We need to add disks to the Production ...
    Radoulov, DimitreRadoulov, Dimitre
    Apr 7, 2011 at 2:03 pm
    Apr 20, 2011 at 2:16 pm
  • I have a table with some specifically-named columns and a group of 210 generic column. For example: table abc customer_num data_map_fk attr001 attr002 attr003 attr004 So, in the example above, ...
    Michael MooreMichael Moore
    Apr 1, 2011 at 6:54 pm
    Apr 14, 2011 at 5:36 pm
  • I'm getting push to disable the recyclebin on a database? I'm pushing back that its not a good idea to disable it for the entire database but to disable for the session or do a drop table ...
    Apr 19, 2011 at 1:55 pm
    Apr 21, 2011 at 7:28 pm
  • Did anyone else see the announcement from Oracle that they will not be providing ASMlib for kernels distributed by RH as part of RHEL 6, only for Oracle kernels? See Metalink Note 1089399.1: "For ...
    Gillfillan, Marianne J.Gillfillan, Marianne J.
    Apr 20, 2011 at 11:54 am
    Jul 20, 2012 at 5:00 am
  • Only slightly off topic I guess. The proliferation of documentation makes it hard to keep the right stuff at hand, as well as any docs I would like read. Printing and stapling/binding just doesn't ...
    Jared StillJared Still
    Apr 15, 2011 at 2:53 am
    Apr 18, 2011 at 11:51 am
  • Hi, I'm curious what other peoples's experience, suggestions are in regard to the use of the "optimizer_index_caching", and "optimizer_index_cost_adj" parameters. As a general practice, I leave them ...
    Ed lewisEd lewis
    Apr 24, 2011 at 12:22 pm
    Apr 27, 2011 at 9:51 pm
  • Hi all, I have the following commands in a batch file scheduled for daily execution: set oracle_sid=mydatadb rman target / catalog mycatusr/mycatpwd_at_mycatdb script Daily_Backup backup.log My ...
    Bill MyersBill Myers
    Apr 24, 2011 at 1:05 am
    Apr 25, 2011 at 3:50 pm
  • Hi, We have a 2 node rac cluster. When I run a query on node 1, it executes in 1-2 seconds. When I run the same query on the node 2, it takes over 2 minutes. The query plans are different with node 1 ...
    Edward LewisEdward Lewis
    Apr 28, 2011 at 6:39 pm
    May 3, 2011 at 12:29 pm
  • Hello Everyone, We are building up a system from scratch and wanted to follow the best practices in setting up SAN Storage Array for ASM. With 22 disks in the array for use, i was planning on doing ...
    Steven AndrewSteven Andrew
    Apr 20, 2011 at 2:40 am
    Apr 26, 2011 at 2:19 pm
  • This made me sad. Dear Oracle Rdb and Oracle Database on OpenVMS Customers, On Tuesday, March 22nd, Oracle announced that we are discontinuing all new software development on the Intel Itanium ...
    Barbara BakerBarbara Baker
    Apr 14, 2011 at 4:13 pm
    Apr 18, 2011 at 2:37 pm
  • Query performance continued. We have a very complicated Materialized view, and a view that utilizes the MV. We cannot use Fast refresh - a complete refresh is necessary. The app can decide when the ...
    Apr 7, 2011 at 12:50 pm
    Apr 9, 2011 at 12:32 pm
  • Why would enabling constraints on tables with ~180000 records create a lot of buffer gets ( millions plus ). Thanks -- http://www.freelists.org/webpage/oracle-l
    Joe SmithJoe Smith
    Apr 20, 2011 at 6:46 pm
    Apr 21, 2011 at 3:05 pm
  • Yes; I'm going through all my old stuff that I never published :) Here's another: http://www.v3rity.com/OracleForensicsInvestigatingPLSQLInjection.pdf Cheers, David -- ...
    David LitchfieldDavid Litchfield
    Apr 13, 2011 at 10:16 pm
    May 23, 2011 at 9:27 pm
  • Do you have any ideas on why this would run in Toad in 2 minutes and take over 4 hours running through the concurrent manager? Actually up until this past week, 4 minutes is the usual run time for ...
    Stephen AndertStephen Andert
    Apr 25, 2011 at 8:51 pm
    Apr 26, 2011 at 12:44 pm
  • Is there any requirement to use direct I/O with NFS? (besides performance) from metalink note: Enterprise Linux: Linux, Filesystem & I/O Type Supportability [ID 279069.1] DIRECTIO is required for ...
    kyle Haileykyle Hailey
    Apr 16, 2011 at 4:30 pm
    Apr 22, 2011 at 9:21 pm
  • dear lists, we had done impdp, and didn't do dbms_capture_adm.build before expdp. but we noted the scn before expdp and specify that SCN during expdp. so my question, can we set SCN for the capture ...
    Ujang JaenudinUjang Jaenudin
    Apr 7, 2011 at 9:22 am
    Apr 8, 2011 at 4:43 pm
  • All, Many years ago (version 9.2) I toyed with this capability of SQL*Net without much luck. Has anyone toyed with it in recent times ( with much success??? I'm facing an issue where we have ...
    Goulet, RichardGoulet, Richard
    Apr 4, 2011 at 1:51 pm
    Apr 6, 2011 at 7:10 am
  • Hi, We have a server with 8 SAS internal disks. The OS is going to be RHEL 5 x86_64 We plan to mirror disk 1 and 2 using software RAID -- OS and Oracle software will be kept on this Remaining 6 disks ...
    DBA DeepakDBA Deepak
    Apr 25, 2011 at 6:26 pm
    Apr 26, 2011 at 5:52 pm
  • Testing on Solaris, I got direct I/O if either NFS mount was set forcedirectio or Oracle had the parameter filesystemio_options=directio The only case I got unix files system caching was when the ...
    kyle Haileykyle Hailey
    Apr 19, 2011 at 12:58 am
    Apr 21, 2011 at 7:37 pm
  • Has anyone found a reasonably fast xwindows server? On my 32 bit windows xp virtual machine I can get the oui to work reasonably fast, even connecting to a data center 4 states away to do an install ...
    Andrew KerberAndrew Kerber
    Apr 18, 2011 at 8:46 pm
    Apr 19, 2011 at 4:17 pm
  • As I have had extensive time with MOS, as of late, I'll chime in here.... I appreciate support, but I tire of how often I'm repeatedly uploading the same files or uploading a full directory to MOS, ...
    Kellyn PedersenKellyn Pedersen
    Apr 7, 2011 at 5:42 pm
    Apr 12, 2011 at 10:16 pm
  • Hi all, Oracle 9i on Win2K3. I am loading data from external file and need to convert it into different format. Current format: DIV CUST JAN FEB MAR New format: DIV CUST JAN DIV CUST FEB DIV CUST MAR ...
    Eugene PipkoEugene Pipko
    Apr 28, 2011 at 6:42 pm
    May 1, 2011 at 2:48 am
  • Hi, Sorry for posting an off-topic email, but I guess that my simple doubt is really simple to you guys. In my shell script to transfer files, I am having difficult to do the way I need. Basically ...
    Alex ListAlex List
    Apr 5, 2011 at 5:40 pm
    Apr 6, 2011 at 1:33 am
  • We have a new application that is multi-tiered with connections coming from many different windows and websphere servers. We've recently completed a new upgrade/install with several changes in ...
    Dianna GibbsDianna Gibbs
    Apr 28, 2011 at 4:27 pm
    May 9, 2011 at 4:14 am
  • I am preparing for our upgrade from to However, the catupgrd is running ~ 3.5 hours. It doesnt appear to stop on anything in particular, so I am dubious about getting it to go ...
    Andrew KerberAndrew Kerber
    Apr 26, 2011 at 2:36 pm
    Apr 27, 2011 at 10:51 am
  • Hi group, One of my coworkers released an AWR formatter plugin. The file has to be the html version. He is also looking for feedback and enhancement requests ...
    Thomas RoachThomas Roach
    Apr 21, 2011 at 3:35 am
    Apr 22, 2011 at 4:38 pm
  • If a VIEW has an ORDER BY clause, am I guaranteed to get that sort order when I use the VIEW (provided of course that I don't specify a different sort order)? Regards, Mike -- ...
    Michael MooreMichael Moore
    Apr 20, 2011 at 6:20 pm
    Apr 21, 2011 at 9:26 pm
  • I have an RMAN backup and need to restore it an existing database with a different name on another server. Can I restore this without using nid? Also the directory structure is different. If anyone ...
    John scottJohn scott
    Apr 15, 2011 at 5:41 pm
    Apr 16, 2011 at 2:44 pm
  • Oracle 11gR1 EE on RHEL 4 (x86_64) Are Oracle enqueue locks obtained in a 'first in, first out' fashion..? I'm specifically interested in 'enqueue - JI' locks - i.e. the exclusive lock obtained to ...
    Matt McClernonMatt McClernon
    Apr 27, 2011 at 12:07 pm
    Jun 28, 2011 at 12:39 pm
  • Hi all, I just came across something I never heard about so far: Reference manual states that v$database.log_type can be NOARCHIVELOG, ARCHIVELOG or MANUAL. The question is: what does "MANUAL" mean? ...
    Vit SpinkaVit Spinka
    Apr 19, 2011 at 8:04 pm
    Apr 19, 2011 at 8:35 pm
  • Hi, I have a shell script scheduled to run daily on Linux and check the disk space. After reaching a limit of x% partition full, it sends mail to a group alerting the issue. For HP-UX and AIX many ...
    Alex ListAlex List
    Apr 13, 2011 at 6:06 pm
    Apr 13, 2011 at 6:36 pm
  • Hello! Finally convinced client long running code wasn't database, application, network problem. Noticed when I was running one of my queries, that usually runs in a tenth of a second elapsed time, ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Apr 28, 2011 at 12:15 am
    May 27, 2011 at 11:31 pm
  • Hi, listers, Is there a rule of thumb that relates sequence cache size to insert rate and number of instances? Anyone can share what the cache size is for your RAC's insert-intensive tables? Denis -- ...
    Apr 20, 2011 at 10:37 pm
    May 5, 2011 at 12:46 pm
  • Hi, I had a production DB on oracle 10g RAC with 2 instances. I had a problem, so I switched to another server with a single instance. Now I would return to the first configuration (DB RAC), it ...
    Apr 20, 2011 at 10:12 am
    May 2, 2011 at 1:46 am
  • I've been using Nagios to monitor Oracle, but am not real happy with the plugin I'm using, or the complexity of Nagios configuration in general. So I was googling around for alternatives and found ...
    Janine OhmerJanine Ohmer
    Apr 15, 2011 at 11:53 pm
    Apr 20, 2011 at 3:59 pm
  • I'm finally getting back to this as I had a moment or 2 inbetween day-to-day support tasks. I believe I can now account for the connection count discrepency. Oracle initially said internal operations ...
    Herring Dave - dherriHerring Dave - dherri
    Apr 18, 2011 at 5:38 pm
    Apr 19, 2011 at 7:12 pm
  • Platform: IBM zSeries OS: Suse10 DB: EE (planning to go to 11g in 4-6 months) Three weeks ago I created a standby database using RMAN and setting everything up manually. Had problems using ...
    Sandra BeckerSandra Becker
    Apr 15, 2011 at 8:01 pm
    Apr 18, 2011 at 1:30 pm
  • Hi all, Please, help: the fdisk partition was put inside another partition. /dev/sda was already partitioned with a single partition as /dev/sda1 /dev/sda1 was labeled as DISK6 and was part of the ...
    Masha GurenichMasha Gurenich
    Apr 11, 2011 at 8:56 pm
    Apr 13, 2011 at 8:54 pm
  • Hi folks, A user is getting this message: ORA-20470: Global query limit exceeded (2500) I've tried googling and even binging but come up with nothing. Is this a init parm setting or is it an ...
    Zelli, BrianZelli, Brian
    Apr 13, 2011 at 3:45 pm
    Apr 13, 2011 at 4:02 pm
  • Friends, I have 7 RAC database ( running on two SunOS 5.10 Generic nodes. I would like to measure the CPU utilized by each *database* in these servers. I have arrived at the following ...
    Sreejith S NairSreejith S Nair
    Apr 6, 2011 at 9:24 am
    Apr 6, 2011 at 1:42 pm
  • Is it possible to run Solaris 9 and 10 nodes within the same Oracle10gR2 RAC cluster? I am thinking about switching out the Solaris 9 nodes with the Solaris 10 nodes... join/remove. Has anyone done ...
    Paul BarrettPaul Barrett
    Apr 4, 2011 at 4:39 pm
    Apr 5, 2011 at 4:05 am
  • Air pocket. Does anyone have any insight to this issue. I feel I am overlooking a fundamental - or its to early in the morning. As the owner of the table, a colleague was unable to truncate a table ...
    Apr 28, 2011 at 1:31 pm
    Apr 28, 2011 at 4:25 pm
  • I'm designing a new set of master-detail tables. The master has about 300,000 rows and the detail table has about 7 rows for each master row. There are thousands of insertions and deletions per day ...
    Kevin Hale BoyesKevin Hale Boyes
    Apr 25, 2011 at 7:28 pm
    Apr 25, 2011 at 11:58 pm
  • Folks, Just a warning up front on this question, I'm still only drinking java and not coding in it nor having little to no understanding of how it's related to the db. That said, we've got a 4-node ...
    Herring Dave - dherriHerring Dave - dherri
    Apr 20, 2011 at 3:22 pm
    Apr 20, 2011 at 6:16 pm
  • EE on Linux x86_64 One of our production databases is experiencing significant materialized view contention (enqueue JI waits). Digging into the problem has revealed that the MV refresh ...
    Matt McClernonMatt McClernon
    Apr 17, 2011 at 10:06 am
    Apr 20, 2011 at 12:12 am
  • If you run a Linux VM on a Windows 2008 server, can you redirect http traffic to the Linux VM guest through the Windows Server? Here's what I'm imagining: Windows Server 2008 64 bit -- Guest Oracle ...
    Taylor, Chris DavidTaylor, Chris David
    Apr 18, 2011 at 6:33 pm
    Apr 19, 2011 at 11:47 am
  • Well, I have been doing an installation. Digging into the details after discovering that we are not supposed to use IPMP, I found out that it uses an oracle technology called HAIP (High ...
    Andrew KerberAndrew Kerber
    Apr 14, 2011 at 1:10 pm
    Apr 15, 2011 at 10:59 pm
  • Wondering if anyone else out there has done upgrades of Grid Infrastructure for standalone ASM from to I seem to be encountering a new bug every time I do it. The latest one ...
    Don SeilerDon Seiler
    Apr 13, 2011 at 4:00 pm
    Apr 15, 2011 at 6:53 pm
  • Hi, list: Anybody has been using this type of RAC combination: clusterware + database? Any known issue? Bugs? Thanks, Lei -- http://www.freelists.org/webpage/oracle-l
    Lei ZengLei Zeng
    Apr 12, 2011 at 7:51 pm
    Apr 15, 2011 at 6:40 pm
Group Navigation
period‹ prev | Apr 2011 | next ›
Group Overview
grouporacle-l @

184 users for April 2011

: 24 posts Radoulov, Dimitre: 21 posts D'Hooge Freek: 16 posts Michael Moore: 14 posts Mark W. Farnham: 13 posts Andrew Kerber: 12 posts Michael Dinh: 12 posts Niall Litchfield: 12 posts Chitale, Hemant Krishnarao: 11 posts Goulet, Richard: 11 posts Guillermo Alan Bort: 11 posts Jared Still: 11 posts Joel.Patterson_at_crowley.com: 11 posts Edward Lewis: 9 posts Stephane Faroult: 9 posts Karl Arao: 8 posts Lange, Kevin G: 8 posts kyle Hailey: 7 posts Nuno Souto: 7 posts Blanchard, William G: 6 posts
show more