Search Discussions

150 discussions - 1,019 posts

  • Company I work for just announced that we're going to convert all but 2 of our 89 Oracle databases to either SQL Server, MYSQL, or PostgreSQL. This is due to the high licensing cost. I'm bummed. -- ...
    John ThompsonJohn Thompson
    Apr 29, 2008 at 6:39 pm
    May 5, 2008 at 6:25 pm
  • I am starting to investigate ASM as a part of a potential to 10g upgrade on Solaris (SunOs 5.9). Oracle's documentation seems to have a bias toward having the ASM instance handle the ...
    Schauss, PeterSchauss, Peter
    Apr 11, 2008 at 1:33 pm
    Apr 22, 2008 at 11:40 pm
  • Hi, I ended up with a crashed Oracle db, which refuses to start. I have all the datafiles for this database and was wondering if it is possible to somehow "Load / Import" the data in these datafiles ...
    Srinivas ChintamaniSrinivas Chintamani
    Apr 25, 2008 at 1:10 pm
    May 4, 2008 at 9:49 am
  • In 11G (OEL5 Linux) using Active dataguard does anybody know if it is possible to capture transactions at a schema level using Streams from the STANDBY database. I have searched the docs but I cannot ...
    John HallasJohn Hallas
    Apr 11, 2008 at 2:46 pm
    Apr 16, 2008 at 6:43 pm
  • Greetings, I find myself again frustrated with Oracle support and I'm looking for some feedback. I recently encountered difficulties with CRS functioning on a two node cluster running on 32-bit linux ...
    William WagmanWilliam Wagman
    Apr 3, 2008 at 11:40 pm
    Apr 7, 2008 at 7:45 pm
  • It used to be if you wanted a detailed timestamp in the RMAN log you just had to: NLS_DATE_FORMAT=YYYY-MM-DD:HH24:MI:SS; export NLS_DATE_FORMAT Call rman. That doesn't seem to cut now. Is there ...
    Apr 14, 2008 at 11:57 am
    Apr 15, 2008 at 9:22 pm
  • Hi Gurus, We did upgrade to from 9i and there is a performance degrade. The CPU looks like below last pid: 4118; load averages: 56.40, 59.29, 58.40 12:05:15 270 processes: 207 sleeping, 59 ...
    Apr 16, 2008 at 7:12 pm
    Apr 28, 2008 at 1:49 am
  • Hi all I'm quite puzzled after reading some measurements taken at a client's IBM DS 8300 Storage subsystem: I simply checked the db file sequential reads, and their elapsed times (Single block, ...
    Stefan KnechtStefan Knecht
    Apr 15, 2008 at 12:31 pm
    Apr 23, 2008 at 1:58 am
  • FYI yesterday, david litchfield released a paper describing how a sql injection attack could be done on a pl/sql routine that does dynamic statement creation, even if the routine has no parameters ...
    Adams, Matthew (GE Indust, ConsInd)Adams, Matthew (GE Indust, ConsInd)
    Apr 25, 2008 at 2:07 pm
    Apr 29, 2008 at 9:08 pm
  • Hello, I have an unix script in 10g, which connects to remote database whose connection string is NOT defined in tnsnames.ora, as described below. sqlplus -s user/password@"(DESCRIPTION = ...
    Apr 7, 2008 at 1:52 pm
    Apr 16, 2008 at 4:22 pm
  • Folks Following Error Occurred during impdp:- ORA-39082: Object type TRIGGER:"CRMUSER"."TRG_LCT" created with compilation warnings ACTION:- SQL alter trigger "CRMUSER"."TRG_LCT" compile; Warning ...
    Apr 24, 2008 at 7:25 pm
    Apr 29, 2008 at 2:32 pm
  • I've been trying to figure this out all morning. I have a table with 20 or so columns. 2 Of those columns are NUMBER(10) not null and are indexed each with it's own one column index. Both have HEIGHT ...
    Christo KutrovskyChristo Kutrovsky
    Apr 16, 2008 at 12:15 pm
    Apr 22, 2008 at 4:39 pm
  • Hi all, Many mails on this list contain Oracle version numbers. That's a good practice. However, pretty often these numbers get represented as links in the message. The mailscanner of my provider ...
    Carel-Jan EngelCarel-Jan Engel
    Apr 17, 2008 at 12:51 pm
    Apr 17, 2008 at 9:16 pm
  • We have an existing 4-node RAC cluster (v440's on Solaris & Oracle 10.2 w/ ASM) that was big time CPU-bound and application performance was suffering. We added 2 new nodes(M5000's) to bring the total ...
    A EbadiA Ebadi
    Apr 2, 2008 at 9:40 pm
    May 22, 2008 at 2:28 pm
  • Dear list, Is there a difference in executing a query in dedicated vs. shared server connection? The query plans are the same, but in shared server the query runs 1:30 min, and in dedicated mode over ...
    Martin KlierMartin Klier
    Apr 22, 2008 at 3:23 pm
    May 9, 2008 at 4:14 pm
  • We have some databases with load profile like lots of light query (mostly pk based), each execution cost only 3-6 buffer_gets and no complex join etc. But due to excessive executions (10K+ query per ...
    Apr 29, 2008 at 2:58 pm
    Apr 30, 2008 at 1:13 pm
  • Greetings, We have a production database running on RAC (4-node) ( on Solaris 10) and I'm noticing a lot of waits on "enq: HW - contention". Doing a bit of researching tells me that it is ...
    Ravi GaurRavi Gaur
    Apr 18, 2008 at 8:33 pm
    Apr 22, 2008 at 3:08 pm
  • We have a two-node RAC system on Solaris 10 using Oracle Clusterware and ASM that is being used for our test database.. We also have a single-instance database on one node of this cluster ...
    Jeffery ThomasJeffery Thomas
    Apr 4, 2008 at 4:55 pm
    Apr 7, 2008 at 10:50 pm
  • Hi Our current Oracle version - Does anyone know what version this feature has been fixed in. I would like to enable the feature, but it seems to have been very buggy (especially with wrong ...
    Rob DempseyRob Dempsey
    Apr 23, 2008 at 5:07 pm
    May 5, 2008 at 2:33 pm
  • Greetings. This was something that happened today in one of the database and I am looking for list's response on this. This is a Oracle database running solaris 9. Around 10am the Unix group ...
    Apr 17, 2008 at 4:30 am
    Apr 24, 2008 at 2:29 am
  • All, I'm running into a problem trying to recover a test database with a read only tablespace ASSETS_21 from an RMAN backup. The restore runs fine and appears to restore the ASSETS_21.dbf ...
    David LordDavid Lord
    Apr 16, 2008 at 3:54 pm
    Apr 19, 2008 at 6:46 am
  • Hi All, I'm a bit confused by this RMAN behaviour. I have a full backup and a level 1 incremental a few days later. However if I restore (preview) it only attempts to use the level 1 (example ...
    Charlotte HammondCharlotte Hammond
    Apr 2, 2008 at 9:23 am
    Apr 3, 2008 at 5:47 pm
  • DBAs, I am currently reviewing options for Oracle 11 RAC on Solaris 10 and one of the proposals on the table is: Use CRS as the only clusterware on the box Use ASM for database (clustered) storage ...
    Lawie, DuncanLawie, Duncan
    Apr 28, 2008 at 12:39 pm
    Apr 29, 2008 at 12:37 pm
  • Hi All, I am getting the following errors when I am trying to open my database. There was a power failure to the server over the weekend, that caused me all of this messs. Here are the errrors: - - - ...
    Srinivas ChintamaniSrinivas Chintamani
    Apr 21, 2008 at 1:16 pm
    Apr 22, 2008 at 3:21 pm
  • Is there anyone out there that has taken the leap to 11g in production yet? Any major problems? Is the general consensus that waiting for release 2 is the way to go? There is a ton of stuff in 11g ...
    Stephens, ChrisStephens, Chris
    Apr 23, 2008 at 3:30 pm
    Apr 25, 2008 at 9:46 pm
  • Hello Everyone, I need some non technical help (more political). As a standard installation/configuration I configure iSQL*Plus and dbcontrol for every 10g database in our environment ( on ...
    Apr 25, 2008 at 2:12 pm
    Apr 25, 2008 at 4:59 pm
  • I have spent the morning cleaning out a tablespace in an attempt to reclaim 800 GB of space and clean up my production data warehouse. To this end... I ran a BUNCH of ALTER TABLE move tablespace; It ...
    April WellsApril Wells
    Apr 16, 2008 at 5:42 pm
    Apr 16, 2008 at 6:41 pm
  • Hi List, Does anyone know how to get a 10053 (aka _optimizer_trace) on a recursive query? I'd never noticed this before, but it seems that this event only traces user queries. The problem I'm working ...
    Allen, BrandonAllen, Brandon
    Apr 29, 2008 at 6:39 pm
    May 2, 2008 at 5:20 pm
  • As part of a company-wide security initiative, I've been tasked with coming up an implementation of limited DBA privileges. Specifically, a set of database privileges that allow a user with these ...
    Cochran, MarkCochran, Mark
    Apr 29, 2008 at 10:27 pm
    Apr 30, 2008 at 9:26 pm
  • We are specing some new servers. The Oracle price list says $100 per user for dataguard yet our supplier says its included in Enterprise edition. Is Advanced DataGuard automatic log shipping to a ...
    Howard LathamHoward Latham
    Apr 28, 2008 at 7:22 am
    Apr 30, 2008 at 12:40 pm
  • Okay, this will probably vary by a considerable margin. I was wondering what everybody's experience has been with getting a patch created by Oracle development and then finally made available. On ...
    Bill FergusonBill Ferguson
    Apr 21, 2008 at 3:28 pm
    Apr 22, 2008 at 4:50 pm
  • Hello all, We are planning to move our DR site which is currently about 30 miles from production site to ~1600 miles away. We currently have a 4-node RAC setup on our production site that houses 3 ...
    Ravi GaurRavi Gaur
    Apr 9, 2008 at 3:39 pm
    Apr 11, 2008 at 8:07 pm
  • A colleague is asking for help with a (Sun Solaris 8) optimizer issue. A unhinted query SELECT max(history_timestamp) AS MaxStamp FROM dmsdb.t_dms_deal_security_xref_h WHERE ...
    Baumgartel, PaulBaumgartel, Paul
    Apr 4, 2008 at 2:27 pm
    Apr 4, 2008 at 7:28 pm
  • Can some brave optimizer wonk interested in a challenge please help me see what I'm missing here? Terms of reading further: Only read further with the kindest of intent. No laughing at the blonde ...
    Mary Elizabeth McNeelyMary Elizabeth McNeely
    Apr 24, 2008 at 5:36 am
    Apr 25, 2008 at 4:12 pm
  • Dear All, I'm trying to install Oracel clusterware on RHES 5, 64 bit AMD architecture. Metalink lists this combination as supported, but OUI quits with following message: Checking operating ...
    Manuela AtouiManuela Atoui
    Apr 23, 2008 at 12:05 pm
    Apr 23, 2008 at 3:04 pm
  • I have two servers that have identical tablespaces. Is it possible to compare them? TIA, \ZK You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost ...
    Zakai KinanZakai Kinan
    Apr 2, 2008 at 5:03 pm
    Apr 2, 2008 at 7:52 pm
  • Hi all, 11g's SQL Performance Analyzer(DBMS_SQLPA - http://tinyurl.com/6xdhvd ) is announced to capture the load of a database and report the differences after applying this load onto a 11g ...
    H.Tongu� YILMAZH.Tongu� YILMAZ
    Apr 23, 2008 at 4:59 pm
    Jun 8, 2008 at 7:41 am
  • Env: Linux 2.6. on Intel Oracle In the past I have been led to believe (without much proof) that when connecting to a database on the local server, that IPC should always be used to avoid ...
    Jared StillJared Still
    Apr 23, 2008 at 8:50 pm
    May 26, 2008 at 8:31 am
  • Dear All, After removing Oracle 10g R2 from Windows 2000 AS or Windows XP it doesn't remove many files and directories. Is this is a BUG. If not, then what is purpose. If yes, then what would be ...
    Amit VermaAmit Verma
    Apr 22, 2008 at 8:23 pm
    Apr 24, 2008 at 5:47 pm
  • Hi, Oracle 1.1.06 RAC on OEL 4 64 bit. We are seeing an insert statement reporting "SQL*Net break/reset to client" as over 1/3 of its time. On the face of it this event suggests network issues but ...
    Peter HitchmanPeter Hitchman
    Apr 8, 2008 at 7:54 pm
    Apr 10, 2008 at 4:25 pm
  • Hi All, Most of you are probably aware of the following document, or similar. http://www.integrigy.com/security-resources/whitepapers/Integrigy_Oracle_Listener_TNS_Security.pdf We support roughly 100 ...
    Tony SequeiraTony Sequeira
    Apr 9, 2008 at 4:19 pm
    Apr 10, 2008 at 5:24 am
  • I've got a 1.08TB warehouse that is pretty much all "batch mode". Because of that "batching" they have almost 80-95% of the production tables set to NOLOGGING, including many at the tablespace ...
    Apr 6, 2008 at 6:09 pm
    Apr 8, 2008 at 9:22 am
  • We have a large test running for a client. It appears ALL DB connects time out in 12 hours and 20 minutes. There isn't any sqlnet.ora file on the database server. What we have: HP/UX B.11.11 U ...
    Apr 30, 2008 at 3:12 pm
    May 13, 2008 at 1:46 pm
  • All - I have a java app running on Tomcat - Linux and going against my DB on Unix. This DB is dedicated to this app so I can configure the init parms and settings to maximize the performance ...
    LeRoy KemnitzLeRoy Kemnitz
    Apr 29, 2008 at 8:19 pm
    Apr 30, 2008 at 7:37 pm
  • If I have a PLSQL "my_array" table defined as below: create or replace type my_rec as object ( emp_id number, emp_name varchar2 ) / create or replace type my_array as table of my_rec / I can select ...
    Deepak SharmaDeepak Sharma
    Apr 29, 2008 at 5:55 am
    Apr 29, 2008 at 5:15 pm
  • We'd rolled out a new system today and user connections rapidly went up to 900 sessions. OK, we are supposed to be able to handle that. However, by the afternoon, I saw 'buffer busy waits' on Block#2 ...
    Hemant K ChitaleHemant K Chitale
    Apr 28, 2008 at 12:36 pm
    Apr 28, 2008 at 5:26 pm
  • The trace file shows two "identical" statement like the following: DELETE FROM APP_TABLEA WHERE ID = :1 How can I learn the value of the two bind variables? -- ...
    Sol beachSol beach
    Apr 9, 2008 at 8:56 pm
    Apr 16, 2008 at 4:34 pm
  • I have a large and busy OLTP table, 100GB or so, against which there is a need to capture changes. Until an asynchronous CDC solution is in place we have to rely on two columns: create_date and ...
    David AldridgeDavid Aldridge
    Apr 9, 2008 at 1:29 am
    Apr 10, 2008 at 2:31 am
  • All, I've been having a conversation where I work about using triggers in our application environment. The DBAs here say that triggers are not appropriate in an Oracle RAC. Specifically they tell ...
    Rumpi GravensteinRumpi Gravenstein
    Apr 9, 2008 at 12:37 pm
    Apr 9, 2008 at 5:10 pm
  • Good day, List, I am playing with 11g and want to experiment with the Fault Diagnosability Infrastructure. I would like to force an ora-600. I thought there was an event one could set to crash smon ...
    Charles SchultzCharles Schultz
    Apr 4, 2008 at 8:23 pm
    Apr 5, 2008 at 4:17 am
Group Navigation
period‹ prev | Apr 2008 | next ›
Group Overview
grouporacle-l @

236 users for April 2008

Allen, Brandon: 34 posts Alex Gorbachev: 33 posts Jared Still: 28 posts Dan Norris: 26 posts Finn Jorgensen: 24 posts Bobak, Mark: 23 posts Robert Freeman: 22 posts Yong Huang: 19 posts Mercadante, Thomas F (LABOR): 17 posts Niall Litchfield: 17 posts ������: 14 posts Don Seiler: 14 posts Krish.hariharan_at_quasardb.com: 14 posts Mark W. Farnham: 14 posts Hemant K Chitale: 13 posts Baumgartel, Paul: 12 posts Jeremy Schneider: 12 posts John Hallas: 12 posts Rich Jesse: 12 posts David Aldridge: 11 posts
show more