FAQ

Oracle > oracle-l > February 2014

Search Discussions

87 discussions - 610 posts

  • Greetings, As you all know, Steve Adams has been the owner of the Oracle-L mailing list for many years. As you may also be aware, Steve has taken a step back from activity on the list, as well as ...
    Mark BobakMark Bobak
    Feb 7, 2014 at 1:40 pm
    Mar 5, 2014 at 11:51 pm
  • Hi List If you work in a security conscious environment, I'd be keen to hear how your site handles the root.sh script. To give you some background: In my environment, DBAs are currently given direct ...
    Austin HackettAustin Hackett
    Feb 3, 2014 at 5:09 pm
    Feb 19, 2014 at 4:17 am
  • Hello List, I have a project that is going to get started soon and i wanted to get some Pointers with regards to it. Please excuse my knowledge, as i am from SQL Server background and a seasonal ...
    Max scalfMax scalf
    Feb 12, 2014 at 8:55 pm
    Mar 27, 2014 at 11:02 pm
  • The email thread about the transition of the group and how Steve is gradually pulling out from the group and Oracle practice made me think of this question. So, one has done Oracle for 20 or more ...
    Fred HabashFred Habash
    Feb 25, 2014 at 6:30 pm
    Apr 2, 2014 at 5:11 pm
  • I am curious how everybody handle database change control. I am not talking about just source control for your code but the process of moving changes into the database, like procedure changes, alter ...
    Jeff CJeff C
    Feb 25, 2014 at 4:26 pm
    Feb 27, 2014 at 4:57 pm
  • http://www.linkedin.com/profile/view?id=1817118 Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Sr Oracle DBA at Pythian Pythian Blog http://www.pythian.com/blog/author/still/ Oracle ...
    Jared StillJared Still
    Feb 11, 2014 at 4:30 pm
    Feb 19, 2014 at 12:14 am
  • Hi Group, We are asked to implement a database backup policy so that the state of database can be resurrected to any given point in time up to past 7 years. I have implemented the classic approaches ...
    Paresh YadavParesh Yadav
    Feb 13, 2014 at 4:56 pm
    Feb 17, 2014 at 1:38 am
  • Dear Experts, I have a table with 200 columns and having above 1000 Records. But for a particular where clause, there is only 3 records fetched. As the table having 200 columns, but the particular 3 ...
    Raja Kannan SengodenRaja Kannan Sengoden
    Feb 17, 2014 at 4:39 am
    Feb 18, 2014 at 5:28 pm
  • I'm running a dbms_stats.gather_schema_stats job thru a unix job and it runs for a while then fails with a ORA-01013: user requested cancel of current operation I didn't cancel the job so why is this ...
    Zelli, BrianZelli, Brian
    Feb 20, 2014 at 8:35 pm
    Feb 26, 2014 at 1:48 pm
  • 11.2.0.4 RAC on Oracle Linux 6. Right now I'm battling an unbelievably slow export but imports seem unreasonably slow as well. This occurs in two different RAC environments. I have a ticket open with ...
    Stephens, ChrisStephens, Chris
    Feb 14, 2014 at 9:01 pm
    Feb 17, 2014 at 2:32 pm
  • Hi... I have a database view that needs has a select-list item something like this: SELECT ... , ADD_MONTHS(po_date, xxcust_profiles_pkg.get_profile_value('LEADTIME_MONTHS')) eta_date, ... FROM ...
    McPeak, MattMcPeak, Matt
    Feb 5, 2014 at 9:33 pm
    Feb 6, 2014 at 5:48 pm
  • Is it possible to Purge the RECYCLEBIN by age ? --- e.g. remove those objects that were DROPped 7 days ago. That way, a periodic cleanup of the RECYCLEBIN can be done and yet objects may be available ...
    Chitale, Hemant KChitale, Hemant K
    Feb 18, 2014 at 9:18 am
    Feb 24, 2014 at 12:14 pm
  • I have a process that executes a lot. Over 6 days it's executed 1.3 million times. The elapsed time per call averages 0.8 seconds, and the I/O wait time per call averages 0.7 seconds. In other words, ...
    McPeak, MattMcPeak, Matt
    Feb 18, 2014 at 5:25 pm
    Feb 19, 2014 at 3:26 pm
  • Everyone We have table with lot of insert/update/delete every day. High OLTP application in 11g R2 on Linux. To gain performance my teammate recommend Rebuild index. His assumption Index size should ...
    Karth PanchanKarth Panchan
    Feb 28, 2014 at 12:15 pm
    Mar 3, 2014 at 8:22 am
  • I do not think items and #1 and #3 are an issue since I have worked on systems like that, but I am not sure about item #2, "no shell." What exactly does that mean? -----Original Message----- From ...
    Powell, MarkPowell, Mark
    Feb 26, 2014 at 8:46 pm
    Feb 27, 2014 at 4:48 pm
  • Good afternoon everyone. Trying to work through a process where I can make a copy of our prod standby (plus archivelogs) and have it stand up as a new dev database. We have the process working but ...
    Don SeilerDon Seiler
    Feb 7, 2014 at 9:54 pm
    Feb 10, 2014 at 11:34 pm
  • Hey all, So I'm looking at a shrinking downtime window for an 11.2.0.3.x- 11.2.0.3.8 (both EE) production DB move/reconfigure across two systems with only 1Gb network connecting them. The move is ...
    Rich JesseRich Jesse
    Feb 6, 2014 at 7:36 pm
    Feb 7, 2014 at 3:52 am
  • Hi list, (I'm in 11.2.0.3/11.2.0.4EE @ RH5.8 env right now) I try to investigate if a session with STATUS=INACTIVE has a statement "in execution" (and maybe get more informations about it). to make ...
    Martin BergerMartin Berger
    Feb 19, 2014 at 11:21 am
    Feb 20, 2014 at 11:42 am
  • 12.1.0.3 EM12c monitoring 11.2.0.4 RAC on Oracle Linux 6. I've got a monitoring template for Target Type = Database Instance. In it I have the "Incident" metric class upload interval set to Every 5 ...
    Stephens, ChrisStephens, Chris
    Feb 26, 2014 at 3:15 pm
    Feb 28, 2014 at 11:16 am
  • Hi list, I had applied latest PSU on our two node RAC environment 11.2.0.3 on AIX. But I applied it only the database part so the clusterware/ASM part is still left. Do you think I should apply that ...
    Saad KhanSaad Khan
    Feb 28, 2014 at 4:32 pm
    Mar 7, 2014 at 5:15 pm
  • Hi, I have been asked what a process on Monday (2/24) timed out. Going to DBA_HIST_ACTIVE_SESS_HISTORY, I can see that the process in question spent all its time waiting for a library cache pin. I ...
    McPeak, MattMcPeak, Matt
    Feb 26, 2014 at 7:40 pm
    Feb 27, 2014 at 12:28 am
  • Hello All, I am using oracle 11gr2 on windows server 2008. This is a test system.Stats are current and archivelog is turned off temporarily. I am trying to update a table that has over 1.1 million ...
    Praveen RamananPraveen Ramanan
    Feb 26, 2014 at 4:01 am
    Feb 26, 2014 at 2:56 pm
  • Hi , I run into deadlock when one session is dropping Foreign key from a table while other session is inserting into the same table. Is there any safe trick to avoid deadlock ?! Im already using ...
    VasuVasu
    Feb 25, 2014 at 5:28 pm
    Feb 25, 2014 at 8:41 pm
  • Hi All, We probably train 3-4 juniors per year. Our success rate is under 40%. The problem is the mindset. Our basic rule is before you do anything you must know "How am I going to return to where I ...
    Dave MorganDave Morgan
    Feb 10, 2014 at 4:58 pm
    Feb 17, 2014 at 3:42 pm
  • Question for the SQL experts ... I need to calculate a value and then use it many times as a criterion for other selections. What is the best way to do that in Oracle SQL? For example, I need to ...
    William ThrelfallWilliam Threlfall
    Feb 21, 2014 at 5:11 pm
    Feb 22, 2014 at 2:28 pm
  • 11.2.0.3.7 on OEL 6, in case that matters. We've been looking into partitioning some large tables (5 trillion rows, 1TB) so that we can better manage them (drop old data, &c.). Right now I'd say ...
    Uzzell, StephanUzzell, Stephan
    Feb 11, 2014 at 4:04 pm
    Feb 12, 2014 at 3:31 am
  • My google skills are not quite up to the challenge: is there a DBA_ (or other) view that shows whether an index is local or global? Anything quicker than dbms_metadata to grab the DDL to figure this ...
    Uzzell, StephanUzzell, Stephan
    Feb 3, 2014 at 9:11 pm
    Feb 6, 2014 at 12:35 pm
  • Hi experts, We've a system with Oracle 11.2.0.1 on windows 2003 server. My other DBA has just informed me of one of the problems they are facing. A couple of days back they turned on the following ...
    Saad KhanSaad Khan
    Feb 4, 2014 at 3:32 pm
    Feb 5, 2014 at 7:02 pm
  • Redhat 6 64 bit 11.2.0.4 clusterware install xming run on laptop I have to get behind a firewall, so I go to a specified unix server and then execute ssh -X oracle@<IP In putty I use x11 forwarding x ...
    Dba DBADba DBA
    Feb 20, 2014 at 9:49 pm
    Feb 20, 2014 at 10:57 pm
  • What are some of the reports that you generate for your upper management on a weekly, monthly, etc basis? What do use to generate these reports? Manually put data in Excel or use Enterprise Manager? ...
    Jeff CJeff C
    Feb 3, 2014 at 4:31 pm
    Feb 4, 2014 at 10:24 am
  • Dear oracle-l'ers, I had my #WTF moment today when I tried to import a dump that was exported with metadata only with the intention to cram this into a much smaller development DB. Export came from ...
    Uwe KüchlerUwe Küchler
    Feb 27, 2014 at 6:27 pm
    Feb 28, 2014 at 6:53 pm
  • Oracle 11.2 Redhat 5 I've been using the same procedure to create a standby for years yet now I find the rman restore controlfile command on the new standby server are writing to the primary server ...
    Howard LathamHoward Latham
    Feb 20, 2014 at 5:33 pm
    Feb 21, 2014 at 2:26 pm
  • Hi I passed Oracle SQL Expert. I work 5% of my job with SQL but I am searching for a full time SQL job. http://shop.oreilly.com/product/0790145363466.do Is the Excel exam (Microsoft Office Specialist ...
    Lukas LehnerLukas Lehner
    Feb 18, 2014 at 7:46 pm
    Feb 19, 2014 at 11:08 am
  • What are you rules for using database links in a production application? We currently have an application that needs data from another database and I am torn between having them just use a database ...
    Jeff CJeff C
    Feb 17, 2014 at 3:48 pm
    Feb 18, 2014 at 2:46 pm
  • Hi, I need to delete 2 of the 3 triplicates i found in a table. Anyone have an easy way to do that? Oracle 10.2.0.2 table has two columns, the ID that has triplicates in it and a date column (sysdate ...
    Lyall BarbourLyall Barbour
    Feb 7, 2014 at 4:31 pm
    Feb 9, 2014 at 1:43 am
  • Has anyone done GoldenGate or Logical Standby setup for an *entire* Peoplesoft (Financials) Schema ? Peoplesoft doesn't have PK and FK definitions and Referential Integrity constraints. Would GG / LS ...
    Chitale, Hemant KChitale, Hemant K
    Feb 26, 2014 at 3:06 am
    Mar 4, 2014 at 9:50 am
  • Hi all, source and target environment: RHEL 5.8 RAC EE 11.2.0.2 on ASM We've been asked to move a multi-terabyte DWH two-node RAC database from one datacenter to another. The database is currently in ...
    Radoulov, DimitreRadoulov, Dimitre
    Feb 26, 2014 at 9:59 pm
    Feb 28, 2014 at 8:36 am
  • Hi, An Oracle client install: Release 11.2.0.4.0 Then when a non dba user calls oraenv: "ORACLE_SID = [CLIENT_1] ? ORACLE_BASE environment variable is not being set since this information is not ...
    Peter HitchmanPeter Hitchman
    Feb 27, 2014 at 3:51 pm
    Feb 27, 2014 at 4:48 pm
  • Hi Listers, I have an issue with an execution plan (or with my brain, whatever direction you prefer :) ). The plan always snaps to a table access full, because the cardinality estimate for the ...
    Martin KlierMartin Klier
    Feb 24, 2014 at 1:08 pm
    Feb 26, 2014 at 4:29 pm
  • I have been doing some research on this topic & this is what I currently understand ... 1) Oracle allows 3 isolation levels, the default is READ_COMMITTED. 2) This default guarantees data consistency ...
    FmhFmh
    Feb 20, 2014 at 3:52 pm
    Feb 20, 2014 at 6:38 pm
  • Hi all, Just in case you've not come across it there's a potential gotcha when upgrading to 11.2.0.4. We hit it a couple of weeks ago and I believe it affects all platforms. The issue is caused by ...
    Chris DunscombeChris Dunscombe
    Feb 12, 2014 at 3:36 pm
    Feb 20, 2014 at 5:47 pm
  • For those of you that allow your users to create their own reports, what procedure is followed to validate the integrity of the user's reports? Jeffrey Beckstrom Database Administrator Information ...
    Jeffrey BeckstromJeffrey Beckstrom
    Feb 19, 2014 at 1:55 pm
    Feb 19, 2014 at 7:59 pm
  • I've asked bits about this before, but I feel like I finally have made some headway... And I think it points at the DB Link as the culprit in our performance issue. We managed to trace one of our ...
    Uzzell, StephanUzzell, Stephan
    Feb 19, 2014 at 6:34 pm
    Feb 19, 2014 at 7:27 pm
  • Dear all, I want to create Data guard physical standby but some of archive log are deleted from primary so my active database duplication failing. I tried to restore from backup but I can't.... log ...
    OutsiderOutsider
    Feb 6, 2014 at 2:34 pm
    Feb 7, 2014 at 6:09 pm
  • Hi Folks *NOTE : *I am not sure it is good to ask this question. But its very important for me understand at this point in time after one month job hunt experience in AUS market. I am planning to ...
    Sameer ChoudhariSameer Choudhari
    Feb 3, 2014 at 9:34 am
    Feb 3, 2014 at 2:15 pm
  • We are now taking on support of SQL Server as well as Oracle databases. Does anyone know of a SQL Server email list that is similar to <span class="m_body_email_addr" ...
    Terrian, Thomas J DLA CTR TRANSACTION SERVICESTerrian, Thomas J DLA CTR TRANSACTION SERVICES
    Feb 25, 2014 at 7:49 pm
    Feb 26, 2014 at 2:59 pm
  • Hi folks, We are looking to move a virtualized, memory and IO bound database from vmware to a physical machine with dedicated storage. We are considering the Oracle database appliance X4-2 (bare ...
    anthony Sanchezanthony Sanchez
    Feb 24, 2014 at 6:40 pm
    Feb 24, 2014 at 9:14 pm
  • Came across this MOS note How to Determine the SQL_ID of a SQL Statement in a PL/SQL Block (Doc ID 741724.1) As part of the note it goes on to say that "The SQL statement within the PL/SQL block is ...
    Rajendra PandeRajendra Pande
    Feb 24, 2014 at 2:12 pm
    Feb 24, 2014 at 3:02 pm
  • Hello List, I just wanted to get some ideas on a problem we have and a solution that we might put in place and see what the community think about it. RMAN backup with multiple versions/multiple OS We ...
    Max scalfMax scalf
    Feb 18, 2014 at 7:40 pm
    Feb 19, 2014 at 3:17 pm
  • Our security office is looking at having the McAfee Database Activity Monitor and McAfee Database Vulnerability Scanner installed on all of our Oracle and SQL Server databases and servers. This is ...
    Scott CanaanScott Canaan
    Feb 17, 2014 at 8:00 pm
    Feb 18, 2014 at 3:20 pm
Feb 2014
12
Group Navigation
period‹ prev | Feb 2014 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions87
posts610
users176
websiteoracle.com

176 users for February 2014

Jonathan Lewis: 22 posts Ric Van Dyke: 20 posts Mark W. Farnham: 18 posts Chitale, Hemant K: 16 posts David Fitzjarrell: 16 posts Chris Taylor: 13 posts Rich Jesse: 13 posts Niall Litchfield: 12 posts Max scalf: 11 posts McPeak, Matt: 10 posts Stephens, Chris: 10 posts Don Seiler: 9 posts Hans Forbrich: 9 posts Jared Still: 9 posts Jeff C: 9 posts Jinwen Zou: 9 posts Stojan Veselinovski: 9 posts Martin Berger: 8 posts Riyaj Shamsudeen: 8 posts Andy Klock: 7 posts
show more
Archives