In the last post about tablespaces (tablespaces free space) I talked about used and free space in permanent and temporary tablespaces. I also included a script to see all the tablespaces with the f… Source: Reducing Tablespace Size
I think SQL Monitoring is an amazing tool when it comes to SQL Tuning but I often find that for one reason or another the report is almost never around for post-mortem investigation. Historical SQL… Source: Top Executions SQL Monitoring style reports in SQLd360
NEW Oracle 11gr2 Feature has “-l” option where database role can be specified while adding the service. This option enables the freedom to start the service if the database role matches with role used to create the service. 1. Create the service resource in primary cluster, for example, add service1 and service2 $ $ORACLE_HOME/bin/srvctl add… Continue reading Adding service in PHYSICAL STANDBY
#!/usr/bin/ksh export ORACLE_HOME=”/u01/oracle/product/11.2.0.3/db” SID=$1 export ORACLE_SID=$SID if [[ $SID = “” ]] then echo “Usage purge_fra.ksh {sid}” fi export ORACLE_SID=$SID if [[ $ORACLE_HOME == “” ]] then echo “Error Oracle Home NOT set” fi SQL=sb_applied_logs.sql RCV=purge_fra_logs.rcv LOG=purge__fra_logs.log echo “” > $LOG echo “set pages 0” > $SQL echo “set lines 132” >> $SQL echo “set… Continue reading Rman Delete archive log at Standby site
LOGDUMP: Step1: —— cd GG_HOME ./logdump Step2: —— ghdr on detail on usertoken on ggstoken on Step3: —— open <Path & filename> (eg. open /home/ggs/dirdat/jd000000) Step 4: —— .Position logdump to desired RBA Logdump > POS rba .Position logdump to first record Logdump > POS FIRST or POS 0 .Use Logdump’s COUNT command to display… Continue reading GG Logdump
Step 1: ——- Info replicat sh ls -ltr <o/p from above output>* Step 2: ——- select BLOCKING_SESSION_STATUS, sql_hash_value, PREV_HASH_VALUE, state, event, saddr, sid,serial#, username,command, status,server,schemaname, process, machine, port,program, sql_id, sql_exec_start,prev_sql_id from gv$session where module like ‘%<replicat>%’; .Use the hash_value and sql_id from above output select sql_text from v$sql where hash_value = &hash_value; select sql_text from… Continue reading Troubleshooting GG Replicat slow
set sqlprompt “_USER’@’_CONNECT_IDENTIFIER _PRIVILEGE> ” in login.sql/glogin.sql
Pre-requisites to configure DGMGRL for standby database: ——————————————————– DG_BROKER_START : Parameter should be set to true for all the databases in configuration. All instances in configuration should be started with SPFILE. Broker Configuration: Config Name: VinDR DB_UNIQUE_NAME Primary: Bank DB_UNIQUE_NAME standby: Bank_DR Protection Mode: Max Performance Steps to configure: Step 1: *$ dgmgrl DGMGRL for… Continue reading DGMGRL
Below Query output gives how far we can restore the statistics in the database SQL> select DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY from dual; GET_STATS_HISTORY_AVAILABILITY ————————————————————————— 13-NOV-15 10.51.37.266819000 PM -08:00 These statistics can also be customized depending on the requirements. SQL> select DBMS_STATS.GET_STATS_HISTORY_RETENTION from dual; GET_STATS_HISTORY_RETENTION ————————— 31 SQL> execute DBMS_STATS.ALTER_STATS_HISTORY_RETENTION (25); PL/SQL procedure successfully completed. SQL> select DBMS_STATS.GET_STATS_HISTORY_RETENTION from… Continue reading Restore statistics to Older time
1. Advanced Index Compression http://docs.oracle.com/database/121/ADMIN/indexes.htm#ADMIN14308 2. Approximate Count Distinct http://docs.oracle.com/database/121/SQLRF/functions013.htm#SQLRF56900 3. Automatic Big Table Caching http://docs.oracle.com/database/121/VLDBG/GUID-A553169D-C6CD-443E-88C3-B746D5E32923.htm#VLDBG14145 4. In-Memory Aggregation 5. In-Memory Column Store http://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN14257 6. Attribute Clustering http://docs.oracle.com/database/121/DWHSG/attcluster.htm#DWHSG8916 7. Full Database Caching http://docs.oracle.com/database/121/TGDBA/tune_buffer_cache.htm#TGDBA95384
vinoracledba.wordpress.com 