We have studied the CLI for both Windows and Linux The real

We have studied the CLI for both Windows and Linux. The real power in using commands comes with scripting. What are some repetitive tasks you can think of that could be done more easily with a well-written script?

Solution

From past 3 decades the information techology made a huge revolution in the world,now we are entering into big data phase ,Internet of Things etc,all these techniques like big data ,or creating connection to the devices(iot) are nothing refining the data into required necessary data.

To achieve all these analytics we need one tool,that tool is nothing but coding or a well written script.

coding made the connection with device,communication,faster communication,wireless communication etc.we can do a lot of tasks using code,ofcourse we can do all the tasks efficiently and quickly using coding.

Repetitive tasks using coding are multitasking,automation,database management,diagnostics and troubleshooting,testing,patches management.

The most repetitive task is Database management and automation,and testing.

Patch management the Independent Oracle User\'s Group found that only one in six DBAs are patching databases manually. Yet you can develop patch plans, which allows patches to be applied with a single period of downtime. Automate patch validation to handle conflict checking, so that you can have it all ready for an automated patch rollout process at the end.

Testing Don\'t restrict yourself to testing patches. Compiling and running test scripts on non-production systems to validate schema changes can save valuable time.

Configuration changes Planned configuration changes ideally start in non-production databases. You can use your automation scripts to capture changes in baseline configurations, and to prepare the SQL for updating the schema on your production database.

Database provisioning 18 per cent of respondents to that survey said that they deploy databases quickly, but that it is done manually most of the time, shackling them to the \'urgent\' quadrants. Almost half of all DBAs say that they only provision databases automatically some of the time, or not at all. You can automate this process using a mixture of techniques, such as database cloning via RMAN, data masking, and the creation of databases from templates.

Automated monitoring Using Adaptive Thresholds to alert DBAs when key activity moves outside a certain range stops you having to check for disasters. And schema change detection can let you know automatically when a schema has been altered, which could have ramifications for the database.

Just as you use automated scripts to monitor configuration changes on non-production databases, you can employ them to watch your production environments, helping you to keep track of configuration creep.

Diagnostics and troubleshooting Configuration issues can often be resolved automatically, but a little more than half of all DBAs are still poring through database statistics and schemas manually for troubleshooting purposes.

Log management Scripts to search for telltale problems in the logs can save you precious time poring through the entries yourself.