FAQ

Search Discussions

157 discussions - 869 posts

  • Is MOS down repeatedly again for everyone? -- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-l
    Niall LitchfieldNiall Litchfield
    Feb 4, 2010 at 11:35 am
    Feb 24, 2010 at 9:27 am
  • I'm being pulled into a meeting later this morning to answer why we shouldn't put every db in RAC? Any white papers etc, stating why its a bad idea? thanks, joe Joe Testa, Oracle Certified ...
    TESTAJ3_at_nationwide.comTESTAJ3_at_nationwide.com
    Feb 22, 2010 at 12:52 pm
    May 19, 2010 at 10:37 pm
  • Dear listers, I tried to come up with a good name for this post but couldn't. So here goes the story: I have been asked to review a product that management is _very_ keen to deploy in production ...
    Martin BachMartin Bach
    Feb 17, 2010 at 9:20 pm
    Feb 19, 2010 at 2:26 pm
  • Hi all, I would like to know if any of you are using Google Wave<http://wave.google.com , and if so, how. Cheers, Christoph -- http://www.freelists.org/webpage/oracle-l
    ChristophChristoph
    Feb 12, 2010 at 4:30 pm
    Feb 17, 2010 at 4:18 pm
  • Hi Oracle-L, I'm preparing to install ASM using our EVA storage and I'm trying to decide how many volumes to request from my storage manager. There are two configurations we consider: 1) Ask for two ...
    Chen ShapiraChen Shapira
    Feb 21, 2010 at 7:16 pm
    Feb 24, 2010 at 11:01 pm
  • Hi All, A general question: *"If you allowed to keep only one book on Oracle - Which book it will be?"* -- Amit Verma v.amit84_at_skype.com "Winning takes talent but it takes character to keep ...
    AMIT VERMAAMIT VERMA
    Feb 1, 2010 at 5:37 pm
    Feb 8, 2010 at 8:03 am
  • I have a script that we run weekly on our databases. It creates some basic documentation about the database (users, tablespaces, segments, v$parameters, jobs etc.). I was going to update this script ...
    Jay HostetterJay Hostetter
    Feb 25, 2010 at 12:59 pm
    Feb 26, 2010 at 4:20 am
  • That would be my approach. Almost all information you mention is in there (if TIMED_STATISTICS=true): sqlid executions elapsed time (total) cpu time (total) open versions (number of "childs") And you ...
    Toon KoppelaarsToon Koppelaars
    Feb 18, 2010 at 5:11 am
    Feb 20, 2010 at 5:28 pm
  • Hi I need to configure an Oracle database into an active-pasive cluster in linux. As HP Serviceguard isn´t now available for linux I will go with RedHat Cluster but my past experiences with v4 aren´t ...
    Juan Cruz Miranda VigoJuan Cruz Miranda Vigo
    Feb 21, 2010 at 10:21 pm
    Feb 26, 2010 at 8:00 am
  • It gets redirected to http://www-portal-stage.oracle.com/splash/www/index.html, which throws a: Access Denied You don't have permission to access ...
    Rich JesseRich Jesse
    Feb 17, 2010 at 2:46 pm
    Feb 18, 2010 at 9:14 pm
  • Is it just me or is this thing really down more often than not recently (like, this year) Stefan Stefan P Knecht CEO & Founder s_at_10046.ch 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 ...
    Stefan KnechtStefan Knecht
    Feb 15, 2010 at 12:26 pm
    Feb 15, 2010 at 8:02 pm
  • Hi, This is an Oracle support renewal question. We wanted to drop support for a couple of products, but were told that if we did that, the other items purchased in the same order would get bumped to ...
    Thomas RoachThomas Roach
    Feb 8, 2010 at 9:10 pm
    Feb 15, 2010 at 12:06 pm
  • Hi All, I assume some of you have already done SAP projects with Oracle DB. I am currently in involved in one such project where I am responsible for a database side. The SAP consultant has come up ...
    Goran bogdanovicGoran bogdanovic
    Feb 10, 2010 at 12:26 pm
    Feb 11, 2010 at 11:22 am
  • I wouldn't "specifically" avoid Windows on RAC as there are many Win/RAC shops out there. I prefer to run Oracle on *nix platforms just because I am more comfortable and experienced running it there ...
    Thomas RoachThomas Roach
    Feb 22, 2010 at 11:17 pm
    Feb 24, 2010 at 1:02 pm
  • Ok so a co-worker asks a question about an implied database link, i'm like "huh". so a database link is NOT created in the source database but the userid/password are the same in both source and ...
    TESTAJ3_at_nationwide.comTESTAJ3_at_nationwide.com
    Feb 17, 2010 at 8:15 pm
    Feb 19, 2010 at 3:59 pm
  • As I have to rely on what my colleague is stating I can't say 100% - but even if another program (potentially 5 different) would try to write the NUM column - shouldn't the trigger generate a new ...
    A. StiebingA. Stiebing
    Feb 2, 2010 at 4:13 pm
    Feb 8, 2010 at 3:36 am
  • Hi Gurus, I need urgent help. This is oracle 9.2.0.7 on AIX 5.3 The application support persons and business had been complaining of the extremely slow performance for last three days. They could not ...
    Saad KhanSaad Khan
    Feb 4, 2010 at 8:58 pm
    Feb 5, 2010 at 4:27 pm
  • Hi A decision has been made by upper management to use RAC for production environment and nonRAC for dev/test environments. I would prefer to have a parallel environment which is identical to prod ...
    Ram RamanRam Raman
    Feb 2, 2010 at 8:30 pm
    Feb 4, 2010 at 2:44 pm
  • Hi Jared, Yep, you're missing something....and that would be a way to set a string parameter in another session. We're all missing it... :) I've seen this discussed a number of times over the years ...
    Bobak, MarkBobak, Mark
    Feb 26, 2010 at 9:14 pm
    Mar 3, 2010 at 11:36 pm
  • Howdy, Does anyone use both the HTML MOS and Flash MOS? Since I use FF3.6 which doesn't like whatever the Flash MOS is doing, I need to use HTML MOS for now, but my favorites haven't transferred to ...
    Rich JesseRich Jesse
    Feb 16, 2010 at 3:34 pm
    Feb 19, 2010 at 8:48 pm
  • Is there a view or query I can use to show which sessions hold state on which packages? tia Mike -- http://www.freelists.org/webpage/oracle-l
    Michael MooreMichael Moore
    Feb 18, 2010 at 9:27 pm
    Feb 19, 2010 at 8:37 pm
  • Anyone know how the Oracle Client (10.2) passes the DOMAIN portion of the client info to the remote DB server? It appears that my Oracle 10.2.0.1 client (nor 10.2.0.4) are passing the DOMAIN ...
    Taylor, Chris DavidTaylor, Chris David
    Feb 18, 2010 at 5:20 pm
    Feb 18, 2010 at 7:42 pm
  • I'm at a total brain block on this one- Query with a order by that MUST be done in Oracle as the file is an output to a dataset in SAS. The query is through a view and I would prefer to avoid ...
    Kellyn PedersenKellyn Pedersen
    Feb 2, 2010 at 4:57 pm
    Feb 10, 2010 at 4:54 pm
  • Hey Dave, Have you tried a different approach and investigated what is actually in your UNDO tablespace? How much space do you really have available to allocate to the process? It does sound like you ...
    Kellyn PedersenKellyn Pedersen
    Feb 7, 2010 at 3:58 am
    Feb 8, 2010 at 6:58 pm
  • Try taking the cache off the sequence. -- http://www.freelists.org/webpage/oracle-l
    Thomas DayThomas Day
    Feb 2, 2010 at 12:30 pm
    Feb 3, 2010 at 12:37 am
  • For an auditor, I am in a rush to show that auditing of create session has been set up for every user in the database. What is the best query to do this without showing too much other information? ...
    J. DexJ. Dex
    Feb 24, 2010 at 2:27 pm
    Feb 28, 2010 at 12:43 am
  • Hi gurus. I've a production database running on oracle10.2.0.3 at SUSE linux 10. The default DB_BLOCK_SIZE for the database is 4K. There was a performance complain coming from the users and ...
    Saad KhanSaad Khan
    Feb 25, 2010 at 4:23 pm
    Feb 25, 2010 at 7:24 pm
  • Hi We just hit a serious bug in 11gR2 RAC would like to let people know before thinking about deploy this new version. The bug seems to be 8809758 (dont know the bug description and details) and ...
    AmonteAmonte
    Feb 24, 2010 at 6:10 am
    Feb 25, 2010 at 5:09 pm
  • Hi friends: What is the best solution for the following problem: I need to retrieve the max(year) from a column. This table will have around 500.000 lines. And then select all lines of this table ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Feb 16, 2010 at 1:45 pm
    Feb 16, 2010 at 6:03 pm
  • Hi I had to upgrade one of the 8 Node RAC environment and it is running 5 Database with ASM and RDBMS with it own Home in 10.2.0.3 on AIX. We have only 2-3 hrs window and so want to have expert ...
    Sanjay MishraSanjay Mishra
    Feb 14, 2010 at 9:07 pm
    Feb 16, 2010 at 4:05 am
  • Hi List, How do you measure the network traffic going on your RAC interconnect? on the Oracle and OS side... Can you share the efficient tools that you use? I'm trying to figure out (aside from the ...
    Karl AraoKarl Arao
    Feb 10, 2010 at 6:34 pm
    Feb 15, 2010 at 4:54 pm
  • hi, can someone give example for ssh to copy/ftp files with compress across servers. i did find some eg on net scp [-Cr] /some/file [ more ... ] host.name:/destination/file and -C is for compress - ...
    A JoshiA Joshi
    Feb 24, 2010 at 6:38 am
    Feb 26, 2010 at 11:30 am
  • Oracle support just gave me following useful feedback regarding the security issues with oracle/aurora/util/Wrapper and dbms_jvm_exp_perms that I want to share with you. Hi Andre, One of the most ...
    Andre van WinssenAndre van Winssen
    Feb 24, 2010 at 7:23 am
    Feb 25, 2010 at 9:12 pm
  • We've got a 4 node RAC 11gR1 on Linux 4.7 with ASM. We need to bring the latest patches into the OS and I was wondering what the best practice would be. I realize that we could do a rolling patch if ...
    Peter NedeljkovichPeter Nedeljkovich
    Feb 16, 2010 at 1:45 pm
    Feb 17, 2010 at 2:39 pm
  • Hi All, We are using sparc 64bit v 10 with oracle 10.2.0.3. Above that we use SAN storage. How to find if storage is mounted for direct or async io We had set filesystem option to setall. How to ...
    Taral DesaiTaral Desai
    Feb 9, 2010 at 6:44 am
    Feb 15, 2010 at 9:10 am
  • Check out http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits <http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits "SQL*Net message to ...
    kyle Haileykyle Hailey
    Feb 6, 2010 at 8:40 pm
    Feb 8, 2010 at 1:14 pm
  • Dear all, I need help about tha am error ORA-25153: Temporary Tablespace is Empty. I create a new view (using create like by OEM). My programmere run sql for such view and this error returned. I ...
    Alessandro LiaAlessandro Lia
    Feb 5, 2010 at 10:37 am
    Feb 5, 2010 at 11:43 am
  • Listers, We are planning to implement 11.201 RAC on AIX 6.1. Has anyone done this combination recently. Can you share any surprises or observations. Thanks -- http://www.freelists.org/webpage/oracle-l
    Ram RamanRam Raman
    Feb 25, 2010 at 6:00 pm
    Feb 25, 2010 at 9:26 pm
  • Good day, list, The documentation is thoroughly confusing on this point - can you actually install a working ACFS in a Solaris environment? The Grid Infrastructure Install Guide for Solaris talks ...
    Charles SchultzCharles Schultz
    Feb 25, 2010 at 6:17 pm
    Feb 25, 2010 at 8:22 pm
  • Hi, I've got some strange memory related problems on my test environment. Here is my configuration: System memory32GB --oracle sga_max_size24G sga_target 24G pre_page_sgaTRUE pga_aggregate_target4G ...
    Helter SkelterHelter Skelter
    Feb 17, 2010 at 9:26 pm
    Feb 19, 2010 at 7:54 am
  • All - I am refreshing a materialized view and occasionally receive the below error. Should I be looking at the local database rollback segment or the remote databases rollback segment? As I don't ...
    Bill ZakrzewskiBill Zakrzewski
    Feb 16, 2010 at 2:04 pm
    Feb 16, 2010 at 5:27 pm
  • Howdy, Revisiting my post from 2008: http://www.freelists.org/post/oracle-l/Scheduler-jobs-run-as-creator-instead-of-owner ...I found a vague inference to a Scheduler job running as *creator* instead ...
    Rich JesseRich Jesse
    Feb 11, 2010 at 8:20 pm
    Feb 15, 2010 at 11:08 pm
  • My new DBA was given a Windows7 32-bit pc. She has not been able to get an oracle client to install/work for her. She said she saw something that said to ignore the pre-req checks but it didn't ...
    Sandra BeckerSandra Becker
    Feb 8, 2010 at 8:57 pm
    Feb 9, 2010 at 8:10 pm
  • Oracle: 10.1.0.3 OS: Solaris 64 bit We have used utl_smtp for emailing for years. Now all of a sudden on some of our servers, mail is not being sent when we use utl_smtp. Nothing in the datbase has ...
    Dba DBADba DBA
    Feb 24, 2010 at 4:23 pm
    Mar 2, 2010 at 1:33 pm
  • Hello Oracle-l, I need some help with configuring RMAN for Oracle 10gR2. I've been asked to submit a request to have our outsourced DBA's configure our backup to exclude the data in certain ...
    Langston, ChrisLangston, Chris
    Feb 22, 2010 at 7:40 pm
    Feb 23, 2010 at 1:31 pm
  • Hi, I'm involved with the development of a web based application, which will update tables in an 11gR2 database. The proposal is to use a timestamp column which will be checked prior to an update. I ...
    Tony SequeiraTony Sequeira
    Feb 17, 2010 at 9:43 am
    Feb 17, 2010 at 2:40 pm
  • I'm curious as to the reason behind this http://blogs.oracle.com/Support/ -- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-l
    Niall LitchfieldNiall Litchfield
    Feb 12, 2010 at 10:54 pm
    Feb 16, 2010 at 11:39 am
  • Dear all, recently I got performance bottleneck on an audittrail database which hold all the transaction logging of our integration system due to log file sync this db usually high insert volume and ...
    Ujang JaenudinUjang Jaenudin
    Feb 8, 2010 at 12:25 am
    Feb 8, 2010 at 1:15 pm
  • We've just purchased several Oracle products and thus we had to understand the licensing rules. The official document to have this information is the "Oracle® Database Licensing Information 11g ...
    David RobillardDavid Robillard
    Feb 5, 2010 at 4:52 pm
    Feb 5, 2010 at 9:24 pm
  • I am writing an Oracle Security Test plan. One of the controls requires Oracle to stop processing transactions if the Oracle OS Audit files or the sys.aud$ table reaches storage capacity. I cannot ...
    Arnold, SandraArnold, Sandra
    Feb 26, 2010 at 3:43 pm
    Feb 26, 2010 at 4:07 pm
Group Navigation
period‹ prev | Feb 2010 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions157
posts869
users228
websiteoracle.com

228 users for February 2010

Jared Still: 32 posts Kellyn Pedersen: 32 posts Niall.litchfield_at_gmail.com: 25 posts Goulet, Richard: 22 posts Guillermo Alan Bort: 20 posts Rich Jesse: 20 posts Martin Bach: 18 posts Troach_at_gmail.com: 17 posts Karl Arao: 15 posts LS Cheng: 15 posts Mark W. Farnham: 15 posts Taylor, Chris David: 14 posts Greg Rahn: 13 posts Allen, Brandon: 12 posts Harel Safra: 12 posts Yong Huang: 11 posts Adam Musch: 10 posts Bobak, Mark: 10 posts Ozgur Ozdemircili: 10 posts Sanjay Mishra: 10 posts
show more
Archives