Pages

▼
Tuesday, December 3, 2024

Create perfstat user, with permissions and jobs

›
======================= Create perfstat user and jobs ======================= set_statspack.sh #!/bin/bash . /etc/sh/orash/oracle_login.sh i...

NLS Settings in SQL Developer

›
NLS Settings in SQL Developer can be out of sync with database defaults. By default,  in SQL Developer,  the NLS Length is set to byte. This...
Thursday, November 21, 2024

How to test a connection to SMTP server

›
CREATE OR REPLACE FUNCTION TEST_SMTP_MAIL RETURN TSTRINGS PIPELINED IS ------------------------------ -- Usage: SELECT column_value as LINE ...
Monday, September 30, 2024

Oracle PL/SQL send mail with attached File using UTL_SMTP

›
CREATE OR REPLACE PROCEDURE send_mail_with_attach_file           (p_from        IN VARCHAR2,            p_to          IN VARCHAR2,          ...
1 comment:
Sunday, September 22, 2024

SYSAUX tablespace is full with Autostats Advisor related objects

›
========== Issue: ========== SYSAUX tablespace is full with Autostats Advisor related objects ========== Solution: ========== Clean up old t...
Monday, September 16, 2024

scp backup files to backup mng server

›
General On oracle server RMAN script running at 03:00 expdp script running at 02:00 scp scripts running at 05:00 and 05:30 On backup server ...
Monday, August 26, 2024

ALTER INDEX REBUILD ONLINE in Partitioned Index

›
ORA-14086: a partitioned index may not be rebuilt as a whole SET LINESIZE 140 COL sql_cmd FOR A120 SET PAGESIZE 0 SET HEADING OFF SET FEEDBA...