FAQ

Oracle > oracle-l > March 2013

Search Discussions

108 discussions - 694 posts

  • Hey all - I'm writing a paper about top causes of downtime. As one component of research, I'd like to get some input from you! One minute, two sentences. First sentence: describe what went down ...
    Jeremy SchneiderJeremy Schneider
    Mar 14, 2013 at 9:08 pm
    Apr 8, 2013 at 7:15 pm
  • What is the simplest way to delete from a line POSITION to end of line through the whole file? The piece I can't figure out is to start the delete/strip portion at a specific line position on a ...
    Christopher Taylor2Christopher Taylor2
    Mar 15, 2013 at 1:37 pm
    Mar 19, 2013 at 8:39 pm
  • A few weeks ago there was a great discussion about Oracle performance books on this list. Learned about a few I had never seen before. I was wondering what IT books we might have studied over and ...
    Steve GardinerSteve Gardiner
    Mar 25, 2013 at 7:59 pm
    Mar 26, 2013 at 11:10 pm
  • Listers, Just wanted to get a general opinion on using comments in the database. For example COMMENT ON COLUMN table.column "No comment". Does anyone do this as a regular best practice? I would ...
    Z bZ b
    Mar 22, 2013 at 4:26 am
    Mar 22, 2013 at 2:47 pm
  • So is TDE the only way to encrypt from the db level? And is that an added expense? I am on HPUX. ciao, Brian ---------------------------------- Brian Zelli Senior Database Administrator Enterprise ...
    Zelli, BrianZelli, Brian
    Mar 19, 2013 at 2:53 pm
    Mar 19, 2013 at 9:19 pm
  • Hello all For a new dot com startup company I'm looking at the various options available, and one thing that struck me as new to me was that apparently you can deploy XE free of charge for production ...
    Stefan KnechtStefan Knecht
    Mar 17, 2013 at 2:04 am
    Mar 18, 2013 at 2:50 pm
  • Object rowed 199909 is a FK on child table. The foreign_key is indexed (one column to one column PK in parent) What scenario might cause this deadlock? I am googling around but not finding this ...
    Patterson, JoelPatterson, Joel
    Mar 20, 2013 at 2:50 pm
    Apr 17, 2013 at 12:50 pm
  • Funny thing happened today. Database backup for one of my development databases failed last night due to a space issue. While fixing that issue today, we received an alert that the archivelog space ...
    Christopher Taylor2Christopher Taylor2
    Mar 26, 2013 at 9:25 pm
    Mar 29, 2013 at 8:36 pm
  • Hi, Can someone explain me, why does AT cause deadlocks. Eg: I updated a table x in session 1 and want to update same from session 2 but with AT. It goes into deadlock. But normal update works fine ...
    Rajugaru VijRajugaru Vij
    Mar 25, 2013 at 7:57 am
    Aug 28, 2013 at 12:46 am
  • Hi, We are migrating DW database from AIX to linux, the online transaction is ok compared to AIX. But the batch job is 35% slower than AIX. Of course, the architecture are different, the storage is ...
    Hsieh, JoanHsieh, Joan
    Mar 22, 2013 at 4:48 pm
    Mar 28, 2013 at 3:20 pm
  • Ok, trying to do an oracle 11g install. I downloaded the 2 files from oracle, concatted them together and then unzipped on HPUX. I get directory /u01/oracle11/database/stage/Components and in that ...
    Zelli, BrianZelli, Brian
    Mar 26, 2013 at 2:31 pm
    Mar 26, 2013 at 4:51 pm
  • Hi all, It looks like it is pretty close to official that we are going to start migrating from Windows to Linux. One of my day-to-day tasks has always been scripting - windows batch scripting. I'll ...
    Uzzell, StephanUzzell, Stephan
    Mar 22, 2013 at 5:40 pm
    Mar 25, 2013 at 11:48 pm
  • Hi I have this doubt for quite long time and asked qite a few people but seems that so far no one knows the reasoning. If I run a simple FTS query against a 8GB table for example I can observe a I/O ...
    Ls ChengLs Cheng
    Mar 11, 2013 at 11:02 pm
    Mar 15, 2013 at 4:57 am
  • I've used DBMS_SERVICE to create a service and can start it successfully and everything is working fine, EXCEPT when I bounce the database, the service doesn't automatically start. What do I need to ...
    Christopher Taylor2Christopher Taylor2
    Mar 5, 2013 at 8:33 pm
    Mar 7, 2013 at 12:10 pm
  • Ok. Who knows/remembers how to log into an Oracle 7 database using os authentication? Thank you, WGB Although this e-mail and any attachments are believed to be free of any virus or other defect ...
    WblanchardWblanchard
    Mar 19, 2013 at 4:05 pm
    Mar 19, 2013 at 9:13 pm
  • I see the term "Oracle Internals" used in some of the Oracle-DBA job postings , not sure what they mean by that. I "guess", by internals they mean , knowledge of few more v$ tables , session trace & ...
    VasuVasu
    Mar 13, 2013 at 6:15 pm
    Mar 14, 2013 at 1:31 pm
  • Stick with VNC for installing/upgrading Cloud Control 12c. I ran into an "interesting" bug (14623310, now patched via auto-update) where Cygwin's openssh+Xserver, with or without the -Y/-X flags, ...
    Brian PardyBrian Pardy
    Mar 20, 2013 at 1:17 pm
    Mar 22, 2013 at 7:03 pm
  • Hello list, I have an outstanding Service Request with Oracle - who has sent this issue to development stating that this is a possible bug. I would like to verify that this issue does not work for ...
    Patterson, JoelPatterson, Joel
    Mar 11, 2013 at 6:46 pm
    Mar 13, 2013 at 7:33 am
  • My understanding for the OEM Grid repository is that you do NOT need a separate license for the Repository database as long as the monitored databases are licensed. Is that correct? -- ...
    Jeffrey BeckstromJeffrey Beckstrom
    Mar 4, 2013 at 3:05 pm
    Mar 7, 2013 at 12:09 am
  • We have a training database that we're going to setup as a flashbackable database (is that a word?). The requirement is to take the restore point on Monday, do the training and then flashback to the ...
    Christopher Taylor2Christopher Taylor2
    Mar 7, 2013 at 9:33 pm
    Mar 16, 2013 at 4:47 am
  • hi: The databases was upgraded from 10204 to 11203 version. After upgrade, we found that the CPU increased more than 30%. Compare the top SQLs CPU time before and after upgrade, I can see big ...
    Eagle FanEagle Fan
    Mar 6, 2013 at 2:18 pm
    Mar 11, 2013 at 6:33 am
  • Hi Gurus, I would like to know how to analyze and size undo for a busy database or while design itself. As the transactions increasing for a busy DB like reporting or DW DB we usually face lot of ...
    Apps DBAApps DBA
    Mar 25, 2013 at 7:54 pm
    Mar 26, 2013 at 1:22 pm
  • About to do our first split-mirror processing where we clone a copy of the DB, and the DB resides on top of ASM. Have done this plenty of times, but never with ASM. Looking for information on this ...
    Hubler, DanielHubler, Daniel
    Mar 1, 2013 at 2:24 pm
    Mar 4, 2013 at 7:53 am
  • 10.2.0.1.1 database on windows. Response is slow. Application seems to be a piece of crap. I set trace on for his session, and he re-enacted the "slowness" Details of the deadlock are below. After I ...
    Barbara BakerBarbara Baker
    Mar 27, 2013 at 7:15 pm
    Mar 27, 2013 at 9:25 pm
  • Oracle 11.2.0.3 Is it possible to set up change data capture for queries? I can register something manually that says 'get new records with this value in this field from this table'? Would need ...
    Dba DBADba DBA
    Mar 11, 2013 at 2:28 pm
    Mar 19, 2013 at 10:33 am
  • Does the /*+ monitor */ hint affect performance at all? Thanks for your help! -- http://www.freelists.org/webpage/oracle-l
    Josh CollierJosh Collier
    Mar 15, 2013 at 6:46 pm
    Mar 17, 2013 at 2:32 pm
  • Hi please post your login.sql / glogin.sql I need some examples for my environment. Lukas -- http://www.freelists.org/webpage/oracle-l
    Lukas LehnerLukas Lehner
    Mar 5, 2013 at 12:35 pm
    Mar 12, 2013 at 6:28 pm
  • I keep getting this error. I've googled and tried everything they say and can't get past this. checking monitor must be configured to display at least 256 colors I can't get past this....... I tried ...
    Zelli, BrianZelli, Brian
    Mar 26, 2013 at 6:39 pm
    Mar 29, 2013 at 5:29 am
  • This was really neat. I had to look up what comes after 999 trillion to figure out the cardinality, and what comes after 999 quadrillion to figure out the cost (I added commas for clarity...) SELECT ...
    DeedsdDeedsd
    Mar 27, 2013 at 8:45 pm
    Mar 28, 2013 at 5:58 pm
  • I just found out we might be getting this product/option. Prior to today, I'd never even heard of it. Is anybody out there using it and willing to share impressions/experiences? Thanks, Chris ...
    Stephens, ChrisStephens, Chris
    Mar 20, 2013 at 7:57 pm
    Mar 26, 2013 at 12:47 am
  • Hi all, This time I got the error ORA-01747: invalid user.table.column, table.column, or column specification in this query and I can't find the error. Please could someone help me? ...
    Jose SoaresJose Soares
    Mar 18, 2013 at 10:59 am
    Mar 18, 2013 at 3:21 pm
  • Hopefully someone has run into a similar issue and can help me out. We are doing a large datapump export to save as a historical archive. The database is 10.2.0.4. Since this version of expdp will ...
    Keith MooreKeith Moore
    Mar 9, 2013 at 2:47 pm
    Mar 11, 2013 at 1:38 pm
  • I downloaded the 11 instant client to my laptop. I try and run sqlplus, I get the ORA-12560 TNS protocol adapter error I set the sid, run it again and get same error I include the tnsnames entry in ...
    Zelli, BrianZelli, Brian
    Mar 6, 2013 at 8:46 pm
    Mar 6, 2013 at 10:10 pm
  • 11g was 10g redhat linux. Our developer dropped some code by mistake- Its Friday afternoon!. So I need to restore the DB but its just been converted to 11g from 10 and we were finally sorting out the ...
    Howard LathamHoward Latham
    Mar 1, 2013 at 3:44 pm
    Mar 1, 2013 at 4:22 pm
  • Spotlight on Oracle Hi, A want to ask about Spotlight on Oracle. Is this something that we can trus= t? I mean the information that provide us this software is enough accurate ?&n= bsp; Please share ...
    RootRoot
    Mar 22, 2013 at 3:17 pm
    Mar 23, 2013 at 2:46 pm
  • Jonathan is a frequent and extremely valuable contributor to this list, as well as being a certified "individual of extraordinary abilities and achievement" (a.k.a. holder of an O-1 visa) in the eyes ...
    Tim GormanTim Gorman
    Mar 8, 2013 at 4:06 pm
    Mar 11, 2013 at 6:20 pm
  • I was researching TDE and set up a test in a small Oracle 11.2.0.3 database on RHEL. I created a table with two rows of "sensitive" unencrypted information. I opened up my datafile in a hex editor ...
    Kevin LidhKevin Lidh
    Mar 7, 2013 at 6:10 pm
    Mar 7, 2013 at 6:46 pm
  • � Does anyone have this book, any feedback? http://www.amazon.com/Oracle-SQL-Tuning-SQLTXPLAIN/dp/1430248092/ref=sr_1_14?s=books&ie=UTF8&qid62520502&sr=1-14&keywords=oracle -- ...
    Rob GRob G
    Mar 5, 2013 at 10:01 pm
    Mar 7, 2013 at 10:18 am
  • Hi List, The "OT" in the subject is because this is an Oracle list and my question is (mostly) geared to MySQL. I've been asked (by a project manager) to perform a healthcheck on a MySQL database ...
    Guillermo Alan BortGuillermo Alan Bort
    Mar 25, 2013 at 8:04 pm
    Mar 26, 2013 at 5:59 pm
  • For those who are currently running production databases using OVM. Can you please share your experience. Specifically ... 1) Are you using Oracle hardware (ODA, Exadata)? If not, why? 2) Oracle ...
    FmhFmh
    Mar 20, 2013 at 2:03 pm
    Mar 24, 2013 at 8:35 am
  • Hi all, I need to dump an oracle database to convert it to postgresql which is the easiest way to do that? thanks j -- http://www.freelists.org/webpage/oracle-l
    Jose SoaresJose Soares
    Mar 15, 2013 at 10:56 am
    Mar 15, 2013 at 4:40 pm
  • Someone on LinkedIn is asking how to start the db when system01.dbf is missing and there is no backup. Interesting topic, but for the life of me I can't think how it can be done. There are some ...
    Andrew KerberAndrew Kerber
    Mar 9, 2013 at 7:22 pm
    Mar 10, 2013 at 8:37 am
  • What Oracle Advanced Compression features are available on environments other than the likes of Exadata and Pillar Axiom ? If I install 11.2.0.3 on OEL 5.6 but no commodity hardware and a "regular ...
    Hemant K ChitaleHemant K Chitale
    Mar 7, 2013 at 3:58 pm
    Mar 7, 2013 at 6:24 pm
  • On Windows, does Oracle or Windows do the I/O? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority Information Systems 1240 W. 6th Street Cleveland, Ohio 44113 -- ...
    Jeffrey BeckstromJeffrey Beckstrom
    Mar 27, 2013 at 12:12 pm
    Mar 29, 2013 at 6:00 am
  • Hi, We had a situation where data guard is used in a maximum performance mode and one (primary node) of the two RAC nodes failed after forceful reboot and primary hadn't switched logs yet, but the ...
    Viljo HakalaViljo Hakala
    Mar 27, 2013 at 8:09 pm
    Mar 28, 2013 at 6:30 am
  • Has anyone else noticed a change in the search results on MOS? Trying to determine if this a browser issue, my imagination or something else? If I put in the search terms using the basic knowledge ...
    April SimsApril Sims
    Mar 18, 2013 at 1:44 pm
    Mar 18, 2013 at 3:29 pm
  • Hallo all, we recently suggested to one of our clients to use table partitioning in order to make deleting old stuff from a large table faster. The partition would have been a range partition over a ...
    Thomas KellererThomas Kellerer
    Mar 18, 2013 at 12:52 pm
    Mar 18, 2013 at 2:18 pm
  • Env: 10.2.0.4 It's my understanding that DBA_PRIV_AUDIT_OPTS audits the use of database privileges (such as SELECT ANY TABLE) and that DBA_STMT_AUDIT_OPTS audits particular statement types. If this ...
    Christopher Taylor2Christopher Taylor2
    Mar 11, 2013 at 4:49 pm
    Mar 12, 2013 at 2:36 pm
  • 10g R2 Linux spfile only, I have deleted in init.ora file to avoid confusion the database is open show parameters job queue processes 2 alter database set job_queue_processes scope=both; shutdown ...
    Josh CollierJosh Collier
    Mar 5, 2013 at 12:21 am
    Mar 6, 2013 at 5:20 pm
  • I am running Oracle 11.2.0.3 on Linux, 64-bit. I am trying to create a physical standby database. Both databases are on the same physical server - this is just to work out the procedure. Normally we ...
    Scott CanaanScott Canaan
    Mar 6, 2013 at 2:32 pm
    Mar 6, 2013 at 3:54 pm
Mar 2013
123
Group Navigation
period‹ prev | Mar 2013 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions108
posts694
users179
websiteoracle.com

179 users for March 2013

Christopher Taylor2: 39 posts Hans Forbrich: 38 posts Patterson, Joel: 19 posts John Hurley: 16 posts Rjamya: 16 posts Andrew Kerber: 15 posts Mark W. Farnham: 15 posts Zelli, Brian: 14 posts Nuno Souto: 13 posts Tim Gorman: 12 posts Rajugaru Vij: 11 posts Wblanchard: 10 posts Ls Cheng: 10 posts Frits Hoogland: 9 posts Hsieh, Joan: 9 posts CRISLER, JON A: 8 posts Gerald Cunningham: 8 posts Hemant K Chitale: 8 posts Josh Collier: 8 posts Keith Moore: 8 posts
show more
Archives