Mithilesh Jambhulkar ORACLE dba

ORACLE_GRID_INSTALLATION FOR STANDALONE SERVER server ip = 10.65.127.37 LINUX Step 1: Download Oracle Software for grid 12c Download and unzip the software Step 2: check Memory, Swap & kernel [root@localhost ~]# grep MemTotal /proc/meminfo MemTotal: 2075468 kB Memory Min : 1.5 GB need. [root@localhost ~]# grep SwapTotal /proc/meminfo SwapTotal: 4128760 kB [root@localhost ~]# df -h /tmp Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 21G 4.4G 15G 23% / [root@localhost ~]# gedit /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default=4194304 net.core.rmem_max=4194304 net.core.wmem_default=1048576 net.core.wmem_max=1048576 [root@localhost ~]#/sbin/sysctl -p [root@localhost ~]...

Difference between Syntax and Runtime errors in PL/SQL?? Explain what is COMMIT, ROLLBACK and SAVEPOINT?? How many types of Triggers are there in PL/SQL and what are they? How to generate Debugging Information in PL/SQL? In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented? Name any 5 PL/SQL exception types What are the two different types of Exceptions in PL/SQL? What is IN parameter and OUT parameter in PLSQL? What is Public and Private Procedures in PL/SQL? What is Referential Integrity? What is SQLCODE and SQLERRM in PL/SQL? What is the difference between CASE and DECODE? What is the difference between VARCHAR and VARCHAR2 in PL/SQL? What is %TYPE and %ROWTYPE in PL/SQL?? What is the disadvantage of using %ROWTYPE in PL/SQL? What are the advantages of using %TYPE and $ROWTYPE in PL/SQL? List all different types of Data Types in PL/SQL? What is the difference between Views and Materialized Views in Oracle? What is difference bet...

run  { crosscheck archivelog all; delete noprompt expireD archivelog all; }         col current_scn form 999999999999999999 col TIMESTAMP_TO_SCN form 9999999999999999 col NOW10G form 99999999999999999999 col NOW9I form 99999999999999999999 col SCN form 99999999999999999999 col TIMESTAMP form 99999999999999999999                           **************FOR  SQL PLAN *************** select * from table(dbms_xplan.display_awr('&sql_id')); col begin_interval_time for a30 break on plan_hash_value on startup_time skip 1 select ss.snap_id, ss.instance_number node, begin_interval_time, s.sql_id, s.plan_hash_value, nvl(executions_delta,0) execs, (elapsed_time_delta/decode(nvl(executions_delta,0),0,1,executions_delta))/1000000 avg_etime, (buffer_gets_delta/decode(nvl(buffer_gets_delta,0),0,1,executions_delta)) avg_lio, (rows_processed_delta/decode(nvl...