Project Management

Plan Academy

Plan Academy Project Controls Training & Courses

Di Andrea Di Dio, fa

Notizie sulla certificazione PMP

OnlinePMCourses Online Project Management Video Courses to Build Your Project Career

  • How to Get the Best from Your Project Team with Situational Leadership
    by Mike Clayton on 28 Luglio 2025 at 4:55

    Situational Leadership is a simple and compelling idea. If you want to get the best from someone, choose a leadership style that suits the situation. The post How to Get the Best from Your Project Team with Situational Leadership appeared first on OnlinePMCourses.

  • What is Feature Driven Development (FDD)?
    by Mike Clayton on 24 Luglio 2025 at 4:55

    In this video, I answer the question, what is Feature Driven Development – an Agile methodology for developing software? The post What is Feature Driven Development (FDD)? appeared first on OnlinePMCourses.

  • How APM Sees The Future of the Project Profession
    by Mike Clayton on 17 Luglio 2025 at 4:55

    What does Edition 8 of its Body of Knowledge tell us about how APM sees the future of the project profession? I spoke with CEO Adam Boddison. The post How APM Sees The Future of the Project Profession appeared first on OnlinePMCourses.

  • Project Crisis Management! How to Handle the Next One Confidently
    by Mike Clayton on 14 Luglio 2025 at 4:55

    At some point in your project management career, you’ll need to deal with a project crisis. It may not be your fault. But, it may be. The post Project Crisis Management! How to Handle the Next One Confidently appeared first on OnlinePMCourses.

  • How to Say NO to Stakeholders, Clients, and Sponsors
    by Mike Clayton on 10 Luglio 2025 at 4:55

    Do you know how to say No to your stakeholders, clients, and sponsors and leave them feeling good? Because we can’t say yes to all of them! The post How to Say NO to Stakeholders, Clients, and Sponsors appeared first on OnlinePMCourses.

  • PM CPD and PDUs: How to Keep Ahead with Your Professional Development
    by Mike Clayton on 7 Luglio 2025 at 4:34

    A Project Manager is like any other professional. To take your career seriously, you’ll undertake Continuing Professional Development (CPD). The post PM CPD and PDUs: How to Keep Ahead with Your Professional Development appeared first on OnlinePMCourses.

  • Who are the Top 25 Project Stakeholders?
    by Mike Clayton on 3 Luglio 2025 at 4:55

    In every project, some stakeholders turn up again and again. Here are my top 25 types of project stakeholders, starting with the most common. The post Who are the Top 25 Project Stakeholders? appeared first on OnlinePMCourses.

  • Project Management Interviews: My Top 15 Videos to Watch Now
    by Mike Clayton on 30 Giugno 2025 at 4:55

    In the four years since I recorded my first project management interview, I’ve had over 60 wonderful conversations with astonishing Project Professionals. In this article, I want to highlight my top 15. Depending on when you read this, you may not see 60 interviews on my Conversations & Interviews playlist. Not all of them have The post Project Management Interviews: My Top 15 Videos to Watch Now appeared first on OnlinePMCourses.

  • What is the Analytical Hierarchy Process? And How Does it Work?
    by Mike Clayton on 26 Giugno 2025 at 5:00

    In this video, I answer the question, ‘What is the Analytical Hierarchy Process?’ and look at how we carry it out, with a worked example. The post What is the Analytical Hierarchy Process? And How Does it Work? appeared first on OnlinePMCourses.

  • Project Reporting Best Practice You Need to Know to Get Better Results
    by Mike Clayton on 23 Giugno 2025 at 4:55

    The cadence of your project reporting cycle sets the rhythm of your project. Quarterly, monthly, weekly – it’s time for your next report. The post Project Reporting Best Practice You Need to Know to Get Better Results appeared first on OnlinePMCourses.

Di Andrea Di Dio, fa

Primavera P6: ridurre il DB locale PPMDBSQLite per velocizzare l’esecuzione dell’applicazione

Ciao come va? Se sei arrivato fino a qui potresti avere bisogno di velocizzare l’esecuzione dell’applicazione Oracle Primavera P6.
La breve guida è riferita alle installazioni con il DB locale di Primavera PPMDBSQLite.db e alla versione P6 Professional R16.2 (x64) anche se questa procedura può funzionare anche con altre versioni.
Per le problematiche riferite a DB Oracle Server in rete chiedete supporto al vostro amministratore IT.

Veniamo al problema, in pratica per ordine e per velocizzare P6 ho rimosso molti progetti dal Primavera ma la dimensione del DB non è mai diminuita.
Come vedi sotto, nel corso del tempo avevo fatto delle copie de DB e si può vedere come la dimensione sia sempre aumentata, seppure abbia a volte cancellato intere annualità di progetti.
Questo penso che sia il problema per cui quando copio un Progetto, o quando ne importo uno grande il processo di import non mi va mai alla fine, o fallisce oppure devo spegnere il programma e riavviare.

Così come altri database, sqlite non riduce le dimensioni dei datafile automaticamente quando vengono cancellati i dati. Quantomeno non lo fa per default.

Per risolvere il problema prima effettuati una copia di sicurezza de DB stesso, chiudi P6, e poi connettiti al database con la console di amministrazione, ovvero lanciando il comando:

sqlite3 NomeDBnel tuo caso penso sia
sqlite3 PPMDBSQLite.db

Una volta connesso, va lanciato il comando
VACUUM;
che comprime il datafile
Alla fine si esce dalla console con il comando
.q

Purtroppo probabilmente non hai quel comando disponibile sul PC, il comendo sqlite3 deriva da una installazione sqlite stand alone che esula dall’istallazione di primavera P6 che ha il driver del DB già al suo interno.

Per cui ho installato il pacchetto:
sqlite-tools-win32-x86-3290000.zip
(1.71 MiB) A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exeprogram, and the sqlite3_analyzer.exe program.
(sha1: f009ff42b8c22886675005e3e57c94d62bca12b3)

Dal sito
https://www.sqlite.org/download.html

A.C:\Users\ofgod>cd \Users\ofgod\Downloads

C:\Users\ofgod\Downloads>cd sqlite-tools-win32-x86-3290000

C:\Users\ofgod\Downloads\sqlite-tools-win32-x86-3290000>sqlite3.exe \TEMP\PPMDBSQLite.db
SQLite version 3.29.0 2019-07-10 17:32:03
Enter “.help” for usage hints.
sqlite> VACUUM;
sqlite>
sqlite>
sqlite> .q

C:\Users\ofgod\Downloads\sqlite-tools-win32-x86-3290000>

Ora il file è quasi la metà come dimensione e spero siano stati ricostruiti anche gli indici.

Adesso P6 lavora meglio ed è veloce come ala prima installazione vuota dello stesso applicativo.

Buon lavoro, ricorda prima di fare questa operazione esporta e svuota progetti non più recenti da P6,

Chiudi P6

Fai una copia di sicurezza del PMDBSQLite.db

Lancia sqlite3 e poi i comandi interni ricordando il ; dopo lo statemend VACUUM.

Buon lavoro

A.D.D.

Di Andrea Di Dio, fa
it_ITItalian
it_ITItalian en_GBEnglish