FAQ

Oracle > oracle-l > May 2006

Search Discussions

251 discussions - 1,385 posts

  • Keywords: Mary Ann Davidson, CNET, Oracle Chief Security Officer, security researcher, security holes, security fixes, security patches Reference ...
    Schultz, CharlesSchultz, Charles
    May 30, 2006 at 1:18 pm
    Jun 7, 2006 at 2:12 am
  • Hi all, contraindications in this respect? Examples/situations when this approach may not be appropriate? Thanks, Dimitre -- http://www.freelists.org/webpage/oracle-l
    Radoulov, DimitreRadoulov, Dimitre
    May 2, 2006 at 11:03 am
    May 10, 2006 at 12:37 am
  • Hi, Having been forewarned, I logged into MetaLink this morning, confirmed my email address to use as the login name and got an automatic email basic with the new initial password. But ever since it ...
    Peter HitchmanPeter Hitchman
    May 22, 2006 at 11:02 am
    May 23, 2006 at 5:39 am
  • Hello All, We are planning on testing a two node 10g RAC using ASM for one of our database on pSeries using AIX 5.3. We have a primary requirement of mirroring data across TWO data centers (Hitachi ...
    Madhu VMadhu V
    May 18, 2006 at 6:00 pm
    May 22, 2006 at 4:30 pm
  • Sql Gurus I need to create the sql script that can display all tables from user_tables in one line seperated by ",". Is there any straighforward SQL that can display the result in Horizontal instead ...
    Sanjay MishraSanjay Mishra
    May 4, 2006 at 6:11 pm
    Jul 16, 2006 at 1:52 pm
  • Hi List, Just thinking aloud - when ASM crashes then all instances connected to it crash too. This can't be good, right ? -- Regards, Ranko Mosic Contract Senior Oracle DBA B. Eng, Oracle 10g, 9i ...
    Ranko MosicRanko Mosic
    May 7, 2006 at 6:53 pm
    May 10, 2006 at 10:02 am
  • Folks, Before I go off re-inventing the wheel, and yes I still have to scan AskTom, but here's by "problem". I've a developer who has calculated the elapsed time of some database action, whatever it ...
    Goulet, DickGoulet, Dick
    May 19, 2006 at 5:11 pm
    May 21, 2006 at 8:08 am
  • We set up a side by side comparison to test our Oracle DB application on Windows 2003 32 Bit vs. Red Hat Linux. We set up two virtual partitions and alternately stopped one and tested the other. We ...
    Freeman, DonaldFreeman, Donald
    May 18, 2006 at 6:46 pm
    May 23, 2006 at 5:17 pm
  • Thanks Nigel Communications on or through ioko's computer systems may be monitored or recorded to secure effective system operation and for other lawful purposes. Unless otherwise agreed expressly in ...
    Nigel BishopNigel Bishop
    May 2, 2006 at 12:26 pm
    May 11, 2006 at 6:16 am
  • Each and every minor change or enhancement to Metalink that I can recall since it was first introduced in 1998 or so has resulted in massive loss of service. Most notable was "2.0" which tipped over ...
    Jeremiah WiltonJeremiah Wilton
    May 23, 2006 at 3:21 pm
    May 30, 2006 at 5:39 pm
  • Dear All I am struggling to get any sort of acceptable performance from our storage array. It's a low end SATA RAID-5 (NOT my choice!) so I'd expect performance to be poor but it's much worse than ...
    Charlotte HammondCharlotte Hammond
    May 23, 2006 at 4:53 pm
    Jun 4, 2006 at 12:37 pm
  • In J Lewis's new book "Cost Based Oracle..." in his example initd10g.ora he has this line: *.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))' what is the advantage ...
    Joe SmithJoe Smith
    May 23, 2006 at 6:43 pm
    May 26, 2006 at 1:20 am
  • Question for opinion: Is overall control, installation, administration and configuration of Oracle Application Server a: DBA Task OS Management Task Development Task End User Admin Task Replies ...
    Michael FontanaMichael Fontana
    May 23, 2006 at 1:16 pm
    May 24, 2006 at 7:20 pm
  • Hi All, Is there a way to load data from an Excel sheet into an Oracle table using SQL*Loader? I know there must be. Please, can anyone help me out how this can be achieved. Thanks in advance ...
    Vikram singhVikram singh
    May 17, 2006 at 2:12 pm
    May 20, 2006 at 12:05 am
  • I'm testing a Sun T2000 Solaris 10 Oracle 10g and have read that if floating point calculations are used then the box is essentially a 1 cpu box. I'm just wondering what this means from the Oracle ...
    Michael McMullenMichael McMullen
    May 5, 2006 at 3:21 pm
    May 8, 2006 at 9:05 pm
  • Hi, We use RMAN to take backup of the database. Once we had problem to restore the backup, so we want to validate backups once they are taken. I came to know about following options. RESTORE VALIDATE ...
    Yadavalli AdityaYadavalli Aditya
    May 25, 2006 at 1:06 am
    Jun 8, 2006 at 4:19 pm
  • Does anyone know who is behind quickdba.blogspot.com? I am rather dismayed to find one of my own articles running as a blog entry there, and with no attribution. I would like to sort out why that is ...
    Jonathan GennickJonathan Gennick
    May 29, 2006 at 3:08 pm
    Jun 1, 2006 at 10:31 am
  • 10.2.0.2 trashes the permissions. Why do they keep doing this? Subject: Wrong File Protection After Installation Of 10.2.0.2 Note:363721.1 -- http://www.freelists.org/webpage/oracle-l
    Ray StellRay Stell
    May 23, 2006 at 2:25 am
    May 25, 2006 at 3:16 pm
  • An export I've been doing monthly for years just stopped using an index and is taking forever to complete. I couldn't find any reference to HINTs in the documentation but I was hoping I just missed ...
    JayMiller_at_TDWaterhouse.comJayMiller_at_TDWaterhouse.com
    May 26, 2006 at 7:01 pm
    May 27, 2006 at 12:11 am
  • Hi List, SELECT * 2 FROM tab1 t1, 3 tab2 t2, 4 tab3 t3 5 WHERE t1.id = t2.id 6 AND t2.id = t3.id 7 AND t1.type IN 8 ('A','B','C') 9 AND t3.type = 'A' 10* AND t3.start_date = '01-APR-2004' All join ...
    Ranko MosicRanko Mosic
    May 16, 2006 at 8:35 pm
    May 19, 2006 at 8:05 pm
  • Anyone familiar with using adb or mdb to attach to Unix (Solaris) processes? I am working with Oracle Support, but the guy behind the curtain (the developer) is in England, and it is hard to ...
    Schultz, CharlesSchultz, Charles
    May 4, 2006 at 1:39 pm
    May 8, 2006 at 5:52 pm
  • I am stress testing an application that performs massive inserts (logs tons of data) into Oracle tables using direct path insert. Multiple tables are used to provide scalability (each log source ...
    Luca CanaliLuca Canali
    May 31, 2006 at 8:23 pm
    Jun 2, 2006 at 2:54 pm
  • Folks For a Big Benchmark should SAME (Stripe Across ALL Disks) setup of a "DS8300" storage box be considered or NOT? Storage has 47 LUNs Each LUN has 8 Disks (Hardware RAID 1+0) Qs. Should the 2nd ...
    VIVEK_SHARMAVIVEK_SHARMA
    May 10, 2006 at 5:45 pm
    May 15, 2006 at 7:17 pm
  • Is anybody else having trouble with these patches? We've tried them twice on two different servers and the each install fails with different errors. We've opened up a ticket but aren't making much ...
    Freeman, DonaldFreeman, Donald
    May 11, 2006 at 7:46 pm
    May 12, 2006 at 1:24 pm
  • In the middle of researching for a colleague, but thought I'd check here too. Database 9.2.0.4.0 OS HP-UX B11.00 Wanted to restore database to 9:15am server time this morning (5/10/06). Last hot ...
    Sweetser, JoeSweetser, Joe
    May 10, 2006 at 8:16 pm
    May 12, 2006 at 5:00 am
  • Got a couple of clients who had us install 10G on some servers where some have DBs and some don't. The installers activated the 10G listener (because we always use highest version) and we got 1000s ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    May 24, 2006 at 4:26 pm
    May 26, 2006 at 12:53 pm
  • Hello, Does anybody know how to find out to which destination an archiver process is currently archiving to? (other than alert.log) Thanks Vadim -- http://www.freelists.org/webpage/oracle-l
    Vadim BobrovVadim Bobrov
    May 19, 2006 at 12:02 pm
    May 21, 2006 at 5:13 pm
  • Hi all, I'm trying to solve an ora-4020 (deadlock) issue; the trace file (sorry if messed) shows: ksqded1: deadlock detected via did DEADLOCK DETECTED Current SQL statement for this session: Update ...
    Alessandro VercelliAlessandro Vercelli
    May 8, 2006 at 5:33 pm
    May 10, 2006 at 1:56 pm
  • In light of Jared's highly informative presention on why we should normalize for performance (Hotsos 2006) I was struck by this statement ...
    Ethan PostEthan Post
    May 4, 2006 at 7:09 pm
    Jul 10, 2006 at 5:03 pm
  • Hi Folks, Would appreciate some help/guidance with an issue I've noticed with the dbv utility on Windows 2000 server. I'm using this utility as part of an offline backup process. For some reason the ...
    SeánSeán
    May 30, 2006 at 10:08 am
    Jun 6, 2006 at 3:46 am
  • Is there any view that lists the name of function/procedure AND IT'S TYPE (function or procedure) in a package? The following query only lists name, but I want the type too. SQL select distinct ...
    Guang MeiGuang Mei
    May 31, 2006 at 7:34 pm
    Jun 1, 2006 at 3:19 am
  • This weekend we upgraded from 8.1.7.4 32-bit to 10.1.0.5 64-bit (AIX 5.2) and we are experiencing a large number of 4031 errors(these were extremely rare under 8). We have contacted Oracle support as ...
    Tracy RahmlowTracy Rahmlow
    May 8, 2006 at 6:28 pm
    May 26, 2006 at 4:55 pm
  • Maybe a this is a mental block, but anyone know if there are any attributes available that would tell us in a merge statement, how many were insert and how many were updates? 9i or 10g TIA Raj Got ...
    RjamyaRjamya
    May 15, 2006 at 11:51 am
    May 15, 2006 at 3:33 pm
  • Is it possible to set a unix server to auto-start a database without having root priviledges? Don�t just search. Find. Check out the new MSN Search! ...
    Fred SmithFred Smith
    May 4, 2006 at 6:38 pm
    May 5, 2006 at 5:26 pm
  • Can anyone recommend a good book for getting started with Postgres? I see open source in my future... Thanks, Jay This message is confidential and sent by TD Waterhouse solely for use by the intended ...
    JayMiller_at_TDWaterhouse.comJayMiller_at_TDWaterhouse.com
    May 1, 2006 at 10:23 pm
    May 2, 2006 at 5:13 pm
  • Hello All, Can anyone out there provide me some valid reasons when a database would need to be downgraded? any reason will be helpful? Thanks in advance. -- http://www.freelists.org/webpage/oracle-l
    Vikram singhVikram singh
    May 1, 2006 at 5:34 pm
    May 1, 2006 at 7:53 pm
  • List, We have accidently set a column in a BIG table (77+ million rows) as "unused" in our staging server, since its not possible to do TSPITR, can we recover the unused column ?. Any advice is ...
    Prabhu, KPrabhu, K
    May 10, 2006 at 12:16 am
    May 31, 2006 at 6:32 pm
  • Hello All, We're doing a direct path to an empty table via: insert /*+ APPEND*/ into TABLE as select * from other_schema.SAME_TABLE; The table has a primary key and a few extra indexes. The goal is ...
    Christo KutrovskyChristo Kutrovsky
    May 30, 2006 at 7:48 pm
    May 31, 2006 at 2:41 pm
  • I'm missing something easy here, so I'd really appreciate a fresh set of eyes. I've got a persistent jdbc connection to a primary database I need to get rid of before I can switch to the standby. The ...
    David BarbourDavid Barbour
    May 26, 2006 at 4:28 pm
    May 26, 2006 at 6:30 pm
  • I have dates in the database as "seconds since epoch".. I need to select items where start_time = epoch(sysdate - 7); How do I get the sysdate converting to epoch easily within the sql code? -- ...
    Anthony EttingerAnthony Ettinger
    May 16, 2006 at 7:04 pm
    May 25, 2006 at 3:19 pm
  • I am trying to make a script to stop the OMS and restart it after running sqlplus. Right now testing with select from DUAL. # set Oracle_home ORACLE_HOME=/home/oracle/OracleHomes/db10g export ...
    Jeffrey BeckstromJeffrey Beckstrom
    May 23, 2006 at 12:37 pm
    May 24, 2006 at 6:00 pm
  • Folks, Is there a way to find out what instance has mastered a certain block in 9i2 RAC? Thanks Amir -- http://www.freelists.org/webpage/oracle-l
    Hameed, AmirHameed, Amir
    May 22, 2006 at 9:03 pm
    May 24, 2006 at 11:53 am
  • I will start no "nologging" constraints validated on import, re-reading the data multiple times paralell only in enterprise (instead of doing multiple no-parallel index builds in workers) no async IO ...
    Christo KutrovskyChristo Kutrovsky
    May 18, 2006 at 3:46 pm
    May 19, 2006 at 4:43 pm
  • Hi all I am trying to replicate 50 tables from one database to another using Oracle 9.2.0.7 on Sun Solaris. this will be basic replication, read only MVs. I am reading the replication manual (which ...
    AmonteAmonte
    May 12, 2006 at 10:24 am
    May 16, 2006 at 3:11 pm
  • I want to be notified every time the DBA role is granted or revoked via email. I found the procedure which takes care of the email. Next I created a trigger on Insert into the Dba Role Privs view and ...
    Burton, LauraBurton, Laura
    May 5, 2006 at 5:41 pm
    May 8, 2006 at 12:19 pm
  • Here is the scenario HP UX, 10G R1, DW, noarchivelog, cold backup only Attempt partial clone to recover data from one tablespace Tablespace X contains datafiles 1-6 Tablespace X was put in readonly ...
    BobBob
    May 2, 2006 at 11:46 pm
    May 5, 2006 at 2:00 am
  • I'm looking to make a cronjob that will every 5 minutes check if the database is up, and if not, start it. Does anyone have a script that does this available? Thanks. On the road to retirement? Check ...
    Fred SmithFred Smith
    May 1, 2006 at 3:20 pm
    May 2, 2006 at 2:15 am
  • I'm aware that a number of people here admin Microsoft SQL Server as well as Oracle. Where I work Oracle has traditionally been used for corporate apps (and some departmental/smaller apps) and ...
    Stephen boothStephen booth
    May 12, 2006 at 11:09 pm
    May 31, 2006 at 5:42 am
  • Hi listers, I have the following problem. When I run a SQL statement (see below) without hint, I am getting pretty bad performance. When I use FIRST_ROWS hint, I am getting a totally diffrent (and ...
    Milen KulevMilen Kulev
    May 22, 2006 at 10:03 am
    May 26, 2006 at 10:09 am
  • Hi Guys, Have you ever restore and try to recover fuzzy datafiles? -- Kind regards, Sinardy -- http://www.freelists.org/webpage/oracle-l
    Sinardy XingSinardy Xing
    May 25, 2006 at 6:00 am
    May 26, 2006 at 7:31 am
May 2006
123456
Group Navigation
period‹ prev | May 2006 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions251
posts1,385
users245
websiteoracle.com

245 users for May 2006

Jared Still: 51 posts Kevin Closson: 42 posts Oracle-l-bounce_at_freelists.org: 40 posts Alex Gorbachev: 37 posts Dennis Williams: 36 posts Rjamya: 34 posts Tanel Põder: 33 posts Mladen Gogala: 30 posts Radoulov, Dimitre: 30 posts Stefan Knecht: 30 posts Mark J. Bobak: 28 posts David Sharples: 25 posts Niall Litchfield: 23 posts Schultz, Charles: 23 posts GovindanK: 21 posts Mercadante, Thomas F \(LABOR\): 19 posts Andrey Kriushin: 18 posts Freeman, Donald: 17 posts Wolfgang Breitling: 17 posts Christian Antognini: 16 posts
show more
Archives