FAQ

Search Discussions

182 discussions - 1,142 posts

  • Hi Team, When i am doing the lsnrctl stauts listener_9i it is throwing error like: Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error ...
    Raja raoRaja rao
    Mar 21, 2007 at 8:31 am
    Apr 2, 2007 at 9:09 pm
  • I know this has been discussed here before....I have a small C++ program in a timer loop that spins around looking for the db file scattered read as well as the db file sequential read event and logs ...
    Jherrick_at_igs.netJherrick_at_igs.net
    Mar 13, 2007 at 1:35 pm
    Mar 30, 2007 at 7:30 pm
  • Hi, I was wondering if anyone knows how this tables came about: SQL run 1 select object_name, 2 object_type 3 from all_objects 4 where owner='DAVIDMOSS' 5 order by 6 object_type, 7* object_name ...
    David MossDavid Moss
    Mar 15, 2007 at 2:52 pm
    Mar 27, 2007 at 11:25 am
  • List, If you've upgraded more than one database to 10g, please let me know what method you chose: dbua Manual upgrade Created a 10g database and migrated the data. Either reply to the list or to me ...
    Dennis WilliamsDennis Williams
    Mar 5, 2007 at 5:22 pm
    Mar 23, 2007 at 3:48 pm
  • I spoke to someone I know who has been a dba for 20 years. He is opposed to using incremental backups. This is his rationale. He says that it takes longer to apply incremental backups, plus its one ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Mar 2, 2007 at 8:10 pm
    Aug 28, 2007 at 12:09 am
  • Hi all, Setup Solaris 2.9 8 node RAC on 10.1.0.5 using Veritas SFRAC 4.1 There is a plan to move to ASM from Veritas Clustered file System (not my decision) Is anyone out there using ASM in ...
    Fairlie regoFairlie rego
    Mar 16, 2007 at 12:12 am
    Mar 29, 2007 at 8:03 pm
  • Hi, From the following tkprof output it looks like we are doing lot of fetch calls and also lot of misses during parsing and we have following 2 questions: Which parameter we need to set at ODBC ...
    Harvinder SinghHarvinder Singh
    Mar 1, 2007 at 9:58 pm
    May 16, 2007 at 10:01 pm
  • Oracle 9.2.0.8 on Solaris 8. I've asked development to rewrite Java code that issues SQL with literals so that it uses binds. The new code dynamically constructs an anonymous PL/SQL block with binds, ...
    Baumgartel, PaulBaumgartel, Paul
    Mar 20, 2007 at 4:04 pm
    Mar 23, 2007 at 6:43 am
  • Dear List I have been tasked to produce a list showing the major differences between Oracle and a Progress database. May you please help me with websites, docs and personal research info, and ...
    Blessing kamutandeBlessing kamutande
    Mar 20, 2007 at 9:14 am
    Mar 21, 2007 at 3:56 pm
  • Whilst trying to simplify our restore procedures by using automatic channels to configure RMAN for tape, I have run into the following problem. A simple restore and recover operations fails because ...
    Jared StillJared Still
    Mar 20, 2007 at 8:12 pm
    Jul 30, 2007 at 7:06 pm
  • Hi all, I am looking for ideas how to scale database horizontally as opposed to adding more CPUs, memory and disks on a single machine. Here are the main requirements: We need to store apporx 300 GB ...
    Sandeep DubeySandeep Dubey
    Mar 15, 2007 at 3:38 pm
    Apr 5, 2007 at 1:29 pm
  • Hi I installed Oracle 10.2.0.2 on a Sun Solaris Box 2 weeks ago and I noticed last Monday by running ipcs -a that the shared memory segment arent using the value I have configured, 4GB. I thought I ...
    AmonteAmonte
    Mar 26, 2007 at 7:45 am
    Apr 3, 2007 at 9:18 am
  • I had a problem last night where you could not log into sql plus. Seen this in cases where you bulk collect and do not use a limit clause and suck up too much memory. I noticed alot of sessions open ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Mar 15, 2007 at 1:13 am
    Mar 16, 2007 at 7:02 pm
  • How on earth Oracle source code can be access from out side Oracle network? -- http://www.freelists.org/webpage/oracle-l
    Sinardy XingSinardy Xing
    Mar 23, 2007 at 7:28 am
    Jul 3, 2007 at 6:34 pm
  • Hi List, I know there's already been a lot of discussion about Grid Control lately, but this is a different question that I couldn't find any discussion about on this list or anywhere else out on the ...
    Allen, BrandonAllen, Brandon
    Mar 30, 2007 at 5:52 pm
    Apr 5, 2007 at 4:39 pm
  • Hi List, I need to update large table sub_svc_parm ( over billion rows). This is PL/SQL block that does it: I want to rewrite so it is executed as single SQL update statement. Any suggestions ? ...
    Ranko MosicRanko Mosic
    Mar 12, 2007 at 6:37 pm
    Mar 15, 2007 at 4:52 pm
  • We currently load large amounts of data into a table using sqlldr which is run from a unix script initiated from a java stored procedure. The application designers want to eliminate the script and ...
    John DunnJohn Dunn
    Mar 12, 2007 at 11:52 am
    Mar 12, 2007 at 9:50 pm
  • Folks, If there are statements where FTS on large tables is unavoidable due to the logic in the statements, is there a downside of using PQ to scan those tables? Jonathan has mentioned one caution on ...
    Hameed, AmirHameed, Amir
    Mar 23, 2007 at 2:34 pm
    Apr 6, 2007 at 9:32 pm
  • Is there any faster way to remove histograms other than re-analyzing the table? I want to keep the existing table, index & column stats, but with only 1 bucket (i.e. no histograms). It seems like ...
    Allen, BrandonAllen, Brandon
    Mar 16, 2007 at 5:21 pm
    Mar 27, 2007 at 6:03 pm
  • Hi all, Which of this product do you guys like most: Quest* monitoring and performance tunning or Oracle* EM with the payable packages. (*) Sales personel from both companies are welcome to comment ...
    Sinardy XingSinardy Xing
    Mar 21, 2007 at 2:04 am
    Apr 20, 2007 at 7:50 pm
  • Hi, Does anyone know how to call unix scripts from oracle database? Is it possible........or am i talking something alien..... regards, Edwin.K Looking for earth-friendly autos? Browse Top Cars by ...
    Edwin devadanamEdwin devadanam
    Mar 30, 2007 at 5:51 am
    Mar 30, 2007 at 2:20 pm
  • Greetings, I am attempting to install CRS 10.2.0.1.0 on a two node RAC cluster running RHEL3. I ran the cluvfy and all checks passed. The installation failed at the end indicating that not all tasks ...
    William WagmanWilliam Wagman
    Mar 29, 2007 at 11:40 pm
    Apr 4, 2007 at 11:50 pm
  • don't know if it is good or bad but uncle Larry has gone shopping. rjamya Got RAC? -- http://www.freelists.org/webpage/oracle-l
    RjamyaRjamya
    Mar 1, 2007 at 2:03 pm
    Mar 13, 2007 at 2:53 am
  • We currently allow users to search a large table for a specific indexed value. Performance is fine. However they have now requested to be able to enter a partial string or wildcards. I am asssuming ...
    John DunnJohn Dunn
    Mar 5, 2007 at 10:42 am
    Mar 8, 2007 at 10:32 pm
  • We recently upgraded a dozen or so databases from 9.2.0.(6|7) to 10.2.0.2 + patch 10 on Win32. Now when we execute a 'connect target' in RMAN, it runs very slow - a 'show all' command takes a couple ...
    Rich Holland [oramail]Rich Holland [oramail]
    Mar 2, 2007 at 3:15 pm
    Mar 2, 2007 at 11:02 pm
  • Anyone have any opinion on the book or author for "Forecasting Oracle Performance" by Craig Shallahamer <http://www.amazon.com/exec/obidos/search-handle-url/104-7503377-2103117 ...
    Joel.Patterson_at_crowley.comJoel.Patterson_at_crowley.com
    Mar 29, 2007 at 2:34 pm
    May 8, 2007 at 12:46 pm
  • Am I missing something? I did an import and it didn't import all of the views. There were no errors other than a few compilation errors on other views (which I expected). The process that I used was ...
    J. DexJ. Dex
    Mar 26, 2007 at 9:03 pm
    Mar 28, 2007 at 5:12 pm
  • We are experiencing problems with the database connectivity from the production web servers for the last 2-3 weeks. We are using Oracle RAC in the production and there are 2 database servers. Somehow ...
    Freeman, DonaldFreeman, Donald
    Mar 22, 2007 at 12:55 pm
    Mar 23, 2007 at 4:09 pm
  • Hi All Recently some Oracle Sales came to our company and show us Grid Control. They also mentioned Diagnostics Pack however i am a bit confused about this Pack. It seems like it is made up of ASH, ...
    AmonteAmonte
    Mar 19, 2007 at 11:11 am
    Mar 20, 2007 at 1:42 pm
  • Hi all, We have a huge production database that is currently 2TB and expected to grow to 3TB soon. We have the corresponding test database that is only a third of its size and was refreshed a while ...
    Ram RamanRam Raman
    Mar 16, 2007 at 10:20 pm
    Apr 5, 2007 at 4:22 pm
  • I wonder if anyone has expertise with Cluster in General and has worked with Oracle Clusterware? Does anyone know how CRS behaves in a two node Split Brain situation? For example the master node ...
    AmonteAmonte
    Mar 28, 2007 at 9:07 am
    Apr 3, 2007 at 1:16 pm
  • Hi All, Is there a way of displaying date columns, truncated to half an hours. For example: select trunc(sysdate,'HH') from dual; Regards, Derya. FYI. We are usig this sort of functions in group by ...
    Derya OktayDerya Oktay
    Mar 6, 2007 at 6:16 pm
    Mar 12, 2007 at 11:12 pm
  • All, I had a developer ask me a question today that I missed in our discussion regarding the DST patches. He showed me where: SQL select to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'), 2 ...
    Mercadante, Thomas F \(LABOR\)Mercadante, Thomas F \(LABOR\)
    Mar 22, 2007 at 7:19 pm
    Mar 23, 2007 at 7:08 pm
  • Good afternoon Does anyone has experience on shared tablespace? The situation is we have a common historical data and would like to share it between QA and DEV encivonment. QA and DEV are on the same ...
    Oracle sosOracle sos
    Mar 15, 2007 at 6:43 pm
    Mar 19, 2007 at 7:45 pm
  • Hi Friends, I am having a database with varchar2(255) columns named title, extra_info1,extra_info2,extra_info3 . I want to search all these columns with a search string given to me via a form,I am ...
    Abhishek jainAbhishek jain
    Mar 13, 2007 at 1:51 pm
    Mar 16, 2007 at 5:59 am
  • I have a database which I created it on 9.2.0.1. Recently I upgraded ORACLE software from 9.2.0.1 to 9.2.0.8. I can NOT remember I upgrade that database or not? Does there has way to check database ...
    Dba1 mccDba1 mcc
    Mar 12, 2007 at 3:43 pm
    Mar 13, 2007 at 1:51 am
  • Folks Instance & CRS shutdown both seem to be Hanging for an internal Test 10gR2 RAC Setup. What approach / action should be considered? Will O.S. RE-BOOT of Both the Nodes in the Current State ...
    VIVEK_SHARMAVIVEK_SHARMA
    Mar 5, 2007 at 7:52 pm
    Mar 8, 2007 at 2:08 pm
  • I've spent all morning R'ing the FMs and looking up examples and I still can't get my PL/Sql to handle my user-defined exception. Obviously I'm missing something that is clear as a bell to all the ...
    Thomas DayThomas Day
    Mar 29, 2007 at 5:31 pm
    Apr 3, 2007 at 5:15 pm
  • OVERVIEW: In recent attempts to correlate 10046 extended trace data from Oracle 10.2, with DTrace data collected under Sun Solaris, I discovered that the tim, ela and e fields in Oracle trace data ...
    Andrew ZitelliAndrew Zitelli
    Mar 31, 2007 at 1:38 am
    Apr 3, 2007 at 5:31 am
  • dear all, i have read jk still article about locking, http://www.jlcomp.demon.co.uk/faq/locked_rows.html and now i tried to develop a script to auto kill which lock that have been retained in system ...
    Ujang JaenudinUjang Jaenudin
    Mar 30, 2007 at 4:09 am
    Apr 3, 2007 at 1:36 am
  • Hi all, I've noticed a strange occurence on my database this weekend with archive logs growing much, much larger than my database itself. I'm running 10.2.0.1 on Windows Server 2003. I'm the only one ...
    Bill FergusonBill Ferguson
    Mar 18, 2007 at 12:10 pm
    Mar 31, 2007 at 12:00 am
  • Does anyone has recommendations for good mysql training (instructor led will be fine) for a oracle dba? No time to sit down and experiment and learn by myself. Preferable in the NE region (or ...
    RjamyaRjamya
    Mar 13, 2007 at 5:30 pm
    Mar 14, 2007 at 5:14 pm
  • Just curious about success stories creating installable packages of an Oracle client for installation via LanDesk or other means. We have tried using the Wise Installer, but it seems to choke on the ...
    Jared StillJared Still
    Mar 9, 2007 at 5:21 am
    Mar 12, 2007 at 9:58 pm
  • Hi, ---- Start ---- Config Details: 2 Node 10gR2 RAC HP-UX (PA-RISC) 64 Bit, 11.23 Serviceguard 11.17 ASM used as storage option for database and recovery files. ---- End ---- This 2 node cluster ...
    Naqi MirzaNaqi Mirza
    Mar 7, 2007 at 9:07 am
    Mar 9, 2007 at 6:07 pm
  • All, I've inherited an Oracle Applications/Forms & Reports system here. We need to move it all to a new set of servers. I've been looking within Oracle Portal itself and have one simple question. How ...
    Mercadante, Thomas F \(LABOR\)Mercadante, Thomas F \(LABOR\)
    Mar 1, 2007 at 4:34 pm
    Mar 5, 2007 at 1:52 pm
  • http://news.com.com/Multicore+move+cuts+Oracle+database+cost+-+page+2/2100-1006_3-6163674-2.html?tag=st.num http://www.oracle.com/corporate/pricing/multicore_faq.pdf Interesting. I'm surprised that ...
    Paul DrakePaul Drake
    Mar 2, 2007 at 8:50 pm
    Mar 3, 2007 at 5:19 pm
  • Without a UDF.... I have data that is a number and a formula - one row would look like this: select 2 num, 'X + X' formula from dual The formula has 1 variable only but it can be repeated more than ...
    Brady, MarkBrady, Mark
    Mar 26, 2007 at 9:59 pm
    Apr 25, 2007 at 4:13 pm
  • Hi all, I've scanned this list and other forums but haven't found a satisfying answer so far: I need to pass arguments containing the SQL string delimiter "'" to sqlplus from a shell script, e.g. ...
    Uwe KüchlerUwe Küchler
    Mar 29, 2007 at 10:06 am
    Mar 29, 2007 at 2:35 pm
  • I have got a file that is gzipped. Is it possible to do a database import through a pipe from a .gz file? Does anybody have a script for doing this? I am having a space issue and need to import the ...
    J. DexJ. Dex
    Mar 15, 2007 at 3:19 pm
    Mar 19, 2007 at 4:41 pm
  • I'm new to the AIX world, but seemed to remember I can rename the listener.ora file without bouncing the listener. Does anyone do this? Thoughts? TIA. Dianna G. -- ...
    DIANNA GIBBSDIANNA GIBBS
    Mar 14, 2007 at 5:45 pm
    Mar 15, 2007 at 6:41 am
Group Navigation
period‹ prev | Mar 2007 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions182
posts1,142
users246
websiteoracle.com

246 users for March 2007

Allen, Brandon: 51 posts Jared Still: 44 posts Dennis Williams: 35 posts Kevin Closson: 28 posts Alexander Fatkulin: 27 posts Joel.Patterson_at_crowley.com: 27 posts Niall Litchfield: 20 posts A. Coskan Gundogar: 19 posts GovindanK: 19 posts Ryan_gaffuri_at_comcast.net: 18 posts Alex Gorbachev: 16 posts Baumgartel, Paul: 16 posts Mercadante, Thomas F \(LABOR\): 16 posts Nigel Thomas: 15 posts Bobak, Mark: 14 posts Robert Freeman: 14 posts William Wagman: 14 posts Rjamya: 13 posts Christian Antognini: 12 posts Ghassan Salem: 12 posts
show more
Archives