Search Discussions

85 discussions - 446 posts

  • Hi List, I'm trying to use data pump to export and import from the AIX database to the LINUX database. The application is peoplesoft Finacial. The expdp take around 4 hours, the impdp take 7 hours ...
    Hsieh, JoanHsieh, Joan
    Jul 9, 2013 at 2:15 pm
    Jul 17, 2013 at 5:48 pm
  • I have come to the realization I've become a little too dependent upon Grid Control for giving me a "quick overview" of system performance. Those colorful graphs are like DBA crack ;) So let's say ...
    Christopher Taylor2Christopher Taylor2
    Jul 17, 2013 at 2:58 pm
    Jul 22, 2013 at 1:19 pm
  • Hi friends, I would like to know if ROWID is a unique identifier for : (1) -- a line in the table (2) -- a line in the database Regards Eriovaldo -- http://www.freelists.org/webpage/oracle-l
    Eriovaldo AndriettaEriovaldo Andrietta
    Jul 10, 2013 at 10:40 pm
    Jul 29, 2013 at 5:44 am
  • Hello Are there any changes on licensing Database 12c ? I just look at price list and processor core factor and it seems there are no changes. -- http://www.freelists.org/webpage/oracle-l
    Juan Cruz Miranda VigoJuan Cruz Miranda Vigo
    Jul 3, 2013 at 12:37 pm
    Jul 8, 2013 at 1:11 pm
  • Hello listers, today again, a question merely for understanding than for solving a current problem. DB-Version SE on Linux x86_64 select * from TABLE where QTY1 < QTY2; There are approx ...
    Martin KlierMartin Klier
    Jul 11, 2013 at 1:28 pm
    Jul 16, 2013 at 11:55 am
  • Dear listers, accessing v$active_session_history is quite slow when fetching data from a wide (time) window. What's best practice to get ash queries back with decent performance? For example, to find ...
    Martin KlierMartin Klier
    Jul 22, 2013 at 12:53 pm
    Jul 29, 2013 at 7:21 am
  • Gurus, Any quicker way to delete 30 million records (based on condition) from a table with 220 million records ? Any pointers greatly appreciated. Thank you all for your time. -- Bala Rao -- ...
    Jul 18, 2013 at 7:28 pm
    Jul 22, 2013 at 1:15 pm
  • Hello everyone, Trying to upgrade our Clusterware to and the OUI gui complains that connecting to the same server needs a password. I thought we had set this up when we installed 10g ...
    Lyall BarbourLyall Barbour
    Jul 25, 2013 at 8:24 pm
    Jul 29, 2013 at 4:30 am
  • To all who own/operate/manage a production Exadata environment... What platform do you use for dev/test/uat/load environments? Have you bought additional Exadata boxes for those environments? Is your ...
    Brady, MarkBrady, Mark
    Jul 16, 2013 at 9:22 pm
    Jul 17, 2013 at 5:54 pm
  • Hello everyone, We have a client on an 64-bit database on Windows server 2008. One of their vendors, using SQLSERVER, is having an intermittent issue connecting to the oracle database; their ...
    Joel SlowikJoel Slowik
    Jul 26, 2013 at 7:08 pm
    Jul 30, 2013 at 2:13 pm
  • Hi, We are having a discussion about the following: we have a set of tables, from these tables we need to have a snapshot of the table at 00:00:00 exactly (all the tables at the same time). Right now ...
    Guillermo Alan BortGuillermo Alan Bort
    Jul 29, 2013 at 4:00 pm
    Jul 29, 2013 at 11:07 pm
  • This is different from the standard logical/physical models that DBAs normally do. From what I can tell its a very high level picture of our data that maps it to business functions for upper ...
    Dba DBADba DBA
    Jul 23, 2013 at 7:18 pm
    Jul 24, 2013 at 12:23 am
  • Hi, I've been working with a customer for the past several months and they pretty much refuse to use DNS resolution for the hostnames of the database servers. I was not bothered by this since I ...
    Guillermo Alan BortGuillermo Alan Bort
    Jul 8, 2013 at 6:51 pm
    Jul 9, 2013 at 5:32 pm
  • Hello everyone, Install GI PSU patch with no problem on the first node. However, when I was applying this patch on the second node, after it indicated the patch completed successfully it ...
    Lu JiangLu Jiang
    Jul 27, 2013 at 10:32 am
    Jul 29, 2013 at 9:12 am
  • <div id="pt1:svMenu:np1" class="xdc xia It just seems to hang after that John www.jhdba.wordpress.com DBA Team Leader Wm Morrison Supermarkets PLC Tel 0845 611 4589 Mob: 07876 790540 E-mail: <span ...
    John HallasJohn Hallas
    Jul 22, 2013 at 9:33 am
    Jul 22, 2013 at 10:57 am
  • All, in a 3 node RAC . one of the node's listener is not registering the instance . i try deleing adding listener but still no help. appreciate any help thanks Kart -- ...
    K RK R
    Jul 18, 2013 at 7:24 am
    Jul 18, 2013 at 6:07 pm
  • I want to test a partition exchange as an alternative method of doing some work in the database. I was thinking about loading a global temporary table with the data and then doing the exchange ...
    Chris TaylorChris Taylor
    Jul 16, 2013 at 4:37 pm
    Jul 16, 2013 at 10:08 pm
  • Hi all I'm doing some tests for 12c new feature. I knew you guys are all experts willing to learn the new technology so I hope someone can answer my question even 12c is just released several days ...
    Jul 15, 2013 at 10:15 am
    Jul 15, 2013 at 11:03 pm
  • I did a quick test on the performance of establishing and disconnecting local sessions on a not very fast RHEL 5 box. With threaded_execution, making 200 sessions takes 2 seconds. Without, it takes 3 ...
    Yong HuangYong Huang
    Jul 12, 2013 at 3:49 pm
    Jul 12, 2013 at 10:25 pm
  • I've been tasked with setting up Administration groups here, and it seems straightforward except for the fact that I can't seem to make the Lifecycle groups look different. *ex:* STAGE PROD ...
    Scott StefickScott Stefick
    Jul 2, 2013 at 6:50 pm
    Jul 3, 2013 at 10:35 pm
  • Hi all, How can I have indexes/constraints info? I tried to delete a row from a table in my db and I got this message: (IntegrityError) ORA-02292: integrity constraint (SFERA.SYS_C0057216) violated - ...
    Jose SoaresJose Soares
    Jul 3, 2013 at 7:16 am
    Jul 3, 2013 at 3:33 pm
  • Hi I work with Oracle and MySQL/MariaDB. I am more developer (job role application manager) than DBA. What blogs and/or print magazines can you recommend me? I am not a DB guru. Lukas -- ...
    Lukas LehnerLukas Lehner
    Jul 31, 2013 at 9:16 am
    Jul 31, 2013 at 3:08 pm
  • All, We recently migrated to Solaris with Veritas clustering. Can anyone recommend a book or training for either one aimed at DBAs? Malcolm Lawrence -- http://www.freelists.org/webpage/oracle-l
    Malcolm LawrenceMalcolm Lawrence
    Jul 23, 2013 at 5:33 pm
    Jul 23, 2013 at 7:48 pm
  • I was told by our Oracle Sales Rep....that the network encryption (formerly part of the ASO license) is now free! It may be dependent on the Enterprise License. Confirm to make sure. -- April C. Sims ...
    April SimsApril Sims
    Jul 22, 2013 at 4:33 pm
    Jul 22, 2013 at 7:28 pm
  • I have a requirement to convert an old tru64 oracle instance ( to linux 86_64, also oracle 10.2. I have the required software, what is the best method to convert, I can see I dont have an ...
    John SmithJohn Smith
    Jul 20, 2013 at 5:31 pm
    Jul 22, 2013 at 2:44 pm
  • Hi Lists, We have an incident occured in our shop wherein our production EM database was crashed due to file system issue. We never received any alert as our em is down. How to setup an alert if EM ...
    Prabhu KrishnaswamyPrabhu Krishnaswamy
    Jul 16, 2013 at 4:43 pm
    Jul 16, 2013 at 9:02 pm
  • Folks, I'm running into a discussion with another DBA on our team concerning differing disk (or LUN, but for the sake of simplicity let's just say "disk") sizes within ASM. Best practices for ASM say ...
    Herring, DavidHerring, David
    Jul 8, 2013 at 4:18 pm
    Jul 8, 2013 at 6:04 pm
  • From the 12c SQL Tuning Guide · Because of the existence of GUI-based tools, it is possible to create applications and administer a database without knowing SQL. However, it is impossible to tune ...
    Hemant K ChitaleHemant K Chitale
    Jul 3, 2013 at 3:22 pm
    Jul 3, 2013 at 3:53 pm
  • Hi Did someone encountered the issue where all 5 nodes got evicted but no log details as why it happened is recorded? This is 11g R2 5-Node RAC on RHat linux.It happen when SAn Team is working on ...
    Sanjay MishraSanjay Mishra
    Jul 2, 2013 at 11:56 am
    Jul 2, 2013 at 7:59 pm
  • Hey all, apress.com is having a sale for July 4th (holiday in The Colonies). 40% off ebooks with code: 4THJ13 The Arduino/LEGO book looks interesting. And I hear they have some Oracle books, too.. ...
    Rich JesseRich Jesse
    Jul 1, 2013 at 3:18 pm
    Jul 1, 2013 at 5:34 pm
  • I have a customer with a home grown set of data warehouse processes. A mix of IBM DataStage for ETL and triggers for data movement are the main components right now. Load/update performance is ...
    David MannDavid Mann
    Jul 29, 2013 at 2:46 pm
    Jul 29, 2013 at 4:00 pm
  • Any idea if this will be a supported platform (AIX 7 for Power) and when they hope to make it available? I don't know if anyone knows what percentage of Oracle's installed base might be on AIX for ...
    Patrice sur GMailPatrice sur GMail
    Jul 18, 2013 at 1:38 pm
    Jul 24, 2013 at 11:31 am
  • In the past, our SAs have typically installed a lot of 32-bit versions of Oracle rpms on a 64-bit machine. One of these is elfutils-libelf.i386. Our procedures have changed and our SAs will now not ...
    Maureen EnglishMaureen English
    Jul 19, 2013 at 4:55 pm
    Jul 19, 2013 at 7:08 pm
  • Hi DBA gurus, Has anyone configured haip or haip plus network interface bonding for Oracle RAC interconnection? Is there any big advantage if compare with network interface bonding? Thanks, Lu -- ...
    Lu JiangLu Jiang
    Jul 11, 2013 at 2:25 pm
    Jul 17, 2013 at 11:51 am
  • Some bugs that I found interesting : http://hemantoracledba.blogspot.com/2013/07/interesting-bugs-in-12cr1.html<http://hemantoracledba.blogspot.sg/2013/07/interesting-bugs-in-12cr1.html -- Hemant K ...
    Hemant K ChitaleHemant K Chitale
    Jul 11, 2013 at 3:06 pm
    Jul 11, 2013 at 10:10 pm
  • Hi, We have a set of (near 700) tables (about 300G) that we need to replicate every night and keep static. The idea is that we have an environment frozen to the day before where we can run certain ...
    Guillermo Alan BortGuillermo Alan Bort
    Jul 4, 2013 at 7:12 pm
    Jul 4, 2013 at 8:11 pm
  • Hi Does anyone know if direct path read cannot be used when the query is a join? For example (dimension has parallel degree 8 so fact) select * from dimension d, fact f where d.id = f.id; Can direct ...
    Ls ChengLs Cheng
    Jul 1, 2013 at 11:52 am
    Jul 2, 2013 at 8:03 am
  • My apologies if this is too far off topic. I am running several instances of Oracle and on some Windows 2003 servers, multiple instances on each server. Our Grid Control 11g ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Jul 26, 2013 at 1:28 pm
    Jul 26, 2013 at 1:43 pm
  • List, Our application vendor has a feature based on Oracle Advanced Replication: 1. Is Replication different in 11g? The manuals mention that in 10g it was trigger-based but is now web-based ...
    Dennis WilliamsDennis Williams
    Jul 24, 2013 at 2:55 pm
    Jul 25, 2013 at 3:58 pm
  • Hi list I've got a large fact table and kind of snowflaked dimensions. I need to go from one dimension through fact into the other dimension. I'm trying to write a query which reads the corresponding ...
    Alexandr AntonovAlexandr Antonov
    Jul 25, 2013 at 10:16 am
    Jul 25, 2013 at 12:26 pm
  • Hello, we had a strang situation on a 2 node RAC this weekend. For some reason one UPDATE statement startet waiting on the event "enq: TX - allocate ITL entry". The AWR shows that in the hour in ...
    Thomas KellererThomas Kellerer
    Jul 22, 2013 at 2:30 pm
    Jul 22, 2013 at 3:07 pm
  • Hi fellows! We think the event "Log File Switch Completion" must be independent of log size but people from support say that it is dependent os log size and as we have a redo log size of 1Gb they ...
    Jul 22, 2013 at 10:14 am
    Jul 22, 2013 at 12:47 pm
  • Ok, I created a new 11g instance and when I try and run catproc, I get: ERROR at line 1: ORA-06554: package DBMS_STANDARD must be created before using PL/SQL I ran @standard as sys. So what the heck ...
    Zelli, BrianZelli, Brian
    Jul 19, 2013 at 3:47 pm
    Jul 19, 2013 at 3:56 pm
  • This is Oracle running on Windows Server 2003. I am in the process of setting up RMAN backups. The relevant part of my backup script says: "backup as compressed backupset database plus ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Jul 18, 2013 at 7:25 pm
    Jul 19, 2013 at 2:03 am
  • Whenever I go to the 12c documentation at: http://www.oracle.com/pls/db121/homepage I (eventually) get a message bar at the bottom with "oracle.com is not responding due to a long-running script, ...
    Don GranamanDon Granaman
    Jul 17, 2013 at 4:32 pm
    Jul 17, 2013 at 5:57 pm
  • Is this misleading , i wanted to download Oracle client for windows but don't want to end up wasting bandwidth. Can anybody confirm. Thanks & Regards, Aten -- http://www.freelists.org/webpage/oracle-l
    Aten tAten t
    Jul 12, 2013 at 6:01 pm
    Jul 14, 2013 at 7:43 am
  • Hello We have a custom application that is built using oracle workspace manager. The problem is the application hangs when workspaces are merged. I think this is expected behavior. This issue is ...
    Kumar MadduriKumar Madduri
    Jul 10, 2013 at 9:09 pm
    Jul 11, 2013 at 4:23 pm
  • Gah! Going through licensing for budgeting and I came across this tripe: http://bit.ly/10MSud5 Full link ...
    Rich JesseRich Jesse
    Jul 10, 2013 at 2:51 pm
    Jul 11, 2013 at 3:31 pm
  • Hi, I set up a job to capture the contents of v$sql_monitor once a minute during my ETL run last night. I am having a hard time writing a query to find evidence of queries downgraded to serial. My ...
    Josh CollierJosh Collier
    Jul 9, 2013 at 4:08 pm
    Jul 10, 2013 at 1:29 pm
  • One of my sites uses a default role for their baseline users. The third party software we use dropped and recreated that role. Now none of my users have a default role. I've looked and can't find a ...
    Denise GwinnDenise Gwinn
    Jul 9, 2013 at 12:25 am
    Jul 9, 2013 at 7:41 pm
Group Navigation
period‹ prev | Jul 2013 | next ›
Group Overview
grouporacle-l @

147 users for July 2013

Mark W. Farnham: 19 posts Nuno Souto: 19 posts Pete Sharman: 18 posts Martin Klier: 17 posts Hans Forbrich: 14 posts Guillermo Alan Bort: 13 posts Niall Litchfield: 10 posts Jonathan Lewis: 9 posts Christopher Taylor2: 8 posts Norman Dunbar: 8 posts Rjamya: 8 posts David Fitzjarrell: 7 posts Hsieh, Joan: 7 posts Iggy Fernandez: 7 posts Seth Miller: 7 posts Tim Gorman: 7 posts Hemant K Chitale: 6 posts Ls Cheng: 6 posts Rich Jesse: 6 posts Tim Hall: 6 posts
show more