This post will provide a simple test case for the efficacy of creating and using an Oracle database cluster using NFS storage. The basic configuration will be shown, as well as the test case scenarios and results. A complete installation…
Author: Steve
Does dropping a foreign key constraint drop the corresponding index?
No, you can safely drop a foreign key referential integrity constraint without affecting any underlying indexes. SQL> create table p(t number primary key); Table created. SQL> create table c(f number primary key, t number references p(t)); Table created. SQL> create…
JBOSS – total CPU time compared to total page response time
I thought this was interesting. By taking the total response time of pages from the access log, you can take the amount of server CPU used and compare it to the total elapsed request time. This works for web servers,…
ATG repository caching and the ServerLockManager
While somewhat ancient, I use what is below to crawl an EAR and find which repositories are configured to actually use the ServerLockManager in ATG. for f in $(find . -name “*.jar” -type f ); do for x in $(jar…
ATG – printing items in a giftlist
What is below will print all SKU’s in a giftlist for a given profile… SQL> select g.catalog_ref_id, stock_level, s.display_name 2 from core.dcs_giftitem g, core.dcs_inventory i, cata.dcs_sku s 3 where id in (select giftitem_id 4 from core.dcs_giftlist_item o 5 where giftlist_id…
Determine the number of active sessions from the JBOSS access log
While planning for holiday shopper traffic, we realized that we did not record the number of active sessions at any given time during holiday 2013. To come up with something that would get us close, we wrote what is below…
Wrong permissions on /tmp cause havoc with java
We had a server that had been behaving oddly since at least April. I finally discovered why. jps returns nothing, which is the first symptom. When we strace, we see it can’t write to /tmp (our setting for java.io.tmpdir), so…
The PL/SQL commit “optimization”
For those of you that may not know, PL/SQL has what is normally an enhancement that results in a full commit being performed at the end of a job, rather than when the programmer instructs it do so. The reason…
HAProxy ACL based on percentage
We use F5 in production environments, but to test a functional setup of A/B testing, we used HAProxy 1.5-dev21. We have a single domain, and would like to forward requests to one of two backends based on a cookie value.…
Finding windows OS files modified in time range with python
We had a need to search some text files in Windows modified during a certain time range with a given piece of text. This is a network drive that is not indexed, so we couldn’t quickly rely on a windows…