Database

Query to find and remove Oracle database locks

Query to find and remove Oracle database locksOracle database locksoracle lock tableblocking session in oracleoracle deadlockoracle lockoracle locked objectsquery to check locks in oracle databaseoracle table lock queryoracle show locksfind blocking session in oracleoracle db lockoracle check locksquery to find locked objects in oracleoracle check table lockHow to find the Oracle database locksHow to remove …

Query to find and remove Oracle database locks Read More »

PL-SQL Procedure to send email with attachment

PL-SQL Procedure to send email with attachmentHow to send email using plsqlHow to send email with attachment using plsqloracle send email from databaseoracle send email with attachment utl_smtp 1.  Compile the below procedure XXSEND_EMAIL in the database 2.  Call the procedure with below anonymous block Please note that the Workflow mailer should be up and running …

PL-SQL Procedure to send email with attachment Read More »

Query to get the details of the lock in the database

Query to get the details of the lock in the databaseHow to find database locksOracle Apps EBS database locks Arista Vault Shuddhi Basket Multipurpose... 3.5 out of 5 stars(34) (as of November 29, 2023 01:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. …

Query to get the details of the lock in the database Read More »

Query to find Table size

Query to find Table sizeOracle apps EBS table size Samsung Galaxy M13 (Stardust Brown, 4GB,... 4.1 out of 5 stars(29510) ₹8,199.00 (as of November 29, 2023 01:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant …

Query to find Table size Read More »