Search Discussions

133 discussions - 757 posts

  • List, Apologies for the rant, but am I the only one with a problem caused by MetaLink's "retirement"? It turns out My Oracle Support is not supported on (for example) HP-UX B.11.11 (no Flash 9 for ...
    Vladimir AndreevVladimir Andreev
    Jul 9, 2009 at 1:42 pm
    Jul 11, 2009 at 4:08 pm
  • http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9135086 Interesting article in ComputerWorld about the NoSQL movement. Most of my DBA experience has been primarily ...
    Sunil KanderiSunil Kanderi
    Jul 2, 2009 at 6:47 pm
    Jul 13, 2009 at 11:42 am
  • Hi Guys, I was playing with dbms_stats.set_table_stats earlier. The reason is, I'd like to see plan changes let's say FTS to index scan (& vice versa) by explicitly setting the numrows and numblocks ...
    Karl AraoKarl Arao
    Jul 28, 2009 at 1:09 pm
    Aug 4, 2009 at 1:48 pm
  • All, We recently had a performance issue on a SQL for which we had stored outlined defined for it. Wondering if oracle an skip stored outline by any means. We created outline using ...
    Jul 23, 2009 at 12:13 am
    Jul 29, 2009 at 5:51 pm
  • *http://tinyurl.com/metalink-vs-myoraclesupport** *Please don't ask me to change the poll. Once it has been released, results are skewed. Jared -- http://www.freelists.org/webpage/oracle-l
    Jared StillJared Still
    Jul 9, 2009 at 9:15 pm
    Aug 4, 2009 at 10:26 pm
  • 18


    Having found some features of OEM that dont work without Grid am I wrong in thinking GRID is an additional cost? -- Howard A. Latham -- http://www.freelists.org/webpage/oracle-l
    Howard LathamHoward Latham
    Jul 28, 2009 at 12:48 pm
    Jul 29, 2009 at 8:36 pm
  • Dear DBAs, We got into a discussion about how read consistency is implemented in Oracle and was wondering what you know of this. The two sides are the following: 1) Undo is used for any and all ...
    Guillermo Alan BortGuillermo Alan Bort
    Jul 14, 2009 at 1:24 pm
    Jul 15, 2009 at 2:03 am
  • Hi guys, Oracle 10.2 on Solaris 10 box. Someone removed a user table this morning. I have a cold backup from last night. I want to restore just the USERS tablespace (where the table was) and perform ...
    David PintorDavid Pintor
    Jul 2, 2009 at 9:47 am
    Jul 2, 2009 at 4:54 pm
  • We have this Peoplesoft query that now runs for about 18hours. This is a payroll batch run and you can see from the SQL that is has 8 subqueries. Last year we were able to trace (10046 and used ...
    Karl AraoKarl Arao
    Jul 13, 2009 at 7:56 am
    Jul 15, 2009 at 9:35 am
  • I suppose that will work. I typically just stage them vi 'ALTER SYSTEM SET = .ora startup Bradd Piontek "Next to doing a good job yourself, the greatest joy is in having someone else do a first-class ...
    Bradd PiontekBradd Piontek
    Jul 31, 2009 at 5:17 pm
    Aug 14, 2009 at 3:01 pm
  • As one of the Alpha, Beta ....customers who Oracle consulted with during the implementation of Oracle Configuration Manager, Flash version of Metalink, etc. I told them from the very first day...it ...
    April SimsApril Sims
    Jul 10, 2009 at 2:59 pm
    Jul 21, 2009 at 9:55 am
  • Hello, We are planning to implement a 2 - node rac cluster, EE, solaris 10, using ASM. The plan is to also use dataguard to create a logical standby db for reporting. I was considering the ...
    Ed lewisEd lewis
    Jul 16, 2009 at 11:44 am
    Jul 19, 2009 at 9:33 am
  • Dear list, I want to design poor man's auditing for one single case: My user accounts are locked, and I want to log the connection attempts. But since there is no BEFORE LOGON ON DATABASE trigger ...
    Martin KlierMartin Klier
    Jul 31, 2009 at 1:52 pm
    Aug 4, 2009 at 2:05 pm
  • Can I flashback a physical standby? Scenario is this.. opps update on table last friday. Can't flashback the table ...snaphsot too old I was thinking that I might be able to open the standby, ...
    Steve montgomerieSteve montgomerie
    Jul 21, 2009 at 6:38 pm
    Aug 21, 2009 at 11:28 am
  • Hi Public IP is for the server (like any other server physical IP) VIP for Database access (provides Failover and Failback if configured) and must be in the same subnet as Public IP Private IP for ...
    LS ChengLS Cheng
    Jul 30, 2009 at 8:57 am
    Aug 3, 2009 at 8:24 am
  • Hello: What are the performance issues I should be aware of if I decide to enable archivelog mode on an OLTP database? I just inherited this database (about 40GB in size, ~200 users, ~2000 ...
    Julio Aguilar-ChangJulio Aguilar-Chang
    Jul 7, 2009 at 4:06 pm
    Jul 7, 2009 at 8:25 pm
  • Hi I would like to know how does a LUN map to a partition from a storage and host point of view ? how do i say /dev/sdb1 maps to LUN0 ? regards Hrishy -- http://www.freelists.org/webpage/oracle-l
    Jul 10, 2009 at 8:15 am
    Jul 19, 2009 at 9:57 am
  • Hey all, In, I have two tables of IP and lat/long info of the CSV data from http://www.maxmind.com/app/geolitecity. PK on the location table is locid. PK on the block table is startipnum ...
    Rich JesseRich Jesse
    Jul 10, 2009 at 9:45 pm
    Jul 13, 2009 at 3:59 pm
  • Sorry, that did not help. Same results. -- http://www.freelists.org/webpage/oracle-l
    Ram RamanRam Raman
    Jul 16, 2009 at 11:48 pm
    Jul 18, 2009 at 2:41 pm
  • Hi I dont think SCN can be reset. Resetlogs reset the log sequence but NOT the SCN Thanks -- LSC -- http://www.freelists.org/webpage/oracle-l
    LS ChengLS Cheng
    Jul 15, 2009 at 10:51 am
    Jul 16, 2009 at 6:39 am
  • If you don't have the PARSE or PARSING lines, you won't have the sql text. However, if the STAT lines were written, you might be able to reverse engineer the statement from the plan. Use the STAT ...
    Daniel FinkDaniel Fink
    Jul 7, 2009 at 10:51 pm
    Jul 9, 2009 at 9:49 am
  • I say choose what ever method fits your space management plan. We like uniform extends since we use raw partitions which for a practical purpose do not support auto-extending of the datafiles, but we ...
    Powell, Mark DPowell, Mark D
    Jul 28, 2009 at 6:04 pm
    Jul 31, 2009 at 7:01 pm
  • Does anyone want to take pity on me and help me with this substr/instr problem? I've wasted hours trying to come up with the "magic combination" I have thousands of records that look like this ...
    Barbara BakerBarbara Baker
    Jul 28, 2009 at 6:36 pm
    Jul 31, 2009 at 8:08 am
  • Hello: I am trying to restore couple of DB files (v10.2.0.3) from the rman backup to another server where I have binaries. Here is the error I am seeing and I am not sure what it is ...
    Jul 23, 2009 at 10:02 pm
    Jul 28, 2009 at 7:54 pm
  • Hi, I am looking at high water mark for tables and doing exp/imp or truncate or move of tables to improve performance by eliminating fragmentation/lowering HWM. For smaller tables : I am assuming ...
    A JoshiA Joshi
    Jul 27, 2009 at 12:45 am
    Jul 27, 2009 at 11:54 pm
  • How do you handle this? This is a large government project environment. Users can basically do whatever they want here. They have the ability to make any query they want. We have one table that is ...
    Dba DBADba DBA
    Jul 22, 2009 at 6:42 pm
    Jul 23, 2009 at 3:21 pm
  • Folks, Is Oracle ARU website http://aru.us.oracle.com <http://aru.us.oracle.com working for anyone? Thanks, Paresh Patel. -- http://www.freelists.org/webpage/oracle-l
    Paresh PatelParesh Patel
    Jul 13, 2009 at 5:09 pm
    Jul 14, 2009 at 3:15 pm
  • The only place I can find that it might cost anything is in the Help section "Data Modeler Concepts and Usage". "SQL Developer Data Modeler is a for-cost option of SQL Developer that requires a ...
    Jul 8, 2009 at 8:08 pm
    Jul 9, 2009 at 5:47 pm
  • Listers, I have a Global temporary table which gets populated by a PL/SQL procedure. Once it is populated, it's used by some other SQLs in the same session. Does anyone have any idea how can I find ...
    Paresh PatelParesh Patel
    Jul 2, 2009 at 7:07 pm
    Jul 5, 2009 at 11:07 pm
  • �Hi, First of all thanks a lot Cheng for the clue. I just turned-off dynamic sampling and it behaved as expected. Means, 1 version_count in case of similar and exact cursor_sharing setting. But, even ...
    Neeraj BhatiaNeeraj Bhatia
    Jul 1, 2009 at 4:56 am
    Jul 2, 2009 at 8:30 am
  • I tried to startup one new database on ORACLE 10GR2 ( on Redhat LINUX AS 4.7. I got following messages: ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget ...
    Dba1 mccDba1 mcc
    Jul 22, 2009 at 8:59 pm
    Jul 23, 2009 at 4:28 pm
  • Hi I am trying to size my undo tablepsace by looking at the undo rates.i.e the column UNDOBLKS in v$undostat. Value for undoblks for particular sql is 13841 and my database size is 8kb.Does this mean ...
    Jul 8, 2009 at 6:50 am
    Jul 8, 2009 at 10:56 pm
  • Hi list I'm trying to copy some data from one of the servers to an oracle instance on my pc. This is what i'm using copy from schema.table_at_server insert local_table using select * from ...
    Jul 30, 2009 at 4:06 pm
    Jul 30, 2009 at 5:47 pm
  • We have this SQL with a good SQL profile.. then suddenly something changed on the optimizer and the good profile was not used anymore on its next execution. I know we could have made it permanent ...
    Karl AraoKarl Arao
    Jul 22, 2009 at 11:10 am
    Jul 27, 2009 at 11:14 am
  • Hello, I have a strange problem with to_date function when I use it in select query. The following query does not give any ORA-nnnnn errors: select * from ( select tid, sequencenumber, submitdate, ...
    Jul 24, 2009 at 12:45 pm
    Jul 27, 2009 at 7:51 am
  • I am trying to get used to SQL Developer as a replacement for SQL*Plus, as Oracle saw fit to kill that simple little front end. It loaded fast and you ran your SQL or script. Done is seconds flat ...
    Jul 24, 2009 at 7:26 pm
    Jul 25, 2009 at 7:38 pm
  • anyone every see this or know how it could happen: SQL select * from toto; NUM -. -. -. -. -. 7 rows selected. SQL desc toto; Name Null? Type ----------------------------------------- -------- ...
    kyle Haileykyle Hailey
    Jul 24, 2009 at 7:29 pm
    Jul 25, 2009 at 7:23 pm
  • Hi Rich, The short answer is yes. The life of a variable is only within the block that it's defined. You can create variables in a package header that have a more global like life span. Although I'm ...
    Ric Van DykeRic Van Dyke
    Jul 22, 2009 at 6:43 pm
    Jul 22, 2009 at 8:30 pm
  • Brandon, the exact issue you are documenting here is the major reason we have to recreate the database. We are not going to recreate it until we know for sure why that happens. I became suspicious of ...
    Michael WehrleMichael Wehrle
    Jul 1, 2009 at 12:24 am
    Jul 22, 2009 at 8:18 pm
  • GRANT|REVOKE SYSDBA|SYSOPER to would do it. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l
    Jared StillJared Still
    Jul 21, 2009 at 12:34 am
    Jul 21, 2009 at 6:27 pm
  • Hi Listers, Can any one shed light on event 10612? I inherited PeopleSoft database Version 9 on Solaris 9. I found this even in init.ora file EVENT=10612 trace name context forever, level 1 I am ...
    Jul 16, 2009 at 5:22 pm
    Jul 20, 2009 at 6:35 pm
  • Maybe this is of interest more to the procurement departments and not DBAs, but I find it intriguing to hear Oracle is increasing the performance pack pricing from $3000 to $5000 per CPU especially ...
    kyle Haileykyle Hailey
    Jul 17, 2009 at 4:57 pm
    Jul 19, 2009 at 1:55 am
  • Oracle Database 11g DBA Handbook (Osborne ORACLE Press Series) or Expert Oracle Database 11g Administration (Expert's Voice in Oracle) or any other suggestion? Thanks, Roger -- ...
    Roger XuRoger Xu
    Jul 14, 2009 at 7:10 pm
    Jul 15, 2009 at 4:53 pm
  • That is quite a large extent size for a 40GB table. Generally I would recommend auto allocate and just use a large initial/next if you want to bypass the 64KB/1MB/... extent ranges and jump to the ...
    Greg RahnGreg Rahn
    Jul 13, 2009 at 11:05 pm
    Jul 14, 2009 at 6:34 pm
  • My memory is that the thin driver populates the program column of v$session with its name, the others may also do the same. -- Sent from Google Mail for mobile | mobile.google.com Niall Litchfield ...
    Niall LitchfieldNiall Litchfield
    Jul 3, 2009 at 4:08 pm
    Jul 8, 2009 at 10:11 am
  • Greetings gurus, RH Linux AS4 I am trying to write a pl/sql program to delete a bunch of records. This came up because a developer wrote a sql statement to delete everything but it was ...
    Sweetser, JoeSweetser, Joe
    Jul 30, 2009 at 10:48 pm
    Jul 31, 2009 at 12:22 pm
  • (On How's this for weird ... SQL select fw_phrase_common_p.normalise_phrase('Über') from dual; select fw_phrase_common_p.normalise_phrase('Über') from dual * ERROR at line 1: ORA-06502 ...
    Steve BaldwinSteve Baldwin
    Jul 30, 2009 at 4:19 pm
    Jul 30, 2009 at 5:54 pm
  • Hi Gurus, I'm trying to setup oracle enterprise manager on 2 node 9i test RAC. I do not find emctl under $ORACLE_HOME/bin . I also did find / -type f -name emctl but no results. I only find emca and ...
    Sundar mahadevanSundar mahadevan
    Jul 29, 2009 at 2:39 pm
    Jul 29, 2009 at 5:30 pm
  • Hi List, We are trying to use below SQL to obtain the last time at which a package/procedure/function being modified. It seems to be working for procedure and functions, but not for the package ...
    Roger XuRoger Xu
    Jul 28, 2009 at 7:46 pm
    Jul 29, 2009 at 12:33 am
  • Hello group, I am trying to use shared storage exported via iSCSI in a OEL 5.2 32bit domU. It seems that every time I am trying to login to the target I get a kernel panic. I am using Oracle VM ...
    Martin BachMartin Bach
    Jul 26, 2009 at 11:26 am
    Jul 28, 2009 at 3:26 pm
Group Navigation
period‹ prev | Jul 2009 | next ›
Group Overview
grouporacle-l @

199 users for July 2009

Jared Still: 29 posts Rich Jesse: 24 posts : 23 posts Hrishy: 22 posts Niall Litchfield: 21 posts Karl Arao: 20 posts Allen, Brandon: 18 posts Bobak, Mark: 18 posts Crisler, Jon: 17 posts D'Hooge Freek: 15 posts Bradd Piontek: 12 posts Genegurevich_at_discover.com: 12 posts Jonathan Lewis: 12 posts Matthew Zito: 12 posts Tony van Lingen: 12 posts Mathias Magnusson: 11 posts TESTAJ3_at_nationwide.com: 11 posts David Ballester: 10 posts Nuno Souto: 10 posts LS Cheng: 9 posts
show more