Caredda Alessandro
DBA Specialist
DBA specialist

Main tasks:

  • Project activities on databases and Businnes Critical applications.
  • Database migrations of different characteristics and sizes.
  • Implementation of new data backup and recovery policies.
  • Performance analysis and tuning on database and dedicated OS.
  • Customer support.
  • Implementation of different monitoring platforms.
  • Scripting activities on different Linux, Unix and Microsoft shells.

Used technologies:

  • Oracle database 10g 11g 12c RAC + ASM
  • SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017 Express, Standard, Enterprise Edition
  • PostgreSQL 9.1 – 10
  • MySQL 4 – 5
  • Sybase
  • TOAD
  • SQL Developer
  • IAS 10g
  • Tomcat apache

Operating systems used:

  • Unix – HP-UX, IBM AIX, Sun Solaris
  • Linux – Red Hat, Centos, Suse, Mint, Ubuntu, Fedora
  • Microsoft – Windows Server 2005, 2008, 2008 R2, 2012, 2012 R2, 2016

External backup client software used:

  • DPM Data Protection Manager
  • NetBackup
  • Veem
  • Legato Networker
  • TSM

Monitoring platforms used:

  • BMC Patrol

Troubleticketing clients used:

  • BMC Remedy
  • OverIT Geocall
  • HP Service Manager 9
  • Companies I worked with:

Employee of companies:

  • SIRFIN spa group via A.Bargoni, 78 Rome
  • STM Italy Viale Alessandro Magno, 146 Rome
  • Global Technology Via Luigi Schiavonetti, 270 Rome
  • ADS Assembly Data System Via Laurentina, km 23,000 Pomezia
  • Alfasoft Corso Svizzera, 126 Turin

Job order managed by:

  • HP Hawlett Packard via Achille Campanile, 85 Rome
  • Reply Via del Giorgione, 59 Rome
  • Ericsson s.p.a. Via Anagnina, 203 Rome
  • Engineering s.p.a. Corso Mortara, 22 Turin

Customer advice:

  • WIND Telecomunicazioni spa via Carlo Veneziani, 56 Rome
  • SKY Italia s.p.a. Via Salaria, 1021 Rome
  • WIND Telecomunicazioni spa viaduct XXV Aprile, 9 Ivrea
  • WIND Telecomunicazioni spa Via Jervis, 77 Ivrea
  • Telecomitalia Via Monte Rosa, 154 Turin
  • ENI (from the Engineering office)
  • ERG (from the Engineering office)
  • METAMER (from the Engineering office)
  • EGEA (from Engineering headquarters)
  • Cariplo Foundation (from Engineering headquarters)
  • S2C (from Engineering headquarters)
  • Illy (from Engineering headquarters)
  • DeAgostini (from the Engineering office)
  • Italiaonline (from Engineering headquarters)

Our Story was born in April 2015 from the idea of ​​two brothers, Alessandro Caredda for DBA side and Andrea Caredda for the web configuration, who have decided to combine their skills acquired in their respective job roles.

The first project started with a Joomla based web site. The purpose was to have a reference point for all novice Oracle DBAs, providing queries, statements, blocks of code to query and the Oracle database management.

In these 5 years, I have started to run courses on Oracle databases for clients and companies with which I have collaborated. Considered the feedback from the employees who followed the courses, and the satisfaction received, I understood that through my words, I was able to convey the passion with which I have always done my job to a facilitated learning system, based on my experience.

Then, I noticed that my LinkedIn profile was visited by HR staff on an almost daily basis and I have often received job offers from prestigious companies, even beyond the European territory with important economic returns.

The method of exposure to companies was the right one, as was the right way to introduce myself, pass interviews and do the job in the most professional way.

Hence I got the idea to ​​transmit my winning method to all my website users.
So I started writeing public didactic material created for private corporate purposes and giving the opportunity to anyone who wants to pursue an IT career and start from Oracle databases without too much difficulty.

This is the main difference between us and other online professional schools.

In addition to the technical courses, included in the price, there will be courses in which it is explained in detail, how to create the professioanl resume, how to introduce yourself and pass job interviews. Finally we will be at your disposal whenever you need it by promptly answering your questions.

With the development in WordPress, the new is presented with new clothes: dynamic menus, innovative pages, but above all new sections, aimed at training and E-recruitment in Italy in the world for DBA positions. The best job offers present throughout the world from the main E-recruitment sites will be selected for you. The latest implementation of the site is the Troubleshooting section where tutorials on creating small laboratory environments with different types of databases on different operating systems are reported, and the Solution section where the procedures to be followed for routine troubleshooting will be reported.

Keep in touch!
Please join our community in facebook or feel free to reach me out on linkedin too

Query disconnect session Oracle

With the Oracle Query disconnect session article, we can disconnect the user session connected to the database, then the end of the session. LOCK session situations in frequently accessed databases occur frequently. With the Oracle Query disconnect session article we provide the solution.

In these cases, it is necessary to identify them with the query available on the article Query to identify which session is determining the LOCK, or with the query on the article Query to see the sessions holding LOCK or with the query available on the article Query to identify the session which is blocking other sessions.

Once the SID that determines the LOCK and the blocked SIDs has been identified, we must deepen the analysis by recovering useful information to be provided to the application group and allowing us to authorize the kill of the session that is causing the block.

The analysis takes place through the query available on the Query article to see the details of a session from SID Once authorized we can proceed with the disconnect of the session.
If that doesn’t work, we can try the kill command instead of the disconnect statement Pay maximum attention to the origin of the session that we have to disconnect, in a RAC the SID can be the same on all instances. SERIAL with SID accurately identify the session we are interested in.

Query to disconnect a session for SID:

select ‘alter system disconnect session ”’||SID||’,’||SERIAL#||”’ immediate;’ from gv$session where SID=&sid; Copy

Query to run the disconnect sessions for SID on RAC environment: select ‘alter system disconnect session’ ” || SID || ‘,’ || SERIAL # || ‘@’ || INST_ID || ‘ immediate; ‘ from gv $ session where SID = & sid; Keep in touch! To view my guides on CRS commands click here! At this LINK, however, you will find SQL queries Stay updated on our activities by joining our community: Facebook Youtube Linkedin   KILL Oracle USER sessions Oracle disconnect session query Query to disconnect a session for SID KILL Oracle USER sessions on RAC LOCK query and number of Oracle sessions Query to identify the sessions blocked by another session Query to see the details of a user’s Oracle session Query sessions processes Oracle cursor transactions Query holders of LOCK Oracle session query retrieved from DATA

Wordpress Social Share Plugin powered by Ultimatelysocial