Anuj Singh Oracle DBA
Thursday, 15 September 2011
crsctl
›
% crsctl Usage: crsctl check crs - checks the viability of the CRS stack crsctl check cssd - checks the viability of CSS crsctl check crsd -...
Oracle Database rename golbal name
›
col "value" format a33 col "comment" format a70 select NAME,substr(VALUE$,1,70) "value" ,substr(COMMENT$,1,7...
Tuesday, 13 September 2011
Oracle active sql , explain plan ,wait , top sql
›
what sql is currently running Running sql Oracle active sql s.sql set linesize 200 set pagesize 200 column sid format a12 column username fo...
Oracle Used space in Meg by segment type
›
set pagesize 50000 set line 80 col "Total Used Meg" format 999,999,990 col "Data part" format 999,999,990 col "Inde...
Oracle object are accessed
›
col object for A34 col owner for A16 trunc col type for A12 head Obj|type col accessed for 9999 head "Accessed|by # users...
Oracle users' table and index on tablespace
›
set pagesize 60 set echo off spool users_obj_tab.txt column tablespace_name format a20 column owner format a20 column objects format a20 bre...
Oracle table PRIVILEGE info
›
tab_priv.sql TABLE PRIVILEGE TABLE PRIVILEGES tab priv ================================== -- TABLE_PRIVILEGES -- Grants on objects for which...
‹
›
Home
View web version