FAQ

Oracle > oracle-l > December 2007

Search Discussions

112 discussions - 549 posts

  • Folks For subsequent RAC Deployment in ver 10gR2, A Banking customer needs to take a decision on use of QFS Cluster file system versus ASM? Prima-facie, How do the 2 compare in terms of Performance, ...
    VIVEK_SHARMAVIVEK_SHARMA
    Dec 5, 2007 at 9:45 pm
    Dec 8, 2007 at 1:20 am
  • Hi, List, I am testing to setup a 2-node RAC environment with separate owner/ORACLE_HOME for crs, ASM, and database, it's 10gR2 on Redhat AS 4. 2 users are created: oracle and oraclex, oracle owns ...
    Li LiLi Li
    Dec 12, 2007 at 9:51 pm
    Dec 14, 2007 at 6:10 pm
  • Hi, Is anyone aware of any shareplex forum. I have question about config file. Is the active config file stored any place on the server? Or do I need to create config and edit config. The manual does ...
    A JoshiA Joshi
    Dec 14, 2007 at 7:58 pm
    Dec 20, 2007 at 2:08 am
  • Just wondering, does anyone know much about "superblock" backups in ASM vs OCFS2? I ran into an interesting case a month or so back where someone had accidentally tried to initialize their ASM disks ...
    Jeremy SchneiderJeremy Schneider
    Dec 13, 2007 at 4:50 pm
    Apr 20, 2009 at 9:55 pm
  • Hi Writting some informix migration scripts here and just got a bit stucked. When we invoke sql scripts in sqlplus with arguments such as @test.sql par1 par2 par3 par1, 2 and 3 can be treated as &1, ...
    LS ChengLS Cheng
    Dec 28, 2007 at 6:27 pm
    Dec 31, 2007 at 9:58 pm
  • I'm building a cluster using Oracle Clusterware and have configured redundant pairs of NICs on the Linux servers using the Linux bonding module (active-passive). I know how to configure the Linux end ...
    Dan NorrisDan Norris
    Dec 12, 2007 at 5:22 am
    Dec 13, 2007 at 2:06 am
  • Hi, Having a bit of a debate with a peer. Perhaps you can help me. Its my understanding that the only i/o operations that trigger multiblock I/O, i.e. db file scattered read i/o that is influenced by ...
    Josh CollierJosh Collier
    Dec 10, 2007 at 7:14 pm
    Dec 11, 2007 at 6:45 pm
  • Hi, Does any one have details note/white paper which describe use of CSS(Cluster Synchronization Services ) in Non-RAC ASM instance. i went thru a ASM book and few Metalink notes but did not get much ...
    Hansraj saoHansraj sao
    Dec 27, 2007 at 5:42 pm
    Dec 28, 2007 at 11:25 pm
  • Oracle 10.2.0.2 on RHEL4. We have two 900gb LUNs using RAID 10. ** SysAdmin says no multipathing is involved. We do use Veritas DMP elsewhere in the SAN, fwiw. Giving this crazy ASM fad another ...
    Don SeilerDon Seiler
    Dec 26, 2007 at 8:32 pm
    Dec 27, 2007 at 3:19 pm
  • My primary key is a composite of 3 columns, but I range parition only on one column. It that a problem? I know it is a date field, but we are using a number for a date, i.e. yyyymmdd. Would I need to ...
    Joe SmithJoe Smith
    Dec 11, 2007 at 9:51 pm
    Dec 12, 2007 at 11:07 pm
  • Hi all, The organization where I am working needs to buy some Sun Sparc servers for a new project. Some of the server models are consideration are the T2000, the T5120 and the T5220. They have ...
    Lou AvramiLou Avrami
    Dec 6, 2007 at 8:48 pm
    Dec 10, 2007 at 3:04 am
  • We are generating alot of redo. We have sql loader data loads and dml on the database. I am trying to track which parts of the application are probably generating the most redo. Is there a way to do ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Dec 31, 2007 at 6:58 pm
    Jan 6, 2008 at 8:40 am
  • Hi Gurus, Can you please suggest good books for Amatuer DBA/Middle level DBA as I have a request to suggest my friends? OR Oracle documentations are better? Your suggestions are highly apprieciated ...
    Shastry(DBA)Shastry(DBA)
    Dec 20, 2007 at 3:13 pm
    Dec 21, 2007 at 9:57 am
  • all I'm betraying my ignorance here so be gentle. We configured an oracle account with an ORACLE_HOME environment variable ( in .bash_profile) of /path/to/oracle/home and also set the PATH as ...
    Niall LitchfieldNiall Litchfield
    Dec 20, 2007 at 2:37 pm
    Dec 20, 2007 at 6:19 pm
  • Hello everyone, I'm setting up a new test server and plan on using Red Hat EL 5 and 10gR2 with ASM for this one. However, there doesn't seem to be an asmlib available for RH5. Notes on Metalink ...
    RobynRobyn
    Dec 21, 2007 at 5:04 pm
    Dec 21, 2007 at 9:59 pm
  • All, I am getting lot of messages as such OciDataSource::executeStatement OCIStmtExecute failed ORA-00028: your session has been killed in the client side .and I tried looking around to see if there ...
    PrasadPrasad
    Dec 12, 2007 at 2:10 am
    Dec 20, 2007 at 5:09 am
  • I was wondering if there was a recommended method for renewing a certificate used to encrypt client/server database communications. I'm developing procedures for securing SQLNet and have successfully ...
    Jason HeinrichJason Heinrich
    Dec 14, 2007 at 5:38 pm
    Dec 18, 2007 at 11:10 pm
  • hi list, We are running Oracle 9iR2 on Linux ES4. there are certain oracle process which is consuming almost 100% of the cpu. I tried finding if there is any latch issue but could not find any ...
    Anju BalaAnju Bala
    Dec 13, 2007 at 10:20 am
    Dec 13, 2007 at 3:56 pm
  • Guys & Gals, I've done Oracle RAC install on Linux before, but noiw I'm being asked to do so on AIX 5.3 and I seem to be getting mixed signals from Oracle. The client originally wants to install AIX ...
    Goulet, DickGoulet, Dick
    Dec 10, 2007 at 7:17 pm
    Dec 11, 2007 at 5:49 am
  • all, according to ML Note:220970.1 that whether use OS cluster or not, we must install oracle clusterware for 10g RAC. what I need other information are: 1 . is it same the behavior between 10g rac ...
    Ujang JaenudinUjang Jaenudin
    Dec 5, 2007 at 12:49 am
    Dec 6, 2007 at 3:05 am
  • Hi, Does anyone know if there is any way to force ASMM memory component to shrink. Eg. Instance has just been bounced and say shared pool is using 1GB and db_cache is using only 100MB. If one wanted ...
    Vishal GuptaVishal Gupta
    Dec 1, 2007 at 4:59 pm
    Dec 4, 2007 at 4:17 pm
  • All, I need to do a stats generation for a oracle 9i db schema everynight. but there are few very large tables which I want to exclude while gathering the schema stats. Can someone please direct me ...
    PrasadPrasad
    Dec 24, 2007 at 8:46 pm
    Jan 2, 2008 at 8:27 pm
  • Hi Gurus, We have upgraded the PROD from 10.2.01 to 10.2.0.3 and we are at the stage where oracel is asking for RMAN catalog upgrade as we are using RMAN for backup purpose How to do this basically? ...
    Shastry(DBA)Shastry(DBA)
    Dec 27, 2007 at 12:34 pm
    Dec 27, 2007 at 7:38 pm
  • Folks Ran the following SQL with 48 Parallel processes (degree=48) to get the Error below. NOTE - This error is expected as some Datafiles are MISSING from the Database & hence Qs Is it possible for ...
    VIVEK_SHARMAVIVEK_SHARMA
    Dec 24, 2007 at 3:06 am
    Dec 25, 2007 at 6:08 pm
  • We have an ETL database where virtually all activity are on tablespace in nologging mode. 90% of our activity is inserts and 10% is updates of 1 column that is not indexed. We do have indexes on the ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Dec 7, 2007 at 4:22 pm
    Dec 21, 2007 at 1:12 pm
  • Anyone have a script to read a DDL file and build indexes using parallel worker processes? Something in perl or shell would be preferable. I am trying to work around data pump's slow "feature" of ...
    Charles SchultzCharles Schultz
    Dec 18, 2007 at 9:43 pm
    Dec 20, 2007 at 1:07 pm
  • hi We are considering the possibility of replacing veritas vxvm/vxfs with oracle asm management, due to higher and higher license cost for veritas. Does anyone has experience manage large database ...
    Zhu,ChaoZhu,Chao
    Dec 18, 2007 at 4:34 pm
    Dec 19, 2007 at 9:46 pm
  • all, is there any one short way to do that job? is the upgrade script a.k.a catupgrd can magically doing convert?? thanks for your share... -- regards ujang jakarta - indonesia -- ...
    Ujang JaenudinUjang Jaenudin
    Dec 15, 2007 at 1:42 am
    Dec 19, 2007 at 3:39 am
  • I rarely use sql loader. I need to account for nulls and set them to January 1, 9999 I am getting errors when I try to use a to_date function in sql loader even though I have seen examples just like ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Dec 17, 2007 at 5:13 pm
    Dec 18, 2007 at 3:58 am
  • Hi all, Can any please suggest me what is data population in Oracle database? User has requested, Data population from Prod to dev instance. Does this mean a data refresh of tables from prod to dev? ...
    Anant (DBA)Anant (DBA)
    Dec 10, 2007 at 9:36 pm
    Dec 12, 2007 at 1:20 am
  • Hey all, How accurate is ADDM? Today we had a severe performance issue with one our of databases. The ADDM recommendation for that period put the most weight on the following: ---[ADDM Snip]--- ...
    Best, DavidBest, David
    Dec 4, 2007 at 8:21 pm
    Dec 5, 2007 at 7:41 pm
  • I have a table with an Index on 4 columns. One particular column (the third in the index) is highly skewed with one value accounting for 70% of the rows. Queries with the Index columns as predicates ...
    Hemant K ChitaleHemant K Chitale
    Dec 13, 2007 at 3:35 pm
    Mar 6, 2008 at 12:19 pm
  • Hi List members, We are planning to install peoplesoft FM version 9 on AIX. Instead of using weblogic BEA, we are planning to install oracle application server to replace weblogic. I am wondering ...
    Joan HsiehJoan Hsieh
    Dec 28, 2007 at 4:39 pm
    Jan 2, 2008 at 8:15 pm
  • Folks Oracle 10.2.0.3 (NON-RAC), Solaris 10 In a Benchmark Run, on Firing 2000 Application processes connecting VIA 24 dispatchers & 100 Shared Servers, getting the following WAITs NOTE - This wait ...
    VIVEK_SHARMAVIVEK_SHARMA
    Dec 30, 2007 at 3:43 pm
    Dec 31, 2007 at 4:36 am
  • Hi I had to copy a Terbayte Prod database and its test box is damanaged and has to recreate with Prod. What are the fastest method. Both Prod and Test server are at different location and so I cannot ...
    Sanjay MishraSanjay Mishra
    Dec 20, 2007 at 3:02 pm
    Dec 28, 2007 at 11:11 pm
  • hi list, I have one table with below structure: PPC_ID NUMBER(15,5) LEADPOSTTIME DATE REFERRERURL VARCHAR2(4000) REFERRERIP VARCHAR2(20) PPCNAME VARCHAR2(40) PPCFORMNAME VARCHAR2(40) ROW_CREATE_DT ...
    Anju BalaAnju Bala
    Dec 21, 2007 at 10:51 am
    Dec 28, 2007 at 7:47 am
  • I'm just wondering if anyone has any insights on how to speed this up. Our fact tables consist of the primary keys of the involved dimension tables plus numeric count columns. To build our fact ...
    Thomas DayThomas Day
    Dec 21, 2007 at 3:17 pm
    Dec 26, 2007 at 5:04 pm
  • Hello all, Can anybody tell me if there is a simple way to script the addition of a role as a default role? Without breaking future additions of default or non-default roles? Here is an example to ...
    Sam BootsmaSam Bootsma
    Dec 18, 2007 at 11:14 pm
    Dec 26, 2007 at 2:59 pm
  • Hi All, There was a request to refresh production database to Test database and the version is 10gR1, Now we are getting the following strange error in Production database Alertlog, I searched in ...
    Avadhani mysAvadhani mys
    Dec 21, 2007 at 12:55 pm
    Dec 21, 2007 at 8:18 pm
  • Does it make any sense to run 4 processes for a rman full database backup when you have configured only 1 default channel? The channel is a disk and the backup files are all going to that same disk ...
    Joe SmithJoe Smith
    Dec 19, 2007 at 3:26 pm
    Dec 20, 2007 at 6:57 pm
  • We are running into something strange. We have queries on the data dictionary hanging, while other queries appear to run correctly. We are in Oracle 10gR2 on AIX. It appears that Patrol is doing ...
    Andrew KerberAndrew Kerber
    Dec 18, 2007 at 4:46 pm
    Dec 19, 2007 at 1:48 pm
  • Hi All, I have a problem with a customer database and performance. I have ran statspack and identified the worst performing SQL statement, but have run out of ideas on how to get the SQL to perform ...
    Ronnie DoggartRonnie Doggart
    Dec 6, 2007 at 1:35 pm
    Dec 17, 2007 at 5:50 pm
  • Running Oracle 9.2.0.7 on AIX 5.3. We're moving to a new datafile structure on a new SAN. I preparation for the move, I've created a a standby database on the new SAN, attached to a different server ...
    David BarbourDavid Barbour
    Dec 7, 2007 at 4:54 pm
    Dec 13, 2007 at 7:06 pm
  • Update on this bug. It is a problem with 'PREDICATE PULLUP'. If I disable this optimizer option (_optimizer_filter_pred_pullup=false) the filter is no longer pulled out of the view. There are a ...
    Henry PorasHenry Poras
    Dec 7, 2007 at 4:00 pm
    Dec 12, 2007 at 3:51 pm
  • We're trying to figure out exactly what an application has done in the db. I restored an archive log from tape and mined it. When querying the logminer view I'm seeing two rows for a transaction in ...
    Ahbaid GaffoorAhbaid Gaffoor
    Dec 8, 2007 at 7:59 pm
    Dec 11, 2007 at 8:40 pm
  • Oracle Standard Edition 1, Ver. 9.2.0.8 RHEL 4.1 I've opened an SR with Oracle, but they haven't responded yet and I was hoping someone could point me in the right direction. We accidentally deleted ...
    Sandra BeckerSandra Becker
    Dec 11, 2007 at 7:27 pm
    Dec 11, 2007 at 8:35 pm
  • Does anybody know of a print utility that can be used when trying to print metalink documents? I used to have one but it now conflicts with Adobe 8 on my new computer. I want to be able to open the ...
    Joe SmithJoe Smith
    Dec 6, 2007 at 2:59 pm
    Dec 7, 2007 at 5:00 am
  • The OracleServicexxx service terminated unexpectedly. It has done this 1 time(s). Faulting application oracle.exe, version 9.2.0.6, faulting module kernel32.dll, version 5.2.3790.2919, fault address ...
    Kathy duretKathy duret
    Dec 5, 2007 at 8:23 pm
    Dec 6, 2007 at 8:15 pm
  • Greetings Oracle 9i AIX 5L we are using SAN Stroage I see quite a few SQL in the STATSPACK report with high Elapsed time, I notice the following: Disk is 100% bussy - topas report sar -d report - ...
    BNBN
    Dec 4, 2007 at 5:13 pm
    Dec 4, 2007 at 11:52 pm
  • we do not want to give developers direct access to query our data in production. For java developers we are simply returning a ref cursor. We have some other people who want to go into production ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Dec 3, 2007 at 5:17 pm
    Dec 4, 2007 at 7:52 pm
Dec 2007
123
Group Navigation
period‹ prev | Dec 2007 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions112
posts549
users175
websiteoracle.com

175 users for December 2007

Dan Norris: 25 posts Krish.hariharan_at_quasardb.com: 21 posts Finn Jorgensen: 19 posts Jared Still: 17 posts Don Seiler: 13 posts LS Cheng: 11 posts Li Li: 10 posts Andrew Kerber: 9 posts Genegurevich_at_discover.com: 9 posts Prasad: 9 posts VIVEK_SHARMA: 9 posts Peter McLarty: 8 posts Yasin Baskan: 8 posts Charles Schultz: 7 posts Crisler, Jon: 7 posts Rajeev Prabhakar: 7 posts Shastry(DBA): 7 posts Taylor, Chris David: 7 posts Allen, Brandon: 6 posts Tim Gorman: 6 posts
show more
Archives