Project Management
Notizie sulla certificazione PMP
OnlinePMCourses Online Project Management Video Courses to Build Your Project Career
- Can AI Really Write Your User Requirements?by Mike Clayton on 25 April 2024 at 4:55
Artificial Intelligence (AI) in Project Management continues to grow. Can we use it to write User Requirements, in Project Definition? The post Can AI Really Write Your User Requirements? appeared first on OnlinePMCourses.
- Cross-Cultural Leadership: What Does it Mean for Project Managers?by Samad Aidane on 22 April 2024 at 4:55
One of the big challenges for Project Managers is a team of people from different cultures. What is the science of cross-cultural leadership? The post Cross-Cultural Leadership: What Does it Mean for Project Managers? appeared first on OnlinePMCourses.
- What’s the Difference: Risk Appetite – Risk Tolerance – Risk Capacity?by Mike Clayton on 18 April 2024 at 4:55
How much risk will your project take on? There are 3 similar measures. What’s the difference: Risk Tolerance, Risk Appetite, & Risk Capacity? The post What’s the Difference: Risk Appetite – Risk Tolerance – Risk Capacity? appeared first on OnlinePMCourses.
- New Project Manager? 6 Parts to My Most Important Adviceby Mike Clayton on 15 April 2024 at 4:55
Congratulations! You’re a New Project Manager. Let’s take a moment to go through my most important advice. I’ve divided it into six areas. The post New Project Manager? 6 Parts to My Most Important Advice appeared first on OnlinePMCourses.
- What is Expected Monetary Value? (EMV)by Mike Clayton on 11 April 2024 at 4:55
In this video, I answer the question, what is Expected Monetary Value, EMV? And we look at its use in risk management and decision theory. The post What is Expected Monetary Value? (EMV) appeared first on OnlinePMCourses.
- Risky Analysis: Pitfalls and Good Practices in Estimating Likelihoodby Mike Clayton on 8 April 2024 at 4:55
Basic risk analysis is easy to understand. But there’s one pitfall that too many Project Managers fail to avoid: estimating likelihood. The post Risky Analysis: Pitfalls and Good Practices in Estimating Likelihood appeared first on OnlinePMCourses.
- My Top 10 Project Management YouTube Channel Recommendations for 2024by Mike Clayton on 4 April 2024 at 4:55
I’ll assume you like Project Management videos. So, If you want to expand your repertoire of channels, here’s my top 10 list for 2024. The post My Top 10 Project Management YouTube Channel Recommendations for 2024 appeared first on OnlinePMCourses.
- Change Control 101 – Your Guide to Project Change Controlby Mike Clayton on 28 March 2024 at 5:55
When your project is going well, but a stakeholder changes their mind, this is a job for Project Change Control. The post Change Control 101 – Your Guide to Project Change Control appeared first on OnlinePMCourses.
- Work Breakdown Structure: How to Build One Effortlessly with a Mind Mapby Mike Clayton on 25 March 2024 at 5:55
A Work Breakdown Structure (WBS) is a hugely valuable Project Management tool. Make it easy for yourself. Create your WBS with a Mind Map. The post Work Breakdown Structure: How to Build One Effortlessly with a Mind Map appeared first on OnlinePMCourses.
- What’s the Difference between PERT and CPM?by Mike Clayton on 21 March 2024 at 5:55
PERT and CPM are two forms of Network Chart that are represented differently, and take different approaches to calculating schedules. The post What’s the Difference between PERT and CPM? appeared first on OnlinePMCourses.
Articoli Project Management
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 NomeDB
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.
Devi effettuare l'accesso per postare un commento.