Oracle Problem Using Cache Advice

I am using Oracle 8.1.7 on NT. I tried using cache advice. I checked for the parameter 'db_cache_advice' using 'show parameter db_cache_advice' but I was not able to find it.But the view v$db_cache_advice is available.What can be the reason? ...

Oracle DB Cache Size

HiHow does reducing DB Cache Size improve the physical read factor ? The histogram indicates that if I reduce my Buffer Cache, then I can have imporvements of 50%, currently it is at 3.5GB. ...

Oracle Collections API value objects, Berkeley DB cache and Garbage Collection

I am using the Berkeley DB Collections API. In my application, I do a lot of repetitive retrieval and updates of DB objects, however, the majority of objects that I create are rarely updated and a minority or updated extremely frequently. I have built a custom memory cache that efficiently stores an ...

Oracle put hangs when in-memory db cache is full

I'm using a in-memory db and found that when cache reaches its maximum limit, attempts to insert new key-data pairs with db->put block the process indefinitely. Is there a way to make db->put return an error when db cache is found to be full?I'm using version 4.6.21.Environment cache is shared ...

Oracle Statistics about DB cache usage

I am trying to find out the utilization of my Database Buffer Cache for a month by using the following SQLselect gv.instance_name, sn.snap_id, to_char(sn.END_INTERVAL_TIME,'dd-Mon-yyyy hh:mi PM') mydate,round((new.consistent_gets + new.db_block_gets - new.physical_reads)/power(1024,3),2) "GB Use"fro ...

Oracle memory-mapped db cache performance with RAID

I am working on some performance problems with our db. We are using BDB 4.6.21, both Windows and linux. We read and write the db, and we confine our db accesses to one process (one writer thread, many readers). The db is about 1 Gig, and we use a 32 Meg cache. At the moment, we can't afford a bigger ...

Oracle DB Cache issue

Hello, I am troubleshooting performance issues on a customer database. I was looking at issues with disk i/o and was wondering if this output may indicate an issue. There are a few tablespaces that use a 16k block size and several that use an 8k block size. Below indicates that db_8k_cache_size is 0 ...

Oracle DB Cache Full or Redo Log Full?

Is there any way that Oracle can write to datafiles in the middle of a transaction?Iam reading, processing and writing very large sized lobs which gives error that "no free buffers available in buffer pool".When in lobs, a lob is not written until the whole tranaction finishes - but in my case the l ...

db splitting advice

I have a 90M Access 2000 DB running on a Windows 2003 Server network. The DB runs on the server is NOT split and seems fine with 2 (maybe 3) concurrent users but once more people use it then I need to Compact & Repair it regularly. A couple of times I’ve got a message about ‘can’t find sysmd ...

PEAR DB:CACHE skipping first row in MySQL results

I am using the PEAR class Cache/DB to run cached query against a MySQL database. The result set is always missing the very first row. I have the latest PEAR Cache distro. Here is an example of my code:require 'Cache/DB.php'; $age = (3*3600);$cache = new Cache_DB('file',array('cache_dir' => '/tmp/ ...

static variable for db cache

i try to cache my db-results in a static hash table like:$ses_cacheArray[$table][$sql] = $result;so if this query is already cached i just wanna return the array entrybut i find no way to create a variable accessable in all sessions without overwritingthx in advance,steffel ...

Oracle Question about DB cache location/consistency

I understand that the DB maintains a cache of DB pages. Is this cache local to a single process? Will multiple processes accessing the DB use the same cache?What I'm trying to figure out is:- If process X writes to the DB (and the write is cached)- And proces Y reads from the DB (and the read is fro ...

Oracle Can the ENV level cache be overridden by a DB cache?

If we set an environment level cache as part of the environment setup, is there a way to ovverride that with a DB level cache ? i.e. does setting a cachesize for a particular DB have any effect if a cahce has been set for the environment to which it belongs? ...

DB Structure advice

I'm having a few dilemma's about designing the following tables of a DB.Or more to the point am unsure how these relationships work.Suitabilty is linked to a Summary table via a foreign key. Suitablility - Partchment - ReccomendedAcceptableFurther researchNot testedFailed.Lights - ReccomendedAccepta ...

Oracle 8i DB Cache

I am running Oracle 8i on Sun Solaris. I have determined that my Cache Hit Ratio is very low - 54%. What can I do to increase this to > 95%? ...

Oracle DB Cache buffer organization

I was reading "Oracle 9i Database Concepts" doc, and found the following information:The buffers in the cache are organized in two lists: the write list and the leastrecently used (LRU) list. The write list holds dirty buffers, which contain data thathas been modified but has not yet been written to ...

Oracle DB Cache hit ratio is low

plz help me. My database DB_cache_size 427 M.B, and DB Cashe Hit ratio is 35%. what I can do. if increase DB_Cache_size parallel increase the Shared_pool and other pool also. plz help me. ...

Oracle Any OCI interface to flush out the V$SQLAREA cache?

As u know, V$SQLAREA list all the recently executed SQL for performance reason.My question is: are there any way to erase the SQL in this table via any combination of the OCI interface?Anyway to set the flush out frequencies, or set the maximum limits (in rows) V$SQLAREA can have? ...

Oracle Berkeley Db Cache

I wanted to know if i were to have a Database size lesser than the size of the cache size will the entire database be loaded into the database by defaolt after my first transaction is completed ...

Oracle increase db cache size?

I' trying to increase the sga to utilize the more than 4GB of memory, but because my system is 32-bit so I have to use the (use_indirect_data_buffers) parameter with db_block_buffers and but 0 in db_cache_size. but unfortunately I get an error while trying to apply the changes: ORA-00381: cannot use ...

Oracle what if I made my db cache REALLY big?

if I had 256G of RAM, and I allocated say 200G to my database cache (and 50G for other stuff), and managed to fill the whole 200G with data blocks, then could it be that I have soooo many data blocks in the buffer that searching for the right one will start taking too long and I would start losing t ...

Ubuntu db related advice

I've been working with php now for about 4 to 5 years doing web delivered database applications. The work I've done wasn't continuous so I am not a 100% programmer. I do lots of hardware and desktop support and am trying to move away from it because it is a big source of aggravation.Recently I picke ...

db theory advice multiple catagories per item

My co worker designed a database where retail items can be placed in multiple catagories. This seems odd to me..... In general, Isnt it more normal than not to be only one catarory for each item? For example, lets say I was selling a bowling ball with a picture of Mickey Mouse on it. I can then find ...

DB Crash - Advice

We are having intermitent crash problems on our Oracle 10.1.0.2 database running on an AIX 5.3 operating system. The environment was stable for over a year, until recently. What is interesting is crashes only occure between 7:00 AM and 9:00 AM, only once a day (not every day).After restart, everythi ...

DB Design - Advice needed

OK here is my design for the database of a site of mine. It's a site about 2nd hand cars. Only dealers will be able to add their cars to the database (after they have been added by an admin). The rest probably explains itself. I would appreciate it if you could take a good look at it and tell me if ...

Oracle CBO v/s RBO advice needed

Hiwe have a database 9.2 that has several tables and their are hevy DML's going on the system and this database is also being used for reporting (Keeping in mind we can not create another instance just for reporting). Some of the Tables are huge like they have more than 360 millions rows in it and s ...

Oracle Auto SGA being disabled?

I noticed the following entry in the alert log on all three instances on a three node rac cluster.AUTO SGA: Could not access db cache advice.AUTO SGA: Disabling background sga auto-tuning.I confirmed that auto sga isn't being resized and remains consistent. I had this problem before and recreated th ...

Oracle DB_CACHE_SIZE TO BE CHANGED

The awr report shows that the buffer hit ration is 50%.So i need to increase the db cache size of the database.So what are the steps I need to follow to have a successful configuration of the db_cache_size parameter.How can i know that the how much SGA_MAX_SIZE is available so that i can accomodate ...

Oracle Berkeley DB environment/cache performance tuning

We have a large in-house applications that is faced with significant issues in dealing with large-scale data management on a collection of Berkeley DB files. The system currently tracks multiple volumes of data, each volume of which consists of more than 50 database files of various sizes and differ ...

Oracle Buffer Cache size Advice in OEM 9i

I have oracle 9i Rel-2 database, since last one week I am continuesly checking Buffer Cache Advice( in OEM in CONFIGURATION panel of INSTANCE expended bar), but it says "...................No statistice have been collection yet because no application have accessed the database......."But infact data ...

Oracle How can I create an EntityStore for a Database? Advice on DB strategy?

How can I create an com.sleepycat.persist.EntityStore for a com.sleepycat.db.Database? Advice on DB strategy?I'm looking to create an application prototype that creates a database dynamically and can delete it programatically. Is openDatabase/removeDatabase what I'd want to use for that?So far, the ...

Oracle 9.2 DB on Win2003, Getting ORA-00381 Trying to USE_INDIRECT_DATA_BUFFERS

I'm trying to use the 8GB of RAM recently installed in our Win2003 server. PAE is turned on, so I think the OS properly configured. I then do the following:SQL> alter system set use_indirect_data_buffers=true scope=spfile;SQL> alter system set db_block_buffers=524288 scope=spfile;SQL> alter ...

Oracle High library cache load lock waits in AWR

Today i faced a significant performance problem related to shared pool. I made some observations, thought it would be a nice idea to share them with Oracle experts. Please feel free to add your observations/recommendations and correct me where i am wrong. Here are the excerpts from AWR report create ...

Alarms, Events, Emails, Monitoring a MySQL DB

I'm very new to MySQL. I want to know if are there alarms or events to monitoring and controll a MySQL DB, to advice me in an automatic mode to abnormal situations. I'm Oracle DBA and use OMS, I'll searching for any similar tool. ...

Online game / 16,000+ users / DB woes!

We have written an online web based resource management game that currently has in excess of 16,000 players and as many as 1,000+ playersonline at any given time. We are having some serious performance issuesat this point (we COULD have more than 1,000 players but we had to limitit because of the pe ...

Oracle Data Buffer Cache Limit

Is there any way that I could signal daat buffer cache to write all data to data files if amount of dirty blocks reach say 50 Mb.Iam processing with BLOBS, one blob at a time, some of which has sizes exceeeding 100 Mb and the diffcult thing is that I cannot write to disk until the whoile blob is fin ...

Pear::DB issues

here is the connection:/*Database Connection | Pear::DB API--------------------------------------------------------------*/$dsn = "mysql://$user:$pass@$host/$db_name";$db = DB::connect($dsn);if (DB::isError($db)) {die ($db->getMessage());}here is the code:/*** Creates the header for the ...

Oracle Update data using spreadsheet with HTML Db

I am new to Oracle HTML Db and have a requirement with the following steps:1. Import data from a Oracle database table into a spreadsheet (Excel) using Oracle HTML Db - preferably by the user clicking a button in a HTML Db application2. User updates the data as required and saves data3. User clicks ...

Ubuntu Thumbs.db:encryptable

I know this may not be the place to post this, but I am running out of options. For a long time I have been using Ubuntu on a dual-boot machine. For work I needed to keep running WindowsXP, and eventually found myself migrating back to Windows full time for various reasons.Don't get me wrong...I lov ...

Oracle Space issue (standby DB is also there)

OS : AIX 433Oracle : 8.1.7We have standby DB running on this PROD DB. I have some space issue on this DBs. we can't bring down the DBs and want to resolve this issue while they are open.File Name Size (M) Used (M) Free (M) /u01/oradata/PROD/data04.dbf 1024 1023.99 /u01/oradata/PROD/data05.dbf 2048 2 ...

Oracle Content DB/Webcenter Suite

What is the role of Oracle Content Database in Webcenter Suite? Is that the default repository? I read a lot of documentation but no where it explains the connection.We are in the process of getting a licence for the Web center Suite. As per Oracle sales rep, the license for Oracle Content Database ...

Oracle BDB JE with Jboss cache.

I've been trying to add functionality to the Berkeley DB cache loader, that will delete old records. upon insertion to the database, a secondary database is updated with a timestamp.when purging, a cursor on the secondary database is opened, and older records are supposed to be deleted. Insertion an ...

Oracle Unable to connect to DB by SQL*Plus 9.2.0.1.0

I do have the same TNSNAMES file in both Oracle 9 client and Oracle 6i client. I have no problems at all with my 6i client to connect a 10g DB. Any advice for that I have a problem with 9i client?For your info, in the same machine, using another login, I'm also able to connect the DBs, by my 9i clie ...

Oracle Data Base Buffer Cache Ful

what if, an update statement causes the existing db cache ful with the updated information(in this case this is uncommited transaction). in this case, if another user run the update statement where that update information stored before written to the datafile. ...

Oracle Does bdb cache use JVM heap memory?

I'm using BDB Java API. Do I need to set the heap size to be bigger than the db cache size? ...

Oracle Updaing "live" read-only Berkeley DB files

I am opening a pre-populated Berkeley DB file (generated externally) in read-only hash access mode:rc = _db->open(_db,NULL,_fileName,NULL,DB_HASH,DB_RDONLY,0444);Let's say, I receive an upgraded version of the file "_fileName" (same format and Berkeley DB version) and go ahead and update it in-pl ...

Oracle There seems to be no defined database cache

Hello, looking at the parameters in this database there appears to be no cache. This shows that AMM is turned off but also that there is no db cache. How is cache being allocate if these are all 0? I am running Oracle 10.2.0.3 on AIX5300-09. Are there other parameters to look at. Shouldn't db_cache_ ...

Oracle Hi RMAN 32 BIT CATALOG DB WITH 64 BIT PROD DATABASE

I had configured a rman server with catalog database in oracle10gR2 32 Bit version. I added 32 bit databases and scheduled It is working well.1.Is it possible to register Oracle 10g 64 bit database in 10g 32 bit catalog database for rman backup?2. I am unable to register 9i database in 10g32bit cata ...

Connect new Oracle DB and existing TimesTen Database

I am new to TimesTen and learning things here. Here is a scenario I am working on and have some vague idea of how things should work:We have a TimesTen database (replicated I think) to which we wish to connect a new Oracle database. The schema in this new Oracle database is design to mimic the TimeT ...

Ubuntu how to put /var/cache/apt/ as a repository server

i want to put the files that synaptic already downloaded to sit in my apache as a local (incomplete) mirror of the "real world" ubuntu repository so all the other ubuntu machines in my network can load them from my machine and dont have to use internet bandwith (wich costs money in some co ...