Search Discussions

167 discussions - 1,000 posts

  • Hi all - I inherited an RMAN environment and discovered something doing test restores to a different server that I would like to bounce off those smarter than I. The current backups do a "backup ...
    Sweetser, JoeSweetser, Joe
    Aug 27, 2007 at 10:15 pm
    Oct 3, 2007 at 3:02 am
  • For anyone interested, I ran some very quick benchmarks on 11g's new Advanced Compression table option COMPRESS FOR ALL OPERATIONS that Oracle is claiming was "specifically written to create only the ...
    Roby ShermanRoby Sherman
    Aug 17, 2007 at 1:14 pm
    Aug 19, 2007 at 10:47 am
  • Hello: I am planning to increase the parallel_max_servers from its current value (32) to either 64 or 128. I am trying to figure out if I need to increase shared_pool or large_pool to avoid running ...
    Aug 24, 2007 at 9:24 pm
    Sep 23, 2007 at 11:29 am
  • Not sure if anyone else has had this experience, but I opened an SR with Oracle for an 11g question and was told the following today (8/14): "11G production release is not yet out and so we from ...
    Allen, BrandonAllen, Brandon
    Aug 14, 2007 at 4:20 pm
    Aug 17, 2007 at 4:35 pm
  • Hi, Something that has been bothering me for a while. I know it's no biggie, just a bit of a pain. I cannot use oraenv to change the default instance to the +ASM instance, I haven't the time to go ...
    S. Anthony SequeiraS. Anthony Sequeira
    Aug 10, 2007 at 1:16 pm
    Aug 22, 2007 at 12:53 pm
  • Hey everybody, This is probably something easy and simple i'm missing. I'm using the & in the WHERE clause of a query to get certain information. How do i get ALL the information, too. Essentially, ...
    Lyall BarbourLyall Barbour
    Aug 15, 2007 at 2:42 pm
    Aug 19, 2007 at 4:28 pm
  • Hi List, Did anybody run into above error when trying to bump up MEMORY_MAX_TARGET ? How to increase /dev/shm ? -- Regards, Ranko Mosic Consultant Senior Oracle DBA B. Eng, Oracle 10g, 9i Certified ...
    Ranko MosicRanko Mosic
    Aug 22, 2007 at 12:59 am
    Aug 24, 2007 at 1:12 am
  • Company in Chicago, Illinois area (west suburb) needs a person with COmbined Oracle DBA and HPUX and SAP Basis Administrator experience to join its' IT staff. ( MUST have all 3 skills) Real nice ...
    Aug 12, 2007 at 3:33 pm
    Aug 21, 2007 at 5:54 pm
  • OK here it is. Currently we're on Oracle on 32-bit RHEL 3. We're going to be migrating to the same version ( on a 64-bit RHEL 4 box. I've done this migration plenty of times to ...
    Don SeilerDon Seiler
    Aug 1, 2007 at 7:45 pm
    Aug 21, 2007 at 10:17 am
  • Hi We have this setup db_writer_processes = 4 disk_asynch_io = false I have doubts whether i can set the below on.... please suggest advantages and disadvantages of below setting.......on HP-UX ...
    Edwin devadanamEdwin devadanam
    Aug 2, 2007 at 5:57 am
    Aug 8, 2007 at 11:54 am
  • I was asked to look into a database which was deadlocking. This was one of dozens of databases which handled switch data. Nothing in the telecoms is small. These were up to 17 TB databases. And they ...
    Tom PallTom Pall
    Aug 24, 2007 at 7:13 pm
    Sep 5, 2007 at 1:38 am
  • I'm currently working on a project that involves a new HP XP12000 Disk Array. The newly acquired array would have 240G of cache on the array that allows data to be cached between the physical disks ...
    Binh PhamBinh Pham
    Aug 3, 2007 at 10:22 pm
    Sep 8, 2007 at 8:39 am
  • Looks like we can now download Oracle 11g for Linux! http://www.oracle.com/technology/software/products/database/index.html -- Jeremy Schneider Chicago, IL ...
    Jeremy Paul SchneiderJeremy Paul Schneider
    Aug 9, 2007 at 10:37 pm
    Aug 14, 2007 at 12:39 am
  • maybe not many people use MTS recently due to nearly-free RAM. But when connection# goes real high, you still have to, and we are such a user. We experienced huge "latch:shared pool" contention in ...
    Aug 6, 2007 at 1:52 pm
    Sep 5, 2007 at 1:25 pm
  • we have ORACLE 9ir2 and 10Gr2 on same server. based on ORACLE document we ONLY turn on 10Gr2 listener. The problem I have is I tried to create DBLINK on 9ir2 database and connect to another 9ir2 ...
    Dba1 mccDba1 mcc
    Aug 13, 2007 at 2:39 pm
    Aug 14, 2007 at 9:00 am
  • Hello all ... I'm working on an upgrade from to with multiple interim patches (version and patch level required by SAP). I'm consistently hitting errors in the upgrade process in ...
    Aug 17, 2007 at 1:57 pm
    Sep 6, 2007 at 5:06 pm
  • Hi I am working on exsiting Perl program and found that it is usinf DBI to connect to Remote Database . The string used to connect the Remote database doesn't have PORT. Connection is going fine ...
    Sanjay MishraSanjay Mishra
    Aug 28, 2007 at 2:42 pm
    Aug 29, 2007 at 8:12 pm
  • Hey all, In on AIX, I'm trying to track down a percieved performance issue. Based on the info from the analyst, I fire up a logon trigger in our test DB that starts a level 12 10046 trace ...
    Rich JesseRich Jesse
    Aug 15, 2007 at 7:48 pm
    Aug 16, 2007 at 6:01 pm
  • Can anyone point me to the rules for oem licensing? Its our understanding that the basic software comes free with Oracle enterprise edition, but we dont know any more than that. We are also looking ...
    Andrew KerberAndrew Kerber
    Aug 30, 2007 at 4:15 pm
    Sep 1, 2007 at 12:42 am
  • We have to decide for a new medium database. Any recent papers on: Performance Ease of use Support In short: any reason to prefer one OS on the other. -- Adar Yechiel Rechovot, Israel -- ...
    Yechiel AdarYechiel Adar
    Aug 26, 2007 at 8:24 am
    Aug 28, 2007 at 10:21 am
  • Hi all, So, i blew up _the_ temp tablespace the other day with an update query *pats himself on the back*. I found some down time and dropped it, looking up on the web how to recreate it, i found ...
    Lyall BarbourLyall Barbour
    Aug 14, 2007 at 1:56 pm
    Aug 17, 2007 at 12:22 pm
  • RE: AUDIT Purpose Use the AUDIT statement to: Track the occurrence of SQL statements in subsequent user sessions. You can track the occurrence of a specific SQL statement or of all SQL statements ...
    Lyndon TiuLyndon Tiu
    Aug 9, 2007 at 8:03 pm
    Aug 15, 2007 at 6:42 pm
  • Does anyone know what table or view will show me what nodes and instances are supposed to be in a RAC Cluster, oracle gv$instance will give me the instances that are currently up, but I ...
    Andrew KerberAndrew Kerber
    Aug 2, 2007 at 4:35 pm
    Aug 3, 2007 at 2:50 pm
  • Hi all, I am working on renaming a tablespace. I am working on Oracle versions 8i & 9i (HP-UX) and would like to request your help in this regard. I have an idea as what process needs to be followed, ...
    Godwin vincentGodwin vincent
    Aug 27, 2007 at 8:37 pm
    Aug 29, 2007 at 6:39 pm
  • First, the disclaimer, someone made a very bad coding decision! Now the question is how to get out of the mess. We have about 2,000 scripts that do not have ORDER BY clauses anywhere in them. In 9i ...
    Peter BarnettPeter Barnett
    Aug 24, 2007 at 1:48 pm
    Aug 28, 2007 at 4:07 pm
  • Greetings, My plan is to migrate an Oracle Win2003 32 bit to an Oracle Linux 64bit RH 4. Have any of you guys ever tried to use RMAN backup/restore function to copy the Win32 DB to ...
    Arnon, YuvalArnon, Yuval
    Aug 1, 2007 at 2:33 pm
    Aug 11, 2007 at 7:22 am
  • Hi all, My management wants to keep a copy of all deleted records for historical purposes, in case somebody decides at a later point that the deletion was a mistake. This happens about once a year ...
    Bill FergusonBill Ferguson
    Aug 9, 2007 at 4:31 pm
    Aug 9, 2007 at 7:54 pm
  • Hello What component in DB I have to install to use " = CHR(0)" instead of "is not null" . -- Wojciech Skrzynecki Database Administrator -- http://www.freelists.org/webpage/oracle-l
    Wojciech SkrzyneckiWojciech Skrzynecki
    Aug 2, 2007 at 6:01 pm
    Aug 8, 2007 at 9:35 pm
  • We are planning to setup RAC with two node on Redhat Linux. We want to use RAW devices with multipath using Hitachi 9970. We could see shared storage from both the nodes. Cluster Verify fails with ...
    Aug 29, 2007 at 6:31 pm
    Sep 17, 2007 at 9:06 pm
  • Hi, All, I was trying to clone my production RAC database to my test box. When I tried to RMAN connect to my production db from my test box (which has the exact same oracle version) and I got the ...
    Li LiLi Li
    Aug 2, 2007 at 9:21 pm
    Aug 3, 2007 at 4:27 pm
  • Linux x86-64 Is there any way to determine if a SQL statement entered via SQL*Plus is using a stored outline other than the fact that the plan changes? -- ...
    Aug 24, 2007 at 4:50 pm
    Aug 25, 2007 at 7:48 am
  • Its Oracle on Solaris, we have a transaction table with approximately 68 million rows. It is consisting of about 100GB space in the tablespace and it is assumed that it is highly fragmented ...
    Khan, Muhammad SKhan, Muhammad S
    Aug 17, 2007 at 3:56 pm
    Aug 21, 2007 at 6:25 am
  • All: I am creating a user as: create user test1 identified by fannymayofomaha default tablespace def001 temporary tablespace temp01; This user test1 has access to all the user_ tables and all_ ...
    Ram SrinivasanRam Srinivasan
    Aug 7, 2007 at 9:48 pm
    Aug 8, 2007 at 6:05 pm
  • We've set up 2 groups, production and test/dev in our Grid deployment, version Can anyone tell me how to set up different notifications for each group of targets? We'd like to keep it ...
    Chris NewmanChris Newman
    Aug 9, 2007 at 2:50 pm
    Nov 22, 2007 at 7:21 pm
  • Good day, We're doing the PeopleSoft upgrade thing which includes an upgrade from Oracle 9i to 10G Rel2. Our environment will be Windows 2003 with RAC 10G. As part of the upgrade I see from the ...
    Steve montgomerieSteve montgomerie
    Aug 30, 2007 at 12:59 pm
    Sep 5, 2007 at 2:05 am
  • In our company Management want to go for Varitas Cluster Software, i am lost....Do we need 2 cluster software,Varitas cluster software + Oracle Clusterware On top of that...I thought these are same ...
    Arif GulzarArif Gulzar
    Aug 28, 2007 at 8:29 pm
    Aug 29, 2007 at 6:51 pm
  • Hi All, I have just started a new job and have to set up monitoring for the oracle/Sybase and sql server environment. Just the usual stuff (listener up/down, database up/down, alert log monitoring, ...
    Jack van ZanenJack van Zanen
    Aug 22, 2007 at 12:53 pm
    Aug 23, 2007 at 5:18 pm
  • I can no longer login to 9207 database on Windows 2003 from command line. I am getting ORA-12557: TNS:protocol adapter not loadable. The only difference that I am aware of since this last worked is ...
    J. DexJ. Dex
    Aug 13, 2007 at 2:46 pm
    Aug 16, 2007 at 12:05 pm
  • List, This is Oracle 8i. I need to write a script to ensure a user has access to all the tables, views, etc. that are needed. So I assumed that I just needed to query ALL_TABLES as the user. Did that ...
    Dennis WilliamsDennis Williams
    Aug 8, 2007 at 8:52 pm
    Aug 10, 2007 at 11:51 am
  • Hi Version and Sun Solaris. What is the effect of pga_aggregate_target in CBO plan generation, specifically in 9i? We have two environments with same statitistics and one major ...
    Shamsudeen, RiyajShamsudeen, Riyaj
    Aug 7, 2007 at 6:46 pm
    Aug 8, 2007 at 6:15 pm
  • Hi All, Have a doubt on the SESSION_CACHED_CURSORS parameter. If we set this parameter to some higher value is there a chance that the shared pool will get fragmented because of this parameter ...
    DBA DeepakDBA Deepak
    Aug 30, 2007 at 5:41 pm
    Aug 31, 2007 at 9:16 pm
  • Hi, has anyone used 10.2 Clusterware with OCFS2 on RHEL5 to get single instance failover from one host to another? I would like to ask some questions about it. Thank you, Carmen Rusu -- ...
    Carmen RusuCarmen Rusu
    Aug 23, 2007 at 9:47 pm
    Aug 31, 2007 at 3:51 pm
  • Hey all, I've just gone production with Grid Control on Ora-Linux EL4 (sympathies accepted). As I'm snooping around, I see that it's warning me that port 1837 is open on the OMS ...
    Rich JesseRich Jesse
    Aug 27, 2007 at 4:34 pm
    Aug 27, 2007 at 7:34 pm
  • hi, all While checking some performance issue on a database (9205/solaris8), i noticed the SQL performance from statspack/sql_trace_tkprof_file are different; sql_trace file shows each execution is ...
    Aug 21, 2007 at 3:32 pm
    Aug 24, 2007 at 5:15 pm
  • Folks, I've noticed that access of SYS.HIST_HEAD$ takes rather long, especially during the drop of an option with hundreds of partitions, hundreds of columns. The table referenced has statistics ...
    Herring Dave - dherriHerring Dave - dherri
    Aug 22, 2007 at 11:39 am
    Aug 23, 2007 at 12:47 pm
  • Hi, My friend has this below problem. Can anyone please let me know the complete functionality of ln - f command. When used in this way, For example, statement like this ln -f ...
    Anant (DBA)Anant (DBA)
    Aug 17, 2007 at 12:32 pm
    Aug 17, 2007 at 4:29 pm
  • I'm looking for a good way to determine total Oracle memory usage, taking shared memory into account, using standard Unix/Linux tools. I can, of course, easily determine how much memory the database ...
    Greg NorrisGreg Norris
    Aug 15, 2007 at 1:52 pm
    Aug 16, 2007 at 1:35 pm
  • Hi all, I want to refresh a production database onto development machine using EXP and IMP. My prod. database is of very small size of approximately 4GB. I can get a full backup of the database using ...
    Godwin vincentGodwin vincent
    Aug 2, 2007 at 4:10 am
    Aug 2, 2007 at 4:49 pm
  • We're inserting records via SQL*Loader into a The table is Range Partitioned. The last partition is defined as Maxvalue. If you have a maxvalue partition it should not be possible to see ...
    Brady, MarkBrady, Mark
    Aug 30, 2007 at 8:19 pm
    Aug 31, 2007 at 6:57 pm
  • Hello We are moving our application from Rule Based Optimisation to Cost Based Optimisation on Standard Edition and have hit a show-stopper for us. There is one particular query that ...
    Luke DaviesLuke Davies
    Aug 23, 2007 at 11:15 am
    Aug 23, 2007 at 9:43 pm
Group Navigation
period‹ prev | Aug 2007 | next ›
Group Overview
grouporacle-l @

215 users for August 2007

Jared Still: 55 posts Robert Freeman: 54 posts Allen, Brandon: 46 posts Alex Gorbachev: 28 posts LS Cheng: 27 posts Alvaro Jose Fernandez: 25 posts Niall Litchfield: 25 posts Kerber, Andrew W.: 22 posts Dan Norris: 20 posts Rich Jesse: 18 posts Ted Coyle: 18 posts Andrew Kerber: 15 posts Closson, Kevin A: 14 posts Dunbar, Norman: 14 posts Zhu,Chao: 13 posts Bobak, Mark: 12 posts David Sharples: 12 posts Don Seiler: 12 posts Dennis Williams: 11 posts Edwin devadanam: 11 posts
show more