[ADVICE] Free Windows Disk Defragmenter Alternative

I strongly recommend to use Smart Defrag tool instead of classical Windows Defragmenter tool.

How to check NTFS file system in CMD?

Only you need to run this command.

e.g. chkntfs C:

C:\Windows\system32>chkntfs C:
The type of the file system is NTFS.
C: is not dirty.

How to defrag disk partiton in CMD?

Only you need to run this command as Administrator.

e.g. defrag C:

How to change font color in CMD?

Only you need to run this command in cmd.

e.g. color A

0 = Black
1 = Blue
2 = Green
3 = Aqua
4 = Red
5 = Purple
6 = Yellow
7 = White
8 = Gray
9 = Light Blue
A = Light Green
B = Light Aqua
C = Light Red
D = Light Purple
E = Light Yellow
F = Bright White

How to define a tablespace in Windows?

Please execute the commands as "sys";

To define the tablespace:
SQL> CREATE TABLESPACE ALPER_DATA 
DATAFILE 'C:\tablespaces\data_01.dbf' SIZE 128M

To alter the tablespace:
SQL> ALTER TABLESPACE ALPER_DATA ADD DATAFILE 'C:\tablespaces\data_new_02.dbf' size 128m;

To drop the datafile from the tablespace:
SQL> ALTER TABLESPACE ALPER_DATA DROP DATAFILE 'C:\tablespaces\data_new_02.dbf';

To drop the tablespace:
SQL> DROP TABLESPACE ALPER_DATA 
INCLUDING CONTENTS AND DATAFILES;

To check tablespace's database files:
SQL> SELECT NAME, FILE#, STATUS FROM V$DATAFILE;

Used Oracle Version and OS: Oracle XE and Win7

How to prepare a video with steps via windows tool?

Please you run this command first in cmd.

CMD> psr

Then you can record the steps by clicking start record.

After finish your video, you are able to check .mht file by extracting zip file.

How to know hostname from IP in Command Prompt?

Press Windows button + R and press cmd then click "OK".
Then, write down "below command" and press enter

nbtstat -a <IP>
e.g. nbtstat -a 10.10.10.10

How to delete linux user?

# sudo userdel -r alper

-r -> Remove home directory and mail spool

How to run sql query in shell script?

Please add these codes into your .sh file then you can run .sh file

e.g. 
ssh -q -T oracle@192.168.2.2 << EOF
sqlplus / as sysdba << EOFSQL
drop user ALPER_DB_USER cascade;
exit;
EOFSQL
EOF

How to know file format description in CMD?

Please you run this command in CMD.

e.g. assoc .rar
.rar=WinRAR

e.g. assoc .txt
.txt=txtfile

What are testing types and methods?

There are two test methods which are Black Box Testing and White Box Testing

Basically, there are two test types which are Functional and Non-functional.

For example, White & Black Box (Mostly), Unit, Interface & Usability, System, Regression and User Acceptance testing are Functional testing types.

Likewise, Load & Performance, Stress, Installation and Compatibility & Migration testing are Non-functional testing types.

White & Black Box Testing

White Box Testing (we know codes and are able to debug testing in codes)

Black Box Testing (we do not know codes and act as a customer)

Black Box Testing Types & Methods

• Equivalence partitioning (keyword is clustering)
• Boundary Value Analysis (keyword is looking boundary conditions)
• Cause Effect Graphing (keyword is causes -> intermediate nodes -> effects and reduced decision table)

What is the goal of testing?

The goal of testing is to reach minimum bug number and using time effectively as person/day.

What are Verification and Validation in software world?

Verification is that the process of evaluating work-products (not the actual final product) of a development phase to determine whether they meet the specified requirements for that phase.

Activity of Verification: Reviews, Walkthroughs and Inspections

Question: Are we building the product right?

Validation is that the process of evaluating software during or at the end of the development process to determine whether it satisfies specified business requirements.

Activity of Validation: Testing

Question: Are we building the right product?

Ref: http://softwaretestingfundamentals.com/verification-vs-validation/

How to know SuSE release version?

Only run this command in terminal;

$ cat /etc/SuSE-release
or
$ cat -n /etc/SuSE-release
(-n) to see rows numbers as well

How to define and drop temporary tablespace?

Please execute the commands as "sys";

SQL> CREATE TEMPORARY TABLESPACE ALPER_TS_TEMP TEMPFILE 
 'C:\tablespaces\data_01.dbf' 
 SIZE 8000M 
 AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

To alter the tablespace:
SQL> ALTER TABLESPACE ALPER_TS_TEMP ADD TEMPFILE 'C:\tablespaces\data_temp_new_02.dbf' size 128m;

To drop the tablespace:
SQL> DROP TABLESPACE ALPER_TS_TEMP INCLUDING CONTENTS AND DATAFILES;

Used Oracle Version and OS: Oracle XE and Win7

Ref: http://onlineappsdba.com/index.php/2008/02/08/tablespace-and-datafiles-in-oracle-database-back-to-basics/

How to run .sql file in sqlplus?

Press Windows button + R and press cmd then click "OK".

Write down "below command" and press enter

Full path approach
echo exit | sqlplus hr/hr @C:\sql\example.sql

Oracle path approach
echo exit | sqlplus hr/hr @?/example.sql
? -> $ORACLE_HOME

Example sql: select * from employees;
Used Oracle Version and OS: Oracle XE and Win7

How to change a specified string inside all files by recursively?

Only run this command in terminal;

$ find . -type f -exec sed -i 's/'old'/'new'/g' {} \;

You can also use escape character to use '/'.

$ find . -type f -exec sed -i 's/'\\/old'/'\\/new'/g' {} \;
(\\ -> escape characters)

How to connect into RMAN tool in Windows?

Press Windows button + R and press cmd then click "OK".
Write down "rman" and press enter

Lastly run that command to connect environment.

RMAN> connect target /

connected to target database: XE (DBID=2732638794)

How to login Windows machine with RDP (mstsc) even though firewall is active?

Please follow the instructions to use mstsc tool for Windows machines.

Press Windows key -> Right-clicking on Computer and select Properties -> Click Remote settings -> Enable Remote connections options -> You can connect with mstsc now!

How to clear screen in sqlplus?

SQL> clear screen;