FAQ

Oracle > oracle-l > March 2011

Search Discussions

121 discussions - 675 posts

  • Database: 11.2.0.2.0 OS: RH 5 OEM: 11.1.0.1.0 OEM Repository DB: 11.2.0.2.0 Anyone run into problems creating a standby database using Oracle 11g Grid Control? I get an internal error during Step 3 ...
    Bill ZakrzewskiBill Zakrzewski
    Mar 10, 2011 at 3:18 pm
    Mar 22, 2011 at 9:52 am
  • List, We have to refresh a QA database from production (to have some real data) but we need to exclude all the PCI/PII from the refresh (it absolutely cannot be copied from Prod to QA). In addition, ...
    Guillermo Alan BortGuillermo Alan Bort
    Mar 22, 2011 at 8:00 pm
    Mar 25, 2011 at 10:51 pm
  • I am really sick and tired of this POS costing me time. Waiting to see if it will work... Restarting firefox when flash hangs... It is just ridiculous. I am going to use HTML only. If it doesn't work ...
    Jared StillJared Still
    Mar 2, 2011 at 9:24 pm
    Mar 4, 2011 at 4:12 am
  • Trying to understand Fetch in a TKPROF output. We have an application on Oracle Apps Server 10.1 Database 10.2.0.4 On production, a specific query runs in about 3 seconds. On this new database server ...
    Lyallbarbour_at_sanfranmail.comLyallbarbour_at_sanfranmail.com
    Mar 30, 2011 at 6:55 pm
    Apr 6, 2011 at 9:00 am
  • Hi list, I have a situation where I'm seeing regular reports of a bad block in the alert log. For example : Tue Mar 08 06:49:39 2011 Corrupt Block Found TSN = 24, TSNAME = XXX RFN = 28, BLK = ...
    Steve BaldwinSteve Baldwin
    Mar 8, 2011 at 1:01 pm
    Mar 10, 2011 at 5:54 am
  • Hi all, we're considering to replace our SunFire v490 servers with newer generation of Oracle SUN or IBM servers. Our current configuration is: 2x SunFire v490, 4GB RAM, 2 (1x dual-port HBA) x 2Gb FC ...
    Marko SuticMarko Sutic
    Mar 17, 2011 at 2:40 pm
    Mar 22, 2011 at 3:09 pm
  • �Friends, In 11g, is there a way to find the progress of dbms_stats.gather stats job ? one of my peer has got a siebel table with 250 indexed columns . While gathering stats using dbms_stats, he ...
    PremPrem
    Mar 29, 2011 at 10:56 am
    Apr 1, 2011 at 2:38 pm
  • List, I recently wrote a SQL script containing a PL/SQL anonymous block. I used DBMS_OUTPUT to sent results to the screen. This worked fine when I copied and pasted the script into a SQL*Plus ...
    Dennis WilliamsDennis Williams
    Mar 9, 2011 at 3:43 pm
    Mar 11, 2011 at 7:57 am
  • We have just had a letter in Which Oracle Invite themselves to audit our licenses. Does anybody know what this entails? It's particularly inconvenient as our DR site is kicking us out in 30 days in ...
    Howard LathamHoward Latham
    Mar 2, 2011 at 9:31 am
    Oct 9, 2013 at 2:19 pm
  • after oracle suggested bumping up db_writer_processes from 2 to 4, at times it is still getting pegged out. "write complete waits" will become a top time event. drilling down will show: SID User Wait ...
    Doug GernaatDoug Gernaat
    Mar 8, 2011 at 3:55 pm
    Mar 10, 2011 at 4:22 am
  • 11.2.0.1 and 11.2.0.2 on OEL. Try "select * from dba_users where username in (select username from dba_tables)". It returns all the rows from dba_users instead of returning an error. Perhaps this is ...
    Mark StricklandMark Strickland
    Mar 29, 2011 at 4:47 pm
    Apr 5, 2011 at 1:31 am
  • Hi folks Did anyone use the self-study CD course from Oracle? Is this a valid course for exam? (Oracle requires official training for certification). Does the training software run on Mac OS X (or ...
    Sven AluoorSven Aluoor
    Mar 24, 2011 at 10:33 am
    Mar 28, 2011 at 5:48 pm
  • On Exadata, You will have flashdisks. Idea to use them: A. Make them for Exadata Smart Flashcache B. Use them for Grid Disk for ASM Disk Group, and store some database files. C. Use both A and B in ...
    Surachart OpunSurachart Opun
    Mar 19, 2011 at 8:34 am
    Mar 22, 2011 at 11:20 am
  • A developer asked for suggestions to speed up a query in oracle 10.2.0.4 Solaris 10, soon to be 11gr2. He comes in around 2 hours from now, and I have asked to see the query. However...., here is the ...
    Joel.Patterson_at_crowley.comJoel.Patterson_at_crowley.com
    Mar 23, 2011 at 12:08 pm
    Mar 24, 2011 at 8:31 am
  • Does anyone have a backup checklist for Oracle Files not held in the database that wont get backed up by RMAN. Eg Oratab tnsnames.ora listener.ora init.ora maybe alertlog if not can we put one ...
    Howard LathamHoward Latham
    Mar 14, 2011 at 3:19 pm
    Mar 14, 2011 at 7:44 pm
  • Does anybody have a dynamic sql script that pulls user definitions (including current passwords) into a text file? I need to move users from a 10g database over to an 11g database. They want to keep ...
    P DP D
    Mar 4, 2011 at 5:08 pm
    Mar 7, 2011 at 3:00 pm
  • I am still confused by maxextents on a datafile and the more documentation and websites that I read the more confused that I get. If I have autoextend ON with NEXT set to 16384K then I understand ...
    P DP D
    Mar 3, 2011 at 6:34 pm
    Mar 3, 2011 at 9:14 pm
  • Hi List, I have just downloaded this tool from http://www.myorasql.com/. Initial impression is quite good. The tool comes with a nice UI with some useful functions shown in the below image. Is anyone ...
    Sreejith S NairSreejith S Nair
    Mar 25, 2011 at 4:51 am
    Mar 31, 2011 at 6:15 am
  • I use default stats collection method on 10.2.0.4 database. I get questioned (via email) about someones attention being drawn to the fact that many tables have not had stats collected in months, and ...
    Joel.Patterson_at_crowley.comJoel.Patterson_at_crowley.com
    Mar 22, 2011 at 5:18 pm
    Mar 30, 2011 at 3:17 pm
  • List, When DBAs are put in charge of unknown applications not developed in house or put in charge of third party COTS applications, how do we go about learning the systems and tune such systems. This ...
    Ram RamanRam Raman
    Mar 23, 2011 at 9:44 pm
    Mar 29, 2011 at 8:05 pm
  • Is it normal for node evictions to happen? If all is going well, then there shouldn't be evictions right? CRS 11.1.0.7 DB: 11.1.0.7 all on linux. joe Joe Testa, Oracle Certified Professional Senior ...
    TESTAJ3_at_nationwide.comTESTAJ3_at_nationwide.com
    Mar 24, 2011 at 2:15 pm
    Mar 24, 2011 at 4:39 pm
  • Hi folks. I haven't seen this one discussed anywhere and can't really find any references to it that are worth repeating. Does anyone have any information on optimal file system block sizes for FRA? ...
    Dbvision_at_iinet.net.auDbvision_at_iinet.net.au
    Mar 28, 2011 at 4:35 am
    Mar 30, 2011 at 9:46 am
  • I would like find out your personal experience on using AUTOALLOACTE for extent management in Oracle 10g. I usually use UNIFORM extent size but wondering what are the drawbacks for using ...
    Mandal, AshokeMandal, Ashoke
    Mar 3, 2011 at 6:42 pm
    Mar 29, 2011 at 5:47 am
  • http://www.oracle.com/us/corporate/press/346696 Will HP-UX run on x86? Cheers -- LSC -- http://www.freelists.org/webpage/oracle-l
    LS ChengLS Cheng
    Mar 23, 2011 at 7:08 pm
    Mar 24, 2011 at 11:34 pm
  • Hello all, I've encountered a challenge installing 11.2.0.2 RAC on a NetApp FiberSan. I thought I would run it by oracle-l and see if anyone might have a solution. I was doing an advanced ...
    Lou AvramiLou Avrami
    Mar 18, 2011 at 2:33 pm
    Mar 21, 2011 at 12:14 pm
  • When we work with Oracle Database as DBA or Developer. We have to maintain about table segments. We have to know about Tablepsace/Database file. When we create table, Do you think about it before? Or ...
    Surachart OpunSurachart Opun
    Mar 18, 2011 at 11:13 am
    Mar 19, 2011 at 2:51 pm
  • Hi, I was thinking in a tools that capture and replay real database workload for benchmarking and upgrade functionality testing; I have never seen a tool that can reproduce database workload, however ...
    Alex ListAlex List
    Mar 13, 2011 at 12:05 am
    Mar 15, 2011 at 4:40 pm
  • Dear list, I need to trace which statement run on one table. I just need to know i.e. "select etc...." My DB parameter are set for auditing. I run the following script : audit select on ...
    Alessandro LiaAlessandro Lia
    Mar 1, 2011 at 2:11 pm
    Mar 3, 2011 at 12:15 pm
  • Hi all, I'm experiencing a problem with a tablespace. In this tablespace there's only a table with 30 partitions with a total size of about 5gb. The table uses interval partitiong to create a new ...
    Stefano CislaghiStefano Cislaghi
    Mar 28, 2011 at 9:34 am
    Mar 31, 2011 at 8:24 pm
  • Hello All, I have question with regards to EMC timefinder consistent split and Oracle. I have 2 device groups Data which has datafile, controlfle and online redo log AND Flashback which has flashback ...
    Sathish balasubramaniamSathish balasubramaniam
    Mar 29, 2011 at 6:59 am
    Mar 29, 2011 at 12:37 pm
  • I saw this answer today on StackOverflow. http://stackoverflow.com/questions/5307590/cpu-usage-of-oracle-installed-database-machine Quote from PerformanceDBA, a notable Oracle basher. "Oracle does ...
    Brady, MarkBrady, Mark
    Mar 15, 2011 at 2:09 pm
    Mar 15, 2011 at 4:32 pm
  • Hello Group, Just wondering if any of you have had experience interviewing with novice interviewers who manage to get canned DBA questions and answers off the net for interviewing experienced ...
    Imtiaz MerchantImtiaz Merchant
    Mar 11, 2011 at 3:58 pm
    Mar 15, 2011 at 12:36 am
  • List, We have several application servers (mostly Tomcat) connecting to the Oracle Databases (jdbc) and we detected that there is a lot of people using the application accounts to connect to the ...
    Guillermo Alan BortGuillermo Alan Bort
    Mar 9, 2011 at 7:11 pm
    Mar 10, 2011 at 4:50 pm
  • List, I have an OEM 11g, with a 10.2.0.4.0 RAC target with 4 nodes. There are no monitoring templates configured in OEM. There is a notification rule set for 'Database Instances' (I'm assuming this ...
    Guillermo Alan BortGuillermo Alan Bort
    Mar 2, 2011 at 2:35 pm
    Mar 2, 2011 at 5:59 pm
  • Hi all, Does someone know what this error mean? "end-of-file on communication channel" I have the following table, with no rows stored: name | data_type | nullable | data_default | data_length ...
    JoJo
    Mar 22, 2011 at 11:08 am
    Mar 22, 2011 at 1:34 pm
  • The password for TDPO can be stored using the old method which produced a file named something like TDPO.-rman. To duplicate a database using RMAN backups to say node2. You have to copy the password ...
    MacGregor, Ian A.MacGregor, Ian A.
    Mar 3, 2011 at 11:35 pm
    Mar 7, 2011 at 1:08 am
  • Hi, Our 11g upgrade seemed to go pretty well, until we started getting an overwhelming number of trace files with ORA-00600 and ORA-07445 messages. These trace files all seem to be related to our ...
    Maureen EnglishMaureen English
    Mar 20, 2011 at 5:50 pm
    Aug 26, 2011 at 5:16 pm
  • Assuming I have a column of PO numbers in an Excel spreadsheet, is it possible to access Oracle for each of those numbers to retrieve additional information. The information retrieved for each PO ...
    Jeffrey BeckstromJeffrey Beckstrom
    Mar 31, 2011 at 3:38 pm
    Mar 31, 2011 at 5:57 pm
  • R e s u l t C a c h e M e m o r y R e p o r t [Parameters] Block Size = 1K bytes Maximum Cache Size = 10M bytes (10K blocks) Maximum Result Size = 512K bytes (512 blocks) [Memory] Total Memory = ...
    Michael MooreMichael Moore
    Mar 30, 2011 at 7:49 pm
    Mar 31, 2011 at 12:57 am
  • Hi all, I've a tricky situation in one of my client environment. My client was taken an hot backup without putting the database in backup mode and in that backup he was not included archivelogs ...
    Sandeep Kumar BSandeep Kumar B
    Mar 28, 2011 at 5:04 am
    Mar 28, 2011 at 11:51 am
  • Hello Gurus, DBLINK is working for one particular user, were as it is not working for other users. Kindly help me to sort out the problem SQL select name from v$database; NAME A SQL show user USER is ...
    Nagaraj SNagaraj S
    Mar 24, 2011 at 4:57 am
    Mar 24, 2011 at 5:28 am
  • �CREATE TABLE DUMMY1(BOB VARCHAR2(2)) * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06502: PL/SQL: numeric or value error: NULL index table key value ORA-06512: at line 22 ...
    Thomas DayThomas Day
    Mar 3, 2011 at 9:05 pm
    Mar 4, 2011 at 3:57 pm
  • Howdy, I'm starting an ERP DB upgrade from 10.1.0.5 to 11.2. One of my concerns is possible compatibility issues for the apps being able to use a new 11.2 client, which may or may not be certified ...
    Rich JesseRich Jesse
    Mar 31, 2011 at 4:33 pm
    Apr 1, 2011 at 6:44 am
  • Is AWR report on Oracle 11gR2 SE (dev database) reliable, and is it supported? I have heard mixed comments on this. Do folks on this list use AWR on Oracle SE? Thanks, Pradeep -- ...
    Pradeep ChetalPradeep Chetal
    Mar 22, 2011 at 9:27 pm
    Mar 23, 2011 at 1:45 am
  • Hi all, I'm not sure if I should be satisfied with an answer from MOSS regarding the applying of the following hints in our application to reduce parse time due to high cpu usage ? *+ ...
    Michael SeiwertMichael Seiwert
    Mar 21, 2011 at 1:37 pm
    Mar 21, 2011 at 7:16 pm
  • Can anyone point me to some practical pages or experience working with CLOBs. We have some databases that are using CLOBs, and will be using them more. So I am interested it things like 'do they grow ...
    Joel.Patterson_at_crowley.comJoel.Patterson_at_crowley.com
    Mar 17, 2011 at 6:07 pm
    Mar 20, 2011 at 10:42 am
  • Has any running Oracle on vmware ever been asked during the course of an SR to recreate the problem on a physical server? We are trying to decide if it's worth the risk of running "unsupported?" on ...
    Armstrong-Champ, Joseph WilliamArmstrong-Champ, Joseph William
    Mar 17, 2011 at 8:24 pm
    Mar 18, 2011 at 9:10 am
  • hi, I wonder if it is possible to write to a file from within a database at the chosen position. What I want to achieve is to modify a kind of header of simple text file (few tens of MB in size). I ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Mar 11, 2011 at 1:14 pm
    Mar 14, 2011 at 6:56 am
  • I've got a report I email myself everyday that is a list of the top 10 most frequently executed sql from the previous day according to awr. This has turned up a piece of sql that, according to ...
    Stephens, ChrisStephens, Chris
    Mar 2, 2011 at 3:26 pm
    Mar 2, 2011 at 5:41 pm
  • Asked internally here. I don't have an answer. 9.2.0.7 db being backed up from the standby. Does anyone know why the rman command below manages to generate a 270gb backupset. backup maxsetsize=50G ...
    Niall LitchfieldNiall Litchfield
    Mar 29, 2011 at 3:53 pm
    Apr 11, 2011 at 10:53 am
Mar 2011
123
Group Navigation
period‹ prev | Mar 2011 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions121
posts675
users214
websiteoracle.com

214 users for March 2011

Niall Litchfield: 36 posts : 29 posts Guillermo Alan Bort: 22 posts Joel.Patterson_at_crowley.com: 20 posts Subodh Deshpande: 19 posts Mark W. Farnham: 17 posts Amaral, Rui: 14 posts D'Hooge Freek: 14 posts Greg Rahn: 13 posts Jared Still: 13 posts Nuno Souto: 13 posts Yechiel Adar: 13 posts Rich Jesse: 11 posts Goulet, Richard: 9 posts Jeffrey Beckstrom: 9 posts Martin Bach: 8 posts Robert Freeman: 8 posts TESTAJ3_at_nationwide.com(B: 8 posts Bobak, Mark: 7 posts Surachart Opun: 7 posts
show more
Archives