Search Discussions

99 discussions - 614 posts

  • Here at the University of Western Ontario we are looking at replacing our current Learning Management System. The current choices seem to be similar in technology and infrastructure - web tier, load ...
    Blake WilsonBlake Wilson
    Jun 9, 2011 at 3:22 pm
    Jul 18, 2011 at 7:27 am
  • I think I'm gonna be sick: http://www.sqlmag.com/article/Performancetuning/ssds-performance-tuning-experts-milkman-139591 This mentality **in a database professional** completely escapes me. It ...
    Rich JesseRich Jesse
    Jun 27, 2011 at 2:45 pm
    Nov 19, 2011 at 1:07 am
  • I think the answer to this is NO, but just to be sure, Is there a single SQL statement that can: SELECT row-X from table A INSERT row-X into table B DELETE row-X from table A It would be nice to be ...
    Michael MooreMichael Moore
    Jun 7, 2011 at 11:12 pm
    Jun 9, 2011 at 6:47 am
  • Hi: We are seeing a single SQL using very big SHARABLE_MEM. select VERSION_COUNT,SHARABLE_MEM from v$sqlarea where hash_value=2038009379; VERSION_COUNT SHARABLE_MEM ------------- ------------ 96 ...
    Eagle FanEagle Fan
    Jun 15, 2011 at 2:41 pm
    Jul 5, 2011 at 3:03 am
  • List, After a few years in the field of database administration I've come to realize that I am utterly unprepared to deal with an attack on my databases. Luckily enough I haven't had to test that, ...
    Guillermo Alan BortGuillermo Alan Bort
    Jun 20, 2011 at 5:31 pm
    Jun 22, 2011 at 9:23 pm
  • The first two queries run fast enough. However, when they are joined (third query below) on 4 columns which is a solid one to one join it runs really slow. I need to force Oracle to resolve each ...
    Ethan PostEthan Post
    Jun 9, 2011 at 8:28 pm
    Jun 10, 2011 at 7:58 pm
  • I have a table that had 16 million records in it. I deleted rows out of it until I had only 6k rows. But I still have 57k blocks (8k size). What is the best way to rebuild the table? The table is ...
    Joe SmithJoe Smith
    Jun 21, 2011 at 8:19 pm
    Jun 27, 2011 at 8:37 am
  • Hi all, I am getting this value back from Amazon.com and wonder if it can be processed in Oracle? 2011-05-24T23:21:30.000Z Thanks, Eugene -- http://www.freelists.org/webpage/oracle-l
    Eugene PipkoEugene Pipko
    Jun 9, 2011 at 9:58 pm
    Jun 10, 2011 at 3:30 pm
  • I had a Veritas Cluster Non-RAC setup where I had 4 Database on Node1 and 4 on Node2 and these cluster nodes act as High availability for each other. All database are running with own VIP. Both Nodes ...
    Sanjay MishraSanjay Mishra
    Jun 3, 2011 at 12:34 am
    Jun 10, 2011 at 12:39 pm
  • We had a dba boo-boo today; and now I have a curious issue on my hands. MMON and several other background processes are down, but the instance seems to have other recovered after an errant shutdown ...
    Charles SchultzCharles Schultz
    Jun 9, 2011 at 7:29 pm
    Jun 10, 2011 at 11:26 am
  • Hi All, Greetings. I have a standby in mount state. I would like to query the latest archive log applied on standby (in mount state) to apply the archive logs from primary with a cron job shell ...
    Sundar mahadevanSundar mahadevan
    Jun 27, 2011 at 6:10 pm
    Jun 28, 2011 at 2:54 pm
  • List, A friend works at a U.S. company where the DBA services are being outsourced to IBM. I believe this is IBM India. He has been invited to interview with them for a job. He resides here in the ...
    Dennis WilliamsDennis Williams
    Jun 13, 2011 at 3:13 pm
    Jun 14, 2011 at 4:16 pm
  • We currently run ocfs2 1.4.x on RHEL 5, and we've been having huge problems. Our four-node cluster is simultaneously rebooting roughly once a week (sometimes more, sometimes less). The qlogic driver ...
    Jonathan SmithJonathan Smith
    Jun 13, 2011 at 8:33 pm
    Jun 17, 2011 at 6:50 am
  • In the role transition doc: http://download.oracle.com/docs/cd/E11882_01/server.112/e17022/role_management.htm#i1030646 is states: "Ensure temporary files exist on the standby database that match the ...
    Ray StellRay Stell
    Jun 15, 2011 at 4:26 pm
    Jun 15, 2011 at 9:09 pm
  • So, the situation is this, I have a tablespace with about 600GB of free space (spread out in about 80 datafiles). The entire database itself has about 2TB and we need to copy it to another server ...
    Guillermo Alan BortGuillermo Alan Bort
    Jun 28, 2011 at 3:50 pm
    Jun 28, 2011 at 5:19 pm
  • Hello, How can i confirm that oracle will be doing Direct I/O and Asynchronous i/o with following options. Database FILESYSTEMIO_OPTIONS is set to ALL which means to use, setall - Enables both ASYNC ...
    Rajesh koppadaRajesh koppada
    Jun 27, 2011 at 8:22 pm
    Jun 28, 2011 at 3:21 pm
  • Is the latest release for AIX 64 bit? Thanks, Manjula -- http://www.freelists.org/webpage/oracle-l
    Manjula KrishnanManjula Krishnan
    Jun 23, 2011 at 6:57 pm
    Jun 25, 2011 at 4:43 pm
  • I am exporting via datapump from and importing to The export is using the flashback_scn argument, Exporting as strmadmin, i get this (note the trans_id table): Processing object ...
    Andrew KerberAndrew Kerber
    Jun 20, 2011 at 5:28 pm
    Jun 23, 2011 at 3:38 pm
  • Hi We recently migrated our ebiz solaris db to linux. We have some bad queries in solaris which take up temp segment (I mean mor than what it should take if the query was properly written in the ...
    Kumar MadduriKumar Madduri
    Jun 20, 2011 at 9:26 pm
    Jun 21, 2011 at 10:15 am
  • I create a table which is a snapshot of v$sql. I want to find all the inserts, updates, and deletes run against a list of tables if I do like '%INSERT%INTO%TABLE_NAME%' I will double count if it is ...
    Dba DBADba DBA
    Jun 29, 2011 at 2:21 pm
    Jul 6, 2011 at 8:19 am
  • Quite A funny utility name I thought! Anyway Linux Redhat 4 Oracle 10 - trying to change database name Anyone got NID (New database ID) to work? I always get this NID-00135: There are 1 active ...
    Howard LathamHoward Latham
    Jun 22, 2011 at 1:36 pm
    Jul 1, 2011 at 7:19 am
  • Hi, List, In a RAC, with 11gR2 RAC Cluster Time Synchronization Service (CTSS) running in active mode, CTSS does its work to sync time among all nodes in the cluster. However, the time on ...
    Li LiLi Li
    Jun 22, 2011 at 3:17 pm
    Jun 23, 2011 at 2:19 pm
  • Hello, I would like to get a way to export data withoout storage. STORAGE(INITIAL 400293888 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "xxx" LOGGING NOCOMPRESS. Because the initial ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Jun 14, 2011 at 7:55 pm
    Jun 16, 2011 at 6:01 am
  • Hi After getting complaints about slow process we found out that one user's session was blocking another user's session. I found out that the waiter's session was waiting to acquire a lock on an ...
    Ram RamanRam Raman
    Jun 15, 2011 at 6:46 pm
    Jun 15, 2011 at 8:12 pm
  • Hi all, Using RDBMS 11.2, I configured my primary remote destination as follows ... log_archive_dest_2 SERVICE=BostonStby DB_UNIQUE_NAME=BostonStby If the process is not specified, it defaults to ...
    Jun 15, 2011 at 2:05 pm
    Jun 15, 2011 at 5:11 pm
  • Hi list, Iam used to install oracle under windows for many years recently i received a request to work under linux redhat or susi,my question is thier an interface or GUI or other utilities that help ...
    Walid alkaakatiWalid alkaakati
    Jun 13, 2011 at 8:00 am
    Jun 13, 2011 at 1:07 pm
  • What monitoring tools are you using to detect performance degradation and to alert in real time for an SQL execution? For example, if a SQL normally takes 5 minutes to run and now runs in 60 minutes, ...
    Michael DinhMichael Dinh
    Jun 10, 2011 at 8:17 pm
    Jun 11, 2011 at 6:42 pm
  • A friend of mine is interested in migrating a 10g Retek 1.5tb database across platforms that involves and endian change. Has anyone done this, or know of white papers addressing this topic? Can it be ...
    Kenneth NaimKenneth Naim
    Jun 8, 2011 at 1:36 am
    Jun 8, 2011 at 7:14 pm
  • Hi all, A bit of a funny question which has been raised today. Oracle RAC with ASM on Linux. Let's assume for a moment that you have a production cluster with a disk group +ARCH used as ...
    Martin BachMartin Bach
    Jun 3, 2011 at 1:36 pm
    Jun 5, 2011 at 5:20 pm
  • Folks, I'm having a bit of a mental block dealing with a query I'm trying to write. What I'd like to do is for data in a table, ordered by some value when queried, to only display totals when rows ...
    Herring Dave - dherriHerring Dave - dherri
    Jun 30, 2011 at 10:11 pm
    Jul 1, 2011 at 4:11 pm
  • Hi List, I have a Datapump import question: Oracle 10.2.03 on Solaris 9 I have need to copy schema from one prod to dev database on weekly basis. Datapump export took about 15 minutes. Problem is ...
    Jun 30, 2011 at 2:56 pm
    Jul 1, 2011 at 3:25 am
  • Has anyone done an upgrade of RAC to RAC on Linux-x86-64? I have pre-staged the binaries, and now I'm attempting to run DBUA. (Running dbua from ORACLE_HOME.) I'm trying ...
    Bobak, MarkBobak, Mark
    Jun 24, 2011 at 5:23 pm
    Jun 25, 2011 at 8:58 pm
  • Hello, We are on 10gR2 5 node RAC (a huge and very busy DB) and also very high number of CPUs (80ish) hence the default number of LMS processes that Oracle generates for us (num_cpu dependant) is way ...
    PD MalikPD Malik
    Jun 21, 2011 at 11:02 am
    Jun 22, 2011 at 9:15 pm
  • Hi All, We are currently on DAS file system and would like to move to SAN. and with New servers and we need to calculate the demand for IO and CPU so that we can design the disk architecture and buy ...
    Vamshi DamidiVamshi Damidi
    Jun 10, 2011 at 8:26 pm
    Jun 20, 2011 at 6:53 pm
  • Hi, I'm currently bussy writing a perl check to verify the status of a rac database service. When the service is down, while the target status is "online" a critical alert has to be given and when ...
    D'Hooge FreekD'Hooge Freek
    Jun 14, 2011 at 2:10 pm
    Jun 17, 2011 at 11:16 am
  • Hi Has anyone been able to do this with Golden Gate" join live queries from an Oracle database with data in an SQL database. " Thanks JR -- http://www.freelists.org/webpage/oracle-l
    Joseph ReidJoseph Reid
    Jun 15, 2011 at 12:16 am
    Jun 16, 2011 at 1:10 pm
  • I manually removed some archivelogs and then did a crosscheck. However, when the backup and reports run those logs that were manually removed are still showing up as 'validation failed for archived ...
    P DP D
    Jun 6, 2011 at 10:07 pm
    Jun 9, 2011 at 5:54 pm
  • OS REDHAT 4 Oracle 10g If you forget the slash in a db file convert parameter as in db_file_name_convert=("/fred/dir1/","/bill/dir1"); for an rman database duplicate you get duplicate files ! Ie ...
    Howard LathamHoward Latham
    Jun 9, 2011 at 3:04 pm
    Jun 9, 2011 at 3:20 pm
  • Hi there Oracle-L, We're getting interesting errors when trying to run RMAN backups against a particular database, involving the repository table RT and the RT_C_STATUS check constraint: RMAN-03002 ...
    Lou AvramiLou Avrami
    Jun 7, 2011 at 7:19 pm
    Jun 8, 2011 at 5:27 pm
  • any one know why this restore command failed??? RMAN restore controlfile from autobackup until time "to_data('06/28/11 01:11:00','mm/dd/yy hh24:mi:ss')"; Starting restore at 30-JUN-11 using channel ...
    Dba1 mccDba1 mcc
    Jun 30, 2011 at 2:18 pm
    Jun 30, 2011 at 2:35 pm
  • Hi, Currently we are migrating an non rac database to rac database. Source: OS :RHEL4 Database Version: 10g R2 32 bit RAC : No Target : OS :RHEL5 Database Version : 10R2 64 Bit RAC : 2 node ASM ...
    Jun 22, 2011 at 5:56 pm
    Jun 24, 2011 at 10:26 am
  • Per document 1121357.1, we should refer to (another) Document 864734.1 to see new event syntax in 11g, which conveniently is not-visible except (perhaps) Oracle employees. Looks like someone is not ...
    Jun 21, 2011 at 12:49 pm
    Jun 21, 2011 at 4:05 pm
  • Hi All, I'm having currently windows XP and unfortunately my Hard Disk got crashed with is very much because of virus . I'm planning to have Ubuntu for Oracle and for Daily use also (i.e for ...
    Balakrishna YBalakrishna Y
    Jun 20, 2011 at 9:13 am
    Jun 20, 2011 at 12:28 pm
  • Hi folks, what's your opinion about the "new" licensing policy ($5000/CPU) regarding ACFS/ADVM, now sold as as "CloudFS"? ...
    Martin KlierMartin Klier
    Jun 15, 2011 at 12:42 pm
    Jun 16, 2011 at 2:27 am
  • Hi All, I have the problem patching Oracle. I get the error: Following files are active : c:\oracle\ora11g\bin\oci.dll ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveF ...
    Kedryna Marcin-HKP384Kedryna Marcin-HKP384
    Jun 14, 2011 at 11:39 am
    Jun 15, 2011 at 8:49 am
  • FYI: I am getting Health Check service is unavailable, Patch service is unavailable and Configuration service is unavailable. Message states to check Site Alerts on the Dashboard for more details ...
    Jun 10, 2011 at 1:43 pm
    Jun 10, 2011 at 8:05 pm
  • Dear List, maybe someone can help me with my interpretation of a 10053 trace file. DB: - 64bit I have a small query with a little error, which causes big troubles. The relevant part of the ...
    Martin BergerMartin Berger
    Jun 8, 2011 at 8:17 pm
    Jun 9, 2011 at 6:10 pm
  • Hello DBAs, Please I need simulation materials for learning Oracle RAC 10g or 11g & Oracle Data-Guard. Also any useful links that can help at installation & managing these technologies. Your response ...
    Mostafa EletribyMostafa Eletriby
    Jun 9, 2011 at 6:04 am
    Jun 9, 2011 at 2:30 pm
  • Folks, I need to change the numeric IDs for the UID and the GID of the oracle account which owns the RDBMS and the Grid infrastructure. This is a two-node RAC ( running on Solaris. The ...
    Hameed, AmirHameed, Amir
    Jun 6, 2011 at 8:56 pm
    Jun 7, 2011 at 12:20 am
  • -- -------------------------------------- -- http://www.freelists.org/webpage/oracle-l
    Wissem elkhlifiWissem elkhlifi
    Jun 30, 2011 at 7:16 am
    Jun 30, 2011 at 9:17 am
Group Navigation
period‹ prev | Jun 2011 | next ›
Group Overview
grouporacle-l @

177 users for June 2011

Guillermo Alan Bort: 30 posts : 28 posts D'Hooge Freek: 17 posts Michael Moore: 15 posts Nuno Souto: 15 posts Robert Freeman: 14 posts Bobak, Mark: 13 posts David Fitzjarrell: 13 posts Radoulov, Dimitre: 13 posts Amaral, Rui: 12 posts Michael Dinh: 12 posts Wolfgang Breitling: 12 posts Andrew Kerber: 11 posts Niall Litchfield: 11 posts Rich Jesse: 11 posts Goulet, Richard: 9 posts Jorgensen, Finn: 9 posts Rjamya: 9 posts Jonathan Lewis: 8 posts Martin Bach: 8 posts
show more