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

  • Think You Know Risk? Top 15 Risk Management Myths Busted
    by Mike Clayton on 5 Giugno 2025 at 4:56

    If you are new to project management, you may come across some of the common risk management myths and not know how to respond. The post Think You Know Risk? Top 15 Risk Management Myths Busted appeared first on OnlinePMCourses.

  • Project Management Intuition: Why is it Essential and How to Strengthen Yours?
    by Mike Clayton on 2 Giugno 2025 at 4:55

    Intuition can cut through complex problems to get quick answers. In this article, learn what it is, why it matters, & how you can develop it. The post Project Management Intuition: Why is it Essential and How to Strengthen Yours? appeared first on OnlinePMCourses.

  • What are Anti-Patterns? And what are some common Project Management Anti-Patterns?
    by Mike Clayton on 29 Maggio 2025 at 5:09

    The term Anti-pattern has come into Project Management from the software engineering world, via the Agile community. But, what does it mean? The post What are Anti-Patterns? And what are some common Project Management Anti-Patterns? appeared first on OnlinePMCourses.

  • Turn Risk into Strength: How to Build a Better Project Risk Culture
    by Mike Clayton on 26 Maggio 2025 at 4:55

    A robust risk culture goes beyond a strong basic risk management process. But the rewards for the extra work are huge. The post Turn Risk into Strength: How to Build a Better Project Risk Culture appeared first on OnlinePMCourses.

  • Managing Portfolios: Steve Jenner on Portfolio Management
    by Mike Clayton on 22 Maggio 2025 at 5:10

    Steve Jenner literally ‘wrote the book’ on Managing Portfolios. He shares his experience and understanding as a Portfolio Management expert. The post Managing Portfolios: Steve Jenner on Portfolio Management appeared first on OnlinePMCourses.

  • Team Member Leaving Your Project? Here’s How to Handle It Smoothly
    by Mike Clayton on 19 Maggio 2025 at 4:55

    You may have to deal with a team member leaving your project. It’s never easy or pleasant. Although, it can sometimes be a bit of a relief! The post Team Member Leaving Your Project? Here’s How to Handle It Smoothly appeared first on OnlinePMCourses.

  • How to Value a Project: 7 Ways to Calculate Project Value
    by Mike Clayton on 15 Maggio 2025 at 4:51

    Value is a crucial concept in Project Management. But there are different ways to calculate it. Let’s look at 7 ways to calculate project value. This video is safe for viewing in the workplace. This is learning, so, sit back and enjoy The Main Ways to Calculate the Value of a Project Simple Value Calculations The post How to Value a Project: 7 Ways to Calculate Project Value appeared first on OnlinePMCourses.

  • Project Management Job: How to Start Your Career with Your First PM Job
    by Mike Clayton on 12 Maggio 2025 at 4:55

    Getting a Project Management job is a ‘chicken and egg’ problem. Mike Clayton shows you how to break the cycle and get your first PM role. The post Project Management Job: How to Start Your Career with Your First PM Job appeared first on OnlinePMCourses.

  • Top 10 Best Change Management Books
    by Mike Clayton on 8 Maggio 2025 at 4:05

    In this video, I have sifted my Change Management library for my top 10 best change management book recommendations. Let me know yours, in the comments.ext This video is safe for viewing in the workplace. This is learning, so, sit back and enjoy Recommended Change Management Books What Kit does a Project Manager Need? I The post Top 10 Best Change Management Books appeared first on OnlinePMCourses.

  • 4 Ways Personal Leadership Can Get You Better Project Results
    by Mike Clayton on 5 Maggio 2025 at 4:55

    What is it that makes people willing to follow you? This article is all about Personal Leadership. It’s what inspires people day-by-day. The post 4 Ways Personal Leadership Can Get You Better Project 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