FAQ

Search Discussions

219 discussions - 1,257 posts

  • I am running single instance Oracle instance with ASM and getting few problems RHAT system crashed and when came back, I tried to start ASM instance I got error Connected to an idle instance. SQL ...
    Sanjay MishraSanjay Mishra
    Nov 6, 2006 at 7:55 pm
    Nov 28, 2006 at 9:37 pm
  • Hi I have to perform a Oracle 10.2.0.2 RAC Installation on Sun Solaris 10, Veritas Storage Foundation for RAC v5.0 will be used and will be installed by some Veritas guy. I havent got previous ...
    AmonteAmonte
    Nov 17, 2006 at 6:39 pm
    Dec 2, 2006 at 10:04 pm
  • Not easily exploited, but still possible. http://www.databasesecurity.com/dbsec/cursor-snarfing.pdf -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- ...
    Jared StillJared Still
    Nov 27, 2006 at 8:43 pm
    Dec 28, 2006 at 3:25 am
  • Hi List, Can I change a user's default schema, so he dose not need to type SCOTT.EMP just EMP? (This user does nothing but queries SCOTT's tables.) I know "Synonyms" can be created to bypass the ...
    Roger XuRoger Xu
    Nov 2, 2006 at 9:04 pm
    Nov 6, 2006 at 8:47 pm
  • �Hi.. Are 2 oracle processor licenses needed to utilize the functionality of dual core processor? Thanks a lot. Sam -- http://www.freelists.org/webpage/oracle-l
    Sam JoseSam Jose
    Nov 21, 2006 at 8:10 am
    Nov 21, 2006 at 11:19 pm
  • Hey all, I've been reading through the Distributed Database Concepts part of the 10gR2 Admin Guide to get a better understanding of how to setup dblink(s), which I've avoided since 7.4 (8.0?) when I ...
    Jesse, RichJesse, Rich
    Nov 21, 2006 at 5:22 pm
    Nov 23, 2006 at 5:52 pm
  • Can I trigger a discussion on the pros and cons of datafile max-size. I am in a shop where the datafile size is limited to 2gb on a 64-bit platform (Raided) and I am trying to weigh the pros and cons ...
    JayDBAJayDBA
    Nov 14, 2006 at 10:57 pm
    Nov 17, 2006 at 3:11 pm
  • We're looking at implementing a new enterprise backup solution. Is anyone using "snapshot technology" to backup your oracle databases? If so, could I get more info - O/S, database version, database ...
    DIANNA GIBBSDIANNA GIBBS
    Nov 8, 2006 at 3:45 pm
    Nov 10, 2006 at 1:04 am
  • Hi, I have found in a schema 3000 tables of the following type: BIN$IU+04Dm/akXgRAADut3aZw==$0 Any idea? Thanks, Ven -- http://www.freelists.org/webpage/oracle-l
    Vnr1995Vnr1995
    Nov 7, 2006 at 4:28 pm
    Nov 8, 2006 at 6:58 pm
  • Hi List!!! I have a question, do you ever have to come that while running a query in 10g you get the following error: select ACUM_PERIODO,con_nombre, ACUM_UNIDADES || ' ' || DESC_UNIDAD desc_unidad, ...
    Crcbedoy_at_proteccion.com.coCrcbedoy_at_proteccion.com.co
    Nov 8, 2006 at 2:25 pm
    Nov 8, 2006 at 4:27 pm
  • Hi list, I need your help on this urgent issue . Each day iam facing a problem, the applicaton is freezing and all my users (150) can not do any thing and you cannot do any new connections, some ...
    Walid alkaakatiWalid alkaakati
    Nov 18, 2006 at 8:19 am
    Nov 28, 2006 at 5:40 pm
  • Unbreakable? http://kevinclosson.wordpress.com/2006/11/02/microsoftnovell-partner-ove r-linux/ Kevin Closson Chief Architect, Oracle Database Solutions PolyServe, Inc kevinc_at_polyserve.com Blogging ...
    Kevin ClossonKevin Closson
    Nov 2, 2006 at 9:46 pm
    Nov 7, 2006 at 12:29 pm
  • Modify Snapshot without drop RH Linux 9.2.0.5 I need to alter my base table (add columns) and thus also the remote db MView referring to it. I don't mind doing some RTFM and I have been on Metalink ...
    Chris MarquezChris Marquez
    Nov 28, 2006 at 5:05 pm
    Nov 30, 2006 at 6:40 pm
  • We are looking into switching from Sparc Solaris to Solaris x86 due to the allure of "cheaper faster" hardware. I'm a little concerned about running our mission critical databases on Solaris x86 ...
    Jim NewmanJim Newman
    Nov 17, 2006 at 12:13 am
    Nov 20, 2006 at 10:37 pm
  • Hi All, My 9.2.0.7 database has an sga size of 1.3 GB and the RAM size is 4096 MB. We were facing a problem of memory contention yesterday due to the increased number of sessions/connections to the ...
    Anurag VermaAnurag Verma
    Nov 29, 2006 at 3:28 am
    Dec 8, 2006 at 1:28 am
  • We had a disk crash. All data files are intact (database was closed at the time). But, all redo log files and controlfiles are lost. Can this database be recovered? This is a development database so ...
    Manjula KrishnanManjula Krishnan
    Nov 30, 2006 at 6:04 pm
    Dec 4, 2006 at 3:38 pm
  • http://www.argeniss.com/woodb.html Dicussion on Slashdot: http://it.slashdot.org/article.pl?sid=06/11/21/1733208&from=rss -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- ...
    Jared StillJared Still
    Nov 21, 2006 at 7:13 pm
    Dec 1, 2006 at 8:54 pm
  • I could no longer wait for Robert Freeman's RMAN book, so I bought Julian Dyke's RAC and Linux book instead. RMAN and new Gopal's book will have to wait until Christmas. I'll let the respected ...
    Mladen GogalaMladen Gogala
    Nov 18, 2006 at 8:03 pm
    Nov 23, 2006 at 10:47 pm
  • Hello all, I've decided to become more intimate with using rman as opposed to cron scripting. So, my first attempt at a test database bombs because of the database not being in ARCHIVELOG mode. I did ...
    Zelli, BrianZelli, Brian
    Nov 6, 2006 at 8:15 pm
    Nov 14, 2006 at 4:42 pm
  • Hello friends, We are thinking of setting up a Standby database for reporting purposes during the business hours and after that apply the pending logs. We are considering various options of multiple ...
    Anurag VermaAnurag Verma
    Nov 3, 2006 at 5:01 pm
    Nov 4, 2006 at 2:55 am
  • Is there any view that contains information about when a particular schema created? Thanks, Ven. -- http://www.freelists.org/webpage/oracle-l
    Vnr1995Vnr1995
    Nov 2, 2006 at 4:36 pm
    Nov 2, 2006 at 5:49 pm
  • Platform is Solaris 10, Oracle 10 I can run sqlplus OK when logged on to Solaris as the oracle user, but if I run sqlplus when logged in as another user I get the error ORA-09925: Unable to create ...
    John DunnJohn Dunn
    Nov 1, 2006 at 11:59 am
    Nov 1, 2006 at 5:46 pm
  • I have three Oracle software in one server 8.06, 817 and 10.2.0.2 and each one is having one instance running on the server. Do I need to run three listener for all three Database separately on 3 ...
    Sanjay MishraSanjay Mishra
    Nov 29, 2006 at 3:23 pm
    Nov 30, 2006 at 10:42 pm
  • Hi all, Oracle version: 9206 I am trying to insert all the rows (~12 million rows) from a small table into a bigger table (~75 million rows). I am testing it with an INSERT INTO big_table SELECT * ...
    Ram RamanRam Raman
    Nov 22, 2006 at 6:28 am
    Nov 26, 2006 at 2:39 pm
  • Hi all, I have a server with 6 Oracle databases running. How do I find out which processes are consuming the CPU? top shows something like this which does not help me: PID USERNAME THR PRI NICE SIZE ...
    Orlando LOrlando L
    Nov 22, 2006 at 2:40 am
    Nov 23, 2006 at 8:06 am
  • Hi, About use of histograms : I think histograms are useful for indexes on columns that are not very selective. However I came across note 1031826.6 on metalink. About maintenance and space cost. I ...
    A JoshiA Joshi
    Nov 19, 2006 at 5:49 pm
    Nov 22, 2006 at 8:41 pm
  • Hi All, Can we move a Oracle 9i (9.2.0.7) database from a Solaris 9(64 bit server) server to an AIX 5.2 (64 bit) server, by using RMAN backup/restore/recovery?? Anurag -- ...
    Anurag VermaAnurag Verma
    Nov 14, 2006 at 4:58 pm
    Nov 15, 2006 at 2:09 pm
  • Hi All, I'm being asked by my security officer that if I can put in control such that a database user can only change password once a day. i.e. the minimum life time of a password should be 1. Any ...
    Michael ChanMichael Chan
    Nov 9, 2006 at 2:28 pm
    Nov 10, 2006 at 1:41 pm
  • I'm trying to compile a list of documentation every database shop should have. Does anyone have any links or suggestions that would help me compile a list of the docs that most shops would need? ...
    David TurnerDavid Turner
    Nov 2, 2006 at 11:50 pm
    Nov 8, 2006 at 2:02 am
  • Hi all Ok, I know this should be easy and I am amazed that I am not getting it right. Client has odd couple of thousand of scripts, Trying to add some stored procedures/package calls with variables ...
    GeorgeGeorge
    Nov 23, 2006 at 4:26 am
    Nov 23, 2006 at 10:20 pm
  • Hi I wonder if any of you use statspack to store a execution plan repository? When run in level 7. Is it worthy? Oracle 9.2.0.8 in HP-UX. TIA Alex -- http://www.freelists.org/webpage/oracle-l
    AmonteAmonte
    Nov 20, 2006 at 2:36 pm
    Nov 22, 2006 at 10:45 pm
  • If I do a query that is doing a hash join. Is the amount of pga/temp space required based entirely on the table that is hashed (smaller) table. Or will more temp space be required for a larger table? ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Nov 14, 2006 at 3:19 pm
    Nov 15, 2006 at 8:03 am
  • Hi folks!!! I would like to know something, I need to export the table data from one instance to another, how can I do so? Thanks:) Isabel Bedoya Gómez Gestión de Tecnología Tel. 2307500 ext: 4077 ...
    Crcbedoy_at_proteccion.com.coCrcbedoy_at_proteccion.com.co
    Nov 1, 2006 at 11:07 pm
    Nov 2, 2006 at 5:22 pm
  • hi: We have a monitoring tool to monitor database performance. It run the following sql every few seconds and it cost a lot of CPU times. About 20% of total CPU time. select kslltnum ...
    Eagle FanEagle Fan
    Nov 30, 2006 at 2:31 am
    Dec 1, 2006 at 3:41 pm
  • Hello I have a question about RMAN and recovery. In my product database I have two files with the same name but other localizations. I use duplication to prepare development environment on other ...
    Wojciech SkrzyneckiWojciech Skrzynecki
    Nov 7, 2006 at 2:29 pm
    Nov 8, 2006 at 2:41 am
  • Just curious. Wondering what the first impressions are. I don't suppose the short-list of beta testers is published, eh? -- Charles Schultz -- http://www.freelists.org/webpage/oracle-l
    Charles SchultzCharles Schultz
    Nov 1, 2006 at 6:58 pm
    Nov 7, 2006 at 10:04 pm
  • Here is my data: drop table zzz; create table zzz (id varchar2 (1), value number (3)); insert into zzz (id, value) select 'j', 30 from dual union all select 'c', 30 from dual union all select 'x', 10 ...
    Jacques KilchoerJacques Kilchoer
    Nov 30, 2006 at 7:03 pm
    Dec 1, 2006 at 2:59 am
  • Curious, is there a good resource to "unabiguify" kernel stub names? Granted, they are undocumented because Oracle does not want anyone to hack their software, but surely somebody knows what all ...
    Charles SchultzCharles Schultz
    Nov 28, 2006 at 11:51 pm
    Nov 30, 2006 at 3:18 pm
  • Hi As mentioned a few days ago I am installing a RAC with Verits SFRAC on Solaris 10. I have to create 2 databases to for this RAC implementation. Both will share a single Gigabit connection (using ...
    AmonteAmonte
    Nov 23, 2006 at 11:00 pm
    Nov 25, 2006 at 3:16 am
  • We're facing a weird issue with 10.2.0.2 which did not exist in 10.1 and before. We've disabled the standard stats gatherign job since it is generating histograms which doesnt work well with the ...
    Fuad ArshadFuad Arshad
    Nov 17, 2006 at 3:21 pm
    Nov 18, 2006 at 9:22 am
  • Folks As part of a 2 node RAC performance benchmark, DB Server nodes are choking at 100% CPU Usage, when 3000 dedicated server sessions are doing OLTP transactions Config:- DB Servers - 2 RAC Nodes - ...
    VIVEK_SHARMAVIVEK_SHARMA
    Nov 16, 2006 at 9:21 am
    Nov 17, 2006 at 4:26 am
  • Hi (oracle 10.2.0.1, OS RH 4, x86_64, storage ASM, 2 nodes) On our testsystem they just recently tried an shutdown abort and after that nothing works. When I try to start the instance on nod 1 I will ...
    Johan ErikssonJohan Eriksson
    Nov 13, 2006 at 3:19 pm
    Nov 13, 2006 at 6:20 pm
  • Just wondering if it was all hype, or are their folks out there who enjoy and/or value this publication? I have not yet looked at it. -- Charles Schultz -- http://www.freelists.org/webpage/oracle-l
    Charles SchultzCharles Schultz
    Nov 8, 2006 at 4:43 pm
    Nov 10, 2006 at 5:18 am
  • Hi All, Slow Streams Performance. I want to reduce the time for the changes to be reflected in target site sooner. WITHOUT USING STREAMS Site A : I execute a particular transaction and it takes 3 ...
    Thotangare, Ajay \(GTI\)Thotangare, Ajay \(GTI\)
    Nov 2, 2006 at 5:03 pm
    Nov 6, 2006 at 7:39 pm
  • So, here I am sitting in a developer's class for our new ERP package, and I decided to monitor the 10.2.0.2.0 DB on AIX 5.3 that all the dev's individual JBoss servers are hammering. The first thing ...
    Jesse, RichJesse, Rich
    Nov 28, 2006 at 8:59 pm
    Dec 5, 2006 at 6:21 pm
  • Hi Anyone know a trick which can invalidate a cursor execution plan? I know if you run any DDL against a tabble we can invalidate the execution plans related to the table but that affects many ...
    LS ChengLS Cheng
    Nov 30, 2006 at 1:30 pm
    Nov 30, 2006 at 4:34 pm
  • I just started looking into the Day Light savings changes that will need to occur in Oracle before April. Both databases and clients will need to be changed if they are v9.x and especially 10.x. I ...
    Pass, StephaniePass, Stephanie
    Nov 21, 2006 at 12:16 am
    Nov 30, 2006 at 12:36 am
  • Hi all, Ora9205 AIX 5.3 We have set up DataGuard in the Max Performance mode. (SERVICE=DG_STY LGWR ASYNC=20480 OPTIONAL REOPEN=30 NOAFFIRM NET_TIMEOUT=60) The standby is about 2000 Kms away and ...
    Sanjay MadanSanjay Madan
    Nov 23, 2006 at 7:02 am
    Nov 29, 2006 at 9:18 pm
  • Is there a way to find the trending growth (next increment) difference between a defined list of values ie 1, 2, 3, 4, 5 -- the next increment would be 1 5,4,3,2,1 -- the next increment would be -1 ...
    BobBob
    Nov 29, 2006 at 2:17 pm
    Nov 29, 2006 at 4:37 pm
  • Hi, i pinned a few SYS packages (DBMS_SHARED_POOL.KEEP) in my 10.2.0.1.0database (AIX 5.3). When i was looking at V$DB_OBJECT_CACHE, i found the following: SQL select ...
    Anand RaoAnand Rao
    Nov 21, 2006 at 7:29 am
    Nov 22, 2006 at 1:03 pm
Group Navigation
period‹ prev | Nov 2006 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions219
posts1,257
users238
websiteoracle.com

238 users for November 2006

Jared Still: 59 posts Alex Gorbachev: 56 posts Kevin Closson: 37 posts Jesse, Rich: 32 posts Wolfgang Breitling: 31 posts Rjamya: 27 posts Dennis Williams: 26 posts LS Cheng: 25 posts Sanjay Mishra: 22 posts David Sharples: 21 posts Goran bogdanovic: 19 posts Ken Naim: 19 posts Mladen Gogala: 19 posts Niall Litchfield: 19 posts Bob: 18 posts Bobak, Mark: 18 posts Mercadante, Thomas F \(LABOR\): 16 posts Norman Dunbar: 16 posts VIVEK_SHARMA: 16 posts Juan Carlos Reyes Pacheco: 15 posts
show more
Archives