Search Discussions

159 discussions - 735 posts

  • This note is a heads-u on a bug which has caused me some problems over the last few days and yet is easily identifiable and resolvable (once you recognize the issue). We have spent the last 2 days ...
    John HallasJohn Hallas
    Feb 13, 2008 at 4:18 pm
    Feb 26, 2008 at 4:00 pm
  • Outside of reinstantiating a primary database after a failover in Data Guard, are there any compelling reasons to use Flashback database versus RMAN for a 10gr2 database that's only about 100GB in ...
    Brian LucasBrian Lucas
    Feb 19, 2008 at 5:51 pm
    Feb 25, 2008 at 11:19 am
  • We recently moved our database to a new SAN. Performance has just tanked. Here's the environment: AIX5.3L Oracle SAN - IBM DS4800 We've got 8 filesystems for Oracle data files. Redo, Archive, ...
    David BarbourDavid Barbour
    Feb 27, 2008 at 6:53 pm
    Feb 29, 2008 at 7:38 pm
  • Content-Type: multipart/alternative; boundary="------------050402000304000607000905" This is a multi-part message in MIME format. --------------050402000304000607000905 Content-Type: text/plain ...
    Feb 26, 2008 at 5:25 pm
    Feb 28, 2008 at 2:46 pm
  • People, I am thinking of running at 10/11g on a FREE Linux. I know the amount of patches you need to stabilise Oracle and get it running can be an issue, SO . . .Of the many flavours out there, which ...
    David cheyneDavid cheyne
    Feb 21, 2008 at 1:47 pm
    Feb 26, 2008 at 12:47 am
  • My brain isn't working... I know there is an easy way to determine what I screwed up... Anyway... my standby database got corrupted so I put did a hot backup and had to copied over all the files this ...
    Kathy duretKathy duret
    Feb 25, 2008 at 3:19 pm
    Feb 25, 2008 at 8:40 pm
  • Hello, I posted the following question a week ago and have not received any response so far. Does it mean nobody has implemented ASM under Windows Server 2003? Hello, I have a little problem with ...
    Estifan PanosianEstifan Panosian
    Feb 2, 2008 at 12:36 am
    Feb 12, 2008 at 7:04 pm
  • USER_A cannot execute a procedure owned by USER_B when one person logs in. USER_A *can* execute a procedure owned by USER_B when a different person logs in. One person is in one city and the other is ...
    Stephen AndertStephen Andert
    Feb 21, 2008 at 6:55 pm
    Feb 23, 2008 at 1:01 am
  • Hello all, Oracle, Enterprise Edition, on AIX 5.3. In our RMAN backup scripts for our AAA database we have several format lines that look like: format ...
    Sam BootsmaSam Bootsma
    Feb 25, 2008 at 5:45 pm
    Feb 26, 2008 at 7:55 pm
  • All, I'm on RH 2.6.9-42.ELsmp x86_64 Linux, running I've been having a lot of log issues for the last week. Thanks to some help here, I seem to have the worst of it under control now ...
    Weatherman, JohnWeatherman, John
    Feb 20, 2008 at 7:58 pm
    Feb 21, 2008 at 10:55 am
  • Can I restore a database from and RMAN backup on disk to new (different) database name? If so how, is it analogous to duplicate? Restore database to newname? Do archive have to be in the previous ...
    Feb 26, 2008 at 2:20 pm
    Feb 26, 2008 at 5:09 pm
  • List, Some developers are starting a development project. Initially their database will be Oracle 8i. Later we will upgrade the database to Oracle 10g. The developers are asking if they can start ...
    Dennis WilliamsDennis Williams
    Feb 25, 2008 at 7:47 pm
    Feb 26, 2008 at 3:37 am
  • We have a data model which looks like the following: ITEMS ITEM_CODE VARCHAR2(100) (Primary Key col 1) ITEM_TYPE VARCHAR2(100) ATTRIBUTE_001 VARCHAR2(4000) ATTRIBUTE_002 VARCHAR2(4000) .. ...
    Ahbaid GaffoorAhbaid Gaffoor
    Feb 7, 2008 at 3:51 am
    Feb 13, 2008 at 12:24 pm
  • All, I'd appreciate your thoughts and input. I'm putting together a 1 or 2 day seminar on advanced RMAN. My problem is that I'm having trouble deciding exactly WHAT advanced RMAN is and what would be ...
    Robert FreemanRobert Freeman
    Feb 26, 2008 at 9:35 pm
    Feb 28, 2008 at 8:48 pm
  • Hi, I've got a conundrum. We've got a new disk system. When I full scan a table with the nocache hint the trace files record lots of reads like this WAIT #1: nam='db file scattered read' ela= 38471 ...
    Josh CollierJosh Collier
    Feb 20, 2008 at 8:20 pm
    Feb 28, 2008 at 7:12 pm
  • Folks In a Benchmark Run, 512 concurrent BATCH Processes using Dedicated Sessions (NON-MTS) showing the following Waits:- How is the "latch: cache buffers chains" wait to be addressed? Should ...
    Feb 15, 2008 at 2:13 am
    Feb 17, 2008 at 11:38 am
  • We are looking at migrating to 10gR2 RAC/ASM from 9i RAC/VERITAS. I've read various papers and purchased the Oracle ASM book from Oracle Press and have researched this stuff, but from a practical ...
    Jeffery ThomasJeffery Thomas
    Feb 7, 2008 at 3:45 pm
    Feb 13, 2008 at 2:48 pm
  • Hi Does anyone know how ASM does host based mirroring. For example we have two storage arrays with 10 metres distance, two failure groups are created, one per array. How does ASM mirror the extents? ...
    LS ChengLS Cheng
    Feb 19, 2008 at 7:33 pm
    Mar 27, 2008 at 12:35 pm
  • Is it possible to use DIRECTORY OBJECTS between servers? Have DIRECTORY OBJECTS from database A on server A point to and create its files on server B? thanks. Climb to the top of the charts! Play the ...
    Joe SmithJoe Smith
    Feb 28, 2008 at 3:57 pm
    Feb 29, 2008 at 4:43 pm
  • Linux Redhat I have code that adds and drops partitions. I am constantly getting this error. I am doing a few things to track this down and alleviate it. at the beginning of the execution of ...
    Feb 25, 2008 at 5:28 pm
    Feb 27, 2008 at 10:46 pm
  • Does the SID of a database ALWAYS register itself with the listener even if the service_name parameter is set to a different name than the SID? I have this configuration : FINNTEST show parameter ...
    Finn JorgensenFinn Jorgensen
    Feb 25, 2008 at 9:18 pm
    Feb 26, 2008 at 4:30 pm
  • To get an idea of how much it would cost to license a point of sale database on Oracle and commodity hardware/software, we requested a quote for a 2-node RAC on Dell 2950's 2 Dual core's per server ...
    John ThompsonJohn Thompson
    Feb 19, 2008 at 1:58 pm
    Feb 19, 2008 at 9:41 pm
  • Folks In a Benchmark Run, 256 concurrent BATCH Processes on RAC using Dedicated Sessions (NON-MTS) showing the following Waits:- How is the "gc current block busy" wait to be addressed? From the ...
    Feb 13, 2008 at 4:54 pm
    Feb 19, 2008 at 1:34 pm
  • Hi all, My 10046 tracing is showing a lot of "log file sync" waits. Also, users log files (processes are doing DML) are showing spikes in response time that match the times of the log switches. This ...
    Gerald CunninghamGerald Cunningham
    Feb 14, 2008 at 7:21 pm
    Feb 17, 2008 at 3:57 am
  • We've recently updated some of our RH database servers to kernel 2.4.21-53ELHugemem and have experienced problems with the databases and ASM instances crashing and huge numbers (like 80,000) ...
    Niall LitchfieldNiall Litchfield
    Feb 10, 2008 at 12:53 pm
    Feb 13, 2008 at 8:25 pm
  • Hi, I'm trying to implement ADDRESS WINDOWING EXTENSIONS (AWE) to take advantage of all of the memory on my server. The server details are: Windows server 2003 enterprise edition, 4 processors, 8 GB ...
    David GrosserDavid Grosser
    Feb 1, 2008 at 9:22 pm
    Feb 8, 2008 at 9:05 pm
  • On a database on Solarix 64, which is created every day from a magical SAN-based mirror process thing (excuse the tech talk), we alter a particular table to a default degree of parallelsim of ...
    David AldridgeDavid Aldridge
    Feb 28, 2008 at 5:03 pm
    Feb 28, 2008 at 9:10 pm
  • My requirements: I have a large table, in the range of 1 billion records. But the machine is a relatively slow one. Therefore I would not like to clog the machine when querying this large table. My ...
    Peter TeohPeter Teoh
    Feb 18, 2008 at 6:01 am
    Feb 19, 2008 at 7:28 am
  • Hi, I need to copy an Oracle database from one machine to another. I am using Oracle 8i on windows. It's a very simple database. It's not even using archive mode or anything like that. The problem ...
    Amir GheibiAmir Gheibi
    Feb 14, 2008 at 8:12 am
    Feb 16, 2008 at 6:24 pm
  • Hi all, I am trying to simulate what is in production in dev box and test out the existing setup. We have Oracle ATES is a small database that I created in dev. Here is the script that I ...
    Ram RamanRam Raman
    Feb 14, 2008 at 4:03 am
    Feb 15, 2008 at 5:41 am
  • Good morning all, I boldly applied the latest cluster patch to one of my little blade servers. However, I don't see anything on Metalink that states you must relink the executable after patching the ...
    Koivu, LisaKoivu, Lisa
    Feb 8, 2008 at 2:09 pm
    Feb 8, 2008 at 8:02 pm
  • 10gR2 is suppose to autotune db_file_multiblock_read_count which sounds like an appealing concept. http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-04-20.2949600305 The idea according ...
    kyle Haileykyle Hailey
    Feb 5, 2008 at 9:27 pm
    Feb 6, 2008 at 12:37 pm
  • I just want to conduct a poll : How frequent and in what circumstances do you use or see used the "ALTER SYSTEM|SESSION COMMIT_WRITE = nowait, batch; " ? How frequently ? What type of application / ...
    Hemant K ChitaleHemant K Chitale
    Feb 2, 2008 at 8:17 am
    Feb 4, 2008 at 1:32 pm
  • Hi, I have an oracle rac ( configuration which runs on windows (windows 2003 SP2). On linux/unix I configure the NTP settings (to keep the time between the different rac nodes in sync) in ...
    D'Hooge FreekD'Hooge Freek
    Feb 28, 2008 at 12:54 pm
    Mar 4, 2008 at 9:35 am
  • I am trying to duplicate a 10g database to a new host. Host has 28Gig of memory it is running REDHAT Enterprise. It reads approx 10 X 2 gig backup slices then Redhat's out of memory utility kicks in ...
    Howard LathamHoward Latham
    Feb 27, 2008 at 12:34 pm
    Feb 28, 2008 at 8:03 pm
  • Hello all, Oracle, Enterprise Edition, on AIX 5.3. I am preparing to change our RMAN backups to use Incremental Backups and Change Block Tracking. I am also considering to use compression ...
    Sam BootsmaSam Bootsma
    Feb 22, 2008 at 3:52 pm
    Feb 26, 2008 at 5:19 am
  • Greetings, Below is the output from ifconfig -a on one node of a two node RAC cluster running Oracle EE on RHEL4. I just noticed something interesting today. If node 2 of the cluster is ...
    William WagmanWilliam Wagman
    Feb 21, 2008 at 10:38 pm
    Feb 22, 2008 at 10:28 pm
  • I am writing a scheduling application in apex. Resources are reserved by hour. I need a calendar to show when resources are reserved. In the 'day view' of that calendar I need the schedule split out ...
    Stephens, ChrisStephens, Chris
    Feb 20, 2008 at 3:38 pm
    Feb 20, 2008 at 4:55 pm
  • Hi all Any one come across to run apps 11i in farsi lang. Could someone put information on this please Thanks Ahmed Never miss a thing. Make Yahoo your homepage. -- ...
    Ahmed kdnlAhmed kdnl
    Feb 13, 2008 at 11:54 am
    Feb 13, 2008 at 3:24 pm
  • Hello everyone, If someone has got RMAN configured w/ TSM (Tivoli Storage Manager), would they be willing to share the configuration steps (or point me to appropriate references)? I'm trying to ...
    Ravi GaurRavi Gaur
    Feb 8, 2008 at 8:20 pm
    Feb 9, 2008 at 1:51 am
  • All, I have a Oracle 10gR2 database on Solaris 9 which is going to be few TB in 6 months time . and my manager wants me to come up with some recommendation for a SAN storage .so Please advise me on ...
    Feb 5, 2008 at 11:55 pm
    Feb 8, 2008 at 5:09 am
  • All, Is anyone running grid control on an Aix box? I had version 1 running on one Aix box here and it crashed the server every morning, so I deinstalled it. I am hesitant to install it again. Right ...
    Mercadante, Thomas F (LABOR)Mercadante, Thomas F (LABOR)
    Feb 5, 2008 at 1:26 pm
    Feb 7, 2008 at 4:11 pm
  • hi, all We have a homegrown script that pulls different views to log many different system level statistics for troubleshooting, and one of the view we query is v$system_event/x$kslei. As we does the ...
    Feb 1, 2008 at 8:21 am
    Feb 5, 2008 at 9:55 pm
  • There is a new Oracle White Paper on OTN that discusses 9i to 10g upgrades, specifically regarding what to expect from the Optimizer. I highly recommend reading it if you are planning 9i to 10g ...
    Greg RahnGreg Rahn
    Feb 27, 2008 at 4:16 am
    Mar 3, 2008 at 5:33 am
  • Hi All, I'm building a 10g database on a VxFS filesystem on HP-UX. I understand this does not support kernelized asynchronous I/O but does support threaded asynchronous I/O which I believe has a ...
    Charlotte HammondCharlotte Hammond
    Feb 25, 2008 at 9:40 pm
    Feb 29, 2008 at 5:21 pm
  • Requirements: How to derive the OS process ID of its OWN Oracle session? Assumption is that we have access to V$PROCESS. In 10g, I solved it this way: From userenv('PID') this get mapped to the PID ...
    Peter TeohPeter Teoh
    Feb 22, 2008 at 5:40 am
    Feb 24, 2008 at 8:05 pm
  • Folks In a Benchmark running 512 concurrent Batch processes High "cursor: pin S" wait is occuring. How is this wait to be approached? Oracle Solaris 10 Cheers & Thanks Vivek P.S. Top 5 Timed ...
    Feb 21, 2008 at 5:50 pm
    Feb 21, 2008 at 7:47 pm
  • I have a situation where I want to have two Oracle 10g2 Homes on my 2-node RAC cluster that ASM already uses ASM. The reason: I want two distinct production environment, one that stays fairly ...
    Brian LucasBrian Lucas
    Feb 15, 2008 at 7:26 pm
    Feb 19, 2008 at 5:41 pm
  • Hi I am having a bit of a mental block ! Primary is on ASM and using OMF, i want to create a standby that does not use ASM and OMF, and i'm (trying to) use RMAN DUPLICATE When creating the ...
    Neil campbellNeil campbell
    Feb 14, 2008 at 3:27 am
    Feb 14, 2008 at 9:51 pm
  • Can somebody share the RAC configuration with Websphere. This is 5 node RAC and using the following ...
    Sanjay MishraSanjay Mishra
    Feb 13, 2008 at 5:24 pm
    Feb 14, 2008 at 6:55 pm
Group Navigation
period‹ prev | Feb 2008 | next ›
Group Overview
grouporacle-l @

209 users for February 2008

Finn Jorgensen: 33 posts Jared Still: 26 posts Roman Podshivalov: 25 posts Niall Litchfield: 17 posts VIVEK_SHARMA: 15 posts Mark W. Farnham: 14 posts Powell, Mark D: 14 posts Don Seiler: 13 posts Nigel Thomas: 13 posts David Barbour: 11 posts Jonathan Lewis: 11 posts Mercadante, Thomas F (LABOR): 11 posts Greg Rahn: 10 posts Kathy duret: 10 posts Andrew Kerber: 8 posts D'Hooge Freek: 8 posts Harvinder Singh: 8 posts Joel.Patterson_at_crowley.com: 8 posts LS Cheng: 8 posts Oxnard Montalvo: 8 posts
show more