Navigation |
syndicatorWhy do I get out of memory errors when 10GB memory is free?I am on HP UNIX 64bit 11.23 titanium using oracle 10.2.0.3. My server has 24GB memory and of that 10GB is free (as seen in glance). When I doing oracle exp or rman commands, I get: ORA-04030: out of process memory when trying to allocate 1049112 bytes (KSFQ heap,KSFQ Buffers) I checked both rman and exp are 64bit executables, so they should be Usage of double quotesHi All, I have an insert statement that is embedded in a PHP code. It basically inserts a JS string. We have lots of single quotes inside the string which we replace by double single quotes. It works fine, but strangely now, the dev team wants to enclose the whole string in double quotes. Is there a way of enclosing the entire string in double Problem installing Oracle Unbreakable Linux on HP DL160G5Here's my situation: 1. HP DL160G5 hardware RAID configured (striped). 2. Installing Oracle Unbreakable Linux (recent version). 3. Installation not a problem and system reboots. 4. Get the following messages (approximate): USB 1-1: device not accepting address 2, error -71 ... .. /dev/sda2: read failed after 0 of 1024 at <large number>: input/ No Install of Oracle on 2003 now, can u upgrade to 2008 later.Wanting to install 10G or 11 onto a windows 2003 server now with a view to upgrading to 2008 server by year end. Will I need to re install oracle if I upgrade the server? Can I get away with an OS upgrade? Automatic checkpoint tuning on RACI recently talked about the automatic checkpoint tuning with a colleague of mine and we considered setting fast_start_mttr_target to a decent non- zero value like 300 on a RAC database. I am aware of the recommendation not to set it and the argument for that recommendation is the fact that another RAC instance will do a recovery, if an instance fails. ASM disk to physical disk mappingDoes anyone know how to map an ASM disk that I can see in OEM to its physical drive? I have a disk that is throwing errors via my hardware diagnostic (but no errors yet in Oracle). I would like to identify it in ASM, remove it and rebalance off of it. I know and can see the exact physical disk that is bad, yet I cannot definitively identify oracle application server 10.1.3 redirect problemStale statisticsHi, We have OLTP system on 10gR2 with RAC (3 nodes) with lot of active tables. Means deletes, inserts and updates. We are only gathering 1% sample statistcs. After bringing the system for couple of hours all the statistics are becoming stale. All our queries use bind varaibles and cursor sharing parameter is set to EXACT. Determing requested parallel slavesI'm on 10.2.0.2 EE As part of some capacity management work I'm trying to ensure I have enough parallel slaves free at certain times to run my big ETL processes without any downgrades. I determine how much I have been using from ASH - yes I know it's not perfect, but it'll do me for now. I do need to determine how many slaves my SQL is going to ask for. |
SearchFree Online File ConvertersBrowse archivesRecent posts
Tips |