(Dbaharrison) Yesterday i posted about my attempts to tune one of my systems – it ended with me not having a solution and having to go back and rethink a solution.

(Steven Chan) Oracle Traffic Director is a high-throughput low-latency load-balancer that can optimize HTTP and HTTPS traffic for Oracle E-Business Suite environments. It offers built-in optimizations for Oracle WebLogic Server along with rule-based request routing, reverse proxy capabilities, requ

(Andrew Reid) I read that you cannot take a tablespace offline if the database is only mounted so I decided to test this in an Oracle 11.2.0.4 database. I mounted the database and tried to take the USERS tablespace offline.

(Martin Bach) This is just another short post about one of the little things worth knowing. Assume you are on 12.1.0.2 for example and you want to know if parallel_degree_limit reliably keeps the degree of parallelism at bay, for all sessions and queries across the board. After all, every machine ha

(amitzil) One of our main lines of business at DBAces is security and database security. Besides that, security is a very interesting topic and I love it. So I decided to start a series of posts about security in general (as an overview) and database security specifically.

(Dbaharrison) You learn something new every day – you really do. Today i finally learnt how to get errors displayed when compiling code in sqlplus that didn’t seem to have worked properly for years. I guess i just thought there was a bug somewhere that was never fixed.

(Ben) Oracle SQL aggregate functions are very useful, and are some of the most commonly used functions. Learn what Oracle SQL aggregate functions are and what they do in this article.

(Michael McLaughlin) If you’re reading this post, you most likely are trying to run the Oracle Database 11g or 12c runInstaller program, and it’s failing a critical dependency check and displaying an error like the one below. If so, choose n because if you choose y it won’t launch the Oracle Install

(Dbaharrison) This week I’ve upgraded one of our dev databases to 12.1.0.2 (from 11.2.0.2), the upgrade went fine no problems with that.

(Iggy Fernandez) Oracle NoSQL Database uses Major and Minor key values to achieve user-controllable record co-location. Records are stored based on the hash of the major key, so all of the records with the same major key will be co-located on the same server.