Search Discussions

138 discussions - 644 posts

  • I installed Oracle Sql Developer 1.5.1 today. I also installed a 3rd party JDBC driver (C:\sqldeveloper\sqldeveloper\extensions\oracle.sqldeveloper.thirdparty. drivers.sqlserver\lib\jtds-1.2.jar) ...
    Sam BootsmaSam Bootsma
    Jul 16, 2008 at 9:16 pm
    Jul 25, 2008 at 1:34 pm
  • When I delete my archive logs, it lists the ones to be deleted than wants me to confirm that I want to delete them. How would I write a shell script to log into rman and delete my archive logs to get ...
    Dba DBADba DBA
    Jul 29, 2008 at 1:10 pm
    Nov 21, 2008 at 7:12 pm
  • I am being persistently told by a DBA that DB links are inherently slow and not suited to bulk transfer of data. Does anyone have any experiences to share on the sort of practical MBytes/sec ...
    David AldridgeDavid Aldridge
    Jul 15, 2008 at 1:23 pm
    Aug 13, 2008 at 5:10 pm
  • Hello. I am attempting to look for a pattern in the continuously growing log file and mail me if match is found. (on Linux). But I am having problem. This is the part of the shell script export ...
    Shivaswamy / ಶಿವಸ್ವಾಮಿShivaswamy / ಶಿವಸ್ವಾಮಿ
    Jul 8, 2008 at 8:57 pm
    Jul 11, 2008 at 2:38 pm
  • Greetings, We are in the process of moving our EE database from Solaris SunOS 5.8 Generic_117350-54 sun4u sparc SUNW,Sun-Fire-480R to Linux 2.6.9-67.0.15.ELsmp #1 SMP Tue Apr 22 13:58:43 ...
    William WagmanWilliam Wagman
    Jul 23, 2008 at 6:29 pm
    Aug 4, 2008 at 1:24 pm
  • We have just begun the process of evaluating a new SAN vendor. We are presently developing a list of criteria/requirements/questions for the new vendor. So far we have come up with the following ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    Jul 9, 2008 at 11:19 am
    Jul 10, 2008 at 3:46 pm
  • While going through an annual sarbox task I noticed that on Linux (maybe unix too) the sticky bit is set on the password file. [oracle_at_server before]$ l $OH/dbs/orapworcl -rwSr----- 1 oracle ...
    Jared StillJared Still
    Jul 1, 2008 at 6:51 pm
    Jul 2, 2008 at 2:07 pm
  • Question, how are you rolling out the Oracle client software for your windows end-users. Are you installing the client software on the local PC and if so how? Are you running the client software from ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jul 22, 2008 at 3:45 pm
    Jul 29, 2008 at 2:13 pm
  • Hello All Red Hat Linux 4.0 Oracle Database Oracle Application Server An OC4J application that had been running on Oracle Application Server has recently been upgraded ...
    Ray FeigheryRay Feighery
    Jul 11, 2008 at 1:47 am
    Jul 24, 2008 at 6:17 am
  • I have installed Rac. I know how to create a VIP. I don't understand why this works. I also don't undertsand why TAF works. I am connected to node 1, how am I on the fly connected to node 2 if node 1 ...
    Dba DBADba DBA
    Jul 10, 2008 at 1:30 pm
    Jul 15, 2008 at 3:51 pm
  • I am studying for the OCP, and one of the practice test questions is how to recover from a lost active online redo log in noarchivelog mode. the answer they give is to restore a consistent backup, ...
    John SmithJohn Smith
    Jul 6, 2008 at 11:57 pm
    Jul 8, 2008 at 2:40 pm
  • Gurus, We have a Requirement to migrate all 10 Oracle databases ( running on Sun Solaris Server ( Solaris 10) to HP-UX Server ( running HP-UX 11i). We want to upgrade all the databases to ...
    Jul 31, 2008 at 3:37 pm
    Aug 12, 2008 at 8:35 pm
  • Hi All, I have this file by name '-C' created by mistake. I am unable to delete this. Any ideas? *[oraapp_at_greece app]# ls -l total 457636 -rw-r--r-- 1 oraapp oraapp 435824640 Oct 4 2007 -C ...
    Vikram singhVikram singh
    Jul 9, 2008 at 6:04 pm
    Jul 14, 2008 at 8:48 pm
  • List, I have a database running on Solaris 9. The database is about 1TB with 900GB of that in a single tablespace which is a single bigfile datafile. Whenever there's a RMAN backup running ...
    Finn JorgensenFinn Jorgensen
    Jul 10, 2008 at 8:16 pm
    Jul 14, 2008 at 4:50 pm
  • This is the only Oracle list i belong too, so, sorry if this is a little off topic. Need a query that will get all the customers who have not ordered a certain item, ever. Have a ORDDETAIL table that ...
    Lyall BarbourLyall Barbour
    Jul 29, 2008 at 8:56 pm
    Aug 12, 2008 at 6:47 am
  • We have a system that is throwing ORA-4031's in rman archive log backups after the system has been up a few days. To my understanding, RMAN tries to use the large pool for it's activities. When we ...
    Douglas CowlesDouglas Cowles
    Jul 15, 2008 at 12:36 am
    Jul 18, 2008 at 9:24 am
  • Does this guy have permission or can the admin please stop this? Thanks, Frank Forwarded Message ---- From: "mmurphy_at_dwconsultants.com" To: oracle-l_at_freelists.org Sent: Wednesday, July 9, 2008 ...
    Frank PettinatoFrank Pettinato
    Jul 9, 2008 at 4:34 pm
    Jul 15, 2008 at 5:58 pm
  • This only occurs with one table. The table is partitioned by day. It has about 160 gb. I do the following: select count(*) from mytable where rownum < 2; No indexes. Takes 30 seconds. Same thing on ...
    Dba DBADba DBA
    Jul 10, 2008 at 4:10 pm
    Jul 11, 2008 at 1:01 am
  • Hey all, Just poking around the new-ish Metalink Flash-based design in the SCM area. It looks prettier, but the interface seems, well, annoying. Maybe I'm just getting old and stuck in my old ways, ...
    Rich JesseRich Jesse
    Jul 2, 2008 at 4:51 pm
    Jul 3, 2008 at 3:10 pm
  • I have a RAC on windows. Oracle 9206. OCFS. I have five datafiles that have nothing in them. I mean that select * from sys.seg$ where file# between 6 and 11 return nothing. When I tried to decrease ...
    Yechiel AdarYechiel Adar
    Jul 8, 2008 at 5:09 pm
    Jul 10, 2008 at 11:11 pm
  • I know this is a bit off-topic for an Oracle list, but I know lots of you are running Oracle on Linux so you might know the answer to this. I'm doing some I/O capacity testing with Orion on a new ...
    Allen, BrandonAllen, Brandon
    Jul 25, 2008 at 2:30 pm
    Sep 3, 2008 at 4:22 pm
  • Does anyone have any negative experiences in using table compression? The following link is what we have on it: http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_data_compres ...
    Ben WittmeierBen Wittmeier
    Jul 23, 2008 at 9:39 pm
    Jul 26, 2008 at 11:14 am
  • Hi, How to Obtain and install the Database Gateway for ODBC for Oracle on Solaris 5.10 server. Also please guide me on the installation steps. Thanks and Regards, DD The information contained ...
    Shanmugam, DhandapaniShanmugam, Dhandapani
    Jul 14, 2008 at 2:14 pm
    Jul 24, 2008 at 5:13 am
  • I have a 3-node RAC cluster on RH4. I was looking for verification that I hadn't dropped any blocks between instances during GC operations. So, I wanted to get a sum of all blocks sent, a ...
    Jul 7, 2008 at 10:09 pm
    Jul 10, 2008 at 7:24 pm
  • Hi, Is anyone using Oracle Std Edition 10gR2 and RMAN? I'm trying to figure out what limitations their are with this setup. I know with the EE edition that I can backup directly to tape but I've been ...
    Jul 29, 2008 at 4:16 pm
    Jul 30, 2008 at 2:45 pm
  • There's an "Admin" in "DBA". Maybe we should have our own day, complete with depictions of Worst SQLs Ever... http://www.sysadminday.com/ Rich -- http://www.freelists.org/webpage/oracle-l
    Rich JesseRich Jesse
    Jul 25, 2008 at 2:45 pm
    Jul 25, 2008 at 7:15 pm
  • Hey all, In on AIX, I'm attempting to merge an app's "lookup" query with it's driving SQL, i.e. app currently runs nasty query, then runs a SELECT for each row returned. The query has 12 ...
    Rich JesseRich Jesse
    Jul 24, 2008 at 4:36 pm
    Jul 25, 2008 at 1:30 pm
  • I have been informed that advice to increase the db_cache_size makes sense for an OLTP system but not a DSS system. That for a DSS system, the db_cache_size should not be large but the ...
    Hemant K ChitaleHemant K Chitale
    Jul 20, 2008 at 4:34 am
    Jul 20, 2008 at 10:37 pm
  • Hi all, GC, Blackberry Curve 8320 Has anyone gotten Grid Control to work on a blackberry browser? I have tried my browser in Microsoft IE and MS Pocket IE emulation and it doesn't work ...
    Koivu, LisaKoivu, Lisa
    Jul 14, 2008 at 4:57 pm
    Jul 15, 2008 at 5:38 pm
  • Hi, Is any specific formula to find the optimum log_buffer size. Any considerations. I read that any size above 3MB might not help since it flushes at that point anyway. Database version 9i. We are ...
    A JoshiA Joshi
    Jul 22, 2008 at 4:00 pm
    Jul 24, 2008 at 6:45 pm
  • We are running rman on without a recovery catalog. I need to retrieve archive log files from an old rman backup for logminer usage. How can I get rman to recognize the old controlfile and ...
    Scott GravesScott Graves
    Jul 21, 2008 at 8:19 pm
    Jul 22, 2008 at 6:30 pm
  • I'm on, 3-node RAC (not that RAC matters in this case), RH4. I'm considering implementing resource consumer groups and having trouble finding any way to place a dbms_job into a particular ...
    Dan NorrisDan Norris
    Jul 7, 2008 at 10:38 pm
    Jul 22, 2008 at 1:51 pm
  • Well, nuttier anyway. Oracle on AIX5.3L. IBM DS4800 SAN with CIO mounted RAID5 Oracle Datafile filesystems. init.ora filesystems_io parameter can be "ASYNCH" or "SETALL" - it doesn't make a ...
    David BarbourDavid Barbour
    Jul 17, 2008 at 2:20 pm
    Jul 17, 2008 at 6:43 pm
  • So there I was this morning sitting on the tube (UK underground rail system) when a young student got on an sat down beside me. Obviously being both English and a commuter I couldn't speak to her!, ...
    Niall LitchfieldNiall Litchfield
    Jul 8, 2008 at 12:44 pm
    Jul 15, 2008 at 1:15 pm
  • Oracle 7.3.3 Oracle Parallel Server A coworker of mine needs to move a datafile that was accidentally created on a local JFS volume to a shared raw device. He's planning on using dd. Can anyone tell ...
    Jason HeinrichJason Heinrich
    Jul 10, 2008 at 7:12 pm
    Jul 10, 2008 at 10:36 pm
  • Much to my surprise & displeasure I have been directed to support Crystal Reports which is installed on a Windoze box & accesses an Oracle database which I support. In case it matters V11.0.0.1282 is ...
    Sol beachSol beach
    Jul 30, 2008 at 8:23 pm
    Aug 2, 2008 at 4:03 am
  • We've got a large materialized view log (100Gb) on a 1.7 Gb table in We need to drop the log, but we aren't sure if dropping the log will put any sort of lock on the base table. We're going ...
    Dan NorrisDan Norris
    Jul 31, 2008 at 3:32 pm
    Aug 1, 2008 at 2:25 pm
  • Oracle EE Solaris 10, running in a zone These are development databases so SGA is very small. I am not setting sga_max_size or sga_target. I set the sga sizes as follows: db_cache_size=128M ...
    Keith MooreKeith Moore
    Jul 30, 2008 at 10:15 pm
    Jul 31, 2008 at 4:38 pm
  • Folks Is "Rollback per transaction %: 73.06" under "Load Profile" section of AWR Report abnormally High? .., If so, what does this imply? .. How is the issue to be approached? NOTE - This was ...
    Jul 29, 2008 at 11:00 am
    Jul 31, 2008 at 9:13 am
  • So I have the following requirement: CODE COL_ID SPECIES FISH_ID LOCUS ALLELES chintest 11 23220 1 Omm1080v1 252,268 chintest 11 23220 1 Oki10v1 183,241 chintest 11 23220 1 christian 252,268 chintest ...
    Laura penaLaura pena
    Jul 24, 2008 at 8:38 pm
    Jul 25, 2008 at 6:01 pm
  • Good day, list, We use olsnodes in oraenv to set the ORACLE_SID. I have seen other implementations of setting the ORACLE_SID in oraenv, but I am asking specifically about olsnodes and how it works ...
    Charles SchultzCharles Schultz
    Jul 23, 2008 at 6:53 pm
    Jul 25, 2008 at 7:50 am
  • Hi, Can someone explain the wait events like rdbms ipc message, jobq slave wait, PX Deque wait, direct path read, enqueue and how to tackle them. Thanks -- http://www.freelists.org/webpage/oracle-l
    A JoshiA Joshi
    Jul 22, 2008 at 1:54 am
    Jul 22, 2008 at 4:13 pm
  • The following bit of SQL uses the mod() function to determine modulus 2 of two large numbers 13:37:20 SQL set echo on 13:37:24 SQL @mod_test 13:37:25 SQL 13:37:25 SQL 13:37:25 SQL 13:37:25 SQL select ...
    Jared StillJared Still
    Jul 3, 2008 at 8:44 pm
    Jul 7, 2008 at 6:49 pm
  • Hello, We're trying to create some in house training material to get our team up to a higher proficiency level in a variety of database topics, which roughly mirror the 10g OCM exam material. One of ...
    Newman, ChristopherNewman, Christopher
    Jul 2, 2008 at 1:31 pm
    Apr 1, 2009 at 2:14 pm
  • Oracle 10gR2 Single node rac Solaris Logical standby Schedule of events Install and configure logical standby Move storage from EMC to XIOTECH Moved from /dev/rdsk/emcpower1g to /dev/rdsk/c1t1d1s1 ...
    April WellsApril Wells
    Jul 31, 2008 at 7:24 pm
    Aug 6, 2008 at 10:46 am
  • Hi List I am trying to load data from a file into an oracle table. the file is in matrix format (rows is timestamp and columns are sids where the value is a status) and needs to be put into the table ...
    Jack van ZanenJack van Zanen
    Jul 29, 2008 at 2:20 am
    Aug 4, 2008 at 5:43 am
  • There's a new background process is 11g called PING; in v$bgprocess it has the description "interconnect latency measurement". I'm setting up a sandbox RAC system in vmware on a very CPU-starved box ...
    Jeremy SchneiderJeremy Schneider
    Jul 30, 2008 at 2:36 pm
    Jul 31, 2008 at 3:53 pm
  • �Hi list, We currently have a 4 node Oracle RAC on HP UX Superdom Itanimum II with EMC SAN (Symatrix DMX4) storage. Since few days, we are facing an abnormal situation where the RAW disks permissions ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Jul 30, 2008 at 8:43 am
    Jul 31, 2008 at 6:45 am
  • apologies for the interruption but does anyone know how to run a windows script when a laptop hibernates? -- Niall Litchfield Oracle DBA http://www.orawin.info -- ...
    Niall LitchfieldNiall Litchfield
    Jul 25, 2008 at 4:09 pm
    Jul 30, 2008 at 7:41 am
  • I am looking at dba_tab_partiitions and dba_part_tables and I don't see the actual partition key column list there. What view do I check ? I know I can use dbms_metadata. I am trying to find it in ...
    Dba DBADba DBA
    Jul 28, 2008 at 7:28 pm
    Jul 29, 2008 at 9:24 pm
Group Navigation
period‹ prev | Jul 2008 | next ›
Group Overview
grouporacle-l @

183 users for July 2008

Jared Still: 43 posts Dannorris_at_dannorris.com: 23 posts Rich Jesse: 17 posts Allen, Brandon: 16 posts Dba DBA: 16 posts Andrew Kerber: 15 posts Mark W. Farnham: 14 posts Yong Huang: 14 posts Bradd Piontek: 12 posts Hemant K Chitale: 12 posts Marco Gralike: 12 posts William Wagman: 12 posts Tanel Poder: 11 posts David Barbour: 10 posts Jonathan Lewis: 9 posts Niall Litchfield: 9 posts Bobak, Mark: 8 posts Dennis Williams: 8 posts Finn Jorgensen: 8 posts Greg Rahn: 8 posts
show more