I am working on a project that requires me to get the name of the program during the logon process to the database.
“What an ideal place for a logon trigger!”, I said to myself.
I thought the task would be quite simple, just get the SYS_CONTEXT(’USERENV’,'SESSIONID’) and use that to query v$session. I know that v$session.audsid is not unique as the background processes are “0″ while other
In the end, my 10.2.0.4 SGA problem ended up being the _db_block_cache_protect parameter. Seems as though setting that parameter in 10.2.0.4 maps the SGA to /tmp/shm instead of real memory. The immediate cause of my:
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
was that I didn’t have enough space mounted at /tmp/shm. When I did allocate enough space, I got an ORA-
If you’ve been following along, I’ve had quite a tough time with 16GB SGAs on 10.2.0.4. With help from Kevin Closson and Oracle Support, we found that the init.ora parameters “_db_block_cache_protect=true”, “_db_block_check_for_debug=true”, and “db_bl…
There was some questions whether I turned NUMA off or not one one of my previous tests. I repeated the test with similar results.If I looked at my /proc/cmdline, I got:ro root=LABEL=/ console=ttyS1 pci=nommconf elevator=deadline selinux=0 numa=offThen…
No, no, not the Brangelina twins announcement, the numactl output.$ ps -ef | grep oracleoracle 13771 2418 0 Jun24 pts/0 00:00:00 -kshoracle 13772 13771 0 09:24 pts/0 00:00:00 ksh -ioracle 13775 13772 0 09:24 pts/0 00:00:00 ps -eforac…
I escalated my issue to a duty manager and explained that in my environment those types of changes are very difficult. He kicked it back to development for alternate solutions.In the background, I managed to secure a test box for a couple hours that I…
We’ve passed the one month anniversary for Something to be aware of (10.2.0.4) and still no meaningful results. I’ve been going back and forth with Oracle Support about switching NUMA off. In a synopsis:OS: Switch NUMA off and retest.Me: But that nev…
I’m pretty particular about my backups at work. In fact, we have a setup where if a nightly backup fails, we get a page in the middle of the night so we can address the problem.At home, it’s a different story. I’ve got a Windows 2000 PC that I haul o…
I needed a new laptop for my home. OK, maybe “need” is not the correct word, but you get my picture.So I did what I always do. I navigated to dell.com and purchased a Inspiron 1525 with a 15″ screen, 4G of RAM and Microsoft Windows Vista Home. I wen…
My standard install of 10.2.0.3 included 23 patches at last count. When the 10.2.0.4 patchset came out a few weeks ago I checked it and decided that since my 23 patches were included in 10.2.0.4, it would be a good idea to upgrade to that version.I fir…