Jul 30, 2013

1. [Re]compiling all objects in a schema
exec DBMS_UTILITY.compile_schema(schema => 'SCHEMA');
To recompile only the invalid objects in parallel:
exec UTL_RECOMP.recomp_parallel(, 'SCHEMA');
A NULL value for SCHEMA recompiles all invalid objects in the database.

2. SGA breakdown in Solaris Locality Groups (lgroup) To find the breakdown, execute pmap -L | grep shm. Then separate the lines that are related to each locality group and sum up the value in 2nd column to arrive at a number that shows the total SGA memory allocated in that locality group.

Solaris lgroups, CT optimization, Data Pump, Recompilation of Objects

Jul 25, 2013

Multiple RDP sessions is disabled on Windows servers. It means that if you are working on the server and at the same time another administrator connects, you get disconnected, because the other admin takes over. How to enable multiple RDP sessions? There is a simple way to do it and I’ll show you how to

How to enable multiple Remote Desktop Protocol sessions on Windows

Jul 12, 2013

StartSSL.com offers completely free verified (your users won't have to see those scary red screens saying "this site isn't trusted" anymore) SSL certificates that you can use on your website. This is a great deal as most companies charge $50-$60 for similar services. The free version is a bit tricky to set up, but it's well worth it.

How To Set Up Apache with a Free Signed SSL Certificate

Jul 7, 2013


Managing Network Configuration Under Solaris 11


Installing and Managing Oracle Solaris 11 Virtualization Features

Jul 6, 2013


How to Build a Web-Based Storage Solution Using Oracle Solaris 11.1

TECHNOCRACY © 2012-2017