e.POWER - FAQ (Frequently Asked Questions)
Northrop Grumman provides a knowledge base of frequently asked questions for the currently supported releases of e.POWER. This set of information is refreshed periodically and is intended to give a technical user advice on the commonly asked questions about the general operation and functionality of the product. While FAQs cannot displace the requisite training in the e.POWER product, they may serve to answer some of the routine issues that occur.
Customers with active maintenance contracts are permitted access to the FAQs by entering a Northrop Grumman supplied password. If you are the primary or secondary technical contact and do not have your current customer password, please submit a request to epowertraining@ngc.com and your password will be returned to you.
FAQ Tip
How do you make your database run more efficiently?
Our e.POWER developers recommend that you optimize your database regularly. Please consult your database administrator (DBA) before implementing any of these recommendations.
Steps for Oracle® Database:
- From the Start menu, find the Oracle program group and run the Enterprise Manager Console.
- Login as the DBA and select your database server. Once you do that, click on Tools, Database Tools, then Analyze.
- The Analyze Wizard will appear. Select Compute Statistics and click Next.
- Highlight and add your database to the list of things to be analyzed and click Finish.
- What you see now, is the analyze script. Click Finish again. Once that's completed, all your data will be populated successfully.
You can check to see if it was completed by going into your e.POWER database and clicking on Tables. If you look to the far right, you'll see a column that has the date and time of your Last Analyzed.
Steps for Microsoft® SQL Server:
- From the Start menu, find SQL Server and run the SQL Server Enterprise Manager.
- Logon as the DBA and right-click on Database Maintenance Plans, Create a New Maintenance Plan. Follow along the wizard by selecting your database.
- Reorganize your data and index pages.
Check for database integrity including the indexes. You should perform these checks before doing any backups.
Optimizing your e.POWER database can make your environment run with a higher efficiency.