WMI Work [ Windows ]

Info Disk

C:\Users\Administrador>wmic LOGICALDISK Get DeviceID,Caption,description,size,freespace
Caption  Description       DeviceID  FreeSpace   Size
C:       Local Fixed Disk  C:        6752161792  21472735232
D:       CD-ROM Disc       D:        0           40814592

Info Disk

C:\Users\Administrador>wmic logicaldisk get Caption, Description, Filesystem
Caption  Description       FileSystem
C:       Local Fixed Disk  NTFS
D:       CD-ROM Disc       CDFS

Info Task Memory

C:\Users\Administrador\Documents\IdaDB>wmic path win32_perfformatteddata_perfproc_process get IOReadOperationsPersec, IOWriteBytesPersec, Name, PercentProcessorTime, PercentUserTime, VirtualBytes, WorkingSet, WorkingSet, WorkingSetPeak, WorkingSetPrivate

Info Task Memory

C:\Users\Administrador\Documents\IdaDB>wmic path win32_perfformatteddata_perfproc_process

Read More

IdaDB for Windows

Modification

1
%s/chomp($date);/chomp($date); $date =\~ s\/\\\/\/\/g;/

2
%s/`date +\\%m\\%d\\%Y`/`echo \%DATE\%`/g

Read More

Windows [ Add Variables PATH ] Oracle

C:\Users\Administrador>sqlplus /nolog
'sqlplus' não é reconhecido como um comando interno
ou externo, um programa operável ou um arquivo em lotes.

C:\Users\Administrador>echo %PATH%
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\strawberry\c\bin;C:\s
trawberry\perl\site\bin;C:\strawberry\perl\bin;C:\Windows\System32\WindowsPowerS
hell\v1.0\

C:\Users\Administrador>set PATH=%PATH%;C:\oraclexe\app\oracle\product\11.2.0\ser
ver\bin

C:\Users\Administrador>echo %PATH%
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\strawberry\c\bin;C:\s
trawberry\perl\site\bin;C:\strawberry\perl\bin;C:\Windows\System32\WindowsPowerS
hell\v1.0\;C:\oraclexe\app\oracle\product\11.2.0\server\bin

C:\Users\Administrador>sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Qua Nov 7 01:27:48 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect sys as sysdba
Informe a senha:
Conectado.
SQL>
SQL>

Read More

Oracle [ ADD USER ]

Create user CommandLine identified by password;

Grant dba to CommandLine;

Read More

Oracle [ Instance idle ]

1 - step

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL>
SQL>
SQL> startup
ORACLE instance started.
SQL> quit


2 - step

SQL> connect sys as sysdba
Enter password:
Connected.
SQL>
SQL> alter system switch logfile;

System altered.

SQL> alter system checkpoint;

System altered.

SQL> quit

Read More

Oracle [ tnsnames.ora ]

File tnsnames.ora

$ORACLE_HOME/network/admin/tnsnames.ora

$tnsping alias_name

$sqlplus system/12345@alias_name_tnsnames.ora

SQL> select * from v$instance;

Read More

Oracle / Linux [ BASH Notify DB ]

[root@localhost notify]# cat notify.sh
sqlplus /nolog << EOF
connect system/12345
@names_sid.sql
quit
EOF

[root@localhost notify]# cat names_sid.sql
spool /home/siltech/name.log
select name from v$database
/
spool off

[root@localhost notify]# cat /home/siltech/name.log

NAME                                                                           
---------                                                                      
XE

Read More