Search Discussions

166 discussions - 979 posts

  • Hi everybody: I am seeing a degradation in SQL*Loader performance after making a seemingly benign changes to couple of tables - the tables were dropped and recreated with some columns being removed ...
    Jan 16, 2008 at 9:39 pm
    Mar 5, 2009 at 9:42 pm
  • All, We have been proposed with following architecture by our consultant. I need your expert opinion on this. Assume a server got 5 database and all the databases running in same oracle version and ...
    Satheesh Babu.SSatheesh Babu.S
    Jan 3, 2008 at 5:49 am
    Jan 4, 2008 at 9:39 am
  • Hi List, I've recently been enlisted as the admin for Oracle App Server 10gR2 and every day I'm realizing more and more how much effort this is going to require for setup and ongoing support. I have ...
    Allen, BrandonAllen, Brandon
    Jan 22, 2008 at 10:31 pm
    May 2, 2008 at 3:00 pm
  • Gurus, I need your opinion regarding setting up High Availability solution between Primary and Secondary Data Centers. Is it better to go with Oracle RAC or Oracle Standby database. Thanks In ...
    Bob RobertBob Robert
    Jan 8, 2008 at 9:15 pm
    Jan 23, 2008 at 6:15 pm
  • I'm just starting to dig in to tuning some SQL in a new (to me) environment. One of the statements of interest is this one: SELECT ma_id FROM some_lookup WHERE program_id = :1 AND :2 BETWEEN ...
    Dan NorrisDan Norris
    Jan 9, 2008 at 11:28 pm
    Jan 11, 2008 at 7:31 pm
  • My PC/LAN manager came by and asked me if I could gather some recommendations for SANs for companies running Oracle. Or types of SANS even. That's real cut and dried is it not? (Tongue planted firmly ...
    Taylor, Chris DavidTaylor, Chris David
    Jan 29, 2008 at 8:56 pm
    Jan 31, 2008 at 5:21 pm
  • folks, I have a machine (RAC configuration) on HPUX - PARISC. in a node I have 38GB physical memory, 8 processors. the machine could not run with asynchronous IO, so I set io slave to 8, and ...
    Ujang JaenudinUjang Jaenudin
    Jan 20, 2008 at 12:36 am
    Jan 23, 2008 at 11:53 pm
  • All, recently I am being offered a remote support DBA job and the hiring company is asking me to quit my current regular position and work with them for 33$/hr on W-2 with no benefits. Well I am in ...
    Jan 14, 2008 at 11:34 pm
    Jan 24, 2008 at 4:20 am
  • Hello Everyone, I have : DB version and DB Platform Solaris 8, 9 & 10 We have database username/password authentication with some security via profile. Our management has decided to ...
    Jan 11, 2008 at 8:50 pm
    Apr 30, 2008 at 5:48 am
  • Which is better to use gzip or compress? All of my work is done on AIX 5L 64bit server. I am doing cold backups of databases where I tar and then compress the resulting file. I have always used ...
    Joe SmithJoe Smith
    Jan 22, 2008 at 7:54 pm
    Jan 23, 2008 at 11:16 pm
  • Hi Does anybody know what the thrid party cluseterware from Veritas SUN and IBM HACMP over and above what has already been offered by Oracle for free. regards Hrishy Sent from Yahoo! Mail - a smarter ...
    Jan 16, 2008 at 4:08 pm
    Jan 20, 2008 at 1:55 pm
  • Oracle on Solaris 10 (64-bit SPARC) I'm having a problem getting my Oracle database to auto-start upon reboot (init -6) on . Yet when I run the dbora script manually (./dbora start) using ...
    Mike RothouseMike Rothouse
    Jan 9, 2008 at 3:17 am
    Jan 11, 2008 at 6:58 pm
  • Platform: Oracle 10gR2 on AIX 5L We have a materialized view refresh that takes just ten minutes to complete between a database in the US-southwest and one on the east coast. That same refresh ...
    David TaftDavid Taft
    Jan 31, 2008 at 5:14 pm
    Feb 1, 2008 at 11:32 pm
  • How many of you guys have seen this? http://www.computerworld.com/action/article.do?command=viewArticleBasic& articleId=9057226&source=NLT_PM&nlid=8 What are your thoughts? I know our organization ...
    Taylor, Chris DavidTaylor, Chris David
    Jan 15, 2008 at 3:42 pm
    Jan 16, 2008 at 4:51 pm
  • Our SA's are just setting up some HP blades for us for a rac and he sent me this below. Just wondering if anyone on the list sees a problem. "Also, since the c class blades have only 2 physical nics, ...
    Michael McMullenMichael McMullen
    Jan 10, 2008 at 3:27 pm
    Jan 13, 2008 at 3:21 pm
  • Hi All, If you purchase an application from a supplier would you expect them to supply a script for gathering statistics on their schema and to make recommendations on how frequently the statistics ...
    Ronnie DoggartRonnie Doggart
    Jan 25, 2008 at 11:29 am
    Jan 27, 2008 at 4:53 pm
  • All, The database is 10gR2 db running on solaris 8 .. There was archiver hung on archlogs01 filesystem . I moved all the archive logs to the backup filesystem . however df still shows archlogs01 100% ...
    Jan 16, 2008 at 10:39 pm
    Jan 17, 2008 at 1:18 pm
  • Hi, List, I'd like to hear your input on how many listeners to run in a RAC environment that will host 4 RAC databases. It'll be Oracle on RHEL 4 (all 64-bit). I am leaning to run just 1 ...
    Li LiLi Li
    Jan 10, 2008 at 4:52 pm
    Jan 10, 2008 at 11:38 pm
  • Hi I tried RMAN compression and it seems to work fast (if you use parallel channels) and very eficiently. I get a compress ratio of 10 to 1. Anyone have some negative experiences (bugs,etc.) working ...
    Juan MirandaJuan Miranda
    Jan 15, 2008 at 5:17 pm
    Jan 20, 2008 at 1:53 pm
  • Hi, Is there a way to determine the dump file size before the export starts? I plan to do a full export of a database. ver 10.2. Thanks. -- http://www.freelists.org/webpage/oracle-l
    Ram RamanRam Raman
    Jan 17, 2008 at 7:27 pm
    Jan 19, 2008 at 4:26 am
  • All, we had a online backup taken on a 10gr2 production db on solaris with configure exclude undo tablespace . we are trying to do a disaster recovery scenario to build a test system. However we are ...
    Jan 18, 2008 at 2:38 pm
    Jan 18, 2008 at 10:17 pm
  • All, We have an Oracle 10g prod database that is being backed up every night just past midnight using user managed backup method. I am trying to restore the files to a test server and create a new ...
    Ram RamanRam Raman
    Jan 30, 2008 at 11:24 pm
    Feb 3, 2008 at 5:25 pm
  • Hi I have two different Database server (A, B) with same Database. If A server database is damaged, but A_USER_ Datafile is fine. In A Server, export and expdp are not working. Is possible get ...
    Enkhbold DashdondogEnkhbold Dashdondog
    Jan 11, 2008 at 3:18 am
    Jan 14, 2008 at 7:07 am
  • Its been so long since I learned SQL, I don't know what to recommend. I don't like the official Oracle SQL docs. Its for someone who has been a Systems Administrator for 20 years. Has done some ...
    Jan 1, 2008 at 11:16 pm
    Jan 2, 2008 at 8:35 pm
  • I recently installed 10g client and 11g client on my laptop which had a 9i client already installed. All seems well, *except* (there's always something), that 9i OEM console will not bring up the ...
    Tony SequeiraTony Sequeira
    Jan 16, 2008 at 12:17 pm
    Jan 29, 2008 at 9:13 pm
  • On our database, we have a very simple query that is not using the index that we expected and is instead doing a full tablescan. The clustering factor of this index is very high. Have any of ...
    Orysia HusakOrysia Husak
    Jan 9, 2008 at 12:44 am
    Jan 23, 2008 at 8:37 pm
  • Ok, guys and gals. I just lost an db that doesn't use RMAN. I have totally forgotten how to recover {until time} a db that doesn't use RMAN. I'm restoring the DB files and the archivelog ...
    Taylor, Chris DavidTaylor, Chris David
    Jan 14, 2008 at 7:21 pm
    Jan 20, 2008 at 1:57 pm
  • Folks During a Benchmark Run of OLTP Transactions very High "log file sync" wait is occuring Storage Box - Sun StoreEdge 9990V (Hitachi SAN) Online Redo logfiles exist on Mounted Filesystem on a LUN ...
    Jan 12, 2008 at 1:56 am
    Jan 14, 2008 at 4:09 pm
  • Hi, one of our server which had Oracle 10203 installed on SuSe 9 crashed and we are trying to restore it We installed CentOS 5.0 however when I try to start Oracle I am getting into different ...
    Jan 8, 2008 at 8:48 pm
    Jan 8, 2008 at 10:46 pm
  • Hello, I'm facing the problem, that all my RAC nodes (2 Node Cluster on Solaris 10, Oracle CRS + ASM) reboot at the same time without any log entries in /var/etc/messages, /var/log/syslog ...
    Jan 16, 2008 at 4:01 pm
    Jan 17, 2008 at 9:09 pm
  • Does anyone have any insight as to when this patchset might be available? -- http://www.freelists.org/webpage/oracle-l
    John ThompsonJohn Thompson
    Jan 28, 2008 at 7:21 pm
    Mar 17, 2008 at 9:39 pm
  • Situation is a "generic" database account that too many people know the password to. But they need to know the password for valid business reasons. Does it make more sense to limit that account's ...
    Sweetser, JoeSweetser, Joe
    Jan 31, 2008 at 4:37 pm
    Jan 31, 2008 at 11:36 pm
  • I have uploaded to Youtube (in 3 parts) a video derived from a presentation I did to some IT managers several months ago about "Good SQL practices". It's a kind of experiment for me, there may be ...
    Stephane FaroultStephane Faroult
    Jan 27, 2008 at 10:03 pm
    Jan 28, 2008 at 8:29 pm
  • Dear Oracle-L, I have been tasked to find what storage solutions is best for our databases. Our current storage solution had been performing very badly not in terms of through put but in terms off ...
    Mir M. MirhashimaliMir M. Mirhashimali
    Jan 14, 2008 at 11:05 pm
    Jan 23, 2008 at 6:06 pm
  • Ok, I'm a little confused here, and looking for some help. This is 10gR2 ( on Linux. I'm trying to move some LOBSEGMENTs and LOBINDEXes from one tablespace to another. If I run this query: 1 ...
    Bobak, MarkBobak, Mark
    Jan 25, 2008 at 6:22 pm
    Jan 26, 2008 at 9:38 am
  • Is a C compiler now a pre-requisite for installing Oracle (on AIX)? John -- http://www.freelists.org/webpage/oracle-l
    John DunnJohn Dunn
    Jan 21, 2008 at 1:23 pm
    Jan 22, 2008 at 7:06 pm
  • Hello List, Problem Summary: Partitioned table "original_table" did not have partitions to properly deal with the last 2 years and future years. My table reorg objective was to create a new set of ...
    Ben WittmeierBen Wittmeier
    Jan 8, 2008 at 7:52 pm
    Jan 16, 2008 at 2:44 pm
  • BismillahirRehmanirRahim Hi All, We are running Oracle 10g R1 on Sun SPARC Solaris 9 Sun Fire V890 Server. By default we have following setting in the Database: disk_asynch_io = TRUE ...
    Junior DBAJunior DBA
    Jan 9, 2008 at 5:41 am
    Jan 15, 2008 at 7:25 pm
  • All Does anyone know how Oracle calculates the cardinality of a query such as: Select * from table_1 where upper(case) like '%12345%'; Execution Plan 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=131 ...
    Ronnie DoggartRonnie Doggart
    Jan 10, 2008 at 3:06 pm
    Jan 12, 2008 at 6:12 pm
  • Note: 271855.1 We are getting massive amounts of redo generation well out of performance of the regular DML we have. We are using AQ and we enqueue and dequeue constantly. I don't have exact ...
    Jan 5, 2008 at 12:51 am
    Jan 10, 2008 at 5:42 pm
  • All I'm almost sure that I read an article linked to here, or perhaps just a response, on the wisdom of setting dbfmbrc to an appropriately high value (so that Oracle tries to read large chunks of ...
    Niall LitchfieldNiall Litchfield
    Jan 8, 2008 at 11:07 am
    Jan 10, 2008 at 4:44 pm
  • Hello everyone and Happy new year to you, Just wonder if you can give your advice if the devices as following will make any difference in the context for Oracle RDBMS performance in the nearest time? ...
    Jurijs VelikanovsJurijs Velikanovs
    Jan 6, 2008 at 9:34 pm
    Jan 8, 2008 at 4:12 pm
  • Hello I have table with sensitive data. I would like to audit if specifics "osusers" execute "select" on this table. I use dbms_fga like below begin dbms_fga.add_policy (object_schema = 'CELIA', ...
    Wojciech SkrzyneckiWojciech Skrzynecki
    Jan 2, 2008 at 11:21 pm
    Jan 7, 2008 at 9:30 am
  • Just wanted to follow-up with my developments. Oracle support said not to set _kks_use_mutex_pin for now, so I didn't. It seems that we ARE being affected by Bug 4367986 - Bind peeked parallel ...
    Don SeilerDon Seiler
    Jan 3, 2008 at 4:13 pm
    Feb 20, 2008 at 3:43 pm
  • I am a newbie to Oracle. I am looking to find out the max number of concurrent connections from a java app that Oracle XE will support and I can't find that info. Does XE have a restriction? TIA, ZK ...
    Zakai KinanZakai Kinan
    Jan 30, 2008 at 4:19 pm
    Feb 1, 2008 at 6:55 am
  • Oracle ver I have a procedure which is called from one of four functions. Other than simply passing the name in as a varchar is there a way to have the procedure known the name. In my ...
    Oxnard MontalvoOxnard Montalvo
    Jan 30, 2008 at 5:01 pm
    Jan 30, 2008 at 6:01 pm
  • Hi Guys, I am trying calculate size of table including size of its indexes too. i am using below script to do so. select a.owner,a.table_name,sum(b.bytes/1024/1024) AS SIZES,a.partitioned from ...
    Hansraj saoHansraj sao
    Jan 22, 2008 at 4:39 pm
    Jan 30, 2008 at 2:59 pm
  • This week I found it necessary to differentiate between strings that were composed of numeric data and those that were alphanumeric. This was kind of fun an interesting. It was also too long to post ...
    Jared StillJared Still
    Jan 25, 2008 at 4:11 pm
    Jan 28, 2008 at 1:20 pm
  • I need to move data from a production table to the test table. I would like to use sqlldr with DIRECT=TRUE. The problem I have is there are multiple physical records on the file for one row on the ...
    Mason, TaraMason, Tara
    Jan 25, 2008 at 3:55 pm
    Jan 27, 2008 at 10:42 pm
  • Is there a way to see how much rollback is left to apply? Currently SMON seems to be busily applying rollback. I can see SMON reading both the UNDO and then the tablespace that contains a 2 gig table ...
    kyle Haileykyle Hailey
    Jan 18, 2008 at 12:20 am
    Jan 18, 2008 at 3:33 pm
Group Navigation
period‹ prev | Jan 2008 | next ›
Group Overview
grouporacle-l @

205 users for January 2008

Andrew Kerber: 55 posts Dan Norris: 42 posts Jared Still: 37 posts Prasad: 34 posts Niall Litchfield: 24 posts Mark W. Farnham: 18 posts Krish.hariharan_at_quasardb.com: 16 posts Pedro Espinoza: 16 posts Sanjay Mishra: 16 posts Taylor, Chris David: 16 posts Hrishy: 15 posts Nigel Thomas: 15 posts Joel.Patterson_at_crowley.com: 14 posts VIVEK_SHARMA: 14 posts Goulet, Dick: 13 posts Jeremiah Wilton: 13 posts Stefan Knecht: 13 posts Matthew Zito: 12 posts Genegurevich_at_discover.com: 11 posts Greg Rahn: 11 posts
show more