Search Discussions

93 discussions - 179 posts

  • Anyone using snapshots to backup Oracle? Does it work? Anything I need to know? -- http://www.freelists.org/webpage/oracle-l
    Ethan PostEthan Post
    Jul 6, 2010 at 3:18 pm
    Jul 7, 2010 at 2:56 pm
  • Hello, I want to make some changes in a table, like changing the order and type of its columns, adding some new columns after or before some specified columns and so on, but I understood that this is ...
    Octavian RasnitaOctavian Rasnita
    Jul 30, 2010 at 7:09 am
    Jul 30, 2010 at 7:35 pm
  • Yeah... I think it went to the whole list. Totally sorry to everyone. Totally didn't mean for this to happen.... a thousand apologies over and over. Robert G. Freeman Master Principal Consultant, ...
    Robert FreemanRobert Freeman
    Jul 14, 2010 at 3:46 pm
    Jul 27, 2010 at 5:15 am
  • You might look in crontab,see if there is a job that runs every few minutes that does it. -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- ...
    Andrew KerberAndrew Kerber
    Jul 25, 2010 at 5:34 pm
    Jul 26, 2010 at 2:37 am
  • Hello All, We are planning to move to RAC from single node database, as a start we want to migrate to 2 node RAC and ASM. Management asked us to present basic starting costs involved so that it helps ...
    Venkat PVenkat P
    Jul 19, 2010 at 4:16 am
    Jul 19, 2010 at 10:52 pm
  • Hi Tanel, thanks for your response. The child cursors are having all different bind variable sets. Is this a satisfactory answer for you? Unfortunately I can't try to collect further information at ...
    Martin KlierMartin Klier
    Jul 11, 2010 at 6:58 pm
    Jul 19, 2010 at 7:52 am
  • Hi all One of databases ( is filling up it's bdump, cdump and udump directories, deleting the files does not free any space because the inode is still being hold by many processes. One way ...
    Jul 14, 2010 at 10:32 am
    Jul 16, 2010 at 1:35 pm
  • Hi List, I'm just getting started with Data Guard and curious which management interface those with extensive experience would recommend? I am very comfortable with the command line and use SQL*Plus ...
    Allen, BrandonAllen, Brandon
    Jul 29, 2010 at 5:26 pm
    Jul 30, 2010 at 6:56 am
  • Which is better for performance on large Red Hat 5 systems (64gb+ memory, 8+ cpu's) - using 10g style shm settings and hugepages, OR the newer 11g Automatic Memory Manager (which does not support ...
    Crisler, JonCrisler, Jon
    Jul 21, 2010 at 3:56 pm
    Jul 22, 2010 at 11:51 pm
  • Anyone on the list have implemented E-Business suite but the database is on Oracle VM ? Are you already using it for production environment? If yes, have you encountered any issues ...
    Karl AraoKarl Arao
    Jul 16, 2010 at 2:16 am
    Jul 18, 2010 at 1:34 pm
  • Hi all, When backing up physical standby database, it is my practice to stop the recovery process prior to starting rman backups. I normally open the db in read only mode. I have reviewed the DG UG ...
    Jul 13, 2010 at 9:16 pm
    Jul 15, 2010 at 3:36 pm
  • I'm usually using the normal redundancy, putting each voting disk / cluster registry in its own volume. You might want to read ...
    D'Hooge FreekD'Hooge Freek
    Jul 1, 2010 at 5:31 am
    Jul 15, 2010 at 5:40 am
  • Hi folks, The OpenView team here where I work currently has just turned on database monitoring for several production databases, built by a vendor. This application creates and drops ...
    Lou AvramiLou Avrami
    Jul 2, 2010 at 7:14 pm
    Jul 14, 2010 at 3:35 pm
  • Thanks heaps, Mark. I'm aware of the differences you mentioned, we have some dbs in 11r1 and those were ironed out a while ago. I'm more interested in the so-called "gotchas". Like the resource ...
    Nuno SoutoNuno Souto
    Jul 3, 2010 at 4:45 am
    Jul 6, 2010 at 6:37 am
  • "What do you people do ... ? " Feel very frustrated. Note that if you provide weekly reports to the VP, after a few weeks he might just stop reading them. He wouldn't have the time or want to go ...
    Hemant K ChitaleHemant K Chitale
    Jul 2, 2010 at 4:32 pm
    Jul 2, 2010 at 6:14 pm
  • Hello, I have used RMAN Incremental Backup to Roll Forward a Physical Standby Database. However, has anyone used Incremental Backup with Block Change Tracking to Roll Forward a Physical Standby ...
    Michael DinhMichael Dinh
    Jul 29, 2010 at 3:56 pm
    Jul 30, 2010 at 6:36 pm
  • Having just been through a month of recovering from a severe logical corruption issue resulting from a SSD that was randomly flipping bits, I'd like to add a couple of other ideas in addition to ...
    Kerry OsborneKerry Osborne
    Jul 30, 2010 at 3:51 am
    Jul 30, 2010 at 1:13 pm
  • It's related to buffer cache operation such as quiesce operation, managing fast start IO target, parallel recovery operation, etc -- Thanks & Regards, Taral Desai -- ...
    Taral DesaiTaral Desai
    Jul 23, 2010 at 6:15 pm
    Jul 26, 2010 at 6:08 am
  • dear lists, does anyone has implement/doing labs/on going to try multiple solaris 10 (sparc) multiple page size? I have 256GB memory and 64 processors.... -- thanks and regards ujang jaenudin jakarta ...
    Ujang JaenudinUjang Jaenudin
    Jul 23, 2010 at 3:18 am
    Jul 26, 2010 at 4:02 am
  • Thanks Chandra. Jaffar suggested another solution which looks good. Regards Rafiq From: chandra_pabba_at_verizon.net To: rafiq9857_at_hotmail.com; oracle-l@freelists.org Subject: RE: Mutiple sessions ...
    Mohammad RafiqMohammad Rafiq
    Jul 19, 2010 at 2:35 pm
    Jul 20, 2010 at 4:13 am
  • Hi list memebers, I would like to disable the default stats gathering job in 10g and would like to configure our own.But I am facing some issues in disabling it. select grantee,table_name from ...
    Sreejith S NairSreejith S Nair
    Jul 8, 2010 at 5:14 am
    Jul 8, 2010 at 7:58 am
  • �Hi List, I remember some list member posted some time before, a script to read entries from archived redo logs. Can anyone please help me to get it. I would like to see what all data changes ...
    Sreejith S NairSreejith S Nair
    Jul 30, 2010 at 5:41 am
    Jul 30, 2010 at 5:50 am
  • Can someone help me explain this weird behaviour. when a subquery has a syntactical error what happens to the parent query. select job_id, job_run_id, job_run_status_id from job_runs where ...
    Dd yakkaliDd yakkali
    Jul 26, 2010 at 11:12 pm
    Jul 26, 2010 at 11:17 pm
  • I’m in the process of doing a proof of concept with IMDB to cache a subset of our application data to improve the performance of our application. I’ve hit a problem which I think makes the product ...
    Matt McClernonMatt McClernon
    Jul 22, 2010 at 5:47 am
    Jul 25, 2010 at 2:06 pm
  • I use different virtual machines depending on vpn client. Cisco's vpn client for example doesn't like VMWare virtual network cards and requires many attempts before connecting. For those who prefer ...
    Martin BachMartin Bach
    Jul 24, 2010 at 6:57 am
    Jul 24, 2010 at 2:29 pm
  • I have a table that uses a composite primary key. On its own, DETAIL_ID is not unique. CREATE TABLE DETAIL ( DETAIL_ID NUMBER NOT NULL, LINE NUMBER NOT NULL, CONSTRAINT XPKDETAIL PRIMARY KEY ...
    Kevin Hale BoyesKevin Hale Boyes
    Jul 23, 2010 at 5:56 pm
    Jul 23, 2010 at 6:38 pm
  • If you need to work on 2008 this is exactly what you are looking for http://blog.sqlauthority.com/2009/11/21/sqlauthority-news-sql-server-2008-for-oracle-dba/ presentations and videos are very handy ...
    Jul 15, 2010 at 10:58 pm
    Jul 20, 2010 at 4:24 pm
  • Hi list, I've got an interesting "read by other session" scenario.. and I documented the details here http://karlarao.tiddlyspot.com/#%5B%5Bread%20by%20other%20session%20scenario%5D%5D that includes ...
    Karl AraoKarl Arao
    Jul 18, 2010 at 8:56 pm
    Jul 20, 2010 at 11:15 am
  • The local bin directory (/usr/local/bin or whatever) does not refer to an ORACLE_HOME directory; rather, it identifies a directory for executables and binaries used system-wide that aren't part of ...
    Jul 16, 2010 at 2:33 pm
    Jul 16, 2010 at 4:34 pm
  • How can I do this? I have a Server and a handheld mobile device. The mobile device is like a laptop. I use the mobile device to connect to, say cars, and download data to the device. There is only a ...
    Joe SmithJoe Smith
    Jul 14, 2010 at 8:35 pm
    Jul 15, 2010 at 5:57 pm
  • Hi, I have installed Oracle 11G under Windows XP and I've seen that for the current database it was installed as DEDICATED, but I want to set it as SHARED. Is it possible? I've used Database ...
    Octavian RasnitaOctavian Rasnita
    Jul 11, 2010 at 12:35 pm
    Jul 12, 2010 at 5:56 am
  • dear lists, I have a case that table has 2 keys: datetime trackingid -- unique (from sys_guid) I have plan to partition the table, but majority of query are by trackingid column in the where clause ...
    Ujang JaenudinUjang Jaenudin
    Jul 9, 2010 at 1:03 pm
    Jul 11, 2010 at 2:55 pm
  • Hi Stefano It looks like your I/O performance is very low(~75GB/hr with SQL backtrack), I'd suggest looking into that first - perhaps by seeing if a disk-to-disk copy can do any faster to help ...
    Jul 9, 2010 at 10:50 am
    Jul 9, 2010 at 12:15 pm
  • Greg, Yes things are that bad out here in the field, and management is totally blind to what is going on. Why, because the duhveloper makes the application work as expected by management no matter ...
    Goulet, RichardGoulet, Richard
    Jul 8, 2010 at 4:06 pm
    Jul 8, 2010 at 4:40 pm
  • I'm wondering what peoples experiences with Oracle's SQL Tuning Advisor (STA) are. My personal experiences have been less than stellar. These experiences I initially wrote off to my bad luck. I tried ...
    kyle Haileykyle Hailey
    Jul 7, 2010 at 8:36 pm
    Jul 8, 2010 at 8:37 am
  • Marcin - We are looking at around 750GB. The window is not set in stone as yet - but generally speaking for a major implementation or change we'll get about 18 hours. Best, Jeff -- ...
    Jeff ThomasJeff Thomas
    Jul 6, 2010 at 4:34 pm
    Jul 7, 2010 at 3:58 pm
  • During the last user group meeting in London a presenter stated that as well. Streams will remain in place, but in a frozen state. A bit like advanced replication which has been frozen yet ...
    Martin BachMartin Bach
    Jul 5, 2010 at 6:57 am
    Jul 5, 2010 at 11:35 pm
  • Hi list members, Is there a way - a single query which I can use to fetch data from the below table, in this format Expected Output format AB 01Jan2010 04Jan2010 AB 06Jan2010 07Jan2010 AB 09Jan2010 ...
    Sreejith S NairSreejith S Nair
    Jul 5, 2010 at 6:54 am
    Jul 5, 2010 at 3:14 pm
  • Hi, I have a Data Guard issue, It is RAC Production on using LGWR ASYNC redo transport to DR site which is also a RAC configuration (Physical Standby). One of the standby database (in Real ...
    Vasu RajagopalVasu Rajagopal
    Jul 3, 2010 at 3:15 am
    Jul 4, 2010 at 12:15 am
  • I did a 10gR2 EE to SE downgrade yesterday, had to use export/import data pump! So 30 seconds is out of question :) Thanks -- LSC On Thu, Jul 1, 2010 at 12:40 AM, Niall Litchfield < ...
    LS ChengLS Cheng
    Jul 1, 2010 at 5:27 am
    Jul 1, 2010 at 5:57 am
  • Hi Aditya, without seing your data...this could be an issue with fragmented data. Try to reorg the tables/indexes with: alter table move; Please notice that the rowids will be changed so that you ...
    Dirk DrexlerDirk Drexler
    Jul 30, 2010 at 5:21 am
    Jul 30, 2010 at 5:21 am
  • Chris, Is this linux? Give output of /proc/meminfo I noticed this when we had allocated hugepages (rhel4 u8) and because of incorrect ulimit setting it was not being used. As OS has already reserved ...
    Amit bansalAmit bansal
    Jul 30, 2010 at 4:57 am
    Jul 30, 2010 at 4:57 am
  • How to test a remote connection and oracle password file on the same server? Does the string sql connect sys_at_hostname as sysdba And $sqlplus sys_at_hostname as sysdba Prove a remote connection and ...
    Joe SmithJoe Smith
    Jul 29, 2010 at 7:15 pm
    Jul 29, 2010 at 7:15 pm
  • Hi, I know it's not relevant to Windows/Linux but if you want to know more in depth stuff about the Oracle optimizer then look no further than Jonathan Lewis's book "Cost Based Oracle Fundamentals" ...
    Chris DunscombeChris Dunscombe
    Jul 29, 2010 at 8:08 am
    Jul 29, 2010 at 8:08 am
  • When you shut down the instance you don't disable the redo thread it's writing. One of the other instances will archive redo logs from that thread in some situations, I have seen it happen when the ...
    Harel SafraHarel Safra
    Jul 28, 2010 at 5:41 pm
    Jul 28, 2010 at 5:41 pm
  • oracle on linux I have some duplicated records in a table (woe_fact_barb) I cannot come up with the sql to remove these. Can anyone help? The only way to identify the duplicate is that there ...
    Barbara BakerBarbara Baker
    Jul 28, 2010 at 5:14 pm
    Jul 28, 2010 at 5:14 pm
  • Gurus, Need to know whether Oracle Standard Edition ONE (OSE1) is installed or not. Is there any way to find it out? V$VERSION could not provide this information. -- Regards, Deepak Oracle DBA -- ...
    DBA DeepakDBA Deepak
    Jul 28, 2010 at 9:17 am
    Jul 28, 2010 at 9:17 am
  • Could be an issue with memory management. Some things to try while you wait for Oracle Support: Try increasing the shared pool Try disabling AMM (set memory_target to 0) Try disabling ASMM (set ...
    Stefan KnechtStefan Knecht
    Jul 26, 2010 at 8:53 pm
    Jul 26, 2010 at 8:53 pm
  • I am attempting the installation of oem 11gr1. In the configuration assistant portion, the OMSCA is failing with this error. It looks like it is complaining about a port being in use, but I cant tell ...
    Andrew KerberAndrew Kerber
    Jul 26, 2010 at 6:36 pm
    Jul 26, 2010 at 6:36 pm
  • dear lists, according to metalink and docs: "The contents of a queue buffer are lost if the instance containing the buffer shuts down normally or abnormally. Streams automatically recovers from these ...
    Ujang JaenudinUjang Jaenudin
    Jul 26, 2010 at 4:07 am
    Jul 26, 2010 at 4:07 am
Group Navigation
period‹ prev | Jul 2010 | next ›
Group Overview
grouporacle-l @

104 users for July 2010

Niall Litchfield: 8 posts D'Hooge Freek: 7 posts Andrew Kerber: 5 posts Karl Arao: 5 posts Octavian Rasnita: 5 posts Ujang Jaenudin: 5 posts Harel Safra: 4 posts Martin Berger: 4 posts Ravi Madabhushanam: 4 posts Tanel Poder: 4 posts Bobak, Mark: 3 posts Goulet, Richard: 3 posts Jeremy Schneider: 3 posts Matt McClernon: 3 posts Michael Dinh: 3 posts Sreejith S Nair: 3 posts Alessandro Vercelli: 2 posts Amonte: 2 posts Cary Millsap: 2 posts Crisler, Jon: 2 posts
show more