FAQ

Search Discussions

111 discussions - 699 posts

  • hi guys, recently we got an alert from OEM on the metric Disk Device Busy (%) (it was at about 99% or something like that). My Oracle Forums and Metalink search yielded some interesting results that ...
    Guillermo Alan BortGuillermo Alan Bort
    Nov 21, 2011 at 3:46 pm
    Nov 27, 2011 at 7:00 pm
  • I am a bit puzzled, maybe I am getting rusty. I need to create a user with bare minimum permissions: CREATE USER bb_stage IDENTIFIED BY "password" DEFAULT TABLESPACE users TEMPORARY TABLESPACE TEMP ...
    Leo DrobnisLeo Drobnis
    Nov 8, 2011 at 3:42 pm
    Nov 10, 2011 at 8:39 am
  • Hi, I have a trigger that under a condition, I call raise_application_error. I also have when others defined to write to an error table passing sqlerrm and sqlcode. My understanding is that when the ...
    Chuck BoddyChuck Boddy
    Nov 30, 2011 at 9:11 pm
    Dec 2, 2011 at 10:03 pm
  • Hi, a sql with the structure: WITH t1 As ( select .. ), WITH t2 As ( select ... ), ... WITH t77 As ( select ... ) select ... from t1 join t2 join .. t77l I run it through sql plus with autotrace, I ...
    DenisDenis
    Nov 14, 2011 at 9:20 pm
    Nov 15, 2011 at 9:15 pm
  • 18

    RAID5

    Stirring the pot a bit maybe... Given improvements in recent years, is RAID 10 still relevant in high-traffic environments? Patrice <http://www.viadeo.com/fr/profile/patrice.boivin [image: Facebook] ...
    Patrice sur GMailPatrice sur GMail
    Nov 15, 2011 at 7:27 pm
    Dec 2, 2011 at 7:19 am
  • Hi I have this simplified SQL statement within Shell Script. function () { sqlplus -S $DBO/$DBOPW@$ORACLE_SID <<EOF /opt/test/output.$(/bin/date '+%d%m%Y.%Hh') set echo Off [...] set linesize 20000 ...
    Sven AluoorSven Aluoor
    Nov 23, 2011 at 3:38 pm
    Nov 29, 2011 at 6:39 pm
  • I have got 2 questions: 1. We are planning to convert our OLTP sql server databases to oracle databases. I tried using SQL Developer to migrate a small sql server database to oracle database(size ...
    KrishnaKrishna
    Nov 12, 2011 at 2:35 am
    Nov 14, 2011 at 1:59 pm
  • Anyone have ideas why an index with blevel 3 is averaging 13 LIOs per lookup/row? I'm working on the query below, which ran for about 10 hours - the majority of which was spent doign 13 logical IOs ...
    Jeremy SchneiderJeremy Schneider
    Nov 17, 2011 at 11:36 am
    Nov 28, 2011 at 11:58 am
  • Ok, this is really ticking me off. I created a user and when I try and connect via sqlplus I get ORA-12154: TNS:could not resolve service name Yet I can connect with other users to the same instance ...
    Zelli, BrianZelli, Brian
    Nov 3, 2011 at 4:22 pm
    Nov 4, 2011 at 1:39 am
  • Hey all, Thought I'd mention that every ebook is $15 at apress.com today (or should that read "each" ebook?). I just added a couple of Oracle ones to my collection. Happy shopping! Rich -- ...
    Rich JesseRich Jesse
    Nov 28, 2011 at 6:02 pm
    Nov 30, 2011 at 7:31 am
  • Its an art and a science isn't it. I like suffixes for some things, and prefixes for others. I'm limiting my question to constraints and associated indexes and only the suffixes. I use suffixes for ...
    Joel PattersonJoel Patterson
    Nov 9, 2011 at 7:19 pm
    Nov 11, 2011 at 7:54 am
  • I often puzzle over the best way to deal with coding for NOT EQUAL conditions ( where x != y) in SQL code when I'm looking at performance tuning. In some cases, it's just a matter of education and ...
    Taylor, Chris DavidTaylor, Chris David
    Nov 15, 2011 at 7:11 pm
    Nov 17, 2011 at 7:14 pm
  • Position: Sr Oracle DBA (Oracle Database Administrator) with nationally known company! Location: Chicago Illinois area (western suburb) Must already be in the Chicago area. Salary: Up To 105,000. and ...
    OrastaffOrastaff
    Nov 2, 2011 at 7:37 pm
    Nov 16, 2011 at 4:57 pm
  • Content-Type: text/plain; charset="US-ASCII" a SR is opened due to an issue with dbms_metadata.get_ddl. Solution: drop and recreate sys.dual, so the junior DBA does as said and now can't recreate due ...
    Testaj3Testaj3
    Nov 1, 2011 at 7:07 pm
    Nov 4, 2011 at 2:51 am
  • Hi, I am migrating a 10g data warehouse to new blade servers with netapp storage. The netapp best practice guide suggests using asm for only the cluster files, but Oracle says I should be using asm ...
    Steiner, RandySteiner, Randy
    Nov 28, 2011 at 5:36 pm
    Dec 13, 2011 at 6:03 pm
  • Hello all, just wondering how others did technical illustrations? I'm immediately thinking "Visio", and although I have a license I don't like the Visio look to technical illustrations. I looked at ...
    Martin BachMartin Bach
    Nov 25, 2011 at 2:07 pm
    Dec 9, 2011 at 6:28 pm
  • All, Here are some particulars: Oracle 11.2.0.1 Windows 2008 Server We normally don't run Oracle on Windows, but one vendor insists that the Oracle database must be on windows. In our Unix / Linux ...
    Scott CanaanScott Canaan
    Nov 10, 2011 at 7:32 pm
    Nov 15, 2011 at 2:24 pm
  • Greetings Oracle List! We're moving an Oracle Database to a new Server upgrading from 10 to 11 with Datapump. Can we migrate the schema's without knowing/changing the passwords? We took a datapump ...
    Steve montgomerieSteve montgomerie
    Nov 30, 2011 at 3:12 pm
    Nov 30, 2011 at 8:59 pm
  • I have set up rman using flash_recovery. I've run a couple of backups for testing. When I do the command: SQL archive log list It returns oldest online sequence of 926; next log sequence to archive ...
    Denise GwinnDenise Gwinn
    Nov 9, 2011 at 9:52 pm
    Nov 10, 2011 at 5:38 pm
  • Hi As part of regression testing in our db upgrade from 11.1.0.7 to 11.2.0.2, one of the developers reported a slow sql (attached slow_sql.sql) We did a 10053 trace and noticed one of the things was ...
    Kumar MadduriKumar Madduri
    Nov 9, 2011 at 3:06 am
    Nov 9, 2011 at 7:19 pm
  • Looking at a variety of systems I can see that there is a difference between the space available on each disk of a ASM disk group. This is despite the documentation stating :- If the disks are the ...
    John HallasJohn Hallas
    Nov 15, 2011 at 11:45 am
    May 2, 2012 at 9:02 am
  • I have been diving into auditing over the past few weeks and have worked out almost all the scenarios that we are interested in auditing. Most of the actions are related to user activity. We have one ...
    David MannDavid Mann
    Nov 18, 2011 at 2:42 pm
    Nov 23, 2011 at 5:20 pm
  • Hi All, Let's say I have 2 sessions open... session one updates a table and does not commit and can view the new updated data. session 2 is able to read the old data. How can session 2 read the old ...
    Paul HarrisonPaul Harrison
    Nov 17, 2011 at 7:53 pm
    Nov 17, 2011 at 9:40 pm
  • There has been discussion on this before on Oracle-L as I have googled and come across some of it. I am having trouble recreating the cases for using Explicit indexes, over implicit (as shown by ...
    Joel PattersonJoel Patterson
    Nov 16, 2011 at 3:11 pm
    Nov 17, 2011 at 6:30 pm
  • Environment: Oracle 9.2.0.8.0 HP-UX 11.11 We would like to audit all activities of the oracle users that have the DBA role granted. My initial thought was to create a logon trigger to check for the ...
    Bill ZakrzewskiBill Zakrzewski
    Nov 10, 2011 at 3:17 pm
    Nov 16, 2011 at 7:13 pm
  • I'm curious how many of you belong to DBA teams where you rarely, if ever, go into an office and work side-by-side with other DBAs on your team. For those who answer "yes, I rarely go into the office ...
    Herring Dave - dherriHerring Dave - dherri
    Nov 2, 2011 at 2:23 pm
    Nov 10, 2011 at 10:56 pm
  • Hi I am not an experienced programmer so I am searching for something simple. In the past years I did all my scripting needs with Bash (Shell Script) scripts and SQL*Plus. Now more and more Windows ...
    Sven AluoorSven Aluoor
    Nov 10, 2011 at 2:52 pm
    Nov 10, 2011 at 8:51 pm
  • Hey all, Just wondering if anyone uses a Mac day to day support Oracle environments. I need to put together a justification to get one at work and apparently, "Just cause its better" isn't good ...
    DaveDave
    Nov 3, 2011 at 5:21 am
    Nov 10, 2011 at 8:23 pm
  • Here's the scenario: We have a saved backup on disk of a test database we like to recover to from time to time. I have the controlfile autobackup, and the necessary backup pieces. Here's the file ...
    Taylor, Chris DavidTaylor, Chris David
    Nov 8, 2011 at 2:43 pm
    Nov 9, 2011 at 1:36 pm
  • Hi all, HP-UX B.11.11 U 9000/800 Oracle Database EE 9.2.0.4.0 Trying to run some statements in parallel (2, 4 on 4CPU host with 70-90% total CPU idle). Parallel PDML and PQ processing result much ...
    Radoulov, DimitreRadoulov, Dimitre
    Nov 18, 2011 at 11:02 am
    Nov 23, 2011 at 3:53 pm
  • I was wondering if anybody else has any experience in performance testing a 2 CPU Dual Core vs 1 CPU Quad Core. We need to swap out one of our Windows database servers to a quad core because they are ...
    Jeff ChircoJeff Chirco
    Nov 7, 2011 at 7:51 pm
    Nov 9, 2011 at 6:22 pm
  • Chaps, Been stuck on a little bit of sql. Need to add up some columns with text values in them e.g 'One', 'Two' etc etc and see if the total is 0. Thought I had it working but its not I am doing ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Nov 7, 2011 at 10:02 pm
    Nov 8, 2011 at 3:37 am
  • I did a crazy thing the other day - reviewed an alert log from a system I inherited a while ago. I found that after a recent auto-restart a message was displayed: "WARNING:Oracle instance running on ...
    Herring Dave - dherriHerring Dave - dherri
    Nov 2, 2011 at 1:51 pm
    Nov 4, 2011 at 3:49 pm
  • Listers, This is not really a database issue, but a Forms/Reports question, but I believe someone here can help me. I have been asked from the security guys to avoid users from sharing their Forms ...
    Ivan Ricardo SchusterIvan Ricardo Schuster
    Nov 29, 2011 at 5:29 pm
    Dec 1, 2011 at 8:10 am
  • it's two nodes rac, 10.2.0.3, Linux server x86_64, with asm running. Here is some obervation It's strange to me at first that lgwr and dbw0 did not issue pwrite64 system call, I enable the 10046 ...
    Sidney ChenSidney Chen
    Nov 26, 2011 at 11:15 am
    Nov 28, 2011 at 12:59 am
  • Hi friends, I have this: 1:002:3:04:xyz:5:777:67:000:11 and I want to extract this as result, using sql or regular expression: 1 002 3 04 xyz 5 777 67 000 11 How can I do it ? Regards Eriovaldo -- ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Nov 25, 2011 at 10:35 am
    Nov 25, 2011 at 2:23 pm
  • Hi Friends, Environment : Solaris 10 , oracle 11.2.0.2 We have our production databases monitored by the BMC portal application. We often get alerts and warnings on free memory on the server. Say my ...
    Sreejith S NairSreejith S Nair
    Nov 14, 2011 at 2:12 am
    Nov 15, 2011 at 10:39 am
  • Hello Gurus, I am trying to rebuild the tablespace using the move and i could move all the objects execpt the below table which is erroring out with block corruption. Please suggest me on this to go ...
    Shastry(DBA)Shastry(DBA)
    Nov 14, 2011 at 5:21 am
    Nov 15, 2011 at 10:27 am
  • Hi, Can anyone recommend where I can find some scripts that query the AWR files ? I would like to generate reports outside of grid control. thanks ed 10.2.0.4- solaris -- ...
    Ed lewisEd lewis
    Nov 14, 2011 at 6:31 pm
    Nov 14, 2011 at 8:04 pm
  • So, I have finally gotten 11g Grid control configured (thank you Chris!). Been playing with it for a few days, looking under the hood, etc. I installed an agent on a small test box I have been using ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Nov 11, 2011 at 2:51 pm
    Nov 14, 2011 at 7:26 pm
  • I've got a 10.2.0.4 database and the developers want to run analyze on one table even though Oracle automates it in this version. If I run this for them and have any issues, is there a way to revert ...
    P DP D
    Nov 14, 2011 at 2:39 pm
    Nov 14, 2011 at 4:52 pm
  • Hi, One of my client currently has Exadata V2 racks, which do not have 10GigE card in them. We were thinking of provisioning Tier-2 storage via dNFS to a NAS filer (read NetApp). Currently since V2 ...
    Vishal GuptaVishal Gupta
    Nov 9, 2011 at 10:48 am
    Nov 12, 2011 at 12:40 am
  • Hi Does anyone know if it is possible to stop a listener started by another user in 11gR2 (I am not sure if 10g had same behaviour). For instance I have user1 and user2 as dba users in the operating ...
    LS ChengLS Cheng
    Nov 4, 2011 at 6:23 pm
    Nov 4, 2011 at 8:40 pm
  • Hello all, Just was browsing oracle site for OEM and other such tools and came across the info that OEM 12c. http://www.oracle.com/us/corporate/press/512064 in downloads this is available at ...
    Subodh DeshpandeSubodh Deshpande
    Nov 28, 2011 at 12:31 pm
    Nov 30, 2011 at 11:03 am
  • how to find out the segments (whether it is table or index) at the end of each datafile in a tablespace. I am trying to reduce the sizes of several datafiles, but getting the below error message ...
    Anurag VermaAnurag Verma
    Nov 27, 2011 at 3:49 am
    Nov 28, 2011 at 8:47 am
  • Hi Folks, I'm looking after a few of sites, one of which has 100 databases. Agent Version : 10.2.0.4.0 OMS Version : 10.2.0.5.0 I've spent some time trying to find out how to bulk update the alert ...
    Tony AdolphTony Adolph
    Nov 27, 2011 at 8:11 pm
    Nov 28, 2011 at 7:28 am
  • Hello I have a question that is not enough clear for me reading the manuals. I do a Level 0 backup on Sunday and then a incremental level 1 from monday to saturday. Also i make 1 normal archive ...
    Ricard MartínezRicard Martínez
    Nov 18, 2011 at 5:30 pm
    Nov 19, 2011 at 8:13 am
  • I am trying to check as the best way to find out the actual space used by table removing any fragmentation in it. I had few partitioned table in 3 digit like one of the table was 150G. I used ...
    Sanjay MishraSanjay Mishra
    Nov 17, 2011 at 12:39 pm
    Nov 17, 2011 at 3:30 pm
  • Does anyone have any experience with Oracle Fail Safe? We are looking into this as an option for High Availability of our Oracle databases running on Windows. It is supposed to work with MS ...
    Reimer, John J.Reimer, John J.
    Nov 11, 2011 at 4:16 pm
    Nov 12, 2011 at 12:31 am
  • To me it seems like a good idea to create a catalog to use with RMAN. The databases where I will be running RMAN are on both AIX and Linux boxes. I'm thinking I should create a new database just for ...
    Denise GwinnDenise Gwinn
    Nov 11, 2011 at 6:07 pm
    Nov 11, 2011 at 7:18 pm
Group Navigation
period‹ prev | Nov 2011 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions111
posts699
users176
websiteoracle.com

176 users for November 2011

Joel Patterson: 30 posts Taylor, Chris David: 26 posts Mark W. Farnham: 22 posts Grzegorz Goryszewski: 19 posts Radoulov, Dimitre: 19 posts Greg Rahn: 18 posts Niall Litchfield: 18 posts D'Hooge Freek: 17 posts Guillermo Alan Bort: 14 posts Norman Dunbar: 14 posts Chitale, Hemant Krishnarao: 13 posts Herring Dave - dherri: 13 posts Sidney Chen: 12 posts Subodh Deshpande: 12 posts Laimutis Nedzinskas: 10 posts Allen, Brandon: 10 posts Bobak, Mark: 10 posts Goulet, Richard: 10 posts Jeremy Schneider: 10 posts LS Cheng: 10 posts
show more
Archives