I knew in Oracle 11g with Automatic Memory Management (AMM), the database was able to give unused memory back to the OS, controlled by MEMORY_TARGET and MEMORY_MAX_TARGET.
This mechanism is present in 11g since day 1 (in 2007), but I never actually played with it.
MEMORY_TARGET and MEMORY_MAX_TARGET
The Oracle documents state the following:
MEMORY_TARGET specifies the Oracle system-wide usable memory.
MEMORY_MAX_TARGET (…) decide on a maximum amount of memory that you would want to allocate to the database for the foreseeable future.
So my guess is, MEMORY_MAX_TARGET (static) is the maximum you can set MEMORY_TARGET (dynamic) to. A couple of days ago, I wanted to experiment a bit with these memory settings.
In this blog post I will talk about the basic workings of Automatic Undo Management, which can cause ORA-01555 and ORA-30036 issues.
The scope is Automatic Undo Management used in 10g and 11g, but has to be explicitly set for 9i (UNDO_MANAGEMENT = AUTO). Manual Undo Management is out of scope for this blog.
The Undo tablespace is a normal tablespace like any other, but only Oracle is controlling what is happening inside it.
The Undo tablespace is used for several features: ROLLBACK, READ CONSISTENCY and FLASHBACK technology. Continue reading
This HTTPS via utl_http using orapki recipe is prepared with certificates and the orapki tool having some sweet and spicy taste. You may also use the Oracle Wallet manager instead of using orapki but for Oracle RDBMS you will need to have Enterprise Edition and Advanced Security pack licenses. Continue reading
Installing the Oracle Instant Client will save you ~600 megabyes compared to the ‘full’ Oracle Client.
- Download Basic Package from the Oracle site
- Unzip to directory x (your ORACLE_HOME)
- Set PATH (Windows) or LD_LIBRARY_PATH (*nix) to the Instant Client directory x
- Move TNSNAMES.ora to directory x/network/admin (or set TNS_ADMIN and ORACLE_HOME).
- Extend with SQL*Plus Package (optional)
- Start your application
Read my full article here: Whiteblog – Installing the Oracle Instant Client. (links in referred blog might not work!)
OLE DB, .NET and ASP.NET drivers are not included in the instant client (first Oracle link might suggest it is). These are included in the ODAC package, download them separately at these locations:
Instant Client vs Full Client (Administrator and Runtime)
What Are The Different Oracle Client Components Installed With Different Installation Types (too much to sum up):
Client master note
Master Note For Oracle Database Client Installation (Doc ID 1157463.1)
Checked for relevance on November 4th, 2019.
Have a look at my Whitehorses Blog where I will explain in more detail.
Final conclusion (on one line):
CustomLog "|<midtier>\Apache\Apache\bin\rotatelogs logs\ssl_request_log 43200" "%t %... %b"
They have finally arrived, the Windows 64 and 32 bit versions of Oracle 11gR2.
Download Oracle Database 11g Release 2 for Windows
The 64 bit version was released a bit earlier, so I was hoping the 32 bit version would not come… Why do we want the 32 bit versions? Older systems? Ancient systems! Why…?!
Now I don’t have an excuse to update my almost 10 years old Windows XP OS (running on 64bit hardware) to a much nicer Windows 7 64 bit. The only excuse now is that I could use 600+ megs of memory… enough to run that XP OS virtually!
In Oracle 11g, the one who is calling a remote site needs to get access to that site. This is done via the Access Control List.
I have written a blog about this error at my Whitehorses Blog: Oracle 11g: Access Control List and ORA-24247.
Today I had to babysit a demo machine I set-up for a proof of concept. All went well, as I expected.
A two gigabyte RAM Linux machine with SOA/BPEL 11g, two WebLogic 10.3 domains extended with ADF and Apex XE running on it. It kept running, but at one point is had only 30 megs of memory left!
Check out ‘Extending your WebLogic standalone environment with ADF runtime libraries‘ for more information about setting up the WebLogic environment with ADF.
When moving/deleting the listener.log, I used to stop and start the listener and move/delete the listener in between the actions.
This method has a big inconvenience: users can not connect to the database for a few seconds…
What I never knew was that the listener could be told to stop and start logging and take the appropriate action in between. Continue reading
When having multiple Oracle homes on Windows, how is decided which Oracle home (in the registry) is used by an Oracle binary? Which NLS_LANG or TNS_ADMIN setting from the registry is used?
The answer is binary, path, oracle.key, registry… and which for Windows. Continue reading