Dear Readers, In this article we will see Cassandra Introduction. Apache Cassandra one of the Popular NoSQL database. it’s an Highly scalable, Masterless open source NoSQl database. it can suitable for managing the large amounts of structured, semi-structured, and unstructured data across homogeneous nodes. Cassandra… Read More
Hi All, Please click on below link for Cassandra demo. https://vimeo.com/216395411 Please send email to ktexperts@gmail.com for password. All the best.
Setting up glogin.sql : cd $ORACLE_HOME/sqlplus/admin cp glogin.sql glogin.sql.bkp vi glogin.sql SET termout off DEFINE myv = ‘Not connected’ COLUMN myc new_value myv select user || ‘@QA@’ || global_name myc from global_name; SET sqlprompt ‘&myv:SQL> ‘ Execution : $ sqlplus scott/PW SQL*Plus: Release 12.1.0.2.0 Production… Read More
Use this script to setup oramenu:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
#!/bin/bash # set -x # Pawan - www.orskl.com - Setting environmental variables from menu. Date: 27-Mar-2017 # # THIS SCRIPT WILL draw the menu of all available Oracle Instances from /etc/oratab. # It will simplify the way you set environment varaibles. # # Get the list of SID's from /etc/oratab file # Draw the menu # let user select the option # set those environment variables. # if [ -f /etc/oratab ] then echo "Please select your SID to set its environment variables" select sid in `cut -f "1" -d "#" /etc/oratab | awk -F: '{print $1}' | grep -v '^$'` do if [ `echo "X"${sid}` == "X" ] then echo "Invalid selection. Select numbers of respectice SID" break else . /usr/local/bin/oraenv <<< $sid >/dev/null break fi done else echo "Oracle is not installed on this server" fi |
~$ chmod +x oramenu ~$ sudo su – root ~# cp /home/oracle/oramenu /usr/local/bin/ ~# exit logout ~$ . oramenu Or Example : $ chmod +x oramenu oracle@server123:ORCL1:/home/oracle > $ . oramenu Please select your SID to… Read More
Performance issue with particular form in EBS: Its common issue which reports by end user that they have a performance problem with particular form or form is slow responding Have the user show DBA exactly which form runs slow by select Help->Diagnostics->Trace and click in the… Read More
Steps for Update Statement Process in SGA: update processes >update emp set sal=5000 where empno=7903; step 1 when user fires update statement first it will start user processes step 2 user processes to server processes with the help of user processe interface step 3… Read More
Steps for Select Statement Process in SGA : >SELECT * FROM EMP; step 1 when user fires update statement first it will start user processes step 2 user processes to server processes with the help of user processe interface step 3 server processes to… Read More
—– Create user for using EXPDP/IMPDP : create user admin identified by PW; grant connect,resource to admin; grant unlimited tablespace to admin; grant create any view to admin; create or replace directory DBA_EXPORT as ‘/u01/app/oracle/admin/cloud12c/dpdump’ grant write on directory DBA_EXPORT to admin; grant EXP_FULL_DATABASE to… Read More
Checking Default_Temp_Tablespace : col property_name for a35 col property_value for a20 col description for a45 set linesize 300 SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’; Temp tablespace usage : set linesize 300 SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,… Read More
RMAN Backup Size : set linesize 300 SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(instance_name, 17) current_instance FROM v$instance; SET TERMOUT ON; PROMPT PROMPT +————————————————————————+ PROMPT | Report : RMAN Status | PROMPT | Instance : ¤t_instance | PROMPT +————————————————————————+ SET ECHO OFF… Read More
