FAQ

Search Discussions

149 discussions - 856 posts

  • Reasons *for* ASM that I can see. I agree with most of your negatives :). Ease of file management - which is mostly OMF rather than ASM per se. (that's a disagreement!) Ease of disk management - ...
    Niall LitchfieldNiall Litchfield
    Oct 16, 2008 at 3:25 pm
    Dec 30, 2008 at 9:28 pm
  • Hello to everyone SuSE SLES 10 64bit, Oracle 10.2.0.4 standalone (no RAC) We are planning to utilize hugepages on systems that come with 32GB to 64GB of memory. We are following steps from Metalink ...
    Vladimir BaracVladimir Barac
    Oct 5, 2008 at 3:08 pm
    Oct 10, 2008 at 3:28 pm
  • Hi to all: Anyone has available the MMA pdf for 9iR2? I tried to obtain it from metalink, thaiti, otn and google with no luck, only can get info about release = 10gR1 If someone can send me it, ...
    David BallesterDavid Ballester
    Oct 3, 2008 at 8:27 am
    Oct 5, 2008 at 4:22 am
  • Folks, I'm trying to find a way to script finding an approximation of the version of the database without connecting to the database itself. The goal is to try to find out of the Oracle_home is a ...
    Fuad ArshadFuad Arshad
    Oct 24, 2008 at 3:45 pm
    Nov 12, 2008 at 10:45 pm
  • Hi, Pete Finnigan released v2 of his oracle database password checker written in plsql. It's worth running against your (SOx) production databases to find out about weak database passwords that might ...
    Andre van WinssenAndre van Winssen
    Oct 7, 2008 at 12:41 pm
    Oct 13, 2008 at 5:17 pm
  • ('binary' encoding is not supported, stored as-is) Hi guys, Is there a way to use sqlplus and connect to a database without using tnsnames.ora? Specify the whole connect string in the command line? ...
    Lyndon TiuLyndon Tiu
    Oct 21, 2008 at 1:20 pm
    Feb 16, 2009 at 10:47 pm
  • Folks We are in the process of Setting up DB Server for an OLTP Banking Application Benchchmark. HP-UX B.11.31 system device block size(think this is the O.S. block size) = 1K Base page size = 4K ...
    VIVEK_SHARMAVIVEK_SHARMA
    Oct 14, 2008 at 10:23 am
    Oct 16, 2008 at 1:48 pm
  • I am curious on your thoughts on this.......we have 3 unrelated databases and 9 boxes to put them on. Would you recommend one 9 node cluster and put them on that one or three 3 node clusters (one for ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    Oct 6, 2008 at 6:10 pm
    Oct 22, 2008 at 1:38 pm
  • Hi guys, I am planning a cheap RAC solution based on Red hat Enterprise 4 Linux (or oracle unbreakable Linux) . I get some hints from Jeff Hunter's storage solution, but i am not sure if it a stable ...
    Bao jiejieBao jiejie
    Oct 28, 2008 at 2:51 am
    Jul 31, 2009 at 9:09 pm
  • I have a developer trying to run an SQL script against a test database that is picking up the wrong sql instead of what is really in my PL/SQL script. What's really strange to me is that if I set ...
    Sandra BeckerSandra Becker
    Oct 10, 2008 at 4:10 pm
    Oct 31, 2008 at 7:10 pm
  • Forgive me if this is well-documented elsewhere, but I Queried The Fine Google and couldn't find anything: Are there any ways of forcing a query to be replanned, other than gathering stats on one of ...
    James BartonJames Barton
    Oct 1, 2008 at 1:46 pm
    Oct 30, 2008 at 6:45 pm
  • Forgot to say the version. It is 10.2.0.4 Regards, Yavor Ivanov Oracle Certified Master From: oracle-l-bounce_at_freelists.org On Behalf Of Yavor Ivanov Sent: Friday, October 03, 2008 4:50 PM To ...
    Yavor IvanovYavor Ivanov
    Oct 3, 2008 at 1:58 pm
    Oct 3, 2008 at 7:20 pm
  • Not an advertisement, but I ran across this little tool today and wondered if anyone has experiences with using it. It is a small tool for Windows RAC clusters that allows a sort of "synchronized" ...
    Dan NorrisDan Norris
    Oct 30, 2008 at 7:58 pm
    Jun 25, 2009 at 1:44 pm
  • I am stuck on a windows DB server. I need to run some .sql scripts from the command line in the background. anyone know how to do this in windows? I have not used windows for a DB server in years.. ...
    Dba DBADba DBA
    Oct 23, 2008 at 2:05 pm
    Oct 25, 2008 at 9:20 pm
  • Hi, I took a cold backup of 9i datafiles and copied them to the new 10g 64-bit server I installed the 10g 64-bit Oracle Home On the new 10g server, I recreated the controlfile to point to the new ...
    AshwinAshwin
    Oct 30, 2008 at 9:15 pm
    Nov 2, 2008 at 8:03 am
  • Steve (as usual) nailed it. As for the operation of the fix if you decide you need it I have some ideas. If you set up the destination table for the chained rows to be one row per block, then the ...
    Mark W. FarnhamMark W. Farnham
    Oct 29, 2008 at 9:21 pm
    Oct 31, 2008 at 6:58 pm
  • I need to restore the QC hot backup to development database. I restored all the datafiles that were backed up in hotbackup. But i could able to restore the archive files that were backed during my ...
    Nagaraj SNagaraj S
    Oct 18, 2008 at 6:05 pm
    Oct 20, 2008 at 9:47 pm
  • Greetings All, I am trying to create an Oracle 10.2.0.4 database with SGA_TARGET=256M on Sun T-5140 server with Solaris 10 but getting the following error ORA-00821: Specified value of sga_target ...
    Mandal, AshokeMandal, Ashoke
    Oct 16, 2008 at 2:16 pm
    Oct 16, 2008 at 10:10 pm
  • This is not a database question. I am currently running a server with VMWare Server and a couple of VMs with RHEL4 and Oracle (9i, 10g, 11g) and a VM with Windows 2003 Server with a MS SQL Server ...
    Bort, GuillermoBort, Guillermo
    Oct 5, 2008 at 2:33 am
    Oct 8, 2008 at 4:27 pm
  • Does anyone have any recommendations for visio equivalents that are either open source or free. I need a tool that will diagram erd. Physical servers logical app design at least. I know visio will do ...
    Niall LitchfieldNiall Litchfield
    Oct 22, 2008 at 5:41 pm
    Oct 23, 2008 at 2:14 pm
  • Greetings, I'm looking for a book on Streams setup and replication that is easy to read and understand. If someone has a recommendation, that would be great. Thanks much - Chris -- ...
    Newman, ChristopherNewman, Christopher
    Oct 22, 2008 at 1:09 pm
    Oct 23, 2008 at 9:36 am
  • Greetings, Running Oracle 10.2.0.3.0 on RHEL4, 64-bit. Table: foo VARCHAR2(300) bar CHAR(1) baz CHAR(1) Data: somelongishstring,A,B shorterstring,A,C shorter,A,D Query: select foo,bar,baz from ...
    William WagmanWilliam Wagman
    Oct 13, 2008 at 11:34 pm
    Oct 14, 2008 at 3:51 pm
  • I recompiled a package. It compiled successfully. The package has several procedures. Each has 1 large insert select. The all select from the same table, but insert to different tables. This has ...
    Dba DBADba DBA
    Oct 4, 2008 at 1:49 am
    Oct 7, 2008 at 5:50 pm
  • Hi I'm adding several pages on http://wiki.oracle.com/, I think if every put a grain of sand this idea can work. The idea is to build something like http://es.wikipedia.org/wiki/Wikipedia:Portada No ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Oct 6, 2008 at 10:54 pm
    Oct 21, 2008 at 7:48 pm
  • Hi all, I have a question about the performance expectation of streams capture process. I just implemented streams to capture DML changes in certain tables in our production and am not happy with the ...
    Madhu SreeramMadhu Sreeram
    Oct 15, 2008 at 10:38 pm
    Oct 18, 2008 at 10:25 am
  • I have a 450 GB table with 150 GB of free space. I'd like to shrink the table, but I'm not sure how much rollback will be needed. Is there a formula? One that accounts for the indexes as well? Ian ...
    Ian MacGregorIan MacGregor
    Oct 16, 2008 at 8:52 pm
    Oct 17, 2008 at 4:02 pm
  • I have a 9.2 database on windows, rac, and we want to move it to Linux. I have a Linux rac, 10.2.0.3 ready. Can I use streams for this? Is it possible, in a simple way, to stream also from Linux 10.2 ...
    Yechiel AdarYechiel Adar
    Oct 5, 2008 at 3:53 pm
    Oct 15, 2008 at 1:06 pm
  • Some of these may be new to you. http://jkstill.blogspot.com/2008/10/undocumented-oracle-functions.html It's time to find the new ones in 11g. :) -- Jared Still Certifiable Oracle DBA and Part Time ...
    Jared StillJared Still
    Oct 2, 2008 at 12:06 am
    Oct 3, 2008 at 3:03 pm
  • Does anyone know how to differentiate between keep and recycle pools in v$bh? Seems like that they are included there but I am not 100% sure as the numbers don't add up properly. Anyone has ...
    Christo KutrovskyChristo Kutrovsky
    Oct 31, 2008 at 9:15 pm
    Nov 8, 2008 at 2:33 pm
  • My friend Michel Cadot sent the following URL to me today: http://latest360.blogspot.com/2008/04/tips-for-better-performance-and-tuning.html I find it quite appropriate for Halloween ("tips or ...
    Stephane FaroultStephane Faroult
    Oct 31, 2008 at 10:15 pm
    Nov 3, 2008 at 10:04 am
  • Folks, I'm looking for what people use today now that Onames has become history. This is a multi location within and outside the US and managing TNSNAMES.ORA files is well a PAIN. I'm especially ...
    Goulet, RichardGoulet, Richard
    Oct 20, 2008 at 2:57 pm
    Oct 21, 2008 at 2:51 pm
  • Greetings, We are using: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options on HP-UX, with a smattering of 9i, 8i, and ...
    Hand, Michael THand, Michael T
    Oct 16, 2008 at 3:08 pm
    Oct 17, 2008 at 3:11 pm
  • ESAVE_at_herbie-SQL select * from v$version; BANNER Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for ...
    Guang MeiGuang Mei
    Oct 3, 2008 at 3:26 pm
    Oct 10, 2008 at 9:25 pm
  • Guys & Gals, I've got a situation where Oracle doesn't recognize disconnected apps on Windows 2003 server. Every time a machine reboots or power goes out, or users terminate an app, it leaves the ...
    Taylor, Chris DavidTaylor, Chris David
    Oct 8, 2008 at 2:22 pm
    Oct 10, 2008 at 5:44 pm
  • We moved our Oracle Apps software to a new 64-bit Solaris 10 server; there is a custom library (.so file) that is still in 32-bit mode. I need to compile it so that it is 64-bit. How do I go about ...
    Vicki PierceVicki Pierce
    Oct 28, 2008 at 8:58 pm
    Oct 30, 2008 at 3:24 pm
  • not talking about an export. I need a comma delimitted file. large amounts of data. is there anything better than spool? sql developer does not work on large data sets. -- ...
    Dba DBADba DBA
    Oct 27, 2008 at 5:01 pm
    Oct 27, 2008 at 6:36 pm
  • There is no need to use the to_date() function as the date-format has been exported. Von: oracle-l-bounce_at_freelists.org Im Auftrag von Syed Jaffar Hussain Gesendet: Montag, 27. Oktober 2008 13:36 ...
    Jan-Hendrik.Boll_at_dataport.deJan-Hendrik.Boll_at_dataport.de
    Oct 27, 2008 at 1:11 pm
    Oct 27, 2008 at 1:38 pm
  • Just curious if any of you guys have ever noted discrepancies in the billing amounts on the invoices Oracle sends your company? We had an itemized invoice from Oracle and one of our managers actually ...
    Taylor, Chris DavidTaylor, Chris David
    Oct 21, 2008 at 5:16 pm
    Oct 24, 2008 at 5:33 am
  • Hi all, After the thread about hugepages a while ago I became interested in them, and told the SA about them. He said it's viable in most of our environments, so it now lies with me to decide where ...
    Bort, GuillermoBort, Guillermo
    Oct 20, 2008 at 2:30 pm
    Oct 21, 2008 at 4:45 pm
  • IBM Series z9 SuSE10 Oracle 10.2.0.3 (highest release for the IBM) Many years ago before I started working here, a developer designed a table with a column DATELOGGED NUMBER(20). They store the date ...
    Sandra BeckerSandra Becker
    Oct 16, 2008 at 8:02 pm
    Oct 17, 2008 at 5:08 pm
  • Good day, list, We have had several sql issues come up that I am sure a pure Application DBA could tackle readily. In general, what are the recognized "best ways" to code a part of an application ...
    Charles SchultzCharles Schultz
    Oct 30, 2008 at 2:11 pm
    Nov 3, 2008 at 12:32 pm
  • I have 2 8i databases that I need to upgrade that I have inherited. There is 1 master table that is being snaphot refreshed to the second database. It is done by " refresh fast with primary key". No ...
    Joe SmithJoe Smith
    Oct 31, 2008 at 6:42 pm
    Oct 31, 2008 at 7:47 pm
  • Hi I have the following query for an Identity Management Tool: SELECT userobj.ID, NAME, summary FROM userobj WHERE userobj.NAME LIKE 'A%' AND userobj.ID IN ( SELECT ID FROM userattr WHERE ( attr1 IN ...
    AmonteAmonte
    Oct 28, 2008 at 2:57 pm
    Oct 28, 2008 at 6:01 pm
  • Just curious, I just barely passed the Oracle 11g OCP upgrade exam. I found it to be ten-times more difficult than the other upgrade exams (10g, 9i, etc). Did anyone else find it very difficult or am ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    Oct 24, 2008 at 6:10 pm
    Oct 25, 2008 at 5:19 pm
  • Ok, not specifically an oracle issue, but I am not sure where to post this. I am not a network admin. The place I am working does not have a senior one. I can connect to VPN to a remote site. I ...
    Dba DBADba DBA
    Oct 23, 2008 at 7:08 pm
    Oct 25, 2008 at 3:13 pm
  • we have a table has a field define as "varchar2(2000)", we tried to change size from varchar2(2000) TO VARCHAR2(1000). dUE TO SOME RECORDS DATA LARGE THAN 1000. I can use following sql statemnet to ...
    Dba1 mccDba1 mcc
    Oct 21, 2008 at 5:17 pm
    Oct 21, 2008 at 6:21 pm
  • Hi all, V: 10.203 We had a long running process that was running for hours (20 hrs for one qry) and the CPU usage spiked to 100%. We had to kill it. The status is being shown as Killed in V$session ...
    Ram RamanRam Raman
    Oct 14, 2008 at 9:59 pm
    Oct 15, 2008 at 3:03 pm
  • Just curious if anyone is using "Live" (SAN provided) replication of Oracle LUNS to a remote site - or have tried it? Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office ...
    Taylor, Chris DavidTaylor, Chris David
    Oct 13, 2008 at 5:52 pm
    Oct 15, 2008 at 6:55 am
  • Oracle 10.2.0.2 RH Linux AS4 No ASM I just started playing around with Data Guard for the first time this week. For reasons I won't go into that MAY be related to age, I am using DGMGRL instead of ...
    Sweetser, JoeSweetser, Joe
    Oct 10, 2008 at 3:51 pm
    Oct 13, 2008 at 2:56 pm
  • We are on Sun servers and multiple oracle versions with veritas clustering software. Is the a document or website out there explaining veritas as it pertains to oracle? I have looked on metalink and ...
    Joe SmithJoe Smith
    Oct 1, 2008 at 3:50 pm
    Oct 1, 2008 at 6:27 pm
Group Navigation
period‹ prev | Oct 2008 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions149
posts856
users211
websiteoracle.com

211 users for October 2008

Bort, Guillermo: 60 posts Jared Still: 32 posts Niall Litchfield: 28 posts Bradd Piontek: 22 posts Roman Podshivalov: 18 posts Yong Huang: 15 posts Allen, Brandon: 14 posts Bobak, Mark: 14 posts David Ballester: 13 posts Mercadante, Thomas F (LABOR): 12 posts Rich Jesse: 12 posts Goulet, Richard: 11 posts Pete Finnigan: 11 posts Andrew Kerber: 10 posts Baumgartel, Paul: 10 posts Sandra Becker: 10 posts Dan Norris: 9 posts GovindanK: 9 posts Tim Gorman: 9 posts Gints Plivna: 8 posts
show more
Archives