how to automate sql script execution

Here are the steps and methods for Oracle batch script file execution1. Create script file (xx.sql):For example, file createtableCreate table tb1 (ID varchar2 (), Name varchar2 (50)); commit;/You can create multiple, but note that you want to end the statement with a semicolon, and note that there are no blank lines in the statement, because when the line is empty, you may get an error in bulk execution.For

=createobject (" ADODB. Connection ") cnn.openstrcnn ' to see if the connection is successful, the success status value is 1 ' msgboxconn.stateifcnn.state=0 then ' msgbox ' connection to database failed ' else ' msgbox ' Connection database succeeded "Endifsetrst=createobject (" ADODB. Recordset ") rst.open" Selectvariable_valuefrominformation_schema. global_statuswherevariable_name= ' slave_running ' ", Cnnstatus=rst (" VARIABLE_VALUE ") .valueifstatusThis article is from the "

Problem Description: Project Feedback The database server's CPU lasts 100%, Tracing the wait events that are found in many active sessions is "Asynch descriptor resize", and these sessions are always in the active state, and the queries executed by these sessions are not complex and feel strange. Review the data for the Oracle Bug 9829397,excessive CPU and many "Asynch descriptor resize" Waits for SQL using Async IO, this bug occurred on 11.2.0.

#!/bin/Bashsource/etc/profileexec $SPARK _home/bin/spark-shell--queue TV--name spark-sql-test--executor-cores8--executor-memory 8g--num-executors8--conf spark.cleaner.ttl=240000Eofimport Org.apache.spark.sql.SaveModesql ("Set Hive.exec.dynamic.partition=true") SQL ("Set Hive.exec.dynamic.partition.mode=nonstrict") SQL ("Use hr")

Label:Little stuff, for database backup. Retained. #!/bin/SHkeepdays= -currenttime=`Date "+%y-%m-%d-%h-%m"' Backpath="/sql_bak/"DbName="Smdb" Echo${currenttime}/usr/bin/mysqldump--default-character-set utf8-u xxx--password=xxx--database ${dbname} >${backpath}${dbname}.${currenttime}.sql; /usr/bin/SCP${backpath}${dbname}.${currenttime}.sql [email protected]1.2.3.4: ${backpath}${dbname}.${currenttime}.

The Linux/unix shell script, such as calling or executing Sql,rman, provides great convenience for automated jobs and multiple iterations, so Oracle is completed through the Linux/unix shellAnd is one of the essential skills of DBAs. This article calls SQL for the Linux/unix shell script, and the Rman

Label:Use Alterdatabase to set a smaller filegrowth or set a new size.Workaround: 1 (the root of the problem)--this method has not been validated. Who weak tried to tell. Thank youI'm actually a database file that timed out when it was added. Instead of flat, the specific SQL statement time-out is often assumed. Set the filegrowth to a lower value, OK everything is restored.The setup of FileGrowth is to set the following window for the properties of t

Label:Modify My.ini (My MySQL installation location is:E:\MySQL\MySQL Server 5.6) log-output=FILE general-log=1 general_log_file= "LvJin.log" The default build log is in the following location: E:\MySQL\MySQL Server 5.6\data\lvjin.log I simply executed a SQL in MySQL. Open the log file as follows: Other versions of the monitoring script log that are circulating on the network are not available for M

By chance, I found that the script was automatically executed. It was amazing that I could execute SQL and console commands. Due to the limited time of research, we know little about it ~~ I 'd like to share with you, haha ~ Dim consoleprocess as new system. Diagnostics. Process Consoleprocess. startinfo. filename = string. Format ("C:/Windows/Microsoft. NET/framework/V {0}/aspnet_regiis.exe", trim (

Label:The person who writes the program often needs to analyze whether the SQL statement that has been written has been optimized, and how fast the server responds, this time it needs to use the statistics state value of SQL to view it. by setting Statistics we can view the system situation when executing SQL. The options are Profile,io, time. Introduced as follo

Label:To test SQL performance:One, by setting statistics to view the system situation when executing SQL. Options: Profile, O, time.SET STATISTICS profile on: Displays the time, in milliseconds, that is required to parse, compile, and execute the query.SET STATISTICS IO on: Reports information about the number of scans per table referenced in the statement, the number of logical reads (pages accessed in the

, Share my knowledge to help others understand the "Execution Plan ". If you like it, you can read it slowly or simulate the experiment below on SQL Server. Start To explain "Table scan", "index scan", "index seek", "clustered index scan", and "clustered index seek" in "display Execution Plan", create a new table first, and add some sample data. The