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…

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…