Search Discussions

98 discussions - 438 posts

  • I've got a vendor going on about SSD Storage for database - Are these the way to go as far as performance goes? -- Howard A. Latham -- http://www.freelists.org/webpage/oracle-l
    Howard LathamHoward Latham
    Oct 17, 2012 at 12:28 pm
    Oct 22, 2012 at 10:15 am
  • Env: Oracle **My Goal: To understand WHY Oracle is opting for the FTS over an INDEX in this case. Why/where Oracle determines the _PERF index is not the best choice.** I have a fairly simple ...
    Christopher Taylor2Christopher Taylor2
    Oct 11, 2012 at 4:54 pm
    Oct 12, 2012 at 8:06 am
  • Can I load 11g on an already existing 10g instance? Any gotchas? ciao, Brian This email message may contain legally privileged and/or confidential information. If you are not the intended ...
    Zelli, BrianZelli, Brian
    Oct 3, 2012 at 2:29 pm
    Oct 3, 2012 at 10:07 pm
  • Hi all, I've wanted to demonstrate to my colleagues that it's safe to configure RMAN CONTROLFILE AUTOBACKUP ON, using the following general setup: * retention policy set to 1 (not advisable of ...
    Sigrid KeydanaSigrid Keydana
    Oct 25, 2012 at 4:34 pm
    Nov 13, 2012 at 10:09 pm
  • Hi Can someone help as what is best approach in term system performance and best practices for auditing. Requirements is only to check what user has not logon to the database in x number of days and ...
    Sanjay MishraSanjay Mishra
    Oct 18, 2012 at 2:33 am
    Oct 19, 2012 at 6:26 pm
  • I figured out how to send attachments using UTL_SMTP (from code found on the web) and the code I'm using uses a clob variable to build the attachment. So I pieced together a function to build a clob ...
    Christopher Taylor2Christopher Taylor2
    Oct 4, 2012 at 8:09 pm
    Oct 5, 2012 at 10:18 pm
  • This is probably a simple one but definitely something new for me. Database: OS: Oracle Linux 5.6 A SQL like SELECT A.COL1, A.COL2, B.COL3 FROM TABLE1 A, TABLE2 B, TABLE3 C WHERE A.ID = B.ID ...
    Ramadoss, KarthikRamadoss, Karthik
    Oct 24, 2012 at 7:01 pm
    Oct 25, 2012 at 12:47 pm
  • Anyone else have metalink connectivity issues? Here at 9:20 am ETD timeframe ? Raj -- http://www.freelists.org/webpage/oracle-l
    Oct 11, 2012 at 1:23 pm
    Oct 11, 2012 at 4:13 pm
  • Let me try this again. I am working on upgrading our Linux servers running Oracle database to a newer generation with faster CPUs and more RAM. I just wanted to share my plan to the list and see if ...
    Ramadoss, KarthikRamadoss, Karthik
    Oct 5, 2012 at 1:17 pm
    Oct 24, 2012 at 3:09 pm
  • Hi Did anyone came accross excessive "tables consistent reads - undo records" in ? In our case it looks like this: - select * from table, full scan - table segment is about 400MB, one would ...
    Laimutis NedzinskasLaimutis Nedzinskas
    Oct 3, 2012 at 8:33 am
    Oct 9, 2012 at 4:31 am
  • Hopefully, I got the right address this time. Okay, generic storage question. ************************************* When I setup my current production box, we bought a beefy box with internal storage ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Oct 24, 2012 at 6:49 pm
    Nov 1, 2012 at 11:14 pm
  • For determining the dataguard standbylag, relying on current_scn from v$database is far more consistent and accurate than v$dataguard_stats. You can use v$dataguard_stats for breakdown of transport ...
    Saibabu DevabhaktuniSaibabu Devabhaktuni
    Oct 24, 2012 at 12:09 am
    Oct 27, 2012 at 9:23 pm
  • I'm attempting to access MOS this morning and I get logged on, eventually, but all I see is a note that says "MOS unavailable, read Site Alerts on the Dashboard page". Ok, I can live with that ...
    Norman DunbarNorman Dunbar
    Oct 24, 2012 at 10:03 am
    Oct 25, 2012 at 1:08 pm
  • Hey all, Recently (this week?) the MOS interface shows ambiguous "1+ week ago" for the dates and times updated on SRs. It can make it very difficult to work on them when they're open for months, not ...
    Rich JesseRich Jesse
    Oct 19, 2012 at 2:29 pm
    Oct 20, 2012 at 4:30 pm
  • Does anyone have any guidelines/docs on sizing memory for ASM instances? Note 437924.1 basically says "Use the default of 272mb and you will be fine in all circumstances, and if you aren't log an SR" ...
    Niall LitchfieldNiall Litchfield
    Oct 8, 2012 at 3:53 pm
    Oct 12, 2012 at 5:43 pm
  • Hi all, I'm looking for some linux script to migrate from pg to oracle. At the moment I dump data from pg using pg_dump in the format: INSERT INTO table (columns) (values) then I load it into the ...
    Oct 24, 2012 at 6:41 am
    Oct 24, 2012 at 4:27 pm
  • I found an interesting non standard feature in postgres to distinguish one column in a query. How can I do this in Oracle? select * from test; a | b ----+----- a | b a | bb a | bbb ab | bbb aa | bbb ...
    Oct 18, 2012 at 6:39 am
    Oct 18, 2012 at 8:22 am
  • Hello I know i can use dbms_output.put_line to write information to the output buffer when using pl/sql. But if i have a loop that must delete 1 million rows, its is possible to write the info ...
    Ricard MartínezRicard Martínez
    Oct 9, 2012 at 6:13 pm
    Oct 9, 2012 at 7:57 pm
  • AIX 6.1 Oracle Have been running RAC on 10g (with 3rd party software) for years. Now putting together our first 11g RAC with ASM. Confused about (best?) practices for ASM, diskgroups, voting ...
    Hubler, DanielHubler, Daniel
    Oct 31, 2012 at 8:05 pm
    Nov 25, 2012 at 4:54 pm
  • Hello From where I can download asmlib packages for Redhat Linux 6.3 x86_64 ? (2.6.32-279.el6.x86_64) I need to install ASM for database. Thanks S -- http://www.freelists.org/webpage/oracle-l
    Mek SMek S
    Oct 22, 2012 at 11:17 am
    Oct 22, 2012 at 7:05 pm
  • Hi Friends, I am running the pl/sql block below and it is too slow. This query returns only 266 lines. SELECT index_name FROM user_indexes WHERE index_type = 'DOMAIN' Any idea ? -- start of script ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Oct 16, 2012 at 3:14 pm
    Oct 16, 2012 at 7:39 pm
  • Hi list, how should ASM register new diskgroups with Grid Infrastructure? I was under the impression that the services like ora.ORADATA.dg are created as soon as I mount the DG for the first time ...
    Martin KlierMartin Klier
    Oct 15, 2012 at 9:24 am
    Jan 7, 2013 at 7:29 pm
  • I'm writing this in the hope that someone has maybe seen this and found a solution. I also have an SR with Oracle. RHEL5.6, oracle, 8-node RAC Two RACS with one-direction Golden Gate ...
    Walker, Jed SWalker, Jed S
    Oct 23, 2012 at 6:42 am
    Oct 23, 2012 at 6:45 pm
  • Hi, We've got a large RAC database where we've been using SPBs for about 6 months. The SPBs were generated in the perf test environment and then migrated across. There are still plenty of SQL ...
    Chris DunscombeChris Dunscombe
    Oct 8, 2012 at 9:07 am
    Oct 8, 2012 at 5:49 pm
  • Interesting, sounds like a Greasemonkey script may be in order to make this more accessible... Or Chrome extension like Tyler Muth's effort to make AWR reports more user friendly. Sent from my iPhone ...
    David MannDavid Mann
    Oct 21, 2012 at 11:56 am
    Oct 30, 2012 at 2:43 pm
  • Hi Has anybody started using this feature https://twitter.com/fritshoogland/status/235146135084351488 of and experienced a 10X improvement in their OLTP applications by enabling flash write back ...
    Oct 25, 2012 at 6:20 am
    Oct 26, 2012 at 12:16 am
  • I was reading somewhere (and I can't put my hands on it now of course) where when LGWR is slow, that it backs stuff up bad enough that blocks can't get into the cache fast enough and will slow the ...
    Christopher Taylor2Christopher Taylor2
    Oct 18, 2012 at 7:48 pm
    Oct 18, 2012 at 11:53 pm
  • For those who did not make it. https://oracleus.activeevents.com/connect/search.ww?event=openworld -Michael. -- http://www.freelists.org/webpage/oracle-l
    Michael DinhMichael Dinh
    Oct 16, 2012 at 12:19 pm
    Oct 17, 2012 at 2:39 am
  • Hi List, Can anyone tell me if there is a v$, x$ or dba_ table/view that contains file system details for the physical files that make up an oracle database? I recently accepted a job (Oracle DBA) at ...
    Kenneth FowlerKenneth Fowler
    Oct 12, 2012 at 8:14 pm
    Oct 15, 2012 at 1:13 pm
  • Can you use database links? I'd create a procedure in the database you want to populate and have it link over, pull the job code out, and then programatically switch the job number before it submits ...
    Christopher Taylor2Christopher Taylor2
    Oct 8, 2012 at 6:36 pm
    Oct 8, 2012 at 8:36 pm
  • Hi all, I would like to convert values of a varchar2 column type to a number. I'm using to_number function but I have mixed values in my table, there are some columns with not numeric values and ...
    Jose soaresJose soares
    Oct 5, 2012 at 9:29 am
    Oct 6, 2012 at 10:16 pm
  • Good afternoon, I'm doing my very first RAC install and I'm wondering if I broke something. I got the Grid Infrastructure completely installed and working OK. Went to install the Oracle DB software ...
    Steve WalesSteve Wales
    Oct 22, 2012 at 9:29 pm
    Oct 23, 2012 at 6:47 pm
  • This pas weekend I upgraded my production OLTP from 10g to 11g (SUSE11 on IBM zLinux), then I created an 11g standby. We moved the database to newer, faster, correctly configured storage at the same ...
    Sandra BeckerSandra Becker
    Oct 22, 2012 at 6:39 pm
    Oct 22, 2012 at 8:11 pm
  • Version I've been going round and round with this. Here's a sample of my data and what I need out of it. NAME....DETAILED_NAME....START_DATE________.....END_DATE_________ ...
    Christopher Taylor2Christopher Taylor2
    Oct 18, 2012 at 11:53 am
    Oct 18, 2012 at 1:31 pm
  • Are there any good online comparisons between current version of sql*server and oracle rdbms? Anyone have any insight into the relative strength of sql*server vs. oracle? -- ...
    Josh CollierJosh Collier
    Oct 16, 2012 at 9:42 pm
    Oct 17, 2012 at 9:29 pm
  • When gathering SYSTEM stats, do those stats take a while to affect the query plans once they are collected? (a "while" being some "x" amount of time - I thought they would be immediate) Last night I ...
    Christopher Taylor2Christopher Taylor2
    Oct 12, 2012 at 3:09 pm
    Oct 17, 2012 at 9:12 am
  • This is more of a curiosity question really. If the database is under high load (many sessions, lots of IO, multiple statements accessing the same tables) would it be reasonable to think that the ...
    Christopher Taylor2Christopher Taylor2
    Oct 13, 2012 at 4:57 pm
    Oct 13, 2012 at 7:18 pm
  • Hi, I am running Oracle 64 bit on Solaris 10. I have a process that runs on the database server and calls a plsql package via a shell script like so: sqlplus user/pass @scriptname parm1 ...
    Mike boliganMike boligan
    Oct 3, 2012 at 10:18 pm
    Oct 11, 2012 at 9:27 pm
  • Hi All, Greeting. I am presently using the queries below to find out which session locks the others. But when the list becomes long, it becomes hard. I was wondering if i can somehow find the lock ...
    Sundar mahadevanSundar mahadevan
    Oct 9, 2012 at 8:01 pm
    Oct 10, 2012 at 8:26 pm
  • That is correct, just make sure it goes to former before you add it back in to another diskgroup. ASM software should prevent it, but be careful. The rebalance operation has to complete before it ...
    Andrew KerberAndrew Kerber
    Oct 10, 2012 at 6:16 pm
    Oct 10, 2012 at 7:29 pm
  • Hi Alan, _if I recall correctly_, the hostname constraint applies only to MR node[s] (where the OID binaries reside). Changing the hostname _of the database_ (the RAC nodes, in your case) shouldn't ...
    Radoulov, DimitreRadoulov, Dimitre
    Oct 9, 2012 at 3:02 pm
    Oct 9, 2012 at 5:14 pm
  • Hi Friends, I have the following situation: I want to retrieve all sequences , or all synonyms without specify each sequence name or synonym name using DBMS_METADATA.get_ddl. This does not work. I ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Oct 5, 2012 at 1:43 pm
    Oct 5, 2012 at 2:17 pm
  • All experts, I am trying to write aws webservice with plsql based on some links i got them from blogs Based on these url's i wrote this code ...
    Vamshi DamidiVamshi Damidi
    Oct 5, 2012 at 12:31 am
    Oct 5, 2012 at 8:42 am
  • Friends, Which Golden Gate book would you recommend for a Oracle DBA ? 1) Expert Oracle GoldenGate - By Ben Prusinski , Steve Phillips , Richard Chung (Apress) OR 2) Oracle GoldenGate 11g ...
    Prem KhannaPrem Khanna
    Oct 29, 2012 at 7:09 am
    Oct 31, 2012 at 7:03 am
  • Hi All, I am a newbie to oracle dataguard. I had one doubt regarding real time apply feature in 10.2 Using Real-Time Apply to Apply Redo Data in a physical standby in 10.2 has the following benefits ...
    Oct 25, 2012 at 5:06 pm
    Oct 25, 2012 at 7:53 pm
  • Hey all, After upgrading to (64-bit AIX 5.3), during index creates with DOP 2 on our dev DB, EM12c goes nuts in alerting me to blocking locks. It looks like the issue is in the DB: There are ...
    Rich JesseRich Jesse
    Oct 17, 2012 at 3:34 pm
    Oct 25, 2012 at 3:29 pm
  • We recently found out about the drop in support for asmlib on RedHat 6. Has anyone configured disks for ASM on IBM XIV storage over fiber channel? OS is RedHat v6 64 bit, hardware is IBM HS22 X86 64 ...
    Don MorseDon Morse
    Oct 24, 2012 at 8:22 pm
    Oct 24, 2012 at 10:33 pm
  • It just struck me that this query could be a victim of bind peeking. We loop through multiple ORG_IDS and we see this perf problem for different orgs every night - each org may or may not have data ...
    Christopher Taylor2Christopher Taylor2
    Oct 13, 2012 at 5:09 pm
    Oct 19, 2012 at 6:28 pm
  • Sayan, Here is what I guess explains what you observed: Whether we call it distributed transaction or not, a simple query over dblink will require transaction to be created on the local and the ...
    Saibabu DevabhaktuniSaibabu Devabhaktuni
    Oct 16, 2012 at 6:15 am
    Oct 19, 2012 at 8:03 am
  • Hello, I wonder if there are any issues in using Oracle 11gR2 restart and DG FSFO Observer together. Oracle restart is used for automatic restart of resources (database instance, listeners, etc..) ...
    Mek SMek S
    Oct 17, 2012 at 3:52 pm
    Oct 18, 2012 at 12:59 pm
Group Navigation
period‹ prev | Oct 2012 | next ›
Group Overview
grouporacle-l @

140 users for October 2012

Christopher Taylor2: 41 posts Rjamya: 17 posts Mark W. Farnham: 16 posts David Fitzjarrell: 13 posts Ramadoss, Karthik: 13 posts Jonathan Lewis: 12 posts Niall Litchfield: 11 posts Saibabu Devabhaktuni: 9 posts Patterson, Joel: 8 posts Powell, Mark: 8 posts Yong Huang: 8 posts Andy Gmail: 7 posts Eriovaldo Andrietta: 7 posts Radoulov, Dimitre: 7 posts Jared Still: 6 posts Kellyn Pot'Vin: 6 posts Michael Dinh: 6 posts Rich Jesse: 6 posts Sanjay Mishra: 6 posts Vamshi Damidi: 6 posts
show more