My Own DBA Experience

Index Re-building.. ALTER INDEX <IDX_NAME> REBUILD ONLINE; If your issue is its huge table and it might take more time to execute then you can use Parallel execution method. 1. Take your session in Parallel DML mode. ALTER SESSION ENABLE PARALLEL DML; 2. Take your table in Parallel Mode ALTER TABLE <TABLE_NAME> PARALLEL; 3. Run Rebuild Index command. ALTER INDEX <IDX_NAME> REBUILD ONLINE; 4.  Take your session back to normal mode. ALTER SESSION DISABLE PARALLEL DML; That is it !!!

Startup Issue...  Recent when I had to start my database...    When I give Startup to an existing database it is giving me this error which I have never come across please help.. here is the complete steps export ORACLE_SID=oracle [oracle@localhost oracle]$ sqlplus sys as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue May 6 15:57:07 2014 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Enter password: Connected to an idle instance. SQL> startup   ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpsemsper SQL> startup ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpsemsper So here the e...