Create a historical query server's physical view environment in the customer from home to Kunming this afternoon.
The database is already installed, the server is Windows 2000 Advanced Server
Someone told me that the database is installed by default.
Need to adjust the configuration of the initialization parameter file today
56K MODEM dials, only 33K connection speed
Using PCAnywhere under this speed is a nightmare
But you must know that hardware configuration can adjust some parameters in the initialization file.
For example, the memory size of each part of SGA
At this time, I can't help but I will knock a few words in Unix, I will know the scene of all the results.
However, in Windows, I don't know how to configure the machine in addition to right-click my computer.
So I went to the Internet, actually
Here is the command to introduce today: msinfo32.exe
Msinfo32.exe is launched after Windows2000, replacing the previous WinMsd.exe command.
If you do not add any parameter input, the execution result of MSINFO32 is still displayed in a GUI window. Fortunately, Msinfo32 provides parameters that allows us to output the results into a text file, and then open this text file.
The Msinfo32.exe program is located in the
The command to get the system configuration information is as follows:
C: / Program Files / Common Files / Microsoft Shared / Msinfo / Msinfo32 / Report D: /Temp/info.txt / Categories Systemsummary
The generated info.txt file, view with Type, the result is as follows:
TYPE D: /TEMP/INFO.TXT
System Information Report Written at: 09/18/04 19: 02: 14xystem name: lyzhang [system summary]
Item ValueOS Name Microsoft Windows XP ProfessionalVersion 5.1.2600 Service Pack 2 Build 2600OS Manufacturer Microsoft CorporationSystem Name LYZHANGSystem Manufacturer IBMSystem Model 0123456System Type X86-based PCProcessor x86 Family 6 Model 9 Stepping 5 GenuineIntel ~ 1495 MhzBIOS Version / Date IBM 1RETD4WW (3.08a), 2004-8-5SMBIOS Version 2.33Windows Directory C: / wINDOWSSystem Directory C: / WINDOWS / system32Boot Device / Device / HarddiskVolume1Locale People's Republic of ChinaHardware Abstraction Layer Version = "5.1.2600.2180 (xpsp_sp2_rtm.040803-2158)" User Name LYZHANG / KamusTime Zone China Standard TimeTotal Physical Memory 1,024.00 MBAvailable Physical Memory 455.49 MBTotal Virtual Memory 2.00 GBAvailable Virtual Memory 1.90 GBPage File Space 2.40 GBPage File C: the results we want /pagefile.sys format though some confusion, but we can still get.
The above results are my notebook, the CPU and memory configuration are as follows:
Processor X86 Family 6 Model 9 Stepping 5 Genuineintel ~ 1495 MHz
Total Physical Memory 1,024.00 MB
That is, this machine is CENTRINO 1.5G CPU, 1G physical memory.
Other parameters of msinfo32.exe introduce the link below:
Http://support.microsoft.com/default.aspx?scid=kb;zh-cn;255713