Search Discussions

85 discussions - 194 posts

  • Hi List, I've been reading a lot about remote DBA services, these appear to be companies based on different locations that provide customers with DBA services while having all the DBAs physically in ...
    Guillermo Alan BortGuillermo Alan Bort
    Sep 26, 2010 at 9:27 pm
    Sep 28, 2010 at 10:53 am
  • I'm looking for a common scripting language for system administration and Oracle administration. I have lots of shell scripts that work fine on Linux but I need something that works unchanged on ...
    Steve HarvilleSteve Harville
    Sep 15, 2010 at 12:58 pm
    Sep 20, 2010 at 6:16 pm
  • Hi all, does anyone know if, and maybe how, it's possibile with EM to monitor datafile space allocation, tablespace free space per minute... I've never used EM for this, instead I've always used and ...
    Stefano CislaghiStefano Cislaghi
    Sep 13, 2010 at 7:38 pm
    Sep 15, 2010 at 12:56 pm
  • Hi Try to gather table statistics with this approach: exec dbms_stats.gather_table_stats(ownname= 'GMMI_CDI','CUST_ADDRESS',estimate_percent= null,method_opt= 'FOR ALL COLUMNS SIZE 1',cascade= true) ...
    Pavel ErmakovPavel Ermakov
    Sep 13, 2010 at 1:14 pm
    Sep 14, 2010 at 2:34 pm
  • Scott is correct for 11g - emctl is the tool to use for this version. I would however check the likely environment variables carefully. PATH,ORACLE_HOME,TNS_ADMIN etc. -- Niall Litchfield Oracle DBA ...
    Niall LitchfieldNiall Litchfield
    Sep 29, 2010 at 10:33 pm
    Sep 30, 2010 at 1:51 pm
  • Solaris 10 Oracle 10.2.0 I've inherited the STANDBY database portion of a DataGuard lash-up and only now have the resources to take a look at it. The previous custodian appeared to have better things ...
    Gus SpierGus Spier
    Sep 22, 2010 at 1:56 am
    Sep 23, 2010 at 1:38 am
  • Other than speed, I don't see what the advantage would be, unless of course some kind of limitation were found. I must say, the DBA you spoke to sounds like someone everyone would love to work with ...
    Jared StillJared Still
    Sep 1, 2010 at 10:35 pm
    Sep 2, 2010 at 12:27 am
  • Since I have this configuration on two servers, with the same OEMGC configuration/versions, but without the problem you describe, can I ask you to elaborate on "agent keeps crashing"? What is it ...
    Kellyn PedersenKellyn Pedersen
    Sep 28, 2010 at 1:26 am
    Sep 29, 2010 at 2:50 am
  • Hi DBAs, Do you know if there a option (oracle parameter ) to do automatic log switching for shipping to standby server in 10gR2 (or 11gR2). For example, if the SLA defined as data loss less than 20 ...
    Amihay GonenAmihay Gonen
    Sep 21, 2010 at 2:26 pm
    Sep 21, 2010 at 6:18 pm
  • Thanks Kenneth. Was your system OLTP or DWH? Alex 2010/9/10 Kenneth Naim -- http://www.freelists.org/webpage/oracle-l
    Sep 11, 2010 at 7:53 am
    Sep 20, 2010 at 1:06 pm
  • Hi I want to know how to find the exact size of a table containing lots of data. Regards Abhishek -- http://www.freelists.org/webpage/oracle-l
    Abhishek GurungAbhishek Gurung
    Sep 14, 2010 at 11:36 am
    Sep 14, 2010 at 1:51 pm
  • Hello, everybody! At last in Dulcian we started to look at 11g and immediately hit a major puzzle. The topic is fine-grained invalidation. Sorry for quoting Oracle docs, but I just want everybody to ...
    Michael RosenblumMichael Rosenblum
    Sep 8, 2010 at 11:21 pm
    Sep 10, 2010 at 2:35 am
  • Hi, I'm trying to perform a PIT recovery of one database onto a different machine. I have a level 0 rman backup but unfortunately I was forced to use a controlfile from a later date. I'm trying to ...
    Steve BaldwinSteve Baldwin
    Sep 27, 2010 at 2:52 am
    Sep 27, 2010 at 8:55 pm
  • Sandy, As you described, there are two issues: 1. connectivity to database using Oracle thin JDBC client. 2. characted set convertion making some characters a "garbage" or upside-down "?". For Java ...
    Mindaugas NavickasMindaugas Navickas
    Sep 24, 2010 at 3:29 am
    Sep 26, 2010 at 5:00 am
  • Having spent all of my time using RMAN for backup/recovery, I find myself at a disadvantage when it comes to hot/cold backups. My questions is, what is the impact on users during a hot backup? My ...
    Blanchard, William GBlanchard, William G
    Sep 24, 2010 at 10:49 pm
    Sep 26, 2010 at 3:00 am
  • Hi I have a query which joins a partition table with some dimensions, when I look the execution plan I can see pstart and pstop shows KEY KEY so pruning is occuring. Is there a way to find out ...
    Sep 14, 2010 at 5:35 pm
    Sep 20, 2010 at 1:06 pm
  • Hi Is there a way to grant awr report generation privileges to grid control users who have read only privileges I am looking to do this in some development environments atleast -- ...
    Sep 14, 2010 at 4:07 pm
    Sep 15, 2010 at 12:37 pm
  • What was his tweet? -- http://www.freelists.org/webpage/oracle-l
    Scott SibertScott Sibert
    Sep 14, 2010 at 1:03 pm
    Sep 14, 2010 at 2:16 pm
  • Hi, we need as straightforward, (fewest moving parts) repeatable method to do this. So the mviews... and all that is going to be much too messy - we have about 50 databases 500gb, the outage could be ...
    Sep 3, 2010 at 1:10 am
    Sep 3, 2010 at 3:03 pm
  • What error number is it using? I believe ORA-006xx errors get written to alert log more or less automatically (but you shouldn't be using them for user exceptions, which start at 20000). You can ...
    Nigel ThomasNigel Thomas
    Sep 1, 2010 at 1:52 pm
    Sep 1, 2010 at 3:32 pm
  • Thanks for your suggestions. 15-20 mins downtime is acceptable. I couldn't find any whitepapers on transportable tablespace for upgrade. There was one in OTN, however the link is broken or the ...
    Upendra NUpendra N
    Sep 1, 2010 at 4:27 am
    Sep 1, 2010 at 5:45 am
  • The reason we are thinking about using Fast Start Failover with DataGuard is, some of our database we plan to move to DAS (locally in the machine) instead of SAN; But then we will need some sort of ...
    Sep 30, 2010 at 5:34 am
    Sep 30, 2010 at 2:39 pm
  • You've no doubt by now heard of the 'Oracle Enterprise Kernel' for linux. (I think I got that right) You may have also seen some of the bashing of it in the press. This however is quite interesting ...
    Jared StillJared Still
    Sep 29, 2010 at 3:37 pm
    Sep 30, 2010 at 1:18 am
  • "Never mind" (unless you know something more useful). It seems that this is essentially new marketing hype wrapped around previously existing (old) functionality - at least from the database level ...
    Don GranamanDon Granaman
    Sep 28, 2010 at 9:50 pm
    Sep 28, 2010 at 10:55 pm
  • Hello, We are considering dataguard for moving a cluster database from one hardware environment to another using v10.2; there will not be any change to Oracle version. The idea is to minimize the ...
    Ram RamanRam Raman
    Sep 27, 2010 at 7:38 pm
    Sep 27, 2010 at 8:12 pm
  • We're in the process of setting up a DR facility and wanted to solicit opinions on the Oracle software install for both RAC and non-RAC systems, in terms of whether or not they should be on the SAN ...
    Dubovecky, JeffDubovecky, Jeff
    Sep 27, 2010 at 2:07 pm
    Sep 27, 2010 at 3:57 pm
  • Ello everyone! Just a little pro-active research here...:) The boss is investigating and would like to test building our OEMGC on a VM, (VMWare, paid version 4 or they are researching the free ...
    Kellyn PedersenKellyn Pedersen
    Sep 24, 2010 at 3:56 pm
    Sep 24, 2010 at 7:57 pm
  • All, is there anywhere in the web where I can watch Larry Ellison's wednesday keynote. thanks in advance Kp -- http://www.freelists.org/webpage/oracle-l
    K RK R
    Sep 24, 2010 at 4:29 am
    Sep 24, 2010 at 6:32 am
  • Digite um texto ou endereço de um site ou traduza um documento.<http://translate.google.com.br/?tr=f&hl=pt-BR Cancelar <http://translate.google.com.br/?tr=t&hl=pt-BR Ouvir Hello Friends, I have an ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Sep 23, 2010 at 12:34 am
    Sep 23, 2010 at 7:53 am
  • Need some guidance on memory config in 11g. Is this a failure/bug of AMM? The db runs fine if I set a shared_pool_size. system conf: Oracle Database 11g Enterprise Edition Release - 64bit ...
    Ray StellRay Stell
    Sep 21, 2010 at 6:30 pm
    Sep 22, 2010 at 1:54 pm
  • G'day. I don't seem to be able to find an answer to this: Oracle physical standby database on Solaris 10 64bit, SPARC. The v$archive_gap view does not have any entries, but the alert logs ...
    De DBADe DBA
    Sep 22, 2010 at 12:51 pm
    Sep 22, 2010 at 12:56 pm
  • Hi all I have a database running in in Linux, while I was doing some query testing I found a query as following with the execution plan and execution statistics: select a.* from impacts a ...
    LS ChengLS Cheng
    Sep 22, 2010 at 12:14 am
    Sep 22, 2010 at 12:56 am
  • Hi All, we're currently testing upgrade to on Linux x86-64 and I'm going through any bugs that might affect us. I've tried to explain the problem I have on ...
    Adrian angelovAdrian angelov
    Sep 17, 2010 at 2:52 pm
    Sep 17, 2010 at 4:34 pm
  • Have worked on a Peoplesoft 9 implementation on on the Oracle Database Machine. The site has been live for the past 2 months  It is one of the presentations at Open World (if memory ...
    Fairlie regoFairlie rego
    Sep 16, 2010 at 10:36 pm
    Sep 17, 2010 at 1:16 pm
  • This has been a Tom Kyte maxim for a few quite some time. I'm wondering if it still holds true between PL/SQL and Java. Do it in SQL. If SQL can't do it, do it in PL/SQL. If PL/SQL can't do it, do it ...
    Brady, MarkBrady, Mark
    Sep 16, 2010 at 9:42 pm
    Sep 17, 2010 at 12:53 am
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" Have you considered using the DBMS_REDEFINITION package? On 9/14/2010 12:06 PM, Thomas A. La Porte wrote: Greetings, all. SQL select ...
    Tim GormanTim Gorman
    Sep 14, 2010 at 8:55 pm
    Sep 15, 2010 at 12:58 pm
  • If you have create any procedure privilege or alter any procedure/view etc, you could create a procedure that selected all invalid objects and recompiled them., this would work for objects except ...
    Kenneth NaimKenneth Naim
    Sep 9, 2010 at 12:16 am
    Sep 9, 2010 at 6:35 pm
  • Hello, I am looking around in a new install and I've noticed that the install seems to have created too many threads and corresponding redo logs. We use a 7-node cluster and I see 13 public threads ...
    Martin BrownMartin Brown
    Sep 8, 2010 at 5:48 pm
    Sep 8, 2010 at 8:54 pm
  • Hi, We have 10g Dataguard setup(primary database and one physical standby database(DR) ) We are facing frequently network issue in primary site.During this time we are not able to login to primary ...
    Sep 8, 2010 at 3:47 am
    Sep 8, 2010 at 1:16 pm
  • Interesting, I hadn't considered that, but it makes sense. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com ...
    Jared StillJared Still
    Sep 2, 2010 at 5:56 pm
    Sep 8, 2010 at 5:30 am
  • Hi Jeffery, We are on Release Thanks, Achutha Shivashankar -- http://www.freelists.org/webpage/oracle-l
    Avadhani mysAvadhani mys
    Sep 3, 2010 at 10:33 am
    Sep 7, 2010 at 3:44 am
  • Not to belittle the concerns of your co-workers, but given the degree of control one has over directory objects (where they are, who can access them, etc), I would be far more worried about the ...
    John PiwowarJohn Piwowar
    Sep 1, 2010 at 7:36 pm
    Sep 3, 2010 at 10:31 am
  • Hi folks, I have a RAC env running on VMWare for lab experiences at home. But I am considering make a copy to another network which the netmaks is different, so I wanted to change the IPs along ...
    Alex OctanAlex Octan
    Sep 2, 2010 at 3:44 am
    Sep 2, 2010 at 3:55 am
  • Hello List, This is 64-bit on RHEL 5.1 x86_64. I have a small PL/SQL procedure which is using the "wrong" index. The SQL only does this within the procedure - I cannot replicate the issue ...
    Sep 1, 2010 at 3:11 pm
    Sep 2, 2010 at 3:28 am
  • Hi, Java developer can provide value in code (if code change is an option) using Java Properties when creating JDBC connection: prop.put("v$session.process", clientProcess) ...
    Igor RacicIgor Racic
    Sep 30, 2010 at 4:53 pm
    Sep 30, 2010 at 4:53 pm
  • I was just talking about this at OpenWorld. I'm getting increasingly frustrated with Oracle (and other folks are getting frustrated too). Oracle needs to fix their broken licensing model. For the ...
    Jeremy SchneiderJeremy Schneider
    Sep 30, 2010 at 3:57 pm
    Sep 30, 2010 at 3:57 pm
  • I totally get it when standalone but for RAC? If i have a FRA of say 50g, and 2 node RAC, since that parm must be set to same for all instances, does it make sense to say set it to 20G? is that the ...
    Sep 30, 2010 at 11:47 am
    Sep 30, 2010 at 11:47 am
  • Hallo, I have following lock problem. JDBC session hangs with 'select for update' on the local table with ' enq: TX - row lock contention'. After 1 minute (distributed_lock_timeout) session gets ...
    Petr NovakPetr Novak
    Sep 30, 2010 at 9:57 am
    Sep 30, 2010 at 9:57 am
  • $ echo "`hostname` has `kstat cpu_info | grep core_id | uniq | wc -l` cores" db1 has 32 cores anyone who is familiar with the system knows the core/socket for a given server model:); The auditor has ...
    Sep 30, 2010 at 5:14 am
    Sep 30, 2010 at 5:14 am
  • Hmm, I'll give that a try. My arraysize is set to 5000. I can certainly try even larger. The connection is local, not over SQL*Net. Thank you for responding! Mark -- ...
    Mark StricklandMark Strickland
    Sep 30, 2010 at 3:26 am
    Sep 30, 2010 at 3:26 am
Group Navigation
period‹ prev | Sep 2010 | next ›
Group Overview
grouporacle-l @

110 users for September 2010

Andrew Kerber: 10 posts Niall Litchfield: 9 posts : 8 posts Amonte: 6 posts Yong Huang: 5 posts De DBA: 4 posts D'Hooge Freek: 4 posts Jared Still: 4 posts Kellyn Pedersen: 4 posts Matthew Zito: 4 posts Pavel Ermakov: 4 posts Hemant K Chitale: 3 posts Kerry Osborne: 3 posts Mark W. Farnham: 3 posts Michael Dinh: 3 posts Ray Stell: 3 posts Stefano Cislaghi: 3 posts Tim Gorman: 3 posts Allen, Brandon: 2 posts Andreas Piesk: 2 posts
show more