Search Discussions

85 discussions - 499 posts

  • Hi all, I need to convince a client that they dont need restart their Oracle db (and their Windows server) every night. Can anyone send me: select to_char(min(logon_time),'DD/MM/YYYY HH24:MI:SS') ...
    Connor McDonaldConnor McDonald
    Sep 13, 2012 at 4:33 am
    Sep 18, 2012 at 2:43 am
  • Wish I could but recovering and on disability not this year:[ sent from my Windows Phone Bill"shrek" thater Oracle DBA <span class="m_body_email_addr" title="68b2b4f024161c3a109da7ed0970c1cf" ...
    Bill thaterBill thater
    Sep 18, 2012 at 4:08 pm
    Sep 24, 2012 at 8:42 pm
  • Hi all, I'm facing with a nice (at least for me) exercise of performance and tuning. I have an OLTP system must process each transaction in no more than 2 seconds. A transaction is not a single query ...
    Stefano CislaghiStefano Cislaghi
    Sep 3, 2012 at 8:04 pm
    Sep 10, 2012 at 2:32 pm
  • Hello everybody, I have a function based index but the CBO is not using it. The DML that I expect to have a plan with index range scan is doing a FTS. Its a simple DML that deletes 1000 rows at a ...
    Purav ChovatiaPurav Chovatia
    Sep 9, 2012 at 6:36 pm
    Sep 20, 2012 at 10:22 pm
  • Being on enforced retirement and going stir-crazy:] I was looking for opinions on what language I should teach myself and resources to do so Thanks sent from my Windows Phone Bill"shrek" thater ...
    Bill thaterBill thater
    Sep 19, 2012 at 11:39 pm
    Sep 22, 2012 at 2:54 pm
  • I was getting ready to toss the message below in a bottle out to Oracle-L when Oracle support came through and I held off for a few days. See "problem statement" below for setup. Outcome... + They ...
    Tornblad, JohnTornblad, John
    Sep 25, 2012 at 6:27 pm
    Sep 27, 2012 at 6:38 pm
  • In a single node Grid Infrastructure install (used for ASM for Single Instance DB), how do you backup the OLR ? Is there a Cluster Registry to backup ? How do you backup the ASM SPFILE (how would it ...
    Hemant K ChitaleHemant K Chitale
    Sep 19, 2012 at 3:42 am
    Nov 25, 2012 at 2:06 pm
  • Anyone use an AWR report generator with graphs/charting? Any suggestions for one? I need to generate a report of the database performance (much like Grid Control does for current period) for a ...
    Christopher Taylor2Christopher Taylor2
    Sep 6, 2012 at 7:08 pm
    Sep 7, 2012 at 8:32 pm
  • We have High CPU Utilization on compute nodes of our Exadata. As we migrate more applications to our Exadata environment, we are going to run out of CPU capacity. When talking about capacity, we have ...
    Q A I S E RQ A I S E R
    Sep 2, 2012 at 4:44 pm
    Sep 5, 2012 at 8:33 pm
  • We have some dss type reports that run on this 10g RAC database using ASM and raw devices and I have created a schema logon trigger to set some session parameters for the report login. I'm curious if ...
    Christopher Taylor2Christopher Taylor2
    Sep 23, 2012 at 8:46 pm
    Sep 26, 2012 at 12:09 pm
  • (apologies for bad formatting - I'm trying to keep it simple tho) (pastebin is blocked, but used gist https://gist.github.com/3751878) 3-node RAC We had a "hang" last night from 2:50 to ...
    Christopher Taylor2Christopher Taylor2
    Sep 19, 2012 at 8:02 pm
    Sep 19, 2012 at 10:39 pm
  • Hi: We have a table which has 17 varchar2 columns. Each varchar2 column has different bind variable ranges. for example varchar2(4000) has 4 ranges: 0-32,33-128,129-2000,2001-4001. if the bind ...
    Eagle FanEagle Fan
    Sep 12, 2012 at 6:32 am
    Sep 17, 2012 at 7:16 am
  • Congrats to Oracle on the 12c install proc. The last time I looked at an oem install it was a nightmare on elm street. Is there a good document that explains the care and feeding of 12c for the ...
    Ray StellRay Stell
    Sep 24, 2012 at 2:58 pm
    Sep 26, 2012 at 4:53 pm
  • Anyone every run Oracle and SQL server together on the same physical box? Do they play well with each other or have both secretly embedded hacking code to look for the other and sabatoge it...lol. -- ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Sep 18, 2012 at 12:03 pm
    Sep 19, 2012 at 12:46 pm
  • (Thanks to Jonathan Lewis, Greg Rahn (and others) I've been learning a lot about tweaking the execution paths for a particular problematic SQL. A special thank you to you guys for all the blog posts ...
    Christopher Taylor2Christopher Taylor2
    Sep 13, 2012 at 8:34 pm
    Sep 16, 2012 at 10:38 am
  • Hi All, I am trying to drop a datafile which is empty and contains no extent and is not the first datafile of the tablespace either. I am getting the following error when I execute the drop command ...
    Hameed, AmirHameed, Amir
    Sep 5, 2012 at 2:36 pm
    Sep 6, 2012 at 11:07 am
  • I'm looking for anyone going to OpenWorld who has some experience with RAC. Can you hang out with me for one hour to help some of our peers get a two-node cluster going on their laptop? We did this ...
    Jeremy SchneiderJeremy Schneider
    Sep 13, 2012 at 2:22 pm
    Sep 21, 2012 at 5:28 pm
  • We have ORACLE database on ORACLE when I use "sqlplus" login and get warning: Enter user-name: user1 Enter password: ERROR: ORA-28002: the password will expire within 1 days I double check ...
    Dba1 mccDba1 mcc
    Sep 4, 2012 at 3:36 pm
    Sep 7, 2012 at 4:29 am
  • Working on moving a 9i database over to 11g. I can easily do a full import to bring everything over, but, I only have 4 schemas that contain my application tables and such. So, what is the benefit of ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Sep 4, 2012 at 5:16 pm
    Sep 6, 2012 at 12:23 pm
  • FYI This may be interesting to this list. (Note, don't work with RIM, just came across it and thought this may be a better place for it) ...
    William MuriithiWilliam Muriithi
    Sep 19, 2012 at 12:58 pm
    Sep 20, 2012 at 5:24 pm
  • G'day! I've got a production database (9i) running on an old server A in the "Production" data centre, a new 11g database on server B in the "DR" data centre and an active dataguard standby on server ...
    De DBADe DBA
    Sep 18, 2012 at 12:06 pm
    Sep 19, 2012 at 3:42 pm
  • I am a little confused. Red Hat Linux 5.6 Physical standby database Real time apply Archive_dest_state_2 = SERVICE=<sid _stby NOAFFIRM ASYNC VALID_FOR=(ALL_LOGFILES, PRIMARY_ROLE) ...
    Sweetser, JoeSweetser, Joe
    Sep 21, 2012 at 4:30 pm
    Oct 3, 2012 at 12:30 pm
  • More specifically objects that depend on db_links, and if those db_links are bad, it seems to take forever for compilation process. Is there a trick/setting/event/parameter to say, if link is not ...
    Sep 5, 2012 at 3:08 pm
    Sep 5, 2012 at 7:37 pm
  • Hi people, Recently I am facing a problem with fragmentation. A supplier is arguing that the way we did a restore using RMAN with multiple channels is causing many fragmentation on the database, and ...
    Alex CwbAlex Cwb
    Sep 3, 2012 at 7:26 pm
    Sep 4, 2012 at 9:42 pm
  • Hi DBA gurus, I know we should synchronize time on all rac nodes with NTP. Time difference between RAC nodes could have impact on data integrity. It is good if we can be notified if one of the RAC ...
    Lu JiangLu Jiang
    Sep 18, 2012 at 10:58 pm
    Sep 25, 2012 at 4:16 am
  • I have a DB Server that's currently running Win 2003 SP2 32-bit and Oracle We're moving the machine to a new physical location - well, actually, it's a new machine that we're going to copy ...
    Steve WalesSteve Wales
    Sep 18, 2012 at 12:43 am
    Sep 18, 2012 at 1:42 pm
  • Hi, RAC - 4 node we are facing "gc buffer busy acquire waits" in our database intermittently. This is an OLTP system. we are getting lot of blocking on our system. for example: 54 seconds ...
    Sep 17, 2012 at 1:27 am
    Sep 18, 2012 at 10:29 am
  • Hi all, We've a Oracle 10gR2 environment on AIX 6.1. I'm seeing a lot of buffer buisy waits and mostly on data segment headers. When I try to add more freelists to the buisy segments, it doesnt let ...
    Saad KhanSaad Khan
    Sep 16, 2012 at 8:01 pm
    Sep 18, 2012 at 9:11 am
  • Hi, I am trying to find the good candidate / objects for reorg in SAP databases. We are planning to do, We are planning to do weekly reorg, monthly once and every six month once. Accordingly we need ...
    Raja SubramaniyanRaja Subramaniyan
    Sep 7, 2012 at 10:49 am
    Sep 13, 2012 at 7:28 pm
  • Oracle db Hi everyone, Problem: Our vendor, that we work kinda closely with to improve and/or make changes to, has coded an AFTER UPDATE trigger: DECLARE CURSOR wo_cur IS SELECT wo_id FROM ...
    Lyall BarbourLyall Barbour
    Sep 12, 2012 at 6:47 pm
    Sep 13, 2012 at 1:33 pm
  • We have a bit of a mystery here.... We just migrated 2 Oracle 10g databases to 11g on 2 new servers. Everything looks good, except that we're getting ORA-03137 errors in one of the databases. I spent ...
    Maureen EnglishMaureen English
    Sep 24, 2012 at 2:54 pm
    Sep 28, 2012 at 12:21 pm
  • My oracle database name(SID) is ORCL However in order to make it easier to support a customer I would like to be able to refer to the same database in my JDBC string as e.g. JOHNTEST rather than ORCL ...
    John DunnJohn Dunn
    Sep 24, 2012 at 12:27 pm
    Sep 26, 2012 at 3:11 pm
  • For those of you that have set plsql_code_type to native, I have a few questions: - Why did you set the parameter - Was there a noticeable change in performance - Did you have any issues as a result ...
    Jeffrey BeckstromJeffrey Beckstrom
    Sep 25, 2012 at 3:17 pm
    Sep 26, 2012 at 7:01 am
  • Hello Friends, I have a doubt related to EXCEPTION. SQL SQL DECLARE 2 x number := 0; 3 y number := 100; 4 BEGIN 5 y := y / 0; 6 exception 7 when ZERO_DIVIDE then 8 dbms_output.put_line ('erro 1: ' || ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Sep 22, 2012 at 7:55 pm
    Sep 25, 2012 at 11:22 am
  • on Linux 5 Any idea why the procedure fails when joining 2 tables? admin@DB create table cs_t1(c1 number); Table created. admin@DB create table cs_t2(c1 number); Table created. admin@DB ...
    Stephens, ChrisStephens, Chris
    Sep 19, 2012 at 7:18 pm
    Sep 19, 2012 at 7:43 pm
  • Oracle Application Server on RHEL 4 Once in a while, users get error "REP-0178: Cannot connect to Reports Server ..." when trying to create a report. Whenever this happens, I notice that the ...
    Yong HuangYong Huang
    Sep 4, 2012 at 9:13 pm
    Sep 15, 2012 at 7:41 am
  • Hi all My experience with RAC 9i is limited and almost cero wrunning this in AIX HACMP. Does anyone know when instance crashes or listener dies for any reason do they get restarted by AIX HACMP? ...
    Ls ChengLs Cheng
    Sep 10, 2012 at 12:53 pm
    Sep 11, 2012 at 3:52 pm
  • Hi All, I am trying to implement SSO using OID. I am running oracle linux version 6. RDBMS version I have ran RCU and installed and configured weblogic. Now I am Installing Oracle Fusion ...
    Harshan eppuramHarshan eppuram
    Sep 28, 2012 at 10:11 am
    Oct 2, 2012 at 7:58 pm
  • All, I was importing a small database into a 11.2 database. It took a while, I realized it was taking too long to build the indexes after importing the rows of some big tables. I remember in older ...
    Orlando LOrlando L
    Sep 25, 2012 at 6:58 pm
    Sep 25, 2012 at 7:44 pm
  • Hello All, Until Oracle 9i I have used dbms_stats package to generate statistics. But I heard that we don't need to generate the statistics manually since it is done automatically. Could anyone ...
    Mandal, AshokeMandal, Ashoke
    Sep 21, 2012 at 3:36 am
    Sep 25, 2012 at 9:58 am
  • We have a bit of a mystery here.... We just migrated 2 Oracle 10g databases to 11g on 2 new servers. Everything looks good, except that we're getting ORA-03137 errors in one of the databases. I spent ...
    Maureen EnglishMaureen English
    Sep 24, 2012 at 3:01 pm
    Sep 25, 2012 at 5:46 am
  • Hi list, I'm trying to figure out the exact formula Oracle uses when computing the index key length (for non-FBI and FBI with NLSSORT), and I think I'm stuck pretty close, so any help would be ...
    Buboi AdrianBuboi Adrian
    Sep 18, 2012 at 9:28 am
    Sep 18, 2012 at 3:04 pm
  • Hi, I need help on resolving wait events on our AIX 6.1 box, Oracle DB with non-RAC. We are seeing lot of CF contention, HW contention and control file parallel write waits in the AWR ...
    Sep 18, 2012 at 7:30 am
    Sep 18, 2012 at 9:32 am
  • Hi List, I tried to check if I can 'guess' the existence of an object by v$mystat. Here is my test case - comments and questions are inline as comments (I removed the SQL prompt so a cut&paste should ...
    Martin BergerMartin Berger
    Sep 14, 2012 at 8:13 pm
    Sep 16, 2012 at 6:52 am
  • Trying to figure out why there are 2 'nested loops' and a 'hash unique' steps in this xplan. This is how am reading it. 1) access table_02 to get rowset matching time stamp (step 5) 2) For each row ...
    Fuad HabashFuad Habash
    Sep 13, 2012 at 2:34 pm
    Sep 14, 2012 at 2:49 pm
  • Oracle on AIX 6.1 Can anybody see anything wrong with the following query. I've ran it from within SQLPLUS and it runs pretty quickly for me...(about 3secs).. Can't see anything wrong with ...
    Zabair AhmedZabair Ahmed
    Sep 12, 2012 at 4:42 pm
    Sep 12, 2012 at 6:31 pm
  • Is there any special consideration when looking at Starts,E-Rows and A-Rows for Partitioned Tables when using dbms_xplan? In the example below, there is an organization table that returns 17 ...
    Christopher Taylor2Christopher Taylor2
    Sep 10, 2012 at 3:58 pm
    Sep 11, 2012 at 7:37 am
  • Resend: Indeed, the PL/SQL engine can be in Oracle forms or reports. I wish it offered something equivalent to dba_* and v$* views, an easy way to monitor its working mechanism. For now, I'll write a ...
    Yong HuangYong Huang
    Sep 7, 2012 at 5:40 pm
    Sep 7, 2012 at 10:06 pm
  • Hi, This is a 11.2 database with Automatic Memory Management with a memory_target and memory_max_target of 101GB. Looking at v$sga I see this: select name, value/1024/1024/1024 from v$sga / NAME ...
    Peter HitchmanPeter Hitchman
    Sep 5, 2012 at 4:51 pm
    Sep 5, 2012 at 8:43 pm
  • Hi all, OEL 5.8 64bit 2.6.32-300.10.1.el5uek GI (PSU July 2012) According to MOS Note 1408670.1 ACFS support for UEK 2.6.32-300 will be in GI PSU (we have PSU). This ...
    Radoulov, DimitreRadoulov, Dimitre
    Sep 4, 2012 at 5:36 pm
    Sep 4, 2012 at 7:29 pm
Group Navigation
period‹ prev | Sep 2012 | next ›
Group Overview
grouporacle-l @

147 users for September 2012

Christopher Taylor2: 36 posts Jonathan Lewis: 21 posts Kellyn Pot'Vin: 13 posts Mark W. Farnham: 13 posts Purav Chovatia: 13 posts Radoulov, Dimitre: 13 posts Rjamya: 12 posts Ls Cheng: 11 posts Martin Klier: 11 posts Yong Huang: 10 posts kyle Hailey: 9 posts Patterson, Joel: 8 posts Storey, Robert (DCSO): 8 posts Tanel Poder: 8 posts Tim Gorman: 8 posts De DBA: 7 posts Jeremy Schneider: 7 posts Martin Berger: 7 posts Michael Schmitt: 7 posts Tornblad, John: 7 posts
show more