How to find the version of MySQL you are running.
Month: August 2017
Command Line Connection with MYSQL
If you are wanting to connect to a remote database using the command line with MySQL, you first need to download the MYSQL client available here Open a DOS shell and run the following: Then run your query
Lambda Function in Aurora
How to create a lambda function to insert some records in an Aurora Database in AWS. Here is some sample code. This will enable us to link to databases in AWS to perform some functions. You also need to create a configuration file that contains the user name, password and database name You…
What is using TEMP
We need to resize temp, but trying to resize hangs. Lets see what is using TEMP DBSNMP 1715 99 myhost 1 TEMP2 You can either wait for the sessions to complete or in my case, it was the agent that was accessing it so we can kill it.
How to resize Undo
You can shrink the datafile of the UNDO tablespace on the primary database to 1G by using the following command: ASM needs the correct ASM filename. The undo datafile on the standby database will be automatically resized as well. If you get the following error: ORA-03297: file contains used data beyond requested RESIZE value…
Protected: How to calculate radius with MySQL
There is no excerpt because this is a protected post.
What is using TEMP tablespace
Find the sessions using the default temporary tablespace.
How to Create an Oracle SQL TUNING TASK manually with the SQL_ID
Step 1: Get the sql_id of the oracle session you would like to tune. There are a number of ways to get this, this is probably the easiest. Step 2: Create the tuning task by using the SQL identified from. We can also increase the time to avoid “Error: ORA-13639: The current operation was…
Kill user sessions in RAC 10g
Goal The 10g version of Oracle RAC only allows ALTER SYSTEM KILL SESSION (SID,SERIAL#); as a local session on a local node. To kill from one node sessions across multiple nodes the following script has been created… – This takes the schema/user name and will loop through all sessions for this user in gv$sessions…
Recover from missing UNDO Tablespace
Step 1. Symptoms when trying to drop a undo tablespace Step 2. File which rollback segments to remove Step 3. Create a pfile from spfile and modify the contents