FAQ

Search Discussions

150 discussions - 751 posts

  • Hello Oracle-L, I have been 'lurking' on this list for manyyears. Time was when I contributed regularly, but now I'm content to read. Until now... I have been reviewing the latest volume by Chris ...
    Peter RobsonPeter Robson
    Sep 12, 2008 at 9:37 am
    Sep 15, 2008 at 4:18 pm
  • Hi Folks, Here is the scenario; If a PL/SQL package contains multiple procedures and functions and there are triggers referencing a certain procedure in that package then is there a way to list all ...
    Hameed, AmirHameed, Amir
    Sep 3, 2008 at 5:49 pm
    Sep 20, 2008 at 11:41 pm
  • Good day, list, Curious if anyone had seen anything like this. Working with OSEE 10.2.0.2, Primary and physical Standby are both on Solaris 10. Several months ago we did a switchover twice ...
    Charles SchultzCharles Schultz
    Sep 8, 2008 at 1:29 pm
    Sep 9, 2008 at 8:39 am
  • I get 404, URL not found. Is it just me? -- Adar Yechiel Rechovot, Israel -- http://www.freelists.org/webpage/oracle-l
    Yechiel AdarYechiel Adar
    Sep 21, 2008 at 7:58 am
    Oct 1, 2008 at 4:38 pm
  • Got one from Carol Dacko. Thanks Carol! Thanks all others for the reply! -Mark -- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O ...
    Bobak, MarkBobak, Mark
    Sep 23, 2008 at 5:27 pm
    Sep 30, 2008 at 4:43 pm
  • Hi Folks, We had migrated a OLTP/Batch hybrid 9i RBO application to 10g and after rounds of tuning the application now is working at its best. We had experimented with various sampling rates for ...
    Sriram KumarSriram Kumar
    Sep 30, 2008 at 9:41 pm
    Oct 7, 2008 at 12:58 pm
  • We need some help. RAC, Oracle 10.2.0.3 on windows 2003 servers 64 bit. We did a fail over test. We disconnected one server from the network by pulling the network cable. The system worked fine, but ...
    Yechiel AdarYechiel Adar
    Sep 2, 2008 at 5:37 am
    Sep 4, 2008 at 3:07 pm
  • Hi Gurus, Recently I migrated one database from 9.2.0.8 to 10.2.0.3 on Solaris 9 (this is test database, copy of production) Strangely when I tried to update stats on one of the partitioned tables I ...
    Mayen.Shah_at_lazard.comMayen.Shah_at_lazard.com
    Sep 11, 2008 at 2:39 pm
    Oct 22, 2008 at 11:04 pm
  • I sure hope nobody on this list is working on these projects. This was just forwarded to me by my Project Chief. Apparently the House Science and Technology Committee finds SQL lacking. Laying off ...
    Bill FergusonBill Ferguson
    Sep 7, 2008 at 1:09 pm
    Sep 12, 2008 at 3:42 pm
  • The somewhat famous Joel from Joel on Software and his team have designed a new Q&A application called StackOverFlow (http://stackoverflow.com/), anyway it is sure to be a destination for a lot of ...
    Ethan PostEthan Post
    Sep 23, 2008 at 1:29 pm
    Sep 25, 2008 at 1:48 pm
  • I have a friend (no really, this isn't some lame way of telling you about me but trying to hide that by ... ) I have a friend, and at his company they have an Oracle database with tables and data ...
    Brady, MarkBrady, Mark
    Sep 24, 2008 at 3:07 pm
    Sep 25, 2008 at 12:32 pm
  • Hi Does anyone know what value should be used for num_disks argument when running I/O stress tests with ORION? For example consider I have a RAID Group within an EMC Clariion CX-700 SAN, formed by 8 ...
    LS ChengLS Cheng
    Sep 12, 2008 at 9:27 am
    Sep 12, 2008 at 9:04 pm
  • We have created a new Oracle 10.2.0.3 rman recovery catalog which works fine with our Oracle 9 and 10 (10.2.0.3) databases on Solaris Server Problem is that I also just created a new installation of ...
    Shanmugam, DhandapaniShanmugam, Dhandapani
    Sep 22, 2008 at 9:06 pm
    Sep 23, 2008 at 5:33 pm
  • Greetings, I'm running 64-bit Oracle 10.2.0.4.0 EE on Windows server 2003. The select statement select patient_id, study_number from ucdv_cc_summaryae where study_number = 'UCDCC#128'; returns 8693 ...
    William WagmanWilliam Wagman
    Sep 19, 2008 at 4:30 pm
    Sep 22, 2008 at 10:33 pm
  • One of our test instances, the startup process is taking more time. sga is ~2gb. Total System Global Area 2130706432 bytes Fixed Size 2031448 bytes Variable Size 1140850856 bytes Database Buffers ...
    Raja raoRaja rao
    Sep 12, 2008 at 3:26 am
    Sep 14, 2008 at 2:46 pm
  • Mark, I appreciate your input and you are right force logging will fix the issue and yes standby databases prompted this effort in the first place. The reason for my looking for the objects is that I ...
    Finn JorgensenFinn Jorgensen
    Sep 1, 2008 at 1:39 pm
    Sep 6, 2008 at 2:02 am
  • Hi, We are using ODM (Oracle Disk Manager) on one of our 10.2.0.3 DBs, and the disk_asynch_io is TRUE in the database. I have also read that ODM supports kernel asynchronous I/O. The platform is AIX ...
    Deepak SharmaDeepak Sharma
    Sep 16, 2008 at 4:39 am
    Oct 27, 2008 at 1:29 pm
  • Wanted to get feedback on Oracle's new Exadata! Larry must love all those CPU cores $$. Will have to wait and see on how this plays out as compared to a traditional SAN/ NAS. Can't imagine to have ...
    RajRaj
    Sep 25, 2008 at 3:20 am
    Oct 3, 2008 at 2:42 pm
  • Hello Gurus, My fellow team member has unknowingly added a datafile of the same name in different mount point and now the database looks having two datafile names which are identical and located in ...
    Shastry(DBA)Shastry(DBA)
    Sep 24, 2008 at 1:04 am
    Sep 27, 2008 at 11:44 pm
  • I have set up a database in archivelog mode with backup as COMPRESSED BACKUPSET archivelog all not backed up delete all input format '/d123/backup/arch_%d_%u_%s'; among my rman script commands. Now ...
    Claudia ZeilerClaudia Zeiler
    Sep 16, 2008 at 1:03 am
    Sep 16, 2008 at 5:42 pm
  • In a recent optimization effort, I found what I think are high physical read times. For example, a single block read was averaging 11 milliseconds with a max of over 1 second (tkprof output). For ...
    Daniel FinkDaniel Fink
    Sep 24, 2008 at 4:17 pm
    Oct 9, 2008 at 7:18 pm
  • Oracle 10.2.0.4 on Linux x86-64; Designer 10.1.2.2 The application sometimes has the following error: Oracle Error Message: ORA-12899: value too large for column "ODS_OWNER"."PATIENT"."CREATED_DATE" ...
    Yong HuangYong Huang
    Sep 29, 2008 at 9:44 pm
    Sep 30, 2008 at 10:14 pm
  • List, Okay, I'm feeling I should get back on the OCP track. I completed the 8i OCP a few years ago, so I understand that I am eligible to take 1Z0-055 10g for 8i DBA without taking any classes. Does ...
    Dennis WilliamsDennis Williams
    Sep 29, 2008 at 2:18 pm
    Sep 30, 2008 at 7:13 pm
  • Hello, The ip addresses for the VIP and public interfaces are going to be changed in our cluster. I found a paper on metalink, that recommends using the oifcfg utility to do this. Basically, shut ...
    Ed lewisEd lewis
    Sep 18, 2008 at 12:30 am
    Sep 22, 2008 at 5:02 pm
  • Folks, I'm about to configure 10 servers using 10.2.0.4 and ASM, all non-RAC. My question is what's the preferred or best location for the listener, to run out of the db's $ORACLE_HOME or ASM's ...
    Herring Dave - dherriHerring Dave - dherri
    Sep 17, 2008 at 8:16 pm
    Oct 28, 2008 at 4:14 am
  • I have auditing turned on. It does not appear to track when someone recompiles code. I have audit all on. is there a way to track this ? -- http://www.freelists.org/webpage/oracle-l
    Dba DBADba DBA
    Sep 25, 2008 at 12:28 pm
    Oct 3, 2008 at 2:59 pm
  • We are setting up a new linux box for Oracle, the following message appears when trying to create the dba group: [root]# groupadd -g 300 dba groupadd: group dba exists I've seen this before, but have ...
    Jared StillJared Still
    Sep 30, 2008 at 8:42 pm
    Sep 30, 2008 at 10:49 pm
  • So how many of you are responsible for examining your database servers for hardware/software faults when it crashes? Not the database, but the actual machine? We recently had a server crash that ...
    Taylor, Chris DavidTaylor, Chris David
    Sep 30, 2008 at 1:18 pm
    Sep 30, 2008 at 6:32 pm
  • http://aws.typepad.com/aws/2008/09/hello-oracle.html I guess the 'big' announcement isn't until tomorrow. For the first time in a while I really feel like we are seeing a new paradigm in computing ...
    Stephens, ChrisStephens, Chris
    Sep 23, 2008 at 1:49 pm
    Sep 24, 2008 at 3:41 pm
  • I live near to Moscone. There is a kind of good Italian place, about 1 block in the opposite direction. It is called Buca di Beppo http://www.bucadibeppo.com/locations/location.aspx?location=0502 The ...
    Claudia ZeilerClaudia Zeiler
    Sep 9, 2008 at 6:03 am
    Sep 23, 2008 at 2:39 pm
  • We recently (today) moved the redo logs from RAID5 to RAID1+0. The obvious reason of doing this is to make things better in terms of performance, as RAID1+0 is better suited for read/writes. Someone ...
    Deepak SharmaDeepak Sharma
    Sep 9, 2008 at 4:32 am
    Sep 10, 2008 at 2:45 am
  • I am on ASM, the group moving the data is not. I think transportable tablespaces is the best way to do this. So I have to use RMAN to put the data in ASM. Is this a copy to an an ASM tablespace? Any ...
    Dba DBADba DBA
    Sep 30, 2008 at 2:28 pm
    Oct 3, 2008 at 9:46 am
  • The only hardware available is this Thinkpad T61 laptop x86_64 with Centos el5 on it. I need to install Oracle 9i on it to rman - clone a production 9i at a point in time. The production db is the ...
    Carmen RusuCarmen Rusu
    Sep 22, 2008 at 9:59 pm
    Sep 24, 2008 at 3:46 pm
  • Is there a method to measure or estimate the impact of context switches when executing SQL inside a PLSQL block -- particularly when the PLSQL block runs the same SQL statement very many times inside ...
    Hemant K ChitaleHemant K Chitale
    Sep 11, 2008 at 3:15 pm
    Sep 13, 2008 at 11:16 am
  • Does anybody have any recommendations on a RAC book? Which RAC book is the best? Thanks. Want to do more with Windows Live? Learn “10 hidden secrets” from Jamie ...
    Joe SmithJoe Smith
    Sep 3, 2008 at 3:28 pm
    Sep 4, 2008 at 11:54 am
  • I've been given the task of setting up our db to be a document repository. My challenge is: 1. that the end users must be able to copy files to a 'network share' (exposing the db as a windows share), ...
    Bryan sultanikBryan sultanik
    Sep 30, 2008 at 2:30 pm
    Oct 3, 2008 at 3:42 pm
  • I have a vendor that insists on running a batch job with statistics_level='ALL' and event 10046, level 8,both set at the session level in *production* only to diagnose performance issues ...
    Hemant K ChitaleHemant K Chitale
    Sep 23, 2008 at 4:16 pm
    Sep 30, 2008 at 2:16 pm
  • Anyone have any recommendations for the collection of system statistics? Any recommendation on how long to run the capture? I've heard 72 hours before (ie, M-W during a business week, which should ...
    Newman, ChristopherNewman, Christopher
    Sep 29, 2008 at 4:48 pm
    Oct 8, 2008 at 2:28 pm
  • Connecting to 10g Database from -- sqlplus/front end application/ or locally as sysdba -- is taking a very long time -- upto 8 mts. How do i troubleshoot this issue ? Any help or insight is highly ...
    BalaBala
    Sep 22, 2008 at 1:55 pm
    Oct 7, 2008 at 12:35 pm
  • We partitions by day and by month depending on the table. All of our partitions have names of the form PART_YYYYMMDD or PART_YYYYMM I am trying to calculate sizing estimates/day and by month (so they ...
    Dba DBADba DBA
    Sep 30, 2008 at 6:09 pm
    Sep 30, 2008 at 10:37 pm
  • I'm looking for anyone else that is using Kronos. We are trying to upgrade from Workforce Central v5.1 to v6.0 and have been having problems. They have a script, called upgrade.sql that has an ...
    Scott CanaanScott Canaan
    Sep 8, 2008 at 8:23 pm
    Sep 26, 2008 at 5:43 pm
  • Hello list, First of all, sorry for the off topic. I just thought of sharing few of my joyful moments with the list from which I have learned a lot. I wrote my OCM exam exactly last month and I got ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Sep 22, 2008 at 10:21 am
    Sep 25, 2008 at 12:41 pm
  • Hi All We have an external table that reads from a datafile just fine in Oracle 9i. However we upgraded our test environment to 10G and now it complaints about the column name "LANGUAGE". It expects ...
    Jack van ZanenJack van Zanen
    Sep 24, 2008 at 4:17 am
    Sep 24, 2008 at 10:15 am
  • https://metalink.oracle.com/CSP/ui/signin_en.html?language=en Paul Baumgartel CREDIT SUISSE Information Technology Prime Services Databases Americas One Madison Avenue New York, NY 10010 USA Phone ...
    Baumgartel, PaulBaumgartel, Paul
    Sep 22, 2008 at 6:47 pm
    Sep 23, 2008 at 4:29 pm
  • All, I was at the the Openworld Conference today and attended Mr Chintala's presentation on Dell IT . It was very informative . As part the presentation he talked about the single instance cluster ...
    PrasadPrasad
    Sep 22, 2008 at 5:15 am
    Sep 22, 2008 at 5:37 pm
  • I am seeing lot of query plans are changing in database. Though not always bad but I would like to know the reason why it changed. I am not doing any changes in database(No DDL) and periodically ...
    Ajay ThotangareAjay Thotangare
    Sep 15, 2008 at 9:29 pm
    Sep 17, 2008 at 4:01 pm
  • It appears to me that OCFS2 has a "space leak" The amount of disk in use reported by du -sh does not agree with df -h I see the same on 3 different systems. Does anyone else see the same? On other ...
    Sol beachSol beach
    Sep 12, 2008 at 10:15 pm
    Sep 15, 2008 at 6:50 pm
  • Just ran into something unexpected. When doing a complete refresh on a materialized view, the deletion of the rows appears to be a different transaction than the insertion of new rows. This is not an ...
    Jared StillJared Still
    Sep 9, 2008 at 10:16 pm
    Sep 11, 2008 at 11:38 am
  • Hi All, Can anyone recommend a best practices or recommendations guide for running Oracle (10g) on ZFS (Solaris 10)? I'm interested in things like FILESYSTEMIO_OPTIONS and DISK_ASYNC_IO etc. and also ...
    Charlotte HammondCharlotte Hammond
    Sep 3, 2008 at 7:37 pm
    Sep 4, 2008 at 8:55 pm
  • Hello, I would like to know whether it is possible to retrieve just one stored procedure from an export. We are currently running 10.2.0.3.0. Cheers Harshan Harshan Eppurath Financial Services ...
    Harshan Vasudevan EppurathHarshan Vasudevan Eppurath
    Sep 25, 2008 at 4:14 am
    Oct 3, 2008 at 9:29 am
Group Navigation
period‹ prev | Sep 2008 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions150
posts751
users202
websiteoracle.com

202 users for September 2008

Jared Still: 32 posts Niall Litchfield: 19 posts Roman Podshivalov: 19 posts Bobak, Mark: 16 posts Allen, Brandon: 15 posts Martin Klier: 15 posts Yechiel Adar: 15 posts Bradd Piontek: 14 posts Finn Jorgensen: 14 posts Crisler, Jon: 13 posts Rich Jesse: 13 posts David Barbour: 12 posts Andrew Kerber: 11 posts Bill Ferguson: 11 posts Claudia Zeiler: 11 posts Taylor, Chris David: 11 posts Charles Schultz: 10 posts Yong Huang: 10 posts Hemant K Chitale: 9 posts John Kanagaraj: 9 posts
show more
Archives