Search Discussions

94 discussions - 496 posts

  • Hi All, So, I thought I really understood this stuff, but I'm a little baffled here, and I wonder if anyone can offer me a clue? Here's what I (think I) know: 1.) AMM (setting memory_target) is *not* ...
    Mark BobakMark Bobak
    Apr 16, 2014 at 3:48 pm
    Apr 18, 2014 at 7:57 am
  • The official oracle docs (UG & MOS) asks that flashback is toggled (and GRP recreated) if db_recovery_file_dest is changed. However, my tests on shows that this is not needed. I saw that ...
    Fred HabashFred Habash
    Apr 11, 2014 at 2:35 pm
    May 26, 2014 at 7:15 am
  • Hi, I've just been testing queries and indexes using the trunc() function on dates and noticed something I didn't expect. I created a simple table on EE, filled it with data and created a ...
    Chris SaxonChris Saxon
    Apr 19, 2014 at 10:16 am
    Apr 30, 2014 at 8:53 pm
  • Ok, I am trying to connect from windows to unix with sqlplus from the command line. I set the SID and enter Sqlplus /nolog SQL connect /as sysdba Gets me the ORA-12560:TNS:protocol adapter error Why ...
    Zelli, BrianZelli, Brian
    Apr 23, 2014 at 7:27 pm
    Apr 24, 2014 at 4:27 pm
  • Dears, I am wondering if someone has succeeded to install *Oracle Enterprise Manager Cloud Control 12c under *windows 8 64bit? *Oracle Enterprise Manager Cloud Control 12c Release 3 Plug-in Update 1 ...
    Mohamed HouriMohamed Houri
    Apr 28, 2014 at 3:15 pm
    May 4, 2014 at 8:37 pm
  • Hi, for reporting purposes we are maintaining some denormalized, pre-aggregated tables in our OLTP database. These queries are aggregating sales and other related data from several source tables into ...
    Thomas KellererThomas Kellerer
    Apr 4, 2014 at 1:13 pm
    Apr 15, 2014 at 8:27 am
  • I’ve been tracking down and coming up with ways to online remedy a somewhat well known derivative of chained rows known as migrated rows for some time. I have also stumbled across intra-block ...
    Kenny PaytonKenny Payton
    Apr 23, 2014 at 8:57 pm
    Apr 29, 2014 at 12:40 pm
  • I was just asked by management whether it would be possible to run Dataguard from Exadata (Primary) to a Database Appliance (Standby). I can't think of a reason why that wouldn't be possible. I'm not ...
    Stephens, ChrisStephens, Chris
    Apr 15, 2014 at 3:10 pm
    Apr 16, 2014 at 6:29 pm
  • Hi, one of our customers' databases has a table with a not null column containing empty data. Do you know how this can be set up? I need to copy the table (via exp/imp) and hit either ORA-01400 (when ...
    Ingrid VoigtIngrid Voigt
    Apr 15, 2014 at 3:55 pm
    Apr 15, 2014 at 8:47 pm
  • A vendor wants me to shrink a table. I've never shrunk one in oracle. Does that delete the data out of them? And then wants me to rebuild the associated indexes. Won't they be empty after you shrink ...
    Zelli, BrianZelli, Brian
    Apr 18, 2014 at 5:28 pm
    Apr 19, 2014 at 5:09 am
  • This is Oracle on Linux 6. I can see a job in dba_jobs that is throwing an error every day at around the same time. 1 4217 AXIS AXISPKG AXISPKG 4/5/2014 10:07:17 AM 10:07:17 0 N null 13 ...
    Scott CanaanScott Canaan
    Apr 4, 2014 at 6:18 pm
    Apr 9, 2014 at 6:52 pm
  • The Long Story of the NoCOUG Journal http://bit.ly/1rqSFGC In this issue: Interview with Apress editor Jonathan Gennick with information for prospective authorsOpinion piece by James Morle on using ...
    Iggy FernandezIggy Fernandez
    Apr 25, 2014 at 3:31 pm
    Apr 28, 2014 at 6:04 pm
  • We have a requirement to prevent database logons by specific users (who can be identified because they have a particular role) during certain times and I am thinking of options and looking for any ...
    John HallasJohn Hallas
    Apr 23, 2014 at 6:43 am
    Apr 24, 2014 at 8:36 pm
  • Hi all Does anyone knw if we need CloudFS (ACFS) license to store RMAN backups in 11gR2 RAC Standard Edition? (Not Enterprise) Thanks
    Ls ChengLs Cheng
    Apr 23, 2014 at 1:22 pm
    Apr 24, 2014 at 2:32 pm
  • All~ Environment:, single instance on Solaris SPARC 64-bit We are seeing a big performance issue on our recently upgraded 11gR2 database for a create table statement. The create table takes ...
    Bheemsen AithaBheemsen Aitha
    Apr 3, 2014 at 8:43 pm
    Apr 4, 2014 at 4:51 am
  • Had a successful first install of Oracle RAC 11gR2 on RHEL6 in the lab... but we were running out of disk on the root drive, where Oracle software is installed. In my absence, disk was added, and ...
    Chris KingChris King
    Apr 30, 2014 at 6:22 pm
    May 1, 2014 at 3:13 pm
  • OK, I'm spacing on this one. I have an SQL statement with a function in the WHERE clause. Is there a way to see how many times it is being executed for each execution of the SQL? All I can think ...
    Henry PorasHenry Poras
    Apr 3, 2014 at 7:26 pm
    Apr 4, 2014 at 12:26 am
  • Since OEM 11 and Cloud Control 12c, (I think) Oracle has required that cygwin be installed on windows servers, and SSH configured properly before the Oracle agent can be pushed to the Oracle servers ...
    Andrew KerberAndrew Kerber
    Apr 23, 2014 at 2:55 pm
    Apr 23, 2014 at 3:42 pm
  • A friend asked me a question that I could not answer. He is in the planning stages of an "extended RAC deployment" and is looking for confirmation that multicasting is optional. Help would be ...
    Iggy FernandezIggy Fernandez
    Apr 14, 2014 at 6:30 pm
    Apr 17, 2014 at 12:19 am
  • We are in the middle of setting up OEM 12c. I setup a separate Incident Rule set for the production group and critical alerts. I am thinking about setting up a different OEM user whose email is the ...
    Chris GrabowyChris Grabowy
    Apr 14, 2014 at 7:45 pm
    Apr 16, 2014 at 7:34 am
  • Hi all, I find myself a little bit frustrated with the OMS install process right now, and wondering if I'm simply missing something, or... Our first OMS was on a VM, and has never been quite stable ...
    Uzzell, StephanUzzell, Stephan
    Apr 30, 2014 at 6:22 pm
    May 1, 2014 at 3:55 am
  • Hi, We are looking for a good SCM tool which can accomodate different kinds of application code like Oracle EBS, Broadvision, Agile, Amdocs and so on. We use PVCS currently and our folks are not very ...
    Rajiv IyerRajiv Iyer
    Apr 24, 2014 at 1:50 pm
    Apr 28, 2014 at 8:13 am
  • Dear all, This is my first attempt to post to this list, so bear with me, please. This paper http://www.oracle.com/technetwork/database/options/clustering/overview/scan-129069.pdf describes "Enabling ...
    Markus MichalewiczMarkus Michalewicz
    Apr 22, 2014 at 6:02 am
    Apr 22, 2014 at 4:04 pm
  • I want to set up a Red Hat Fedora test machine at home to run 12c and Grid Control. Any recommendations on the most reliable Fedora version ? Right now I am using rev 17 but I am considering ...
    Apr 11, 2014 at 2:50 pm
    Apr 11, 2014 at 5:45 pm
  • Hi, I have question about oracle heap tables vs. tables with b-tree index vs. IOT tables. Say I have a table T1 a) CREATE TABLE T1 (C1 NUMBER NOT NULL, C2 VARCHAR2(100)); b) CREATE TABLE T1 (C1 ...
    Nik TekNik Tek
    Apr 1, 2014 at 11:22 pm
    Apr 2, 2014 at 8:25 pm
  • I wanted to know what everyone's opinion is on separating schemas. Like having a data only schema, a code only schema and then a schema the application logs into and executes code from the app ...
    Jeff CJeff C
    Apr 7, 2014 at 8:12 pm
    May 14, 2014 at 5:54 pm
  • I’m tuning a query and I’m having trouble understanding why part of a REMOTE execution plan is executing 650 times. Can anyone shed some light on this? I hope the plan is enough to help shed light on ...
    Cunningham, MikeCunningham, Mike
    Apr 24, 2014 at 5:45 pm
    Apr 24, 2014 at 9:00 pm
  • In this scenario the HKC_TARGET_1 table has 0 rows and the HKC_SOURCE_1 table has 769K rows. If I do a (HKC_TARGET_1 minus HKC_SOURCE_1) Oracle reads all the rows from HKC_SOURCE_1 inspite ...
    Chitale, Hemant KChitale, Hemant K
    Apr 8, 2014 at 9:19 am
    Apr 10, 2014 at 1:26 pm
  • hi, I have just tried to realize how to count a segment growth trend based on the dba_hits_seg_stat rows. And now I am puzzled: 1. on the metalink I have found the article 1395195.1, which suggests ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Apr 2, 2014 at 6:18 am
    Apr 8, 2014 at 10:34 am
  • I´m looking for any free tool or script to gather, in nice html format, daily reports with info and stats about my databases: storage and segment growing, daily connections, daily redo generation, ...
    Juan MirandaJuan Miranda
    Apr 23, 2014 at 2:45 pm
    Apr 24, 2014 at 8:14 pm
  • Oracle EE As part of a POC project, I had to import 8 partitioned tables into a new database. Six of them are partitioned on yyyymmdd and I had no problems with them. The last two are range ...
    Sandra BeckerSandra Becker
    Apr 16, 2014 at 7:15 pm
    Apr 16, 2014 at 8:07 pm
  • To whomever it might concern, I recently noticed that the Oracle Documentation has been enhanced to include "deep link" visible anchor tags at each sub-section. Excellent idea!! It's one of those "I ...
    Charles SchultzCharles Schultz
    Apr 7, 2014 at 6:59 pm
    Apr 15, 2014 at 1:04 pm
  • Dear, I wonder if somebody can help to solve this problem. I opened SR in Oracle and after week I got answer like they cannot help me and again they ask logs. I just wanted to restore primary DB to ...
    Apr 4, 2014 at 9:38 am
    Apr 14, 2014 at 9:50 am
  • I’m trying to get over the dogma of R2 being the production R1. Anyone running 12cR1 in production yet and do you have any success or horror stories you would like to share? We’re deploying 12cR1 ASM ...
    Kenny PaytonKenny Payton
    Apr 3, 2014 at 5:16 pm
    Apr 9, 2014 at 1:14 pm
  • Clusterware(2 nodes): DB Homes:,, 11.2.4 (all use same clusterware) OS: Redhat 6. Migrating existing DBs from a customer to us. Our standard is to use SCAN listener. The ...
    Dba DBADba DBA
    Apr 2, 2014 at 4:53 pm
    Apr 8, 2014 at 8:10 am
  • Hi, Is there a way to find that a certain stored procedure was ever created in Oracle? When I deploy the schema from a file, I'm missing few SPs, I wanted to know if the stored procedure was ever ...
    Nik TekNik Tek
    Apr 2, 2014 at 4:39 am
    Apr 3, 2014 at 5:15 am
  • Hi All, We are in the process of looking at migrating some older legacy RAC systems to a new 12C GI on Solaris T4. One of the challenges we are facing is getting any level of application change ...
    Stojan VeselinovskiStojan Veselinovski
    Apr 30, 2014 at 5:41 am
    May 1, 2014 at 11:13 am
  • Hi all, Does anyone have any experience with Oracle, MySQL, and configuring ODBC? The ultimate goal is to create a database link in an Oracle (11.2.0) database, that can select from a MySQL (5.6) ...
    Mark BobakMark Bobak
    Apr 28, 2014 at 8:36 pm
    Apr 29, 2014 at 11:08 pm
  • Just installed EM 12C and created a blocking session to test alerts. EM is not generating an alert even though a lock is existing in the database. Does some metric have to be turned on to enable ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 24, 2014 at 5:36 pm
    Apr 24, 2014 at 6:15 pm
  • Lists, We have facing an issue with one of our production Streams setup. The streams processes got broke after a network issue and once after the network is back alive, the capture process start ...
    Prabhu KrishnaswamyPrabhu Krishnaswamy
    Apr 11, 2014 at 5:19 pm
    Apr 12, 2014 at 2:04 am
  • Anyone know where I can download old versions of OPatch? I need a copy of but MOS seems to only have the latest version ( or maybe I just don't know where to look. -Jeremy -- ...
    Jeremy SchneiderJeremy Schneider
    Apr 9, 2014 at 10:23 pm
    Apr 10, 2014 at 11:31 am
  • Folks, I'm more and more involved in database education, and one of the things I feel much concerned by is the correct assessment of what people learn and of their ability with SQL. It's easy to ...
    Stéphane FaroultStéphane Faroult
    Apr 9, 2014 at 10:18 am
    Apr 10, 2014 at 7:59 am
  • I'm having a slightly weird situation here that I don't fully know how to troubleshoot. We ran a one-off backup to refresh a test environment, transferred the pieces to the test environment, ...
    Uzzell, StephanUzzell, Stephan
    Apr 7, 2014 at 3:39 pm
    Apr 7, 2014 at 6:28 pm
  • Dear list I was looking to an AWR report particularly to the SQL ordered by Gets part as shown below *SQL ordered by Gets* *Buffer Gets * *Executions* *Gets per Exec * *%Total* *Elapsed Time (s)* ...
    Mohamed HouriMohamed Houri
    Apr 7, 2014 at 9:20 am
    Apr 7, 2014 at 10:57 am
  • Dear multi-platform DBA's, We currently maintain Oracle databases and will be taking over DBA support for SQL Server databases in future. Could you please share recommendation on good training & ...
    Apr 1, 2014 at 7:51 pm
    Apr 1, 2014 at 8:43 pm
  • For those of you that support ms win db servers I saw an interesting line in the readme for the bundle released today. 3.1.1 environment checks 3. Explicitly disable WMI Sc config winmgmt ...
    Paul DrakePaul Drake
    Apr 22, 2014 at 12:49 pm
    May 8, 2014 at 12:22 pm
  • I am having a problem accessing a Global Temporary table inside a trigger. Here is my code: CREATE GLOBAL TEMPORARY TABLE gtt_ai_fin_transaction ( transaction_nbr number null, gl_date date null, ...
    Murray SobolMurray Sobol
    Apr 30, 2014 at 6:34 pm
    Apr 30, 2014 at 6:49 pm
  • One of my customers would like to send simple messages to SolarWinds from Enterprise Manager for alerts. There doesn't appear to be an existing connector in EM and I couldn't find anything ...
    Seth MillerSeth Miller
    Apr 29, 2014 at 9:58 pm
    Apr 30, 2014 at 2:27 pm
  • Running the agentpull.bat script at it failed at the end with: Performing the agent configuration... Executing command: f:\OracleHomes\agent12c\core\\oui\bin\runConfig.bat ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 2, 2014 at 6:14 pm
    Apr 28, 2014 at 10:35 pm
  • Hi I am check a query statistics in Exadata and I noticed that v$sql.IO_CELL_OFFLOAD_ELIGIBLE_BYTES is cero but IO_CELL_OFFLOAD_RETURNED_BYTES has a pretty high value. How can this possible? ...
    Ls ChengLs Cheng
    Apr 25, 2014 at 3:39 pm
    Apr 28, 2014 at 4:21 pm
Group Navigation
period‹ prev | Apr 2014 | next ›
Group Overview
grouporacle-l @

155 users for April 2014

Andy Gmail: 14 posts Hans Forbrich: 14 posts Mark Bobak: 14 posts Kenny Payton: 13 posts Mark W. Farnham: 13 posts Jonathan Lewis: 12 posts Cunningham, Mike: 11 posts Jeffrey Beckstrom: 10 posts Ls Cheng: 10 posts Mohamed Houri: 10 posts Upendra: 10 posts Iggy Fernandez: 9 posts Uzzell, Stephan: 9 posts Rich Jesse: 8 posts Tim Gorman: 8 posts Jay Miller: 7 posts Chitale, Hemant K: 7 posts Mangesh jagdale: 7 posts Powell, Mark: 7 posts Sayan Malakshinov: 7 posts
show more