FAQ

Search Discussions

235 discussions - 1,315 posts

  • Everybody: Has anyone experienced performance issues with dba_extents view (bug 5029334)? I was told by Oracle that the workaround is to create a new view and use it instead of dba_extents. When I ...
    Genegurevich_at_discoverfinancial.comGenegurevich_at_discoverfinancial.com
    Jun 23, 2006 at 10:02 pm
    Dec 7, 2006 at 4:05 pm
  • On a slightly modified topic, for a long time I've had a problem with this section 13.5.1.2.3 of the Oracle documentation. It's one of those sections that was written 25 years ago and apparently ...
    Oracle-l-bounce_at_freelists.orgOracle-l-bounce_at_freelists.org
    Jun 27, 2006 at 1:03 pm
    Jun 30, 2006 at 7:17 pm
  • We are having an argument with our CoLo facility over the issue of a dedicated switch for our RAC interconnect. We are saying it's an Oracle requirement and Oracle does not support any other ...
    Freeman, DonaldFreeman, Donald
    Jun 5, 2006 at 6:26 pm
    Jun 13, 2006 at 11:36 pm
  • Oracle 8.1.7.4.1 Windows 2000 SP4 Intermittent error that (so far) is only resolved with a server reboot. Error manifests itself many ways but the most obvious are inability to connect to the ...
    Sweetser, JoeSweetser, Joe
    Jun 27, 2006 at 7:51 pm
    Jul 25, 2006 at 4:20 pm
  • Hi! We are new to RAC and are discovering serveral uncertainties regarding the best disk layout to use for ASM. We are running two EMC Clariion systems (under RAID-5) and want ASM to write to both ...
    Daiminger, HelmutDaiminger, Helmut
    Jun 9, 2006 at 10:41 am
    Jun 12, 2006 at 7:16 pm
  • We are seeing big problems when issuing disk writes using 10G (both 10.1 and 10.2). Reads are not an issue Very difficult to track down the exact combination but so far it looks as if it is a ...
    Hallas, John, Tech DevHallas, John, Tech Dev
    Jun 8, 2006 at 8:16 am
    Jun 12, 2006 at 4:09 pm
  • I was looking into some CRS (clusterware, Compaq portable clusterware, whatever they call it) logs and found one on 10gR2 linux with spaces in the pathname...check it out funny ...
    Kevin ClossonKevin Closson
    Jun 9, 2006 at 7:06 pm
    Jun 11, 2006 at 7:17 pm
  • Hi all Recently, I came across an 'interesting' paper on the comparative difference of the total cost of database administration between Oracle and SQL Server. It was conducted by Alinean. Some ...
    Tony JambuTony Jambu
    Jun 13, 2006 at 11:08 am
    Jun 14, 2006 at 5:20 pm
  • Hi, I am running OLTP system on Oracle 10.2 and J2EE weblogic. I am getting some ratios as: Load Profile Per Second Per Transaction ~~~~~~~~~~~~ --------------- --------------- Redo size: 156,162.18 ...
    Sandeep DubeySandeep Dubey
    Jun 6, 2006 at 6:05 pm
    Jun 11, 2006 at 12:08 pm
  • Hi If I have 10 millions records in a table and if I drop the table or delete 1 million records and if ASM_POWER_LIMIT to 0, Is it going to rebalance the Disk space among all Disks used in the ...
    Sanjay MishraSanjay Mishra
    Jun 13, 2006 at 11:07 pm
    Jun 17, 2006 at 4:06 pm
  • I've got a monster join (27 tables) coming from my Baan ERP app. It's taking 0.00 seconds to parse and only .05 seconds to fetch, but is taking 15.05 seconds for the execute phase - see below from ...
    Allen, BrandonAllen, Brandon
    Jun 27, 2006 at 11:43 pm
    Jul 4, 2006 at 6:55 am
  • Hey all, As I'm researching what I need to know about AIX for a new 10gR2 install, I'm wondering about _CPU_COUNT. We're buying an IBM 2x2 (two dual-core CPUs) JS21 blade that will be running IBM's ...
    Jesse, RichJesse, Rich
    Jun 26, 2006 at 9:29 pm
    Jul 7, 2006 at 5:30 pm
  • hi: When database hang, I got the sql hash value from v$session_wait view. Then I wanted to find the sql_text from v$sql. But I can't find it there. SQL select sql_text from stats$sql_summary where ...
    Eagle fanEagle fan
    Jun 17, 2006 at 5:14 am
    Jun 27, 2006 at 7:43 pm
  • Hi, We have applications developed by using forms 6i and reports 6i . We have implemented roles on the DB side . But we dont want our users to access the database by using other tools like ms excel, ...
    Muhammed SoyerMuhammed Soyer
    Jun 8, 2006 at 6:42 am
    Jun 8, 2006 at 11:09 pm
  • Hi, While I was studing to the 1z0-147 exam I see a question which I coudnt be sure the answer . Here is the question .. its written that the choice A is correct but I dont agree with this ..B seems ...
    Muhammed SoyerMuhammed Soyer
    Jun 7, 2006 at 8:35 am
    Jun 7, 2006 at 11:47 pm
  • any quick ideas on how to fix this? Fri Jun 2 17:07:11 2006 Doing block recovery for file 2 block 22497 Fri Jun 2 17:07:11 2006 Errors in file ...
    John D ParkerJohn D Parker
    Jun 2, 2006 at 10:09 pm
    Jun 6, 2006 at 12:14 pm
  • Just wanted to run this by everyone here, I have a 9.2.0.6 database on HP-UX. Some of my read only tablespaces are on a physical disk that I keep at about 99% capacity (it's not going to grow ...
    Fred SmithFred Smith
    Jun 6, 2006 at 12:05 pm
    Jun 6, 2006 at 5:45 pm
  • Granted that x$ksmsp is not documented and therefore subject to changes from version to version (or patch to patch), I have an Oracle Support Engineer telling me that one entry in ksmsp might ...
    Schultz, CharlesSchultz, Charles
    Jun 26, 2006 at 2:27 pm
    Jun 28, 2006 at 6:13 pm
  • Hello, I'm supporting an ERP app (SSA BaanIV) that uses bind variables extensively, which is a good thing for the most part, but occasionally I'm having queries that are suffering from plan ...
    Allen, BrandonAllen, Brandon
    Jun 23, 2006 at 6:15 pm
    Jun 26, 2006 at 3:45 pm
  • Is it good or bad to use all available (not used for other purposes, eg. shared pool or pga) RAM for buffer cache? I am talking about 32GB RAM range. Oracle is not in-memory database but anyway - ...
    Laimutis NedzinskasLaimutis Nedzinskas
    Jun 19, 2006 at 10:43 am
    Jun 20, 2006 at 9:36 pm
  • HELLO How to Encrypt and Decrypt the data in oracle . Thanks & Regards Sachin Sethi Software Engineer Telserra, Gurgaon Suite 501, 5th floor, Pacific Squre, 32nd Milestone, NH - 8, Gurgaon -122 001, ...
    Sachin SethiSachin Sethi
    Jun 12, 2006 at 6:16 am
    Jun 14, 2006 at 12:46 am
  • How to transfer a zip file from windows system to linux serever. I just have the tool of putty on remote site.. Regards Solo -- http://www.freelists.org/webpage/oracle-l
    Solo MahiSolo Mahi
    Jun 10, 2006 at 3:27 am
    Jun 11, 2006 at 3:07 am
  • Oracle 9.2.0.6 on 64-bit Solaris 5.8. We have a BCV setup to maintain a copy of a production database on another server. The BCV is updated every night. Tablespaces are placed in backup mode ...
    Baumgartel, PaulBaumgartel, Paul
    Jun 1, 2006 at 7:56 pm
    Jun 10, 2006 at 8:44 am
  • Friends, I am want to install 10g Agent (10.2.0.1) on a 2 node veritas active/passive cluster. I found no document on metalink for doing this. The most confusing part is : Normally a cluster node has ...
    PremPrem
    Jun 21, 2006 at 5:30 am
    Jul 18, 2006 at 12:43 pm
  • I'm seriously considering turning off the automated memory management in 10gR2 because of fragmentation, complaints I've seen on this list and support's inability to give me a decent solution to our ...
    Michael RayMichael Ray
    Jun 30, 2006 at 3:27 am
    Jun 30, 2006 at 5:55 pm
  • Hi all Reviewing an application over here and came across to an issue, probably not a very big issue but have kept me thinking several days. The database is designed to report the "workflow" about ...
    AmonteAmonte
    Jun 20, 2006 at 10:31 am
    Jun 20, 2006 at 4:48 pm
  • Overloading words: How can we get Oracle to stop it? First a definition: By “overloading” I mean using the same word for two different things. Now in normal linguistic discourse we do that all ...
    Mark W. FarnhamMark W. Farnham
    Jun 9, 2006 at 6:02 pm
    Jun 12, 2006 at 5:26 pm
  • I am using 10.2 on linux for OLTP system. I am getting log file sync as top event. I can not change disk or combine transactions in one or some thing other as suggested in metalink. Does rman backup ...
    Sandeep DubeySandeep Dubey
    Jun 8, 2006 at 6:55 pm
    Jun 9, 2006 at 7:13 pm
  • Hi, We have a big table and it has one field with CLOB datatype. Doing an export on this table is very slow. I have tried with different buffer sizes of 2MB - 250MB. It is still slow. Any way to ...
    A JoshiA Joshi
    Jun 23, 2006 at 2:35 am
    Jul 17, 2006 at 5:02 pm
  • Hello members, sorry, forgot the subject. We have a problem with locally managed tablespaces and segment space management auto on 9.2.0.6 on AIX 5.2. The problem follows: We created a table in a ...
    Markus KuehnMarkus Kuehn
    Jun 27, 2006 at 2:20 pm
    Jun 28, 2006 at 10:02 am
  • Hi all, In our Development system, We have a TEMP tablespace. Just now we got the message that "Unable to extend TEMP segment..". We have bounced the database to free up this tablespace. But, even ...
    Ravi MadabhushanamRavi Madabhushanam
    Jun 21, 2006 at 11:43 pm
    Jun 23, 2006 at 2:41 pm
  • Friends, I have got 10.2.0.2 OMS setup on a machine U029. And on another machine U502, i have a 10.2.0.1 agent running. U502 also has a 9.2.0.7 database VMP1, listener VMP1_LISTENER running on port ...
    PremPrem
    Jun 15, 2006 at 5:27 pm
    Jun 16, 2006 at 5:47 pm
  • Hi, How to migrate code/applications between development, test & production environments? Thanks in advance. Is your PC infected? Get a FREE online computer virus scan from McAfee® Security ...
    Dean PaulDean Paul
    Jun 13, 2006 at 3:47 am
    Jun 13, 2006 at 11:06 pm
  • So let's say you have a 10gR2 database that you need to downgrade to 10gR1. You have no choice, you have to downgrade. The immediate solution that comes to mind: export the entire database shutdown ...
    Grabowy, ChrisGrabowy, Chris
    Jun 1, 2006 at 5:18 pm
    Jun 2, 2006 at 5:37 pm
  • Anyone has web site for ORACLE interview questions? Thanks.
    Dba1 mccDba1 mcc
    Jun 27, 2006 at 12:30 pm
    Jun 29, 2006 at 6:18 pm
  • I'm after opinions and others practice. At my new site we use RMAN with a catalog, at least some databases do and some didn't. I'm trying to ensure that what and how we backup is policy driven and ...
    Niall LitchfieldNiall Litchfield
    Jun 28, 2006 at 10:20 am
    Jun 28, 2006 at 2:14 pm
  • Hi, In one of my programs : I am doing a lot of deletes for one key existing in many tables. I have to visit each table and delete the row for the key. This process is real slow. Are there any ...
    A JoshiA Joshi
    Jun 23, 2006 at 2:32 am
    Jun 25, 2006 at 12:08 pm
  • List, We have a packaged app. One of our processes is issuing 'SELECT X FROM TABLE_Y WHERE A=:1 FOR UPDATE WAIT 10' (names changed to protect the vendor....). . This process is periodically having ...
    Stuart ClowesStuart Clowes
    Jun 21, 2006 at 3:39 pm
    Jun 22, 2006 at 8:38 am
  • I got called today about one of our RAC clusters (RHEL 4, 2 cpus, 8GB RAM, 10.2.0.1, 32-bit, ASM 2, EMC clariion cx700 storage, dual qlogic hbas). that was locked up. the cpu on both nodes were ...
    Steve PerrySteve Perry
    Jun 13, 2006 at 12:11 am
    Jun 16, 2006 at 8:35 am
  • Hi I have single instance Dev database using ASM and it is using DtDg1 as Disk group. Now I want to move the whole database to DtDg2 Disk group as I had to use Disk involved in DtDg1 for some other ...
    Sanjay MishraSanjay Mishra
    Jun 15, 2006 at 2:42 am
    Jun 15, 2006 at 10:00 pm
  • That was not the question. It was: how do I deny access to *applications* - not users! If you *allow* access to the known applications then you can deny access to an unknown number of unknown ...
    F.Castillo_at_hzd.hessen.deF.Castillo_at_hzd.hessen.de
    Jun 9, 2006 at 5:22 am
    Jun 12, 2006 at 7:36 am
  • Hey all, According to a LOB perftuning paper from Oracle, specifying RETENTION is preferred over PCTVERSION for creating LOBs when using automatic UNDO. In 9.2.0.5.0, a dev here has created a table ...
    Jesse, RichJesse, Rich
    Jun 9, 2006 at 7:16 pm
    Jun 12, 2006 at 5:27 am
  • Hi all, I don't know if it's off topic, but I met it in SQLPlus. I SPOOLed the output into a text. When the file reached to GB, an exception "xrealloc: cannot reallocate 706258176 bytes (0 bytes ...
    Yongping YaoYongping Yao
    Jun 7, 2006 at 2:13 am
    Jun 7, 2006 at 10:34 am
  • We bit the bullet and implemented concurrent I/O (AIX 5.2 ML6, 9.2.0.5, JFS2, ESS storage). It seemed to make operations doing table scans slower (exports in particular took 50% longer). We have 8K ...
    Stuart ClowesStuart Clowes
    Jun 28, 2006 at 8:06 pm
    Jun 29, 2006 at 11:14 pm
  • WHAT IS HASH JOIN IN ORACLE, HOW TO MAKE FAST HASH JOINS Thanking You. With Best Regards SACHIN -- http://www.freelists.org/webpage/oracle-l
    Ravindra K SinghRavindra K Singh
    Jun 24, 2006 at 9:56 am
    Jun 28, 2006 at 3:05 pm
  • Wondering what other people do in granting privileges to developers in non-production. Do you grant system (update any table) privilege or privilege to the individual tables. Jeffrey Beckstrom ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jun 27, 2006 at 1:58 pm
    Jun 28, 2006 at 2:26 pm
  • Hi, I am looking at instructor-led Oracle DBA courses (in London), specifically as preparation for taking the OCA/OCP Oracle certification exams. The Oracle University courses appear to be ...
    Renee DekenahRenee Dekenah
    Jun 22, 2006 at 8:50 pm
    Jun 23, 2006 at 3:12 pm
  • Hi all, Can someone please tell me if you skip a COLUMN in a logical standby? The reason I'm asking is that one of our clients replicate all columns except for the CLOB. How do we go about doing ...
    Leng KaingLeng Kaing
    Jun 21, 2006 at 12:08 pm
    Jun 23, 2006 at 12:06 pm
  • Hi all, in the next weeks, I'll have to perform an update from 8.1.7.3 rel. directly to 10gR2, platform is Win2K sp4. On Oracle documentation, I found "Oracle Database Update Guide for 10g Rel. 2", ...
    Alessandro VercelliAlessandro Vercelli
    Jun 16, 2006 at 2:18 pm
    Jun 20, 2006 at 6:50 pm
  • in 8 and 9, oracle had the link to the data dicionary docs right on the main page. They reorganized it with 10g and I have been unable to find them. Instead of a link can someone tell me how to ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Jun 19, 2006 at 1:25 pm
    Jun 19, 2006 at 5:00 pm
Group Navigation
period‹ prev | Jun 2006 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions235
posts1,315
users244
websiteoracle.com

244 users for June 2006

Alex Gorbachev: 62 posts Kevin Closson: 62 posts Oracle-l-bounce_at_freelists.org: 53 posts Allen, Brandon: 31 posts Mladen Gogala: 26 posts Jared Still: 25 posts Niall Litchfield: 23 posts Schultz, Charles: 22 posts Laimutis Nedzinskas: 21 posts David Sharples: 20 posts Ghassan Salem: 19 posts Genegurevich_at_discoverfinancial.com: 18 posts Jesse, Rich: 18 posts Sanjay Mishra: 18 posts MVE: 17 posts Radoulov, Dimitre: 17 posts Rjamya: 17 posts Mark J. Bobak: 16 posts Hallas, John, Tech Dev: 15 posts Juan Carlos Reyes Pacheco: 14 posts
show more
Archives