Search Discussions

137 discussions - 784 posts

  • After mulling this over with a few folks, I thought to hit a larger audience. Has anyone done work to identify basic, standard and advanced DBA skills? Oracle University has an interesting framework ...
    Charles SchultzCharles Schultz
    Apr 3, 2009 at 12:49 pm
    Apr 10, 2009 at 11:20 pm
  • Hi I am trying to implement vpd using a slightly modified version of the example given here http://oraclue.com/2009/02/26/virtual-on-virtual-vpd-on-virtual-column/ My example is like this. CREATE ...
    Kumar MadduriKumar Madduri
    Apr 7, 2009 at 12:56 am
    Jun 18, 2009 at 11:35 pm
  • Hi All, I am looking at some INSERT INTO table VALUES (...) type queries in DBA_HIST_SQLSTAT where the rows_processed executions. Normally I'd expect to see 1-to-1 relation unless bulk binds are ...
    Charlotte HammondCharlotte Hammond
    Apr 9, 2009 at 6:37 pm
    Apr 9, 2009 at 8:36 pm
  • I want to "borrow" this topic to ask, Is there a way in Enterprise Manager or Grid Control to plot a graph of any statistic or wait event for a given period of time? By any, I mean any one in ...
    Yong HuangYong Huang
    Apr 3, 2009 at 3:41 pm
    Apr 8, 2009 at 12:34 pm
  • I'm looking for thoughts / feedback / experiences of : applications that leave enforcement of foreign key relationships to the application (or simply assume that those relationships will not be ...
    Peter bellPeter bell
    Apr 20, 2009 at 7:53 pm
    Apr 22, 2009 at 2:42 pm
  • Little bit confused. If using RMAN to do a backup to disk, do you need a large pool configured. I have one configured and was monitoring free space in the pool during an RMAN backup and it did not ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 24, 2009 at 2:03 pm
    May 1, 2009 at 11:33 am
  • I have encountered, for me, two new lock types from v$lock (Oracle 11g) Does anyone now whats related to types "AE" and "TO" ? (and in my case "AE" is not OMS/Oracle agent related) Thanks! Marco -- ...
    Marco GralikeMarco Gralike
    Apr 22, 2009 at 1:48 pm
    Apr 24, 2009 at 4:15 pm
  • Hi Listers, I was wondering what are the real-life PL/SQL usages in these days of n-tier applications. Is anybody putting code into the PL/SQL layer in the modern applications any more? Looks like ...
    Apr 13, 2009 at 11:33 am
    Apr 15, 2009 at 9:15 am
  • http://www.oracle.com/sun/index.html This should be interesting. And MySQL is going to go down the crapper! =) -- Charles Schultz Sent from Champaign, Illinois, United States -- ...
    Charles SchultzCharles Schultz
    Apr 20, 2009 at 12:51 pm
    Apr 23, 2009 at 2:57 pm
  • Hey all, If you had 8 disks in a server what would you do? From watching this list I can see alot of people using RAID 5 but i'm wary of the performance implicatons. (http://www.miracleas.com/BAARF/) ...
    Apr 8, 2009 at 3:47 am
    Apr 10, 2009 at 5:23 pm
  • Hi, Please tell me how density is calculated in case of histograms. I've a table with very skewed data: scott_at_ORADB10G select col_skew, count(*) from tab_skew group by col_skew order by 1 ...
    Neeraj BhatiaNeeraj Bhatia
    Apr 6, 2009 at 6:47 am
    Apr 9, 2009 at 8:46 pm
  • We are a reasonably large corporation, with 650 Oracle databases. We are having a bit of internal discussion going on concerning different support models: (1) Having separation of duties for DBAs ...
    Apr 2, 2009 at 5:51 pm
    Apr 7, 2009 at 5:00 pm
  • 11g - LInux Test messages go fine. I have set up a schedule Even set alerts on tablespaces full very low - the alerts are generate but no emails are sent - what have I missed ? -- Howard A. Latham -- ...
    Howard LathamHoward Latham
    Apr 2, 2009 at 1:40 pm
    Apr 2, 2009 at 6:07 pm
  • One of our databases ( hung a few times in the last days. Finally it was traced to a bug in Rman compressed backup against a database that was created in 9.2 and was upgraded to ...
    Yechiel AdarYechiel Adar
    Apr 20, 2009 at 9:52 am
    May 19, 2009 at 7:40 pm
  • fyi, http://www.oracle.com/sun/index.html -- http://www.freelists.org/webpage/oracle-l
    Tomi WijantoTomi Wijanto
    Apr 20, 2009 at 12:46 pm
    Apr 21, 2009 at 8:32 pm
  • <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" If you're going to use ORADEBUG, then how about taking another approach and simply obtaining the regular trace file name using ORADEBUG ...
    Tim GormanTim Gorman
    Apr 19, 2009 at 5:37 pm
    Apr 29, 2009 at 3:07 pm
  • So, We have a debate going on about allowing databases with datafiles with autoextend on... anybody has any input on this? any experience? My side: I don't like autoextend, I can't trust the unix ...
    Guillermo Alan BortGuillermo Alan Bort
    Apr 13, 2009 at 9:33 am
    Apr 20, 2009 at 6:25 pm
  • Hi Listers, I am newbie to the DBA / Performance tuning world and was wondering if there were some environments available to "practice" performance tuning in realistic situations. I have been a ...
    Ramesh GeeceeRamesh Geecee
    Apr 9, 2009 at 8:10 am
    Apr 13, 2009 at 4:36 am
  • Is anyone patching database according to this: " Subject: Oracle Recommended Patches -- Oracle Database Doc ID: 756671.1 Type: ANNOUNCEMENT Modified Date : 15-APR-2009 Status: PUBLISHED Beginning ...
    Apr 21, 2009 at 3:40 pm
    Apr 24, 2009 at 12:39 pm
  • We tried to use 9000 MTU on the interconnect and were getting intermittent node evictions due to communication errors, for those of you running RAC, are you using jumbo frames on your network cards ...
    Apr 21, 2009 at 12:13 pm
    Apr 23, 2009 at 5:34 am
  • Hi all, I have a table with the following columns: HTS_CODE HTS_DESC ----------------------- ----------------------------------------- 338K10_340W81 6109.10.0027 & 6205.20.2061 338K5_338K9_1 ...
    Eugene PipkoEugene Pipko
    Apr 16, 2009 at 11:47 pm
    Apr 18, 2009 at 8:30 pm
  • Has anyone written a guide for a non dba to do a manual dataguard switchover on Linux Oracle 11g? -- Howard A. Latham -- http://www.freelists.org/webpage/oracle-l
    Howard LathamHoward Latham
    Apr 2, 2009 at 11:33 am
    Apr 3, 2009 at 2:14 pm
  • With the release of Intel (Nehalem) 5500 series, which is 45nm and I believe also supports multicore and hyperthreading. There are some things going on my mind..So from a single socket (Nehalem), ...
    Karl AraoKarl Arao
    Apr 27, 2009 at 11:21 am
    May 6, 2009 at 2:10 am
  • Last week I was testing my first rman backup. I did a restore and it worked fine. Today I try to backup the restored database and get the following error: Here is my entire script. Do I have to drop ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 27, 2009 at 6:27 pm
    Apr 28, 2009 at 1:05 pm
  • Hi, What is a good way to set ulimit stack value at OS/UNIX level permanently. Right now I can set it for a session but I want it set permanently. Thanks for help. When I say ulimit it says unlimited ...
    A JoshiA Joshi
    Apr 10, 2009 at 6:55 pm
    Apr 12, 2009 at 4:00 pm
  • Oracle recommends one more group for standby redo logs (SRL) on the physical standby than the primary online logfile groups ...
    Yong HuangYong Huang
    Apr 4, 2009 at 1:53 am
    Apr 10, 2009 at 6:12 pm
  • I have a simple sql script that selects from a couple of tables. What I would like to do is store the script in the database and run it from there. For example, instead of _at_test.sql going to the ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    Apr 3, 2009 at 4:52 pm
    Apr 6, 2009 at 12:43 pm
  • Greetings, I am running Oracle EE. Is there an equivalent to login.sql for RMAN such that I don't have to store passwords in my scripts? I have looked but am unable to find a solution. What ...
    William WagmanWilliam Wagman
    Apr 29, 2009 at 9:25 pm
    May 12, 2009 at 1:48 pm
  • Hi List, Today I have to face a more or less non technical question: I have to search, ifthere is any possibility to measure the execution time of [any|set of|every] SQL thrown onto a database. Even ...
    Martin BergerMartin Berger
    Apr 21, 2009 at 8:17 am
    Apr 26, 2009 at 7:39 pm
  • One issue I've encountered with this is that RMAN will not know ANYTHING about the backups on tape. So say, for example, you keep 7 days of backups on disk and then they are deleted since they have ...
    Sweetser, JoeSweetser, Joe
    Apr 13, 2009 at 5:34 pm
    Apr 14, 2009 at 4:00 pm
  • Oracle 10g in a NONARCHIVE mode. I need to create some temp tables during some process. These temp tables will not be updated. I am doing something like this now: CREATE TABLE TMP_TABLE123 PCTFREE 0 ...
    Guang MeiGuang Mei
    Apr 28, 2009 at 3:56 pm
    Apr 30, 2009 at 1:26 pm
  • Hi, We have been experiencing crashes on our RAC cluster. It's a 2-node cluster, Oracle SE, RAC, ASM, on Solaris servers,T5220, running 5.10. In all cases the server, or ...
    Ed lewisEd lewis
    Apr 20, 2009 at 8:15 pm
    Apr 24, 2009 at 3:50 pm
  • Hello all, I can see oracle processes in unix but how do I see them in windows? We have some connection issues and I want to see how many pids are out there. ciao, Brian This email message may ...
    Zelli, BrianZelli, Brian
    Apr 22, 2009 at 2:04 pm
    Apr 23, 2009 at 10:09 pm
  • The Data Warehousing group in our organization continues to say that their sources indicate that Oracle Warehouse Builder (OWB) "is not worth a dime." Some non-technical folks in our organization ...
    Carol DackoCarol Dacko
    Apr 20, 2009 at 3:30 pm
    Apr 22, 2009 at 9:43 am
  • Hi all I have a probably very basic question but I cant think how Oracle does it. When we query a table we know that data block address is hashed to read if buffer chain if reading from cache, ...
    Apr 10, 2009 at 8:51 pm
    Apr 10, 2009 at 10:37 pm
  • I get this code below, first glance says, this should work, Oracle is so much like C, gives you a gun, ammo, takes off the safety and has the trigger most of the way pulled while pointing the gun at ...
    Apr 10, 2009 at 2:47 pm
    Apr 10, 2009 at 4:49 pm
  • Redhat linux 2 cpu 12 GB ram COTS app: kana Kana is telling our developer that we need to run begin ctx_ddl.sync_index('kc_ctx_rawtext', '12M'); end; to resync the text index. The index is ...
    Michael McMullenMichael McMullen
    Apr 8, 2009 at 2:25 pm
    Apr 9, 2009 at 5:42 pm
  • Hi all, I started to think about writing an archiving procedure for one of our apps. The idea is to move/delete records from SALES table and all other tables that related to it. I am using the ...
    Eugene PipkoEugene Pipko
    Apr 29, 2009 at 9:35 pm
    Apr 30, 2009 at 9:16 pm
  • Our company is now thinking about *Secure* backup, which means not a single DBA/SA have access to all the production/DR (and 3rd online copy). Currently our implementation is every DBA/SA have ...
    Apr 29, 2009 at 2:56 pm
    Apr 30, 2009 at 1:51 pm
  • Hi DBAs, I've the environment of Oracle 10g ( on SUSE Linux 9 (32-bit). I've got 5 redo logfiles of 250MB each, still I'm seeing this the following error messages in the alert log file ...
    Saad KhanSaad Khan
    Apr 23, 2009 at 6:32 pm
    Apr 29, 2009 at 3:12 pm
  • List Our current standby is using the Oracle 8 way of apply archive logs to standby by manually transfering the files and applying it on standby. Now we want to build a standby at DR location but we ...
    Kumar MadduriKumar Madduri
    Apr 25, 2009 at 7:03 pm
    Apr 26, 2009 at 2:32 am
  • Hello, listers We are facing rather strange situation... When accessing table for analyze or to export table, we are seeing "db file sequential read" wait event. V$session_wait file# is 2, that is - ...
    Vladimir BaracVladimir Barac
    Apr 13, 2009 at 3:36 pm
    Apr 13, 2009 at 6:51 pm
  • We just received some new servers and the admin group is proposing a new naming convention for them. The name would be 12 characters in length. Are there any limitations on windows for the length of ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 3, 2009 at 11:35 am
    Apr 6, 2009 at 1:54 pm
  • I'll admit up front that I'm not a network guy and still have trouble spelling TCP. That said, I'm trying to understand how the value in "bytes received via SQL*Net from dblink" would be less than ...
    Herring Dave - dherriHerring Dave - dherri
    Apr 2, 2009 at 5:58 pm
    Apr 3, 2009 at 4:33 pm
  • Ok, so this is my first time attending the Collaborate, and I'm curious what things I can do to make the most out of it? I've signed up for the education sessions (of course), and I saw the ...
    Taylor, Chris DavidTaylor, Chris David
    Apr 28, 2009 at 7:38 pm
    Apr 30, 2009 at 1:08 pm
  • Greetings, I'm running Oracle (vendor restriction) Enterprise Edition on RHEL4 all 64-bit. I have created a process which allows me to automate a refresh of our developer sandboxes from the ...
    William WagmanWilliam Wagman
    Apr 24, 2009 at 6:48 pm
    Apr 27, 2009 at 7:40 pm
  • Hi, I am sure lot of people might have faced this problem. From what i have researched so far, RMAN does not support duplication (i am not talking restore here, but duplicate clone) between different ...
    Vishal GuptaVishal Gupta
    Apr 22, 2009 at 10:25 pm
    Apr 26, 2009 at 8:10 am
  • After talking with some folks, it sounds like this functionality is not even available at present, so there are no such tools that can take advantage of it. Which got me to thinking. Hypothetically, ...
    Charles SchultzCharles Schultz
    Apr 23, 2009 at 8:54 pm
    Apr 24, 2009 at 10:56 am
  • This doesn't directly relate to the patches, but may be helpful as a timestamp is included. 1 select * from DBA_REGISTRY_HISTORY 2* order by action_time 15:49:15 SQL / ACTION_TIME ACTION NAMESPACE ...
    Jared StillJared Still
    Apr 17, 2009 at 10:50 pm
    Apr 20, 2009 at 5:22 pm
  • Hi fellows, I've oracle 10g ( running at Linux with partitioning option. The users were running pipelines while I was informed that the they got crashed. When I checked the alert log file, I ...
    Saad KhanSaad Khan
    Apr 15, 2009 at 7:09 pm
    Apr 16, 2009 at 1:58 pm
Group Navigation
period‹ prev | Apr 2009 | next ›
Group Overview
grouporacle-l @

195 users for April 2009

Jared Still: 43 posts Guillermo Alan Bort: 20 posts Yong Huang: 20 posts Bobak, Mark: 19 posts : 17 posts Rich Jesse: 16 posts Jeffrey Beckstrom: 15 posts Mark W. Farnham: 15 posts Niall Litchfield: 15 posts SHEEHAN, JEREMY: 15 posts Martin Berger: 14 posts Mathias Magnusson: 14 posts Crisler, Jon: 12 posts Howard Latham: 12 posts A Joshi: 11 posts Fuad Arshad: 11 posts Goulet, Richard: 11 posts Robert Freeman: 11 posts TESTAJ3_at_nationwide.com: 11 posts Saad Khan: 10 posts
show more