Index failed to create with ORA-01450

Index failed to create with ORA-01450 Trying to create an Index when the tablespace is of 8k block size SQL> CREATE   INDEX PSOPSPMTRANSHIST ON PSPMTRANSHIST (PM_TRANS_DEFN_ID,    PM_CONTEXT_VALUE1,    PM_CONTEXT_VALUE2,    PM_METRIC_VALUE1,    PM_METRIC_VALUE7,    PM_AGENT_STRT_DTTM) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING; CREATE   INDEX PSOPSPMTRANSHIST ON PSPMTRANSHIST (PM_TRANS_DEFN_ID,    PM_CONTEXT_VALUE1,    PM_CONTEXT_VALUE2,    PM_METRIC_VALUE1,…

Snapshot Workload Repository & Retention

Snapshot Workload Repository & Retention DBA_HIST_SNAPSHOT displays information about the snapshots in the Workload Repository. It results Snapshots for each instance Time at the beginning of the snapshot interval, Time at the end of the snapshot interval, Startup time of the instance, Snapshot level, Number of errors occurring in the tables for the particular snapshots.…

UNNAMED file in standby after adding new file to primary – ORA-01111, ORA-01110, ORA-01157

How to resolve ORA-01111, ORA-01110, ORA-01157 There are many reasons for a file being created as UNNAMED or MISSING in the standby database, including insufficient disk space on standby site (or) Improper parameter settings related to file management. STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management. When automatic standby file management is enabled, operating system…

Tracking Alert Log file by x$dbgalertext

Instead of reviewing whole alert log file for any Particular information, We can search using that key word from X$DBGALERTEXT Table. Grep The word “Starting Up” of Alert log file from Instance. col ORIGINATING_TIMESTAMP for a40 col MESSAGE_TEXT for a80 set linesize 500 SELECT originating_timestamp, message_text FROM sys.x$dbgalertext WHERE message_text LIKE ‘%Starting up%’;   Grep…

User Administration scripts

User session Monitor from Shell Script [oracle@superlinux ~]$ cat  user_session_monitor.sh #!/bin/sh if [ $# -ne 1 ] then echo “Usage: $0 pass the pid” exit 1 fi HOSTNAME=`hostname` U=$1 export U sqlplus -s “/ as sysdba” << EOI set linesize 500 col hostname for a15 col program for a15 col username for a15 col osuser…