Search Discussions

93 discussions - 522 posts

  • I was asked about converting a 5 TB 10.2 database on RHEL to a 11.2 database on AIX. As I was thinking through this, I understand that to do the conversion from Linux to AIX the database would have ...
    Taylor, Chris DavidTaylor, Chris David
    Mar 6, 2012 at 3:18 pm
    Apr 11, 2012 at 6:18 am
  • All- I put up a new blog entry on enabling hugepages in Linux. I put it together after discovering that there doesn't seem to be a single location with all the steps, including both the Linux os ...
    Andrew KerberAndrew Kerber
    Mar 15, 2012 at 1:42 pm
    Apr 27, 2012 at 7:24 pm
  • Hi all As refugees of the Itanium-Oracle smackdown, we are now evaluating new platforms and I was wondering if anyone had any opinions on the following for production use: - RedHat 4 or 5 - Solaris ...
    Mar 12, 2012 at 10:45 pm
    Mar 15, 2012 at 6:20 pm
  • Kindly give me steps that need to schedule Audit Purge Job for purging the table SYS.AUD$ records more than 90 days -- http://www.freelists.org/webpage/oracle-l
    Nagaraj SNagaraj S
    Mar 29, 2012 at 8:46 pm
    Mar 30, 2012 at 6:32 pm
  • Hi all, I'm trying to SET a sequence VALUE but seems it can't be done on oracle. PostgreSQL allows to do such thing in this way: SELECT setval('mysequence', 42); -- setting value to 42 Is there a way ...
    Jose soaresJose soares
    Mar 29, 2012 at 10:13 am
    Mar 29, 2012 at 2:25 pm
  • As of today: Oracle 11gR2 is now certified with Oracle Linux 6 and Red Hat Enterprise Linux 6 http://www.oracle.com/us/corporate/press/1563775 Of course, I was made aware of this announcement ...
    Bobak, MarkBobak, Mark
    Mar 22, 2012 at 10:00 pm
    Mar 23, 2012 at 4:29 pm
  • Hello all! We have some old instances running on Oracle 8i ( and right now we are planning to migrate those to the latest version of Oracle (11g release 2); I know that this is maybe an ...
    David Ramírez ReyesDavid Ramírez Reyes
    Mar 5, 2012 at 1:40 pm
    Mar 8, 2012 at 12:21 am
  • The HCC is usually done by the storage; if the storage decides not to do so (e.g. due to CPU load), it will pass the blocks uncompressed and it's then job of the database to uncompress them. So ...
    Vit SpinkaVit Spinka
    Mar 20, 2012 at 4:18 pm
    May 23, 2012 at 10:24 pm
  • 10


    It has been a while but I created a role, assigned objects to the role and then assigned the role to a user. The user is saying he can't select the objects I gave him select privs on. I forgot but am ...
    Zelli, BrianZelli, Brian
    Mar 8, 2012 at 7:08 pm
    Mar 9, 2012 at 4:17 pm
  • I am looking for scripts people have on the internet. I know about the hotsos application. I am primarily looking for scripts to parse 10046 traces that do more than tkprof. One issue with tkprof is ...
    Dba DBADba DBA
    Mar 5, 2012 at 4:43 pm
    Mar 9, 2012 at 3:40 pm
  • Hi all, I think I have a problem with NULL values on composit indexes: create table test(id int primary key, pia int, ua int, data date, ver int); create unique index unik on test(pia int, ua , data ...
    Jose soaresJose soares
    Mar 29, 2012 at 2:37 pm
    Apr 2, 2012 at 8:50 pm
  • G'day, I'm involved in a project to migrate a 4TB database from HP/UX 11 and Oracle 9i to a brand-new Sun M5000 server with Oracle This database suffers insert transactions in the order of ...
    De DBADe DBA
    Mar 28, 2012 at 1:35 pm
    Apr 2, 2012 at 6:47 pm
  • Folks, I am trying to understand if it is expected to see performance degradation of DML transactions that are active during a hot backup. It is my understanding that the only noticeable thing that ...
    Hameed, AmirHameed, Amir
    Mar 30, 2012 at 1:39 pm
    Mar 30, 2012 at 6:37 pm
  • Hi All,**** ** ** We recently built a RAC 2 node Environment. **** I created a service named �test� and configured 2 nodes as preferred. **** ** ** when I am connecting using sqlplus, I am getting ...
    Mar 28, 2012 at 12:18 pm
    Mar 29, 2012 at 1:43 am
  • Hello all, I am trying to duplicate a 3TB database, which has 927 datafiles. It is failing with the following error. Some of the google notes refers me to work with the backup media vendor. I have ...
    Mandal, AshokeMandal, Ashoke
    Mar 19, 2012 at 7:53 pm
    Mar 21, 2012 at 12:58 am
  • This may be a stupid question, but I was installing a new database for the first time, and I started wondering, what is the useful purpose of redo logs if a database is in noarchivelog mode? Only if ...
    Richard, CarmelindaRichard, Carmelinda
    Mar 28, 2012 at 2:38 pm
    Mar 30, 2012 at 9:39 pm
  • 8


    Hi All, RAC.. In database instance... I query for some data and the database instance has to communicate with the asm instance in order to get the path to the block within the asm disk group. Does ...
    Paul HarrisonPaul Harrison
    Mar 15, 2012 at 6:04 pm
    Mar 30, 2012 at 6:43 pm
  • Hi all, Using and trying to work out if I can do an RMAN duplicate from 4 node RAC to single instance without the duplicate generating the 4 threads of redo? Also, I wondered if it was ...
    Neil campbellNeil campbell
    Mar 28, 2012 at 5:01 am
    Mar 30, 2012 at 2:24 pm
  • I've got a potential resume-faxing situation in dealing with a 20+ TB db. This is on a 6-node RAC, Oracle, RHEL 4.x, ASM, OMF. I added a datafile to a tablespace on node1 and unfortunately ...
    Herring Dave - dherriHerring Dave - dherri
    Mar 7, 2012 at 11:44 pm
    Mar 9, 2012 at 11:30 pm
  • Hi All, We need to run the database as a different user then the "Local System" account because we need to make backups to an UNC share. Therefore we have created a domain user that is in the local ...
    Patrick RoozenPatrick Roozen
    Mar 13, 2012 at 9:38 am
    Mar 14, 2012 at 12:20 pm
  • Hello, I have a table with four rows. I issue the sql statement: update table set name = 'test'; this will update 4 rows. Will Oracle create 4 locks one for each row or 1 lock for the 4 rows? Thanks, ...
    Paul HarrisonPaul Harrison
    Mar 10, 2012 at 4:57 pm
    Mar 12, 2012 at 12:36 pm
  • Hi all, RAC on RHEL 5.7 with role separation (different groups for sysasm and sysdba) I've noticed that the directory <diagnostic_dest /rdbms and the files inside it are owned by the group ...
    Radoulov, DimitreRadoulov, Dimitre
    Mar 6, 2012 at 10:38 pm
    Mar 7, 2012 at 9:09 am
  • Hi All, Let's say I run the following command... insert into cure.thecure (firstname ,lastname) values('oracle','11gr2'); The table has an index on the lastname column... Using Log Miner, There is ...
    Paul HarrisonPaul Harrison
    Mar 5, 2012 at 3:33 pm
    Mar 6, 2012 at 1:52 am
  • The environment: Oracle Database 11g Enterprise Edition Release - 64bit Production We are planning on extensive use of flashback enabled tables. The standard here is to do exports of ...
    Rumpi GravensteinRumpi Gravenstein
    Mar 18, 2012 at 2:52 pm
    Mar 31, 2012 at 1:54 am
  • Hi, I opened an SR for this as well but haven't gotten anywhere with it yet :) I have a primary and physical standby - both 32bit - and want to switch them to 64bit with no downtime. It's, ...
    Kathryn axelrodKathryn axelrod
    Mar 23, 2012 at 4:25 pm
    Mar 26, 2012 at 6:16 pm
  • Oracle - EE Platform - IBM zSeries, SLES 10 I have 19 related tables that need to have data archived daily. If I run my merge script manually, it uses the primary key index on all the ...
    Sandra BeckerSandra Becker
    Mar 23, 2012 at 6:00 pm
    Mar 26, 2012 at 1:25 pm
  • There is a 10 year old function that I think Tom Kyte put on the web called remove_constraints that will turn literal values into a single @ sign. That is pretty slow because it has to loop through ...
    Dba DBADba DBA
    Mar 16, 2012 at 3:07 pm
    Mar 16, 2012 at 9:37 pm
  • Linux RAC , Query runs fast with hard coding / SQL*Plus '&' ; But when run through the application using bind variables , the plan is different and it goes for MERGE CARTESIAN JOIN. Metalink ...
    Mar 23, 2012 at 5:54 am
    Mar 27, 2012 at 9:49 pm
  • We are planning a hardware refresh and management wants to move to Oracle T4-2 servers. These come with two 8-core CPUs, which breaks down to 8 "processors" for Oracle licensing (11gR2 EE). We're ...
    Robert LavertyRobert Laverty
    Mar 20, 2012 at 2:21 pm
    Mar 25, 2012 at 8:43 pm
  • Oracle Database 10.2 has now transitioned from Premier Support to Sustaining Support. Our records indicate the CSI used for this SR does not have Extended Support so you are only eligible to ...
    Sheldon QuinnySheldon Quinny
    Mar 1, 2012 at 11:56 am
    Mar 1, 2012 at 5:23 pm
  • Folks, I would like to understand which one is a better option for a RAC interconnect: (a) NIC bonding (b) IPMP based failover. The OS is Solaris 10, the Grid version is and the RDBMS ...
    Hameed, AmirHameed, Amir
    Mar 27, 2012 at 11:27 pm
    Apr 6, 2012 at 9:00 am
  • EE on RHEL5 I'm having a helluva time tracking down the source of an ORA-00942 error refreshing a materialized view. I've done "alter system set events '942 trace name errorstack level 3';" ...
    Stephens, ChrisStephens, Chris
    Mar 27, 2012 at 9:36 pm
    Apr 2, 2012 at 6:06 pm
  • ** Hi all, ** ** I don't understand this error: ** ** ORA-01861: literal does not match format string ** ** 'UPDATE unita_aziendale SET ts_ultima_modifica=CURRENT_TIMESTAMP, data_inizio=:data_inizio ...
    Jose soaresJose soares
    Mar 29, 2012 at 3:24 pm
    Apr 2, 2012 at 7:20 am
  • 1) I have been steeped in a bunch of Incremental Stats blog posts for the past week and I think I am just confusing myself at this point. If I want to use Incremental stats on my Partitioned tables, ...
    David MannDavid Mann
    Mar 22, 2012 at 3:29 pm
    Mar 29, 2012 at 6:16 pm
  • List, v10.2. We have a dev db whose backups have been failing with message that db_recovery_file_dest_size is full. Our location in FLASH group in ASM. Upon looking into the FLASH diskgroup I see ...
    Ram RamanRam Raman
    Mar 26, 2012 at 11:14 pm
    Mar 29, 2012 at 2:44 pm
  • Hi, I'm looking for some real world experiences with user separation setups on Exadata. The default on Exadata setups seems to be to install both the grid infrastructure software and the db software ...
    D'Hooge FreekD'Hooge Freek
    Mar 26, 2012 at 9:57 am
    Mar 26, 2012 at 3:38 pm
  • Hi All, Good day. I have a physical standby setup and the archived location on the standby got filled up. After cleaning up the disk, I manually copied the archived log files from primary to standby, ...
    Sundar mahadevanSundar mahadevan
    Mar 23, 2012 at 2:48 pm
    Mar 25, 2012 at 5:40 am
  • Hi, We have a requirement to apply application patches online i.e. without downtime. Our apps run in active-active mode and hence the app layer is taken care of i.e. while instance-1 of app is being ...
    Purav ChovatiaPurav Chovatia
    Mar 20, 2012 at 6:37 am
    Mar 20, 2012 at 8:41 am
  • Has anyone integrated grid control with nagios or similar Enterprise monitoring suites. I'd love to know some details. -- http://www.freelists.org/webpage/oracle-l
    Niall LitchfieldNiall Litchfield
    Mar 16, 2012 at 7:41 pm
    Mar 19, 2012 at 2:51 pm
  • I recently saw Tom Kyte and he mentioned how he doesn't like autonomous transactions and said you should never really use them except for when logging errors. I didn't understand what was so bad ...
    Jeff ChircoJeff Chirco
    Mar 12, 2012 at 2:20 pm
    Mar 13, 2012 at 1:59 pm
  • I have a database that when statistics_level=ALL is set, queries become 10x slower, spending all their time on CPU. I have run 10046 trace and verified that the plans are the same when I change this ...
    Josh CollierJosh Collier
    Mar 7, 2012 at 6:00 pm
    Mar 8, 2012 at 4:05 pm
  • So far, I can run frmdbld.sh as user oracle using Exceed as my X server, but I would like to be able to suggest a free alternative for my users. So far, everything I tested fails to run forms builder ...
    Patrice sur GMailPatrice sur GMail
    Mar 7, 2012 at 3:24 pm
    Mar 7, 2012 at 8:39 pm
  • Folks, I have a statement, which produces the following plan, which is based on FTS: SELECT * FROM <TABLE_NAME WHERE reprocess_flag = 'Y' AND processing_phase = 1 AND processing_status_code2 = ...
    Hameed, AmirHameed, Amir
    Mar 5, 2012 at 8:46 pm
    Mar 7, 2012 at 8:32 pm
  • Hi All, Can anyone please let me know the URL to download the old Oracle 8i version for Linux platform? I tried searching Oracle download index link and not found. We require this for some testing ...
    Mar 3, 2012 at 11:14 am
    Mar 3, 2012 at 6:35 pm
  • hi, anyone tried to kill M000 - what are possible implications? Will the instance die? It just took library cache mutex (X) and holds for very considerable amount of time. Regards Remigiusz -- Pole ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Mar 28, 2012 at 8:48 am
    Mar 28, 2012 at 2:27 pm
  • Hello Anyone have hit this error trying to do alter system scope=spfile? ORA-32000: write to SPFILE requested but SPFILE is not modifiable No single note on metalink about it. I saw a few notes in ...
    Ricard MartínezRicard Martínez
    Mar 28, 2012 at 10:46 am
    Mar 28, 2012 at 11:35 am
  • When I query v$sql_plan, I see some SQL_IDs with different plan_hash_value. I thought if the plan changed while the query was cached, it would generate a child_number. When would a query generate a ...
    Dba DBADba DBA
    Mar 23, 2012 at 7:50 pm
    Mar 27, 2012 at 2:27 pm
  • Anyone using this for production db's? We're thinking of using it for a small db and we might also use the mulit a-z deployment. Is everything done through a console? You never get access to the ...
    Michael McMullenMichael McMullen
    Mar 26, 2012 at 5:14 pm
    Mar 26, 2012 at 6:07 pm
  • Hi all Recently Oracle/Pillar announced hybrid columnar compression in their storage arrays. Does anyone know if it is possible mixing data using HCC enabled array and a traditional array? I dont ...
    Ls ChengLs Cheng
    Mar 20, 2012 at 12:44 pm
    Mar 20, 2012 at 1:28 pm
  • Hi, List, I wonder how to expire an account after certain days? I looked at profile and all the password resource_type doesn't seem to accomplish that purpose. Anyone suggestion or comments? TIA, -Li ...
    Li LiLi Li
    Mar 8, 2012 at 11:59 pm
    Mar 9, 2012 at 2:14 pm
Group Navigation
period‹ prev | Mar 2012 | next ›
Group Overview
grouporacle-l @

159 users for March 2012

Taylor, Chris David: 25 posts Radoulov, Dimitre: 21 posts Niall Litchfield: 15 posts Kathryn axelrod: 13 posts Martin Berger: 13 posts Norman Dunbar: 12 posts Hameed, Amir: 11 posts Jonathan Lewis: 9 posts Dba DBA: 8 posts Guillermo Alan Bort: 8 posts Mark W. Farnham: 8 posts Paul Harrison: 8 posts Phillip Jones: 8 posts David Fitzjarrell: 7 posts De DBA: 7 posts D'Hooge Freek: 7 posts Gaja Krishna Vaidyanatha: 7 posts Jose soares: 7 posts Ls Cheng: 7 posts Rich Jesse: 7 posts
show more