SHELL Script Looping
For Loop
for a in seq 1 1 10
do
echo "$a"
done
While Loop
a=0
while [ $a -lt 5 ]
do
echo "$a"
a=expr $a + 1
done
Until
a=10
while [ $a -lt 5 ]
do
echo "$a"
a=expr $a - 1
done
Oracle Database 19C Performance Tunning - PART 1
Advantages: 1. Improved Query Performance • Optimized SQL execution plans lead to faster query response times. • Reduces unnecessary full table scans and improves indexing strategies. • Parallel execution tuning speeds up large data processing tasks. 2. Better Resource Utilization • Efficient use of CPU, memory, disk I/O, and network resources. • Reduces contention on Redo Logs, Undo Tablespaces, and Buffer Cache. • Helps in load balancing across multiple instances in RAC (Real Application Clusters). 3. Increased System Scalability • Ensures that the database can handle a growing number of users and transactions. • Proper tuning allows scaling without degrading performance. • Optimized parallel processing ensures better performance on multi-core servers. 4. Lower Infrastructure Costs • Reduces the need for add...
