Search Discussions

89 discussions - 456 posts

  • Hello We are running a few Oracle (11.2) databases on VMware. We have of course licensed all CPUs in the underlying physical machine. But where can I find official licensing rules regarding Oracle ...
    Niels JespersenNiels Jespersen
    Oct 11, 2013 at 10:47 am
    Oct 19, 2013 at 7:35 am
  • Hi, Looking for a way of "logging" the number of rows returned by all queries run by a specific user, running Any ideas anyone? Thanks, Chris -- http://www.freelists.org/webpage/oracle-l
    Chris DunscombeChris Dunscombe
    Oct 28, 2013 at 8:42 am
    Nov 11, 2013 at 3:44 pm
  • We are implementing Exadata and are in the process of evaluating backup appliances. We are looking at the Oracle ZFS solution and the EMC Datadomain solution. Anyone go through a similar evaluation ...
    Mike boliganMike boligan
    Oct 28, 2013 at 5:43 pm
    Nov 6, 2013 at 4:57 pm
  • Hey all, I'm configuring new DBs on a new AIX 7.1 box. Instead of cloning our current setup on AIX 5.3, I'm revisiting all options for both flexibility and performance. The docs ...
    Rich JesseRich Jesse
    Oct 24, 2013 at 5:03 pm
    Oct 30, 2013 at 1:33 pm
  • Hi What is best way to check max number of concurrent session reported in a specific AWR snapshot. Need to check number of concurrent session at some outage time and so need to compare if the number ...
    Sanjay MishraSanjay Mishra
    Oct 28, 2013 at 7:49 pm
    Nov 8, 2013 at 10:13 pm
  • Afternoon all. I want to make sure I'm interpreting this AWR (see below) correctly. I am performing an import to an 11g database using a 9i export file. I'm importing 1 table that contains ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Oct 30, 2013 at 6:28 pm
    Nov 1, 2013 at 3:14 pm
  • Morning, I don't understand the decision process for the CHOOSE optimizer sometimes. Maybe I'm just overlooking something fundamental about query parsing. Here is the scenario and maybe someone can ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Oct 10, 2013 at 1:26 pm
    Oct 28, 2013 at 1:12 am
  • G'day, I've got this old 8i database, that was quietly chugging away on an old NT4 server, until the server finally and irretrievably crashed a few days ago. The sysadmin has succeeded in copying the ...
    De DBADe DBA
    Oct 31, 2013 at 8:24 am
    Nov 1, 2013 at 2:26 am
  • Dear list I have a performance problem that I have narrowed to a statistics problem where the CBO is not doing good estimations on a partitioned table The culprit select looks like select a ,b ,c ...
    Mohamed HouriMohamed Houri
    Oct 1, 2013 at 2:07 pm
    Oct 2, 2013 at 5:33 pm
  • Hi all, Oracle database EE Sun OS 5.10 Getting "ORA-12592: TNS:bad packet" upon MV refresh 4 - 5min after executing the code: begin dbms_mview.refresh ( list = '<mv_name ', method = 'c', ...
    Radoulov, DimitreRadoulov, Dimitre
    Oct 29, 2013 at 9:11 pm
    Jan 23, 2014 at 7:47 pm
  • I'm trying to track down a SQL_ID which is *always* very prominent in the Top Activity view of OEM 12c. When I attempt to drill down into the specific statement, however, it always reports that "The ...
    Adric NorrisAdric Norris
    Oct 16, 2013 at 6:48 pm
    Oct 21, 2013 at 2:41 pm
  • Hi, I thought I understood sql until I came across this which has me confused. This is on an Oracle 10g database. I have removed some columns from the select to just show my problem. If I run this ...
    Fred TillyFred Tilly
    Oct 16, 2013 at 10:55 am
    Oct 16, 2013 at 5:55 pm
  • Hi Folks, Here is the environment configuration: - RHEL 6/u4 - Cisco UCS 16xcores & 128GB RAM - Oracle RDBMS (Oracle ERP database) - db_cache_size=6G - pga_aggregate_target=2G - ...
    Hameed, AmirHameed, Amir
    Oct 25, 2013 at 10:22 pm
    Oct 27, 2013 at 4:38 pm
  • Dear experts, I have physical data guard implemented and I also scheduled the backup of database with cron on Linux to IBM tape. Everything was fine for about 6 months. few days ago I realized that ...
    Oct 2, 2013 at 10:31 am
    Oct 4, 2013 at 12:27 pm
  • We are looking into the possibility of licensing the Partitioning option. My understanding of partitioning is that it only helps when the optimizer can eliminate partitions. Doesn't that mean that it ...
    Jeffrey BeckstromJeffrey Beckstrom
    Oct 28, 2013 at 1:59 pm
    Oct 29, 2013 at 12:51 pm
  • Does anyone have any ideas how to limit temp usage before the query at hand fills up the temp tablespace and then suspends everyone else until the condition is cleared? Is there a way to monitor ...
    Josh CollierJosh Collier
    Oct 22, 2013 at 8:38 pm
    Oct 24, 2013 at 10:42 pm
  • Solaris 5.10, 128G RAM, 8G swap Oracle EE We've been getting the ORA-04030 errors several times a week since they did an OS patch in August. The SE team says there isn't anything wrong with ...
    Sandra BeckerSandra Becker
    Oct 21, 2013 at 5:09 pm
    Oct 22, 2013 at 12:41 pm
  • Hi All, Sorry, I must be missing something obvious here, but I am just not seeing it. I am able to login to our catalog database with sqlplus, but RMAN connection is throwing invalid username ...
    Michael SchmittMichael Schmitt
    Oct 7, 2013 at 3:06 pm
    Oct 7, 2013 at 5:51 pm
  • Linux server, Oracle We had some core dumps and then the database crashed. It didn't come all the way down. Some processes were still running so we did a shutdown abort (non-prod database) ...
    Sandra BeckerSandra Becker
    Oct 4, 2013 at 7:28 pm
    Oct 7, 2013 at 12:33 pm
  • We have a need to have both the 32 and 64 bit clients installed on a Windows 7 PC. In order for the 32-bit application to access the 32-bit Oracle client, due we have to alter the search "path" prior ...
    Jeffrey BeckstromJeffrey Beckstrom
    Oct 29, 2013 at 7:14 pm
    Oct 30, 2013 at 1:50 pm
  • Hey all, Did the MOS update this weekend break opening KB articles in new browser tabs? I used to just middle click several article links from a search to get them in their own tab, but now it looks ...
    Rich JesseRich Jesse
    Oct 14, 2013 at 8:31 pm
    Oct 21, 2013 at 2:01 pm
  • Hello, I want start to study for preparing OCA 11g exam. Could you help me please giving me inet resources with documentation, exam examples, and so on for going ready to the exam? I have some of ...
    Oct 18, 2013 at 6:32 pm
    Oct 19, 2013 at 2:39 am
  • Hey all, Anyone using Oracle Configuration Manager? I finally broke down and set it up with EM12c last week only to have its nightly update job fail since. It did manage to run a few days last week, ...
    Rich JesseRich Jesse
    Oct 10, 2013 at 9:32 pm
    Oct 17, 2013 at 6:55 pm
  • Hello, A position in our company became available, working with Oracle E-business Suite, release 12. The project is in the early stages, and will not be rolled-out until next year. I would be ...
    Ed lewisEd lewis
    Oct 11, 2013 at 7:43 pm
    Oct 13, 2013 at 8:48 pm
  • The column is YES on the SQL Plans for this SQL_ID ----- Original Message ----- From: Carlos Sierra Sent: 10/02/13 11:09 AM To: <span class="m_body_email_addr" ...
    Lyall BarbourLyall Barbour
    Oct 7, 2013 at 7:45 pm
    Oct 8, 2013 at 2:45 pm
  • Hi All, I've got a problem with a Windows 7 PC client ( which after a period of time (days/hours) starts throwing ORA-03135 (after a hang of about 20 seconds) when I try to connect to a ...
    Charlotte HammondCharlotte Hammond
    Oct 2, 2013 at 7:11 pm
    Oct 2, 2013 at 9:33 pm
  • Oracle 11.2 Redhat enterprise Linux One of My 8 Year old Redhat LInux Servers keeps crashing every time I add an 18gig datafile to a tablespace. It 'goes' away and has to be powered off and on to get ...
    Howard LathamHoward Latham
    Oct 25, 2013 at 3:25 pm
    Nov 14, 2013 at 4:23 pm
  • Dears, I have the following *Top 5 Timed Foreground Events *for 2 hours (I know it�s too long but the job was still running after these 2 hours snapshots): *Event* *Waits* *Time(s)* *Avg wait (ms)* ...
    Mohamed HouriMohamed Houri
    Oct 30, 2013 at 1:46 pm
    Oct 31, 2013 at 2:40 pm
  • I am looking for a benchmark comparing the two OS'es on identical hardware. I found a number of benchmarks, but the hardware differed in the comparisons. Can anyone point me to relevant documents ...
    Jeffrey BeckstromJeffrey Beckstrom
    Oct 21, 2013 at 6:54 pm
    Oct 25, 2013 at 12:00 pm
  • Hi folks, It seems like we've encountered some unexpected behavior of optimizer after complete non-atomic mview refresh. Please see the issue below: Oracle version yakov@oracle create table ...
    Yakov VasilchenkoYakov Vasilchenko
    Oct 22, 2013 at 9:01 am
    Oct 23, 2013 at 6:57 am
  • Database: Oracle EE OS: RHL 4 Hi This Saturday just gone, one of our production databases suffered a partial outage because all of the available sessions on the first of the two cluster ...
    Peter HitchmanPeter Hitchman
    Oct 21, 2013 at 12:03 pm
    Oct 22, 2013 at 1:40 pm
  • Is anyone else having problems with MOS running really slow? -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-l
    Andrew KerberAndrew Kerber
    Oct 18, 2013 at 6:12 pm
    Oct 18, 2013 at 7:19 pm
  • Hey all, I see that is out. As I have a new install coming up in a month or so, I figured I'd go that route instead of (no, 12.1 is not an option). Anyone running this patch? It ...
    Rich JesseRich Jesse
    Oct 2, 2013 at 2:12 pm
    Oct 9, 2013 at 8:50 am
  • When I try to use the database link of a schema remotely then I get the error ORA-12154: TNS: could not resolve the connect identifier specified. If I login to the server, hosting the database, login ...
    Mandal, AshokeMandal, Ashoke
    Oct 21, 2013 at 9:49 pm
    Oct 31, 2013 at 3:18 pm
  • Folks, RDBMS - Linux - RHEL 6/U4 Oracle E-Business Suite R12 I have noticed that DCD is not working quickly enough in my database even if I set "SQLNET.EXPIRE_TIME= 1" on the database ...
    Hameed, AmirHameed, Amir
    Oct 31, 2013 at 12:51 am
    Oct 31, 2013 at 1:42 am
  • Hi Does any one knows as how I can get Instance name and Listener Port configured on the database server from Oracle enterprise Manager Repository tables. I has 1200 database in one of the new client ...
    Sanjay MishraSanjay Mishra
    Oct 25, 2013 at 4:33 am
    Oct 25, 2013 at 3:05 pm
  • Listers, Here is the problem that we have in one of our production DB and an Oracle SR is also open for this: DB/CRS/ASM : Early morning today, RDBMS and ASM instances on one node of a two ...
    Saurabh manroySaurabh manroy
    Oct 23, 2013 at 3:55 pm
    Oct 24, 2013 at 10:16 am
  • This is Oracle running on Windows 2008 r2 - 64 bit. Rman fails with the following errors: RMAN-03002: failure of backup plus archivelog command at 10/22/2013 09:33:44 ORA-19501: read error ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Oct 22, 2013 at 2:20 pm
    Oct 22, 2013 at 7:31 pm
  • I have seen references in MOS docs (Doc ID 1484809.1) & (803238.1) to disable NUMA before configuring HPs. They were specific to 10g and 11.1. Is this required for 11.2 (or may be at all)? Can't ...
    Oct 11, 2013 at 4:12 pm
    Oct 14, 2013 at 3:35 pm
  • Hello, Is there a way to identify if a line (gtype = 2002) crosses itself ? I know that when the geometry is a polygon (gtype=2003) Oracle spatial generates the error: ORA-13349. But it does not ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Oct 13, 2013 at 10:07 am
    Oct 13, 2013 at 5:26 pm
  • We took a backup-as-copy of our standby DB, and copied the archived logs that spanned that time and beyond (the next day). Created a new controlfile to point to those copy files and recovered the ...
    Don SeilerDon Seiler
    Oct 10, 2013 at 8:41 pm
    Oct 10, 2013 at 9:37 pm
  • Dear lists, I migrate a database using expdp/impdp and exp/imp today. When I export a database using expdp, there isn't any errors. But there are some views, procedure and others error, so I compile ...
    Oct 7, 2013 at 3:24 pm
    Oct 7, 2013 at 5:04 pm
  • Hi All, Hoping someone can help shed some light on an issue that has me completely puzzled. Environment: Enterprise Manager Database Control 11g Oracle database (Enterprise Edition) RHEL5 I ...
    Lisa DobsonLisa Dobson
    Oct 3, 2013 at 8:57 pm
    Oct 4, 2013 at 3:21 pm
  • it's set to I'm going to try to bounce the db, delete my baseline and the load the baseline back in this morning. Lyall Barbour ----- Original Message ----- From: David Fitzjarrell Sent ...
    Lyall BarbourLyall Barbour
    Oct 2, 2013 at 12:23 pm
    Oct 2, 2013 at 4:39 pm
  •, standby is mounted and in managed recovery. We're in the process of moving datafiles off of ASM and onto NAS storage. I run this query to see what work we have remaining: 1 select t.name, ...
    Don SeilerDon Seiler
    Oct 25, 2013 at 7:10 pm
    Oct 25, 2013 at 9:55 pm
  • /à»+z¯y£«iÉ^×_öÿO÷D -- http://www.freelists.org/webpage/oracle-l
    Oct 24, 2013 at 6:58 am
    Oct 25, 2013 at 12:38 am
  • I need some hints / tips about loading and storing a NaN into an Oracle table. The incoming value would likely be from a flat file, so I'd have to be using SQLLoader. Currently, the target table ...
    Hemant K ChitaleHemant K Chitale
    Oct 24, 2013 at 2:52 pm
    Oct 24, 2013 at 4:55 pm
  • SQL select namespace,gets,gethits,round(gethitratio,2) gethitratio 2 from V$LIBRARYCACHE 3 where namespace like 'SQL%'; NAMESPACE GETS ---------------------------------------------------------------- ...
    Oct 23, 2013 at 6:33 pm
    Oct 24, 2013 at 1:08 am
  • Can anyone explain to me what is happening here? The CPU on this node went crazy last night, load average went over 200, and we had to restart the server. Looking at the AWR report, I see PGA memory ...
    Andrew KerberAndrew Kerber
    Oct 22, 2013 at 6:38 pm
    Oct 22, 2013 at 9:44 pm
  • Lists Does 11g and 12c OEM supports for credential with a public key. We are configuring an OS user to run all the jobs through OEM, for which we planned to have the named credential with public ...
    Prabhu KrishnaswamyPrabhu Krishnaswamy
    Oct 14, 2013 at 6:19 pm
    Oct 16, 2013 at 12:50 am
Group Navigation
period‹ prev | Oct 2013 | next ›
Group Overview
grouporacle-l @

159 users for October 2013

Rich Jesse: 15 posts Jonathan Lewis: 13 posts Hameed, Amir: 10 posts Jared Still: 10 posts Mohamed Houri: 10 posts Radoulov, Dimitre: 10 posts Storey, Robert (DCSO): 10 posts Adric Norris: 9 posts Andrew Kerber: 9 posts Mark W. Farnham: 9 posts Ric Van Dyke: 9 posts David Fitzjarrell: 8 posts Nuno Souto: 8 posts Hans Forbrich: 7 posts Mark Bobak: 7 posts Outsider: 7 posts Andy Klock: 6 posts Chris Taylor: 6 posts Don Seiler: 6 posts Justin Mungal: 6 posts
show more