Search Discussions

252 discussions - 1,260 posts

  • Hello, I've been diagnosing some mis-used full table scans vs index access. Part of my troubleshooting involved trying to use system statistics to force oracle to consider full table scans more ...
    Christo KutrovskyChristo Kutrovsky
    May 17, 2005 at 3:36 pm
    May 26, 2005 at 3:57 am
  • Here's a guest editorial by one of Oracle-L's more outspoken open source proponents. Particularly when it comes to PostgreSQL. :) ...
    Jared StillJared Still
    May 3, 2005 at 8:33 pm
    May 9, 2005 at 8:20 pm
  • Can anyone tell me how to turn off the "try then buy" options in 9.2.0? i have been running some scripts and have found "options" such as OLAP, Partitioning, et. al. turned on and wish to turn them ...
    Bryan WellsBryan Wells
    May 18, 2005 at 9:54 am
    May 24, 2005 at 5:48 pm
  • I am tracking a process that's exhibiting what I consider odd behavior. This is on Windows. A stored procedure is executing a loop in which it performs a cursor fetch, then updates the same ...
    Paul BaumgartelPaul Baumgartel
    May 20, 2005 at 12:29 pm
    May 25, 2005 at 4:28 am
  • Quote: "We just don't know why the server with 25 databases is slow. But, I'm a firm believer in the silver bullet methodology. If we just start shutting down production databases one-by-one we'll ...
    May 10, 2005 at 2:20 am
    May 10, 2005 at 11:55 pm
  • Overheard a rumour that a new manager whom I think has not managed before is considering using Agility Programming as his management style. What is Agility Programming - does anyone know and how ...
    May 26, 2005 at 7:29 am
    May 26, 2005 at 2:40 pm
  • All, We are just creating CTX type indexes for the first time and I have a couple of questions. I know that I need to periodically resync the indexes using the Ctx_ddl package. We plan on doing this ...
    Mercadante, Thomas F (LABOR)Mercadante, Thomas F (LABOR)
    May 25, 2005 at 8:04 am
    May 26, 2005 at 1:53 pm
  • Someone posted this about 1-2 years ago. anyone have it? -- http://www.freelists.org/webpage/oracle-l
    May 16, 2005 at 11:15 pm
    May 23, 2005 at 1:01 pm
  • Hi, I have been sending bit and pieces of question into this forum. I manage to go this far, but then i am stuck here again... I have created : table name : myclass table column : id, name, type ...
    Kean JacintaKean Jacinta
    May 18, 2005 at 3:21 am
    May 19, 2005 at 12:51 pm
  • Hi, all, We will recently migrate some important database server from 8i to 9i( with a bunch of fixes). As we have very high concurrency and load, we want to keep the optimizer the same ...
    Zhu chaoZhu chao
    May 9, 2005 at 5:48 am
    May 12, 2005 at 11:48 am
  • Hi,list My query is select a.* from peak_present a,present b where a.present_id=b.id and a.peak_id=:1 order by a.id; The table a has 39M rows,and table b is very small,I have a index on a.peak_id,all ...
    Zhai JingminZhai Jingmin
    May 27, 2005 at 10:50 pm
    May 31, 2005 at 6:08 pm
  • I am having issues with execution plans changing even though the statistics on tables are kept static. Can anyone give me any information on the dynamic factors which are taken into account by the ...
    Terry BarnettTerry Barnett
    May 19, 2005 at 4:09 pm
    May 22, 2005 at 3:24 pm
  • Has anyone had an issue with MAX* columns within DBA_TEMP_FILES being wrong? I've got one temp tablespace, type temporary, defined for all users and the default at the database level ( on ...
    Herring Dave - dherriHerring Dave - dherri
    May 30, 2005 at 10:32 am
    Jun 16, 2005 at 8:45 pm
  • Boy, do I love patching. Especially Oracle. Especially Oracle on Windows. You could refer to it as the Full Employment for DBA's Under Pressure act. Having made the determination to patch the ...
    Jared StillJared Still
    May 23, 2005 at 2:34 pm
    May 31, 2005 at 4:07 pm
  • Dear all, I wonder if someone has already=20 read the new book of C.J.Date: Database in Depth,=20 O'Reilly. What do you think about it? Many Thanks. Mario Cariggi. -- ...
    Mario CariggiMario Cariggi
    May 16, 2005 at 9:25 am
    May 17, 2005 at 8:57 am
  • I have created a database manually via sqlplus and need to configure the web-based console to see this new database. When I use emca it says the instance is unavailable, however it is definitely ...
    May 3, 2005 at 9:03 am
    May 3, 2005 at 9:27 pm
  • Hi can someone confirm (or deny) my assumption here. An archived log is currently being sent from the primary to the standby. Primary site goes mid transfer, we end up with a 90% completed log on the ...
    David SharplesDavid Sharples
    May 31, 2005 at 10:46 am
    Jun 3, 2005 at 4:17 am
  • We have redo members mirrored on multiple file systems. We write the redos to an archive log. We backup the database in full along with archivelogs each night. The problem is that if the entire box ...
    May 17, 2005 at 9:06 am
    May 23, 2005 at 5:14 am
  • Hello List, First of all, I am not using TABLESPACES with ASSM feature. I saw a lot of buffer busy waits on couple of tables which being used for heavy inserts. I have increased the freelist of those ...
    The Human FlyThe Human Fly
    May 10, 2005 at 8:45 am
    May 18, 2005 at 11:15 pm
  • In Oracle 9i what is the best way to identify an unused index? -- http://www.freelists.org/webpage/oracle-l
    May 12, 2005 at 2:05 pm
    May 16, 2005 at 10:43 pm
  • Was Oracle 8.1.7 ever certified to run on non-x86 Linux? Thanks! Ron=20 -- http://www.freelists.org/webpage/oracle-l
    Smith, Ron L.Smith, Ron L.
    May 24, 2005 at 12:01 pm
    Jun 1, 2005 at 4:45 am
  • I am setting up a disaster recovery site and I was thinking about the best way to do this. My theory is that I would like to not just use another recovery catalog on the DR site to backup my primary ...
    May 25, 2005 at 4:59 am
    May 26, 2005 at 12:34 pm
  • One of our databases was started with TNS_ADMIN set to a directory where there was no TNSNAMES.ORA file. Now, when a remote user starts an Sqlplus session and attempts to use a synonym using a ...
    Rusnak, George A. (SEC-Lee) CTRRusnak, George A. (SEC-Lee) CTR
    May 24, 2005 at 11:13 am
    May 24, 2005 at 3:17 pm
  • GURUS, Oracle EE: Hardware: HP-UX 3 tier architecture: Presentation, Application and Database. Language: Cold Fusion Challenge: How do we capture the user logging into the Presentation layer ...
    Rusnak, George A. (SEC-Lee) CTRRusnak, George A. (SEC-Lee) CTR
    May 9, 2005 at 1:56 pm
    May 23, 2005 at 10:35 am
  • Hi,=20 I need to quickly create array; then browse it. I am thinking of using index by binary_integer type of collection because= =20 they don't need to be extended etc.=20 How do I traverse this ...
    Ranko MosicRanko Mosic
    May 17, 2005 at 4:52 pm
    May 21, 2005 at 2:40 am
  • Hi All, One of my collegue has got a problem on index rebuilds. ***************************************************************************= ** We have a table of 35 partitions with a CLOB column ...
    Prem Khanna JPrem Khanna J
    May 19, 2005 at 7:12 am
    May 19, 2005 at 8:54 pm
  • Well, I've R'd the FMs, and can't seem to find a clear answer - as I'm new to DataGuard, I need your help! :-) I've been asked what the ramifications of doing a cold backup on a physical standby ...
    The OracleThe Oracle
    May 29, 2005 at 6:09 pm
    Jun 1, 2005 at 1:06 pm
  • We've been using set client info on many of our production systems for some time and this helps us create resource usage reports so we can identify owners of bottlenecks. However, we do have some ...
    David TurnerDavid Turner
    May 26, 2005 at 3:01 pm
    May 29, 2005 at 11:57 pm
  • so they just told me that they're going to "rebuild" the one solaris server over the weekend, if i remember correctly, any changes to the OS will require a "relink -all" before i bring all the ...
    Bill thaterBill thater
    May 24, 2005 at 3:31 pm
    May 25, 2005 at 7:58 am
  • Good Day everyone, I have a small doubt about using tkprof with explain parameter. Say, when we use, set autot trac exp for any insert,update,delete that command is executed and produces the ...
    The Human FlyThe Human Fly
    May 21, 2005 at 8:03 am
    May 23, 2005 at 7:44 am
  • I have mounted Oracle software cd's on my cd tower. I can see them mounted from my Sun server. I have checked dfstab to ensure they were "shared". I have run /etc/init.d/nfs.server stop ...
    May 15, 2005 at 8:37 am
    May 15, 2005 at 2:34 pm
  • I noticed some of the snp processes take a LOT of memory, probably their PGA grows to accommodate the largest nightly jobs. Looks like the PGA never shrinks back down, is there a way to force ...
    Boivin, Patrice JBoivin, Patrice J
    May 5, 2005 at 10:06 am
    May 13, 2005 at 5:14 pm
  • I was wondering if there was an elegant way to model (or implement the business rule)=20 for those situations where the requirement in a parent-child relationship is such=20 that there a quantity ...
    Thomas JeffThomas Jeff
    May 11, 2005 at 8:42 am
    May 12, 2005 at 3:01 pm
  • Hi All, How do i schedule a job on second saturday of every month using cron ? Can someone help ? TIA. Regards, Prem. -- http://www.freelists.org/webpage/oracle-l
    Prem Khanna JPrem Khanna J
    May 23, 2005 at 9:25 am
    May 31, 2005 at 5:49 am
  • I've got a client who think they are going to take a highly tailored Oracle subscription system written in UniFace and C and take it to Sql Server. From the most I can gather, this is going to happen ...
    May 26, 2005 at 10:09 am
    May 27, 2005 at 10:33 am
  • Anyone no if any/all Oracle datatypes that are NOT supported by "insert into select...". How about "insert into select...from t1_at_dblink" over db link? insert into SCOTT.B_[LOB_TABLE | ...
    Marquez, ChrisMarquez, Chris
    May 20, 2005 at 4:46 pm
    May 24, 2005 at 5:27 pm
  • Wanna see something interesting with opatch? *nix: perl -cw $ORACLE_HOME/OPatch/opatch.pl Windoze: perl -cw %ORACLE_HOME%\opatch\opatch.pl Anyone else have trouble with opatch and Perl 5.8.3? Windows ...
    Jared StillJared Still
    May 20, 2005 at 2:47 pm
    May 23, 2005 at 5:01 pm
  • Hello list, We are facing performance problems with PAY_BALANCE_VALUES_V view which comes with Oracle Apps HRMS module. Since it is written by ORACLE, one should expect it runs very fast and there ...
    The Human FlyThe Human Fly
    May 30, 2005 at 3:09 am
    May 31, 2005 at 9:40 am
  • List, I have been looking into using Data Guard as a method of providing HA is = the company decides it is an option they want to invest in. The question that I have are. 1. Using a physical database ...
    Ron RogersRon Rogers
    May 27, 2005 at 3:42 pm
    May 31, 2005 at 7:46 am
  • Hi, Does anyone have advance knowledge about this? http://www.oreilly.com/catalog/advperl2/ New version due next month? Regards, Mike Thomas -- http://www.freelists.org/webpage/oracle-l
    May 26, 2005 at 11:43 pm
    May 27, 2005 at 9:11 pm
  • Hi gurus I am trying to install 10g 1.0.3 grid agent on a sun box which has a 9i database i am getting the following error Error in writing to directory /tmp/OraInstall2005-05-25_05-25-39PM. Please ...
    Arun chakrapani raoArun chakrapani rao
    May 25, 2005 at 5:40 pm
    May 27, 2005 at 12:58 pm
  • I have an application where data is never deleted, I have just rebuilt an index which was previously 4gb in size and its now 3gb in size. Can anybody explain? -- ...
    Peter DixonPeter Dixon
    May 22, 2005 at 1:50 pm
    May 24, 2005 at 7:36 am
  • Have a HUGE table that I do NOT want to EXPort, but other that I would like *everything* else...FULL=Y. Any ideas? Thanks in advance, Chris Marquez Oracle DBA -- ...
    Marquez, ChrisMarquez, Chris
    May 23, 2005 at 6:04 pm
    May 24, 2005 at 4:22 am
  • Hi Team, Can anyone tell me how to find the latest patch applied on the DB? Any Idea? I am on Solaris, Oracle version 9.2.=20 Regards - Chirag -- http://www.freelists.org/webpage/oracle-l
    Chirag DBAChirag DBA
    May 9, 2005 at 2:24 pm
    May 9, 2005 at 9:19 pm
  • Hi all, I am having a problem with a database not automatically starting up when a box is rebooted. The machine is Windows 2003. There is an old ORACLE_HOME on this box, not sure if that is ...
    May 25, 2005 at 10:07 am
    Jun 28, 2006 at 1:09 pm
  • hi, Just want to know, would it be possible to search all tables that contains medicode. Giving an example: i have 15 tables .And only 9 tables contains medicode. The field name medicode is d same in ...
    Kean JacintaKean Jacinta
    May 27, 2005 at 2:38 am
    May 27, 2005 at 9:36 pm
  • This backup/rman script (korn shell) works fine in other environments but is not working in Linux. It gets to this rman line and doesn't pass in the variables for the passwords or SIDs. Any idea why ...
    J. DexJ. Dex
    May 25, 2005 at 7:52 am
    May 25, 2005 at 11:51 am
  • I have a table which has multiple records for one individual. Each record represents a different field, i.e. id 31 represents start time, id 19 represents shift, id 10 represents rate, etc. 012222 0 ...
    Burton, LauraBurton, Laura
    May 23, 2005 at 11:30 am
    May 24, 2005 at 4:44 am
  • I'm working on a project that will use Oracle with some type of replication, either at the application layer, using advanced rep, or Oracle Streams. I've heard Advanaced Rep is resource intensive and ...
    David TurnerDavid Turner
    May 20, 2005 at 5:49 pm
    May 23, 2005 at 4:24 pm
  • Hi, All,=20 We have a database with buffer busy wait that we can't explain.=20 A huge table (1.5TB) with long raw column and high concurrency insert. (6-9M rows inserted per day) No FK etc. Just one ...
    Zhu chaoZhu chao
    May 19, 2005 at 10:29 am
    May 21, 2005 at 4:18 am
Group Navigation
period‹ prev | May 2005 | next ›
Group Overview
grouporacle-l @

242 users for May 2005

Marquez, Chris: 48 posts Jared Still: 39 posts Wolfgang Breitling: 34 posts Paula_Stankus_at_doh.state.fl.us: 33 posts Christian Antognini: 31 posts Christo Kutrovsky: 24 posts Martic Zoran: 24 posts Oracle: 24 posts Goulet, Dick: 23 posts Mercadante, Thomas F (LABOR): 23 posts Niall Litchfield: 23 posts Mladen Gogala: 22 posts Tim Gorman: 22 posts Zhu chao: 22 posts Connor McDonald: 20 posts Mhthomas: 19 posts Stephen booth: 19 posts David Sharples: 16 posts Carel-Jan Engel: 15 posts Kean Jacinta: 15 posts
show more