Search Discussions

84 discussions - 387 posts

  • Hello all I'm wondering whether it is common practice to use the program chopt (resides in $ORACLE_HOME/bin) to disable certain non-licensed database options (11g onwards) (on 12c you can even ...
    Niels JespersenNiels Jespersen
    Nov 11, 2013 at 1:09 pm
    Nov 19, 2013 at 10:14 pm
  • I had a problem doesn't matter what - though it was with rman. Did lots of traces and diags and sent them to support. Support advised me to use a command option that when I tried it wasn't supported ...
    Howard LathamHoward Latham
    Nov 26, 2013 at 11:24 am
    Dec 4, 2013 at 8:32 pm
  • Hi All, Oracle AIX 6.1 We have this select statement on a table that is in a cluster by itself and has an index on it. if we run the following version of our select it uses the index and ...
    Jack van ZanenJack van Zanen
    Nov 5, 2013 at 12:57 am
    Nov 6, 2013 at 9:34 pm
  • We have an application that has been using a 10g database for years. We just created a new RAC database on a new RHEL5 Linux server. When the application used the 10g database, also on a ...
    Maureen EnglishMaureen English
    Nov 28, 2013 at 7:20 pm
    Dec 3, 2013 at 8:18 am
  • From the docs: "The SQLPATH registry entry specifies the location of SQL scripts. SQL*Plus searches for SQL scripts in the current directory and then in the directories specified by the SQLPATH ...
    Stephens, ChrisStephens, Chris
    Nov 7, 2013 at 4:42 pm
    Nov 11, 2013 at 5:21 pm
  • We have installed Enterprise Manger Grid Control 12c on Red Hat 6 and are trying to figure out how to use it. We can't get it to discover anything. It will monitor anything that we add completely ...
    Scott CanaanScott Canaan
    Nov 18, 2013 at 9:28 pm
    Nov 20, 2013 at 2:23 pm
  • All, I'm Trying to analyze the need to coalesce indexes after purge operations. Since our purge operations deletes rows from tables that are older than 6 months, we expect to see clean-up of leaf ...
    Nov 5, 2013 at 5:35 pm
    Nov 5, 2013 at 11:29 pm
  • This is a marketing article. I have not used teradata or exadata. I think Teradata is basically Oracle running on custom hardware sold by Oracle that is specialized for DB performance. anyone know ...
    Dba DBADba DBA
    Nov 27, 2013 at 5:02 am
    Nov 28, 2013 at 3:02 pm
  • Hi dbgurus, I have a db schema, which has around 950 table, 700 indexes, 70 views, 800 sequences. As of now when I deploy the schema, it takes around 10-12 minutes. I was wondering, if there's a way ...
    Raju AnganiRaju Angani
    Nov 8, 2013 at 5:42 am
    Nov 8, 2013 at 10:19 pm
  • (second attempt to send...first didn't appear to get to the list) Oracle Linux 6 RAC 2 node (development) and 3 node (production) I'm very new to RAC so pardon my leaving out relevant ...
    Stephens, ChrisStephens, Chris
    Nov 1, 2013 at 3:03 pm
    Nov 5, 2013 at 12:15 am
  • Hello all, I am trying to fix a hard parsing issue for database, Code on the app cannot be changed. So i was thinking to make use of SQL Profiles and use force_match=true...there are couple of SQL ...
    Abdul MohammedAbdul Mohammed
    Nov 23, 2013 at 1:09 am
    Nov 23, 2013 at 4:48 pm
  • LOL -- -- Patrice My profiles: [image: Facebook]<http://www.facebook.com/home.php?#!/profile.php?id=100000206805521 [image: LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9 [image ...
    Patrice sur GMailPatrice sur GMail
    Nov 20, 2013 at 3:06 pm
    Nov 21, 2013 at 5:42 am
  • Hi List, On a play-around sytem I do the following: (This is a RDBMS on linux x86 (32 bits)) drop table cbo_tab_1; create table cbo_tab_1 (id number, sca number(10,0), clu number(10,0), ...
    Martijn BosMartijn Bos
    Nov 17, 2013 at 9:51 pm
    Nov 20, 2013 at 10:14 pm
  • We are looking at migrating to Linux. We would like to configure HUGE Pages. When determining how many HUGE PAGES to allocate, do we just consider the SGA, the SGA and PGA or should all memory be ...
    Jeffrey BeckstromJeffrey Beckstrom
    Nov 20, 2013 at 8:14 pm
    Nov 20, 2013 at 8:42 pm
  • Hello All, NTP was running ahead of 5 hrs of normal time on Linux box. We have oracle database running on that server version 10g. Network team tried to synchronize the NTP and they synchronized the ...
    Nilesh kumarNilesh kumar
    Nov 18, 2013 at 1:34 pm
    Nov 18, 2013 at 5:33 pm
  • Any OS Any current Version A quick question that MAY promote some discussion. Whats the easiest/ most accurate way to get a database size with a view to copying it to another server (resizing is ok) ...
    Howard LathamHoward Latham
    Nov 14, 2013 at 11:56 am
    Nov 15, 2013 at 5:08 pm
  • Hi all, Creating a Dataguard configuration. As far as I can see the data guard itself is playing nice: archive logs generated on the primary side are shipped and applied to the standby database. I'm ...
    Martijn BosMartijn Bos
    Nov 12, 2013 at 9:50 am
    Nov 14, 2013 at 12:44 pm
  • Dear Gurus, I have a scenario, Table data from database A should be moved to database B on regular interval. If i purge table data on database A it should not purge on table B..how can we auto mate ...
    Nagaraj SNagaraj S
    Nov 4, 2013 at 5:58 pm
    Nov 7, 2013 at 3:53 pm
  • We are currently evaluating running a new database on Amazon Web Service Relational Database Service. The decision hasn't been made whether to run an Oracle or a SQL Server database. Another DBA ...
    Sandra BeckerSandra Becker
    Nov 13, 2013 at 8:50 pm
    Feb 21, 2014 at 7:45 pm
  • Hi all Does anyone know how Enterprise Manager gather and store Host CPU statistics? I am interetsed in knowing if the data stored is per minute to show the 24 hours chart, weekly and monthly or the ...
    Ls ChengLs Cheng
    Nov 12, 2013 at 12:33 pm
    Dec 12, 2013 at 11:46 am
  • List, I am looking for some of the most common and frequently used techniques to improve scalability of oracle database systems. I see that minimizing the work like reducing latch contention, ...
    C PC P
    Nov 1, 2013 at 7:33 am
    Nov 14, 2013 at 6:07 pm
  • We recently had to change the hostname of one of the servers my EM 12c is monitoring. What do I have to do to in EM 12c to recognize the new server name? Do I have to uninstall the agent and ...
    Backseat DBABackseat DBA
    Nov 11, 2013 at 9:10 pm
    Nov 12, 2013 at 10:46 pm
  • I am seeking recommendations on good books for a DBA new to the Linux/Unix environment. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority Information Systems 1240 ...
    Jeffrey BeckstromJeffrey Beckstrom
    Nov 8, 2013 at 7:39 pm
    Nov 9, 2013 at 9:32 pm
  • I understand (I think) the following points: Metalink Documents say that: "In Automatic Degree of Parallelism can only be used if I/O statistics are gathered." DocID: 1269321.1 "The hardware ...
    Chris TaylorChris Taylor
    Nov 1, 2013 at 6:53 pm
    Nov 3, 2013 at 3:27 pm
  • Hi List I was hoping to pick the brains of those who've had a similar challenge: I've automated installation of the Oracle Client in my company via scripted cloning (unzip the software gold image, ...
    Austin HackettAustin Hackett
    Nov 19, 2013 at 8:39 pm
    Dec 4, 2013 at 9:00 pm
  • Hi, I am facing problem installing with ASM on OEL 6.4 64 bit (2.6.39-400.211.1.el6uek.x86_64), while executing /u01/app/oracle/product/11.2.0/grid/root.sh I get errors [[email protected] app]# cd ...
    Ankit ThakwaniAnkit Thakwani
    Nov 26, 2013 at 4:44 pm
    Nov 26, 2013 at 5:39 pm
  • Folks, We are transitioning from Solaris to Linux and my question is around Linux because I am not seeing the same behavior on Solaris. I have a multi-tier Oracle ERP environment where the DB is ...
    Hameed, AmirHameed, Amir
    Nov 12, 2013 at 10:34 pm
    Nov 14, 2013 at 8:03 pm
  • Hello Andy and Henry, I've been sending Oracle audit logs to syslog for quite a while now. I very much like this setup because it's then very easy to generate audit reports with log mining tools such ...
    David RobillardDavid Robillard
    Nov 6, 2013 at 12:54 pm
    Nov 6, 2013 at 5:19 pm
  • G'day Oracle with Oct13 CPU, on RHEL 6 We have 2 servers: one runs just one instance - Production - with Memory_Target = 4G and Memory_Max_Target = 25G. The other server has 7 instances: an ...
    De DBADe DBA
    Nov 29, 2013 at 2:09 am
    Dec 1, 2013 at 11:38 pm
  • We are considering a migration from Windows to Linux for our databases and application tiers. To gauge usage, I have created a short three question survey on which vendor is most popular. I would ...
    Jeffrey BeckstromJeffrey Beckstrom
    Nov 26, 2013 at 5:27 pm
    Nov 26, 2013 at 9:43 pm
  • Hey all, Creating new DBs in and my SOP has been to create datafiles with a MAXSIZE of 31G (8K blocksize). I thought I should revisit -- and *document* -- that SOP, but all I can remember is ...
    Rich JesseRich Jesse
    Nov 26, 2013 at 5:06 pm
    Nov 26, 2013 at 8:01 pm
  • I am seeking recommendations on companies that do DBA training in the Cleveland, Ohio area. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority Information Systems ...
    Jeffrey BeckstromJeffrey Beckstrom
    Nov 25, 2013 at 5:13 pm
    Nov 26, 2013 at 8:35 am
  • Hello, I have several locks in the instance. All stopped and don´t finish ... I would like to know what is the main session that is the root cause for all locks. I used these queries, but I cannot ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Nov 20, 2013 at 7:44 pm
    Nov 20, 2013 at 8:39 pm
  • Hi Can someone provide the views as what is difference on 2 node active-active cluster and not on RESTART as what is difference for the following two command to stop/start Cluster software crsctl ...
    Sanjay MishraSanjay Mishra
    Nov 12, 2013 at 5:22 pm
    Nov 13, 2013 at 1:43 am
  • Do you need to separately license SQLPLUS, SQLLDR, etc. or do they fall under your database licensing agreement? Please reference an Oracle document if possible. Jeffrey Beckstrom Database ...
    Jeffrey BeckstromJeffrey Beckstrom
    Nov 12, 2013 at 4:48 pm
    Nov 12, 2013 at 5:23 pm
  • I'm used to seeing raw disks/devices inside ASM diskgroups, but at my new contracting gig, they have a Netapp storage appliance, and are using nfs mounted luns. What they've done in the ASM ...
    Chris TaylorChris Taylor
    Nov 7, 2013 at 3:49 pm
    Nov 7, 2013 at 6:13 pm
  • Hello All, Hope every one is doing good!! I have a question. Can select 1 from dual can cause the Temp tablespace Full ? I see from Toad several sessions of a user executing select 1 from dual ...
    Nilesh kumarNilesh kumar
    Nov 6, 2013 at 4:49 pm
    Nov 6, 2013 at 5:59 pm
  • It appears only is certified on Solaris 11? I assume I'm reading this correctly: Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation ...
    Chris TaylorChris Taylor
    Nov 26, 2013 at 10:56 pm
    Nov 26, 2013 at 11:26 pm
  • Hello, I have licensing question about subj. If a have 2 server cluster , each has 2 cpu , 8 cores per cpu. (total 32 cores). I wish use option Oracle RAC One, how to correct license my cluster ? Do ...
    Andrejs KaulinsAndrejs Kaulins
    Nov 26, 2013 at 9:33 pm
    Nov 26, 2013 at 11:02 pm
  • Hi, I'm tuning some queries and the developers seem to be quite fond of nesting views in views in ... To get a better understanding of all tables involved I would like to see the expanded statement, ...
    D'Hooge FreekD'Hooge Freek
    Nov 26, 2013 at 5:10 am
    Nov 26, 2013 at 8:26 am
  • Hi all, I have a query generated by sqlalchemy like this: SELECT fattura_master.tipo_documento AS fattura_master_tipo_documento, fattura_master.sezionale || '/' || CAST(fattura_master.anno AS ...
    Jose SoaresJose Soares
    Nov 22, 2013 at 9:42 am
    Nov 22, 2013 at 3:58 pm
  • Hi, I am facing this problem. When the refresh COMPLETE ON DEMAND of a mview starts via job (automatically from user_jobs), as schedulled and some tables (at least 10) used in the mview are locked , ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Nov 21, 2013 at 10:18 pm
    Nov 22, 2013 at 1:10 am
  • Hi list! I was wondering if anyone found particulaly useful Apps from the Splunk website that we may have overlooked? We've been using it for about a year and have been using it for multiple ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Nov 18, 2013 at 6:13 pm
    Nov 19, 2013 at 6:48 pm
  • Hi listers, who will be in Nuremberg for DOAG conference tomorrow and the following days? Would be great to collect more faces to the names on the list! :) Hope to see you there Martin Klier -- Usn's ...
    Martin KlierMartin Klier
    Nov 18, 2013 at 9:42 am
    Nov 18, 2013 at 5:00 pm
  • Hi List, Oracle version 11.2 or higher (RHEL 6.3). Subject nearly says it all: Can an MV be directly (not CTAS) converted into a "normal" table? I did a search of Oracle SQL syntax and I find nothing ...
    Nov 15, 2013 at 7:34 pm
    Nov 15, 2013 at 8:52 pm
  • We are running an Oracle 10g XE instance which has worked fine for years but we recently started using Apex with it, upgraded to Apex 4.2. There have been two instance in the last week where the ...
    Jeff CJeff C
    Nov 13, 2013 at 10:07 pm
    Nov 14, 2013 at 11:44 pm
  • Listers, Looking for feedback on what others do for personal/learning usage for various features. I've used the downloadable versions for years for this purpose, but there is no support, and they are ...
    Larry ElkinsLarry Elkins
    Nov 9, 2013 at 3:48 am
    Nov 11, 2013 at 11:16 pm
  • It is a common idea that there are more sql server than oracle dba jobs in the united states. Is this true? How would it be verified? Have a good day, Josh C.
    Josh CollierJosh Collier
    Nov 5, 2013 at 11:31 pm
    Nov 6, 2013 at 4:34 am
  • Good Morning Gurus, Please share me windows batch script to automate the export and import activity in oracle version. I need to take export of a table daily and import to table of different ...
    Nagaraj SNagaraj S
    Nov 5, 2013 at 12:57 pm
    Nov 6, 2013 at 2:55 am
  • Hello, Is it possible to have cloud control monitor a listener for a service name? For example, let's say we have a process that will log into database A or database B and set the database ...
    Michael SchmittMichael Schmitt
    Nov 1, 2013 at 8:53 pm
    Nov 4, 2013 at 8:51 pm
Group Navigation
period‹ prev | Nov 2013 | next ›
Group Overview
grouporacle-l @

128 users for November 2013

Hans Forbrich: 17 posts Niall Litchfield: 13 posts Jonathan Lewis: 12 posts Andy Klock: 11 posts Mark Bobak: 11 posts Mark W. Farnham: 11 posts Chris Taylor: 10 posts Rich Jesse: 10 posts Jeffrey Beckstrom: 9 posts Justin Mungal: 9 posts Stephens, Chris: 9 posts Martijn Bos: 8 posts Howard Latham: 7 posts Radoulov, Dimitre: 7 posts Sanjay Mishra: 7 posts De DBA: 6 posts Jared Still: 6 posts Jeff C: 6 posts Brent Day: 5 posts David Fitzjarrell: 5 posts
show more