Get capacity metrics for SQL Server and Oracle
Second round of the capacity metrics SQL Server Size of database : Size of all the tables > 10mo : Current users Current queries Oracle Size of the instance Size of the tablespaces Size of the schemas (only the one above 10MB) Size of the tables (only the one above 10MB) Current users and queries
Install Oracle on CentOS 6
I followed the quick installation guide Oracle provides so that’s more like an even quicker installation guide. To start, we need to install the necessary packages : [root@oracletest database]# yum install binutils compat-libstdc++* elfutils* gcc gcc-c++ glibc* compat-glibc* ksh libaio* libstdc++* make sysstat unixODBC unixODBC-devel We now need to create the users and groups : [...]
SQL Expert 101 3/X : DDL and DML
This article is the third of a series of articles aiming to prepare me (and you) to pass the 1Z0-047 Oracle Database SQL Expert. This part covers DDL (like creating table, adding constraints) and DML (insert/update/delete data). Maybe I should have done it in first but anyway let’s begin. Summary : Using DDL Statements to [...]
SQL Expert 101 2/X : Advanced Select
This article is the second of a series of articles aiming to prepare me (and you) to pass the 1Z0-047 Oracle Database SQL Expert. This part covers more advanced SELECT operation. Summary : Displaying Data from Multiple Tables Using Subqueries to Solve Queries Using the Set Operators
SQL Expert 101 1/X : Select
This article is the first of a series of articles aiming to prepare me (and you) to pass the 1Z0-047 Oracle Database SQL Expert.This part covers the basic SELECT operation and basic functions associated. Summary : Retrieving Data Using the SQL SELECT Statement Restricting and Sorting Data Using Single-Row Functions to Customize Output Reporting Aggregated [...]