Search Discussions

94 discussions - 460 posts

  • Hello, Can anyone point me to any official documentation that says that if you have a feature (such as Oracle Partitioning or OLAP) installed but do not use it that you do not have to purchase a ...
    May 17, 2011 at 2:04 pm
    Oct 27, 2011 at 4:11 pm
  • Good day, listers, Environment: Oracle EE on Solaris 10 I know, the first thing that comes to mind "Oh yeah, the binary_dump_destination is overridden by diag_destination in 11g". That's not ...
    Charles SchultzCharles Schultz
    May 15, 2011 at 1:22 pm
    May 18, 2011 at 2:34 pm
  • I've got a query in ANSI join format that returns all employees along with the required training courses and the ethics training. If they've completed a course then there will be a completed date in ...
    Thomas DayThomas Day
    May 4, 2011 at 1:10 pm
    May 5, 2011 at 3:04 pm
  • Hi, I was doing a reorg of my storage device at my home and I use to store all oracle related materails./artciles/tips/OOW slides etc and some of then are really old but still relavent and dont want ...
    Sriram KumarSriram Kumar
    May 20, 2011 at 11:40 am
    Jul 20, 2011 at 10:29 am
  • Not using Oracle :D Hello gurus and senseis, Just wanted to ask a silly question (well, not so silly if you are a big shop with tons of clients to whom you sell ASP :p) Have you guys ever considered ...
    Masha GurenichMasha Gurenich
    May 20, 2011 at 4:49 pm
    May 25, 2011 at 4:01 pm
  • First, the assumption is that you are working with a 3rd party application, and there is nothing you can do to modify the SQL statements used by the app. Nor are you able at this time to apply an ...
    Jared StillJared Still
    May 2, 2011 at 5:49 pm
    May 5, 2011 at 7:00 pm
  • Hi all, Oracle on Win 2003. SAP admitted a bug in their app, which resulted in millions of rows inserted in a couple of tables. They came up with a script to delete them, but failing to ...
    Eugene PipkoEugene Pipko
    May 31, 2011 at 10:54 pm
    Jun 2, 2011 at 4:20 am
  • Howdy, Having an issue this AM with a query and a very bad explain plan. It's odd that Grid Control's Top Activity can't seem to locate this SQL in history, considering 15+ folks are running it right ...
    Rich JesseRich Jesse
    May 12, 2011 at 1:55 pm
    May 20, 2011 at 11:52 am
  • Ok, it has been awhile and I completely have gone brain-dead on this. I want to import one table to another. I looked up my import options and can't seem to locate how to go about this. I have a ...
    Zelli, BrianZelli, Brian
    May 16, 2011 at 6:01 pm
    May 16, 2011 at 7:05 pm
  • Has anyone heard of this tool? In a meeting this morning a customer DBA asked a non-DBA from our company if we had started using this free tool from Oracle called "SQL T". I tried to find it to check ...
    Sandra BeckerSandra Becker
    May 20, 2011 at 7:42 pm
    May 23, 2011 at 8:27 pm
  • Hello, Export backup faling with below error. Kindly help here. Export: Release - Production on Wed May 11 00:00:54 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected ...
    Nagaraj SNagaraj S
    May 11, 2011 at 10:39 am
    May 13, 2011 at 12:52 am
  • All, I have the primary db on server A, and planning to make the standby on server B. Can I have the db_unique_name same same as db_name in standby database.? appreicate any suggestion. thanks Kart ...
    K RK R
    May 24, 2011 at 6:47 pm
    May 31, 2011 at 11:16 am
  • I'm writing a script to allow the sysadmin's to kill any active sessions for a particular database user. If the script is called as root, I re-invoke it as oracle. However, 'dirname' doesn't seem to ...
    Stephens, ChrisStephens, Chris
    May 27, 2011 at 6:42 pm
    May 27, 2011 at 7:58 pm
  • Anyone know what the AWR report section SQL ordered by Physical Reads (UnOptimized) is showing? Kyle http://dboptimizer.com SQL ordered by Physical Reads (UnOptimized) UnOptimized Read Reqs ...
    kyle Haileykyle Hailey
    May 21, 2011 at 12:24 am
    May 22, 2011 at 10:50 am
  • One of our DBAs is creating a test DB from production, going from one HP server to another. He's done numerous refreshes like this. Believe this is first He's having the issue below and ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    May 11, 2011 at 3:10 pm
    May 13, 2011 at 2:32 pm
  • $ sqlplus sys/XXXX_at_ASM1 as sysdba SQL*Plus: Release - Production on Thu May 12 01:27:10 2011 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR: ORA-01031: insufficient ...
    Nadeem M. KhanNadeem M. Khan
    May 11, 2011 at 9:31 pm
    May 12, 2011 at 10:12 am
  • Hi all, I'm working with a new oracle restart configuration and I'm finding few problem. Grid infrastructure is installed as user grid, I have also 3 different databases installed with user db1, db2, ...
    Stefano CislaghiStefano Cislaghi
    May 10, 2011 at 3:58 pm
    May 11, 2011 at 10:28 am
  • Hi, list: I am on 10g, not 11g. How to find out the complete list of names for SQL_OPCODE? I want to do something like decode(OPCODE 0,'BACKGROUND', 1,'Create Table', 2,'INSERT', ....) Thanks, Lei -- ...
    Lei ZengLei Zeng
    May 6, 2011 at 3:33 am
    May 6, 2011 at 8:16 pm
  • In the test case below the subquery (IN) SQL visits 25% less buffers than the join query. The :B1 bind variable is an array of strings. any ideas why the IN does so much less work than the JOIN for ...
    Matt McClernonMatt McClernon
    May 31, 2011 at 11:16 pm
    Jun 2, 2011 at 12:48 pm
  • Hi List, I am looking for various options to encrypt a sensitive password in a unix shell script. After a bit of googling, I learned about 'shc'. Can you please advice on what things you use for this ...
    Sreejith S NairSreejith S Nair
    May 16, 2011 at 1:30 pm
    May 17, 2011 at 7:02 am
  • All, I have a requirement to build 2 standby database on the standby server in 10gR2. and this whole process needs to be automated . So I was thinking to build first standby database using rman ...
    K RK R
    May 8, 2011 at 10:31 pm
    May 10, 2011 at 11:38 pm
  • Hi I want to export selective data from three tables in one dump. Can anyone suggest me how it can be done? If it is not possible can I combine the three dump files into one? Thankyou. Regards ...
    Abhishek GurungAbhishek Gurung
    May 9, 2011 at 6:50 am
    May 9, 2011 at 12:20 pm
  • Which of the two statements do you find is easier to understand? WHERE (txv.business_unit2tcode NOT IN (41940) OR (txv.business_unit2tcode IN (41940) AND txv.ext_source_key IS NULL)); *OR* WHERE CASE ...
    Michael MooreMichael Moore
    May 6, 2011 at 5:46 pm
    May 6, 2011 at 7:38 pm
  • We have got Grid Control running on a seperate server -- OMS is on AIX. I have another server/databases that are on Linux RHEL5 x86-64 bit and I want to install an agent on it so ...
    P DP D
    May 3, 2011 at 7:13 pm
    May 3, 2011 at 11:31 pm
  • Hi Can ASM be used to migrate data from one SAN array to another SAN array without any downtime and when users are online. Thank you Kumar -- http://www.freelists.org/webpage/oracle-l
    Kumar MadduriKumar Madduri
    May 24, 2011 at 10:50 pm
    May 27, 2011 at 1:48 pm
  • I have an application generated 4 table query that produced explain plan that has an index join of 3 indexes (hash join of 2 indexes hash joined to a third) among the other joins. The 3 indexes are ...
    Kenneth NaimKenneth Naim
    May 19, 2011 at 4:28 pm
    May 19, 2011 at 6:08 pm
  • Anyone know when Oracle first required the purchase of licences for development.? -- Howard A. Latham Sent from my Nokia N97 -- http://www.freelists.org/webpage/oracle-l
    Howard LathamHoward Latham
    May 13, 2011 at 9:31 am
    May 17, 2011 at 2:56 pm
  • Hello Has anyone cloned an oracle restart installation succesfully. The clustereware admin and deploy guide (chapter 4) talks about cloning clusterware but that seems to be valid for rac ...
    Kumar MadduriKumar Madduri
    May 5, 2011 at 2:45 pm
    May 13, 2011 at 6:58 pm
  • http://www.cvent.com/en/company/positions/database-architect.shtml " When you think data, you chuckle at terabytes, relish petabytes, and dream beyond exabytes. You think RDBMS may be the problem, ...
    Dba DBADba DBA
    May 13, 2011 at 12:07 am
    May 13, 2011 at 2:23 pm
  • Just to avoid re-inventing the wheel ... has anyone written something to change the DBID of AWR data when importing into a shared repository? SInce many of my databases are clones they all have the ...
    kyle Haileykyle Hailey
    May 10, 2011 at 6:46 pm
    May 10, 2011 at 11:36 pm
  • Can anyone tell me why I have some objects being reloaded in the SGA, even though they are pinned? To my knowledge, no dependent objects are being modified. I had posted a similar question last year ...
    Jay HostetterJay Hostetter
    May 26, 2011 at 6:53 pm
    Jun 6, 2011 at 3:44 pm
  • List, I am configuring a Java JDBC connection to a database (which I don't manage). I am able to connect using SQL*Plus, but the java connection gets the error: ORA-28030: Server encountered problems ...
    Dennis WilliamsDennis Williams
    May 24, 2011 at 9:58 pm
    May 27, 2011 at 4:49 pm
  • All, What is the range I should be looking at for file i/o average read in milli second in a ASM environment. I see some of my database have average read between 3ms and 8ms . appreciate any ...
    K RK R
    May 18, 2011 at 12:15 am
    May 23, 2011 at 9:58 am
  • Hi Friends, I hope we all are managing small -medium - large number of databases which runs in N servers. Say, If I have 40 databases which runs in 40 + servers, How do you manage the credentials / ...
    Sreejith sSreejith s
    May 21, 2011 at 8:23 am
    May 22, 2011 at 8:09 am
  • Hi Listers, Â Â Â A few days ago we had a problem with EM, some of the weird things that happen from time to time that make you wonder what is packed in that weird product. Anyway, this is not an EM ...
    Guillermo Alan BortGuillermo Alan Bort
    May 19, 2011 at 6:41 pm
    May 20, 2011 at 4:06 pm
  • Hello list, I have a question, what does Grock mean in Oracle RAC CSS? I always find some Grock associated info from ocssd.log, like below: " 2011-04-29 04:00:19.056: [ ...
    Maclean LiuMaclean Liu
    May 4, 2011 at 10:41 am
    Aug 6, 2013 at 12:09 pm
  • Hi list, I'm trying to do an automated Tablespace Point In Time Recovery (TSPITR) with RMAN and I'm stumped on why it is requiring an old controlfile, which unfortunately is offsite already. I've got ...
    Allen, BrandonAllen, Brandon
    May 25, 2011 at 5:12 pm
    May 27, 2011 at 4:22 pm
  • It seems to be official. You have to buy a Full Oracle License if you do ANY development for more than 90 days and/or use more than 1 developer on a box. -- Howard A. Latham Sent from my Nokia N97 -- ...
    Howard LathamHoward Latham
    May 17, 2011 at 12:15 pm
    May 18, 2011 at 12:51 pm
  • Dear list, anyone knows if there is a way to automatically delete (both side: real machine and stand by server) the archive logs after they are managed by stand by server. thanks Alessandro -- ...
    Alessandro LiaAlessandro Lia
    May 17, 2011 at 6:45 am
    May 18, 2011 at 9:49 am
  • Hello All, Good Morning/Afternoon, Hope every one is doing a good job!! I had a problem yesterday, OS:- SOLARIS database version:- ORACLE 10G ( Task assigned to me was:- To create a replica ...
    Nilesh kumarNilesh kumar
    May 16, 2011 at 6:39 am
    May 17, 2011 at 2:05 pm
  • Hi all Anyone know if the metric I/O Megabytes per Second is valid in DBA_HIST_SYSMETRIC_HISTORY at version 11gR1? I am checking some I/O throguhput in a pretty loaded system (around 1200MB/sec) and ...
    LS ChengLS Cheng
    May 12, 2011 at 9:09 am
    May 13, 2011 at 5:56 pm
  • Hi Gurus, One particular sql runs in less than a sec when run from sqlplus client on desktop whereas it takes 85 seconds for it to complete when run directly on the solaris 10 box where they have ...
    P SureshP Suresh
    May 12, 2011 at 9:56 pm
    May 13, 2011 at 12:37 am
  • Hi, I'm installing a new infrastructure with EM 11g. My past infrastructure was based on EM 10g and was monitoring few solaris clusters with veritas as clustering software. Every database had a ...
    May 5, 2011 at 6:40 pm
    May 12, 2011 at 2:06 pm
  • I end up comparing a lot of AWR reports and all the reports tend to be HTML which is nice for browsing visually but not so nice for my scripts which diff the data. In order to diff AWR reports that ...
    kyle Haileykyle Hailey
    May 10, 2011 at 6:55 pm
    May 12, 2011 at 4:12 am
  • Since upgrading to, the SQL Tuning Advisor is generating a core dump every night on one SQL statement. In the application, the statement runs fine. Is there any harm in disabling the Tuning ...
    Jeffrey BeckstromJeffrey Beckstrom
    May 6, 2011 at 7:05 pm
    May 9, 2011 at 7:51 pm
  • For those of you who haven't noticed that blogs.oracle.com has moved with some rather unexpected downsides, I have created a google CSE just for blogs.oracle.com available at ...
    Niall LitchfieldNiall Litchfield
    May 9, 2011 at 2:18 pm
    May 9, 2011 at 4:03 pm
  • Hello list, I have a Websphere Portal admin facing some issues with the product and in his research of the problem he found a support note from IBM saying that all the default portal schemas ...
    May 3, 2011 at 2:53 pm
    May 7, 2011 at 7:44 pm
  • Anyone using the MS SQL Server plugin with Enterprise Manager and is there any costs associated with using it? (Licensing etc) I looked on OTN and I can't find anything that indicates that you have ...
    Taylor, Chris DavidTaylor, Chris David
    May 4, 2011 at 2:01 pm
    May 4, 2011 at 2:48 pm
  • I would like to request a prefix for the subject line of emails from this list. For example, instead of: *Subject:need help with sql query* you would see * Subject:[ORA-L]need help with sql query* * ...
    Michael MooreMichael Moore
    May 27, 2011 at 7:33 pm
    May 30, 2011 at 3:40 pm
  • DB: HP-Unix We have a database used for ETL/data loads and then the data is fed to an oltp. We had performance issues on it yesterday and noticed that the waits were on log file sync. The ...
    Dba DBADba DBA
    May 26, 2011 at 12:59 pm
    May 29, 2011 at 7:55 am
Group Navigation
period‹ prev | May 2011 | next ›
Group Overview
grouporacle-l @

156 users for May 2011

: 22 posts Niall Litchfield: 20 posts Allen, Brandon: 12 posts Goulet, Richard: 12 posts Jared Still: 12 posts Rich Jesse: 12 posts Charles Schultz: 11 posts Guillermo Alan Bort: 11 posts David Fitzjarrell: 10 posts Wolfgang Breitling: 8 posts Yechiel Adar: 8 posts Jorgensen, Finn: 7 posts K R: 7 posts kyle Hailey: 7 posts Michael Dinh: 7 posts Howard Latham: 6 posts Kenneth Naim: 6 posts Kumar Madduri: 6 posts LS Cheng: 6 posts Michael Moore: 6 posts
show more