Ameer Khan

mysql> SELECT    ->     CONCAT(FORMAT(DAT/POWER(1024,pw1),2),’ ‘,SUBSTR(units,pw1*2+1,2)) DATSIZE,    ->     CONCAT(FORMAT(NDX/POWER(1024,pw2),2),’ ‘,SUBSTR(units,pw2*2+1,2)) NDXSIZE,    ->     CONCAT(FORMAT(TBL/POWER(1024,pw3),2),’ ‘,SUBSTR(units,pw3*2+1,2)) TBLSIZE    -> FROM    -> (    ->     SELECT DAT,NDX,TBL,IF(px>4,4,px) pw1,IF(py>4,4,py) pw2,IF(pz>4,4,pz) pw3    ->     FROM    ->     (    ->         SELECT… Continue Reading

Q. What is the difference between a physical and logical standby database ? Ans. 1.A physical standby database is a block-for-block identical copy of the primary database because it is kept in sync with the primary database by using media recovery to apply redo that was generated on the primary database. Instead a logical standby database… Continue Reading

— Number of users and CPU/ProcessorsSQL> select L.SESSIONS_MAX, L.SESSIONS_WARNING, L.SESSIONS_CURRENT,  2  L.SESSIONS_HIGHWATER,  3  L.USERS_MAX, L.CPU_COUNT_CURRENT, L.CPU_SOCKET_COUNT_CURRENT,  4  L.CPU_COUNT_HIGHWATER,  5  L.CPU_CORE_COUNT_CURRENT, L.CPU_CORE_COUNT_HIGHWATER,  6  L.CPU_SOCKET_COUNT_HIGHWATER  7  from v$license l;SQL> set linesize 300SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER  USERS_MAX CPU_COUNT_CURRENT CPU_SOCKET_COUNT_CURRENT CPU_COUNT_HIGHWATER CPU_CORE_COUNT_CURRENT CPU_CORE_COUNT_HIGHWATER CPU_SOCKET_COUNT_HIGHWATER———— —————- —————- —————— ———- —————– ———————— ——————- ———————- ———————— ————————–           0… Continue Reading

Oracle Version :- 11g SQL> select value from v$parameter where upper(name)=’MEMORY_TARGET’; VALUE——————————————————————————–415236096 SQL> select value/1024/1024 mb  2  from v$parameter where upper(name) = ‘SGA_MAX_SIZE’;         MB———-       396 — size taken by a memory componentSQL> select pool, round(sum(BYTES)/1024/1024) MB  2  from V$SGASTAT  3  group by pool; POOL          … Continue Reading

Step 1: Save the Repo File for The MySql 5.7 or Install the RPM for Mysql 5.7 [root@server1 ~]# vi /etc/yum.repos.d/mysql-community.repo [mysql57-community]name=MySQL 5.7 Community Serverbaseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/enabled=1gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql — save n quit (:wq) — or, For RHEL/CentOS 7[root@server1 ~]# wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm[root@server1 ~]# yum localinstall mysql57-community-release-el7-7.noarch.rpm For RHEL/CentOS 6[root@server1 ~]# wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm[root@server1 ~]# yum localinstall mysql57-community-release-el6-7.noarch.rpm Step 2: Install… Continue Reading

Create the following backup path:-[oracle@server1 ~]$ mkdir -p /u01/backups/rman_backup/full_backup[oracle@server1 ~]$ mkdir -p /u01/backups/scripts/ Make sure database is in archivelog mode , if its not put it on archivelog mode. SQL> sqlplus / as sysdbaSQL> startup mount;SQL> alter database archivelog;SQL> alter database open; [oracle@server1 ~]$ vi  /u01/backups/scripts/full_backup.sh #!/bin/bashexport ORACLE_SID=orclexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export LD_LIBRARY_PATH=$ORACLE_HOME/libexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binexport path1=/u01/backups/rman_backup/full_backupdate1=`date +%d%m%y_%H%M%S`mkdir $path1/$date1chown oracle:oinstall -R… Continue Reading

Version:- Oracle 11gAll the below scripts are stored and will run from oracle user & from Primary Database. [oracle@server1 ~]$ vi /home/oracle/dg.sqlSet linesize 222SELECT DB_NAME, HOSTNAME, LOG_ARCHIVED, LOG_APPLIED,APPLIED_TIME,LOG_ARCHIVED-LOG_APPLIED LOG_GAPFROM(SELECT NAME DB_NAME FROM V$DATABASE),(SELECT UPPER(SUBSTR(HOST_NAME,1,(DECODE(INSTR(HOST_NAME,’.’),0,LENGTH(HOST_NAME),(INSTR(HOST_NAME,’.’)-1))))) HOSTNAME FROM V$INSTANCE),(SELECT MAX(SEQUENCE#) LOG_ARCHIVED FROM V$ARCHIVED_LOG WHERE DEST_ID=1 AND ARCHIVED=’YES’ ),(SELECT MAX(SEQUENCE#) LOG_APPLIED FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND APPLIED=’YES’ ),(SELECT… Continue Reading

Oracle Version: 11g SQL> set linesize 250SQL> select * from V$LOG;     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME———- ———- ———- ———- ———- ———- — —————- ————- ——— ———— ———         1          1  … Continue Reading

mysql> SELECT CONCAT(table_schema, ‘.’, table_name),    ->        CONCAT(ROUND(table_rows / 1000000, 2), ‘M’)                                    rows,    ->        CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), ‘G’)            … Continue Reading

SQL> select username, account_status from dba_users where lock_date is not null; USERNAME                       ACCOUNT_STATUS—————————— ——————————–FLOWS_FILES                    EXPIRED & LOCKEDMDSYS                          EXPIRED & LOCKEDORDSYS      … Continue Reading