Articoli

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

  • Mastering Project Closure Report: What You NEED in Your Final Doc
    by Mike Clayton on 30 Ottobre 2025 at 5:53

    I walk you through every critical component of a robust Project Closure Report, ensuring you wrap up every project properly. The post Mastering Project Closure Report: What You NEED in Your Final Doc appeared first on OnlinePMCourses.

  • Do you Know the 7 Habits of Successful Project Managers?
    by Mike Clayton on 27 Ottobre 2025 at 5:51

    You’ve probably heard of Stephen Covey’s bestseller, The 7 Habits of Highly Effective People. What about Highly Successful Project Managers? The post Do you Know the 7 Habits of Successful Project Managers? appeared first on OnlinePMCourses.

  • Is PMI-RMP Worth it? Top 10 Things to Know about it.
    by Mike Clayton on 23 Ottobre 2025 at 4:55

    PMI Risk Management Professional (PMI-RMP) is PMI’s certification for Risk Management. They designed it to offer a professional credential for project risk managers. For an in-depth discussion about the PMI-RMP certification and how to prepare for it: PMI-RMP: PMI’s Risk Management Professional Certification – with Harry Hall Take a look at my recommended PMI-RMP course. The post Is PMI-RMP Worth it? Top 10 Things to Know about it. appeared first on OnlinePMCourses.

  • Win Team Commitment on Your Project: Top 10 Ways
    by Mike Clayton on 20 Ottobre 2025 at 4:54

    If you want to supercharge your project team, you must win their commitment. It’s easy to spot: hard to do. Here are my top 10 strategies. The post Win Team Commitment on Your Project: Top 10 Ways appeared first on OnlinePMCourses.

  • Continuous Delivery Explained: Faster, Safer Software Releases
    by Mike Clayton on 16 Ottobre 2025 at 4:55

    What is continuous delivery, and how does it relate to project managers? In this video, we’re demystifying Continuous Delivery (CD). The post Continuous Delivery Explained: Faster, Safer Software Releases appeared first on OnlinePMCourses.

  • Things Go Wrong: Do You Know the Best Way to Handle Setbacks?
    by Mike Clayton on 13 Ottobre 2025 at 4:55

    Things go wrong. These setbacks can leave us feeling out of control and stressed. Do you know what to do, to handle it? The post Things Go Wrong: Do You Know the Best Way to Handle Setbacks? appeared first on OnlinePMCourses.

  • Stop Wasting Time: James Garner Demos Agentic AI for PMs ⏱️
    by Mike Clayton on 9 Ottobre 2025 at 4:55

    Agentic AI is astonishing. James Garner demonstrates what it can do for project management with just a few prompts. The post Stop Wasting Time: James Garner Demos Agentic AI for PMs ⏱️ appeared first on OnlinePMCourses.

  • Alpha Project Managers: What Makes Some PMs the Very Best?
    by Mike Clayton on 6 Ottobre 2025 at 4:55

    ‘Alpha Project Managers: What the Top 2% Know that Everyone Else Does Not’ is a far better book than I had expected. The post Alpha Project Managers: What Makes Some PMs the Very Best? appeared first on OnlinePMCourses.

  • How to Do a Training Needs Analysis: The Ultimate Guide
    by Mike Clayton on 2 Ottobre 2025 at 4:55

    How do you assess what training is needed, and how best to deliver it? That’s the objective of TNA: Training Needs Analysis. The post How to Do a Training Needs Analysis: The Ultimate Guide appeared first on OnlinePMCourses.

  • Use Soft Power: How to Improve your Project Management Negotiation
    by Mike Clayton on 29 Settembre 2025 at 4:55

    Hard and economic power are familiar. But how can you get people to do what you want, without incentives, sanctions, or coercion? Soft Power. The post Use Soft Power: How to Improve your Project Management Negotiation 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