FAQ

Oracle > oracle-l > October 2006

Search Discussions

241 discussions - 1,179 posts

  • Let us suppose that I were to be writing a PL/SQL package that will be installed on a variety of databases in my company, and not all the databases are at the same version or patch level (but all are ...
    Jacques KilchoerJacques Kilchoer
    Oct 16, 2006 at 8:28 pm
    Oct 19, 2006 at 9:12 pm
  • This is only a thought, Talking previously with other dbas, if there would be other certifications on oracle, could be a way to help recruiters to find the better dba, and a way to hundreds of dba to ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Oct 6, 2006 at 2:10 pm
    Oct 17, 2006 at 8:07 pm
  • Hi, Â Â Â Â For efficient use of shared pool and SGA : On 9i : I assume it is beneficial to keep objects and sql in sga. Or is it not needed on 9i? I think parameter CURSOR SHARING can be set to ...
    A JoshiA Joshi
    Oct 20, 2006 at 8:20 pm
    Nov 13, 2006 at 8:20 pm
  • Hi all I have a question about RAC. I have implemented a few RAC on a couple of customers. I have always worked with two nodes and a single database, i.e 2 servers and a common database in a shared ...
    AmonteAmonte
    Oct 30, 2006 at 6:24 pm
    Nov 1, 2006 at 4:09 pm
  • hi, I am trying to uncover the root cause of log file sync waits causing an application to decrease in performance. 10046 trace shows hundreds of thousands of lines of log file sync with ela time ...
    Oracle_at_digistar.comOracle_at_digistar.com
    Oct 10, 2006 at 7:13 pm
    Oct 16, 2006 at 4:10 pm
  • Oracle Announces The Same Enterprise Class Support For Linux As For Its Database http://www.oracle.com/corporate/press/2006_oct/Oracle-Linux-Program.html "This announcement is provided to you solely ...
    Paul DrakePaul Drake
    Oct 25, 2006 at 10:30 pm
    Oct 26, 2006 at 7:24 pm
  • I am sure many of you, like me, have been befuddled when Oracle refuses to answer a question because of "proprietary information". Has anyone had any luck in arguing, convincing, persuading, bribing ...
    Charles SchultzCharles Schultz
    Oct 3, 2006 at 1:58 pm
    Oct 4, 2006 at 2:12 am
  • Hi, We are getting following error while running the following query: SELECT accmap.id_acc as id_acc, av.c_firstname as firstname, av.c_lastname as lastname, av.c_middleinitial as middleinitial, ...
    Harvinder SinghHarvinder Singh
    Oct 2, 2006 at 2:41 pm
    Oct 3, 2006 at 3:36 pm
  • My boss believes that if Oracle can't come down in price to that of SQL Server, we should just switch. I have never used SQL Server so I had nothing to draw on other than what I've heard. We're a ...
    Sandra BeckerSandra Becker
    Oct 1, 2006 at 5:34 pm
    Oct 2, 2006 at 4:14 pm
  • Two days ago my SQL*Developer told me that there is an update available on Metalink. I downloaded the update and ever since my SQL*Developer is reporting the following ...
    Mladen GogalaMladen Gogala
    Oct 21, 2006 at 8:07 pm
    Oct 23, 2006 at 2:29 pm
  • I've copied the example from the SQL Reference 9.2 CREATE MATERIALIZED VIEW LOG ON sales WITH ROWID, SEQUENCE(amount_sold, time_id, prod_id) INCLUDNG NEW VALUES; But when I run it on our AIX, oracle ...
    Thomas DayThomas Day
    Oct 9, 2006 at 2:32 pm
    Oct 16, 2006 at 1:18 am
  • Does anybody know how to reset s$sesstat, v$sysstat and v$sql without restarting the database? -- Mladen Gogala http://www.mladen-gogala.com -- http://www.freelists.org/webpage/oracle-l
    Mladen GogalaMladen Gogala
    Oct 11, 2006 at 1:01 am
    Oct 11, 2006 at 11:29 am
  • Does anyone have a fairly accurate method for determining how much memory is actually being used on a Linux box? The linux in question is RedHat Enterprise Server 4. Before dashing off a reply to use ...
    Jared StillJared Still
    Oct 2, 2006 at 7:47 pm
    Oct 4, 2006 at 5:18 pm
  • Hi, I'm running a 10gR2 (10.2.0.2) 64-bit RAC cluster, three nodes on DL-585s (configured w/ 4 dual core CPUs and 32GB of RAM). I've been doing some fairly large-scale load testing, pointing our ...
    Bobak, MarkBobak, Mark
    Oct 31, 2006 at 4:58 pm
    Nov 2, 2006 at 12:48 am
  • Hi I was wondering if anyone know what does cas latch do? I know is a shared latch but not sure for what part of SGA? Thanks -- http://www.freelists.org/webpage/oracle-l
    LS ChengLS Cheng
    Oct 30, 2006 at 4:43 pm
    Nov 1, 2006 at 11:06 am
  • Folks Puzzle 1 - For a Banking Application, for certain V.I.P. Accounts (translating to respective rows in a set of Tables), the general Staff should NOT be able to View the respective Account info ...
    VIVEK_SHARMAVIVEK_SHARMA
    Oct 16, 2006 at 10:33 am
    Oct 16, 2006 at 8:06 pm
  • I just was asked about converting some MySQL databases to Oracle. I personally have never seen MySQL so I have no idea where to start with. Has anyone else done this? Can it be done? Can anyone point ...
    LeRoy KemnitzLeRoy Kemnitz
    Oct 9, 2006 at 3:42 pm
    Oct 10, 2006 at 11:18 am
  • Hi! I'm running the below query in PROD(10g R1) and ACPT(10g R2). the query returns in fraction of a second in PROD and, If I run the same query in ACPT, it's taking 30+ mins. In Prod S5UVAD@powls01 ...
    Sarma AryasomayajulaSarma Aryasomayajula
    Oct 6, 2006 at 3:10 pm
    Oct 6, 2006 at 5:06 pm
  • Hello Everybody I would like ask you to about explain plan. I am looking for the best script to see explain plan. I know that it is possible to see explain plan for active session of other users. I ...
    Wojciech SkrzyneckiWojciech Skrzynecki
    Oct 5, 2006 at 9:04 pm
    Oct 6, 2006 at 6:31 am
  • Hey all, We're well on our way to implementing a new ERP system in 10.2.0.2.0 on AIX 5.3. One thing I've noticed is that while the redo logs are ~50MB, the archived redo logs from "regular" log ...
    Jesse, RichJesse, Rich
    Oct 31, 2006 at 7:49 pm
    Nov 1, 2006 at 4:58 pm
  • Hi List, I remember in the past someone shared a script which dumps tables to CSV files. If anybody has it and is willing to share, I do not have to write it myself. Thanks, Laziest DBA in the world ...
    Roger XuRoger Xu
    Oct 19, 2006 at 4:35 pm
    Oct 19, 2006 at 11:21 pm
  • Hi Suppose we have 4 datafiles in a tablespace, when we load data into this tablespace how will Oracle assign the space? I thought it would use round-robin like but it does not. Before load I had ...
    AmonteAmonte
    Oct 6, 2006 at 8:52 am
    Oct 6, 2006 at 11:41 am
  • For all those on Linux and Oracle ... Around how much did it cost getting Oracle (with Partitioning) Enterprise Solution running on RH 2 cpu system? I was under the impression the support cost was ...
    Laura penaLaura pena
    Oct 26, 2006 at 2:58 pm
    Oct 30, 2006 at 8:38 pm
  • Greetings, Yes, one of the APP still uses RBO, we are pushing the Vender to test the app in CBO. The DB is: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production PL/SQL Release 9.2.0.4.0 - ...
    BNBN
    Oct 30, 2006 at 6:52 pm
    Nov 2, 2006 at 9:41 pm
  • Hi, Presentations were posted on Oracle's web site last year, if I remember correctly. Can't find URL now. Is it too early, or you have to buy CD/DVD ? -- Regards, Ranko Mosic Contract Senior Oracle ...
    Ranko MosicRanko Mosic
    Oct 29, 2006 at 7:49 pm
    Nov 2, 2006 at 2:28 am
  • hi guys, i am confused by "Resource" role, follow my operations SQL select * from v$version; BANNER Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - ...
    ?? ??? ?
    Oct 31, 2006 at 1:08 pm
    Nov 1, 2006 at 2:53 pm
  • I almost hate to ask, but here goes... Adding a second instance to VMS RAC. It was not previously configured as RAC. After issueing the startup command, the error returned is "ORA-00061: another ...
    John D ParkerJohn D Parker
    Oct 17, 2006 at 9:07 pm
    Oct 20, 2006 at 2:49 pm
  • I just wanted to share some information with this list on a corruption scenario that I have recently experienced in my lab environment. I recently upgraded an Oracle applications 11.5.9 database from ...
    Hameed, AmirHameed, Amir
    Oct 6, 2006 at 12:40 pm
    Oct 10, 2006 at 1:12 pm
  • Hi In our RAC environment (oracle 10.2 on linux, storage is in ASM, 2 node cluster) I should add a second diskgroup so that we could run some bigger tests but instead of creating a new diskgroup I ...
    Johan ErikssonJohan Eriksson
    Oct 5, 2006 at 8:45 am
    Oct 9, 2006 at 8:19 am
  • Hi, In our application we array insert about 1000-10k rows into staging tables and then insert into application tables from this staging tables and then truncate this staging tables. All of this is ...
    Harvinder SinghHarvinder Singh
    Oct 17, 2006 at 2:34 pm
    Nov 6, 2006 at 2:56 am
  • Critical Patch Updates and Security Alerts http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpuoct2006.html metalink note ...
    Paul DrakePaul Drake
    Oct 17, 2006 at 8:05 pm
    Oct 30, 2006 at 5:34 pm
  • I just had an interesting and disturbing discussion with damagement and wanted to run this by the DBA Gods that read this list. We are planning to migrate out production environment from Oracle 8i ...
    Rick WeissRick Weiss
    Oct 26, 2006 at 5:13 am
    Oct 27, 2006 at 10:57 pm
  • All, I am having some problems with a union all view. During my debugging, I commented out either the top or bottom part of the union all, and my queries run in a second or two. When I keep both ...
    Steiner, RandySteiner, Randy
    Oct 25, 2006 at 6:31 pm
    Oct 26, 2006 at 10:29 pm
  • folks, I am in need of an urgent help. I am trying to find out how to identify what processes are using certain devices. Our iostat shows high average service times on some SD devices. Our Unix folks ...
    Hameed, AmirHameed, Amir
    Oct 19, 2006 at 1:09 pm
    Oct 19, 2006 at 5:43 pm
  • hello again, I don't have any real-world experience with RMAN but I'm contending w/ the DBA who says running backups through RMAN, **every day**, for 10 hours, does not impact our production ...
    Cosmin ioanCosmin ioan
    Oct 18, 2006 at 3:40 pm
    Oct 18, 2006 at 6:59 pm
  • http://www.anysql.net/aul/aulkey.cgi -- Welcome! Home: http://www.AnySQL.net/en -- http://www.freelists.org/webpage/oracle-l
    Lou FangxinLou Fangxin
    Oct 11, 2006 at 12:06 pm
    Oct 17, 2006 at 2:52 pm
  • I have one application in production where several Procedure become invalid at the same time. Can somebody suggest as how I can check as why all become invalid. Currently I am running utlrp every 5 ...
    Sanjay MishraSanjay Mishra
    Oct 11, 2006 at 11:15 pm
    Oct 12, 2006 at 5:14 am
  • Thanks to Christopher Boyle and AskTom for the Type and function. Here's what I ended up with after creating them. set heading off set feedback off set linesize 32000 set pagesize 0 Spool ...
    Rodd HolmanRodd Holman
    Oct 5, 2006 at 9:35 pm
    Oct 10, 2006 at 7:15 pm
  • Hi, I am testing failover but getting ORA-1666 error. Am I missing something here? Thanks, Roger SQL alter database recover managed standby database finish; Database altered. SQL alter database ...
    Roger XuRoger Xu
    Oct 9, 2006 at 7:54 pm
    Oct 10, 2006 at 12:47 pm
  • OK, I've been searching the docs (docs.oracle.com) and trying to figure out how to make this work from sqlplusw.exe. I'll let it be known from the first that I despise Windows and hate working in ...
    Rodd HolmanRodd Holman
    Oct 5, 2006 at 5:44 pm
    Oct 6, 2006 at 7:37 am
  • Hi All, If some db option is installed and not used, according to your experience, is this illegal? Thanks. lale -- http://www.freelists.org/webpage/oracle-l
    Lale obradovicLale obradovic
    Oct 31, 2006 at 11:59 am
    Nov 4, 2006 at 11:36 pm
  • Hi All, I just have a question about tracing a session. Using sys.dbms_system.set_ev(&sid, &serial, 10046, 12, '') Hypothetically speaking: If we start a trace with sys.dbms_system.set_ev(&sid, ...
    Oliver JostOliver Jost
    Oct 27, 2006 at 9:05 pm
    Oct 31, 2006 at 2:08 am
  • Hello. I could not find a way to list the disk or disk partition underlying the disk group in any of the ASM views. Can you help me? Thanks, Shiva -- http://www.freelists.org/webpage/oracle-l
    Shivaswamy RaghunathShivaswamy Raghunath
    Oct 30, 2006 at 12:29 am
    Oct 30, 2006 at 5:50 pm
  • Appears to be down for me. Perhaps it's all the Linux people pointing up2date at it to get the world-renowned support. -- Niall Litchfield Oracle DBA http://www.orawin.info -- ...
    Niall LitchfieldNiall Litchfield
    Oct 30, 2006 at 9:32 am
    Oct 30, 2006 at 3:19 pm
  • Red Hat responded to Oracle's announcement: http://www.redhat.com/promo/unfakeable/ I like the wordplay with "unfakeable", but there are some idiotic statements in the article: "Q: Does Oracle's ...
    Mladen GogalaMladen Gogala
    Oct 27, 2006 at 5:13 am
    Oct 30, 2006 at 10:13 am
  • The company that I work for is looking for another DBA. Job is in NYC. If anybody is interested or if you know of somebody interested, please ask them to forward their resume to me. The sooner you ...
    Mladen GogalaMladen Gogala
    Oct 25, 2006 at 1:48 am
    Oct 26, 2006 at 10:10 pm
  • I'm creating bitmapped indexes on a non-partitioned table. If I add "parallel" to the mix of options I get an end-of-channel and the database takes a core dump. If I'm creating local bitmapped ...
    Thomas DayThomas Day
    Oct 25, 2006 at 4:05 pm
    Oct 26, 2006 at 6:54 am
  • Folks Can Missing Tempfiles be Simply ADDED with the SAME NAME after eXtract of FULL Database Cold Backup? NOTE - Realised that a few Tempfiles were Missing after a FEW Days of Database being UP. If ...
    VIVEK_SHARMAVIVEK_SHARMA
    Oct 25, 2006 at 12:04 pm
    Oct 25, 2006 at 6:45 pm
  • Our third-party version control software uses an Oracle database as its repository. Documents are stored in a BLOB column in an Oracle table. It is NOT stored "in_row" and logging is turned off (for ...
    Sam BootsmaSam Bootsma
    Oct 23, 2006 at 6:46 pm
    Oct 24, 2006 at 6:22 pm
  • Listed below is a sample of some horrific SQL. As you can see it joins multiple tables together (large ones) 67 times only to add a literal (the county number) to a specific field each time. I know ...
    Paula StankusPaula Stankus
    Oct 19, 2006 at 1:51 pm
    Oct 19, 2006 at 9:50 pm
Oct 2006
12345
Group Navigation
period‹ prev | Oct 2006 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions241
posts1,179
users231
websiteoracle.com

231 users for October 2006

Niall Litchfield: 37 posts Mladen Gogala: 30 posts Jared Still: 28 posts Kevin Closson: 28 posts Allen, Brandon: 27 posts David Sharples: 27 posts Polarski, Bernard: 27 posts Stefan Knecht: 25 posts Rjamya: 22 posts Bobak, Mark: 21 posts Dennis Williams: 21 posts Jesse, Rich: 20 posts Jonathan Lewis: 20 posts Alex Gorbachev: 19 posts Mark W. Farnham: 19 posts Richard J. Goulet: 19 posts Juan Carlos Reyes Pacheco: 18 posts VIVEK_SHARMA: 18 posts Cosmin ioan: 15 posts Mercadante, Thomas F \(LABOR\): 15 posts
show more
Archives