<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>expertDBA.com</title>
	<link>http://expertdba.com/blog</link>
	<description>A Database Administration Blog</description>
	<lastBuildDate>Fri, 18 Dec 2009 06:15:07 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>ASM Hands-On Training</title>
		<description><![CDATA[Here is a nice link for the hands on training of ASM:
http://www.expertDBA.com/oracle/articles/ASM_Hands_On_Training.pdf
Note: Above mentioned training document is copied/taken from the Oracle Blog http://blogs.oracle.com.
]]></description>
		<link>http://expertdba.com/blog/?p=84</link>
			</item>
	<item>
		<title>Configuring Oracle ASM on Linux (using ASMlib)</title>
		<description><![CDATA[Oracle Automatic Storage Management (ASM) on Red Hat Linux (using ASMlib)
As a first step we need to install support ASM libraries to configure the ASM. This library is provided to enable ASM I/O to Linux disks without the limitations of the standard Unix I/O API.
The ASMLib software is available from the Oracle Technology Network at [...]]]></description>
		<link>http://expertdba.com/blog/?p=82</link>
			</item>
	<item>
		<title>MySQL NDB Cluster Node status monitor</title>
		<description><![CDATA[# NDB CLUSTER MONITOR
# script for monitoring mysql-cluster status data/ndb/mgmnodes
NDB_MGM=&#8221;ndb_mgm&#8221;
ndb_ps=`ps -ef&#124;grep &#8220;ndb_mgmd&#8221;&#124;grep -v grep &#124;wc -l`
node_count=`$NDB_MGM -e &#8220;show&#8221; &#124;grep -w &#8220;id&#8221;&#124;wc -l`
echo ${Log}
&#62; ${Log}
if [ $ndb_ps -ne 1 ] ; then
echo &#8220;Looks like NDB_MGMD is not running&#8221;
echo &#8220;check MANAGEMENT Node status&#8221;
exit 1
### need to work on this condition.
else
echo &#8220;MANAGEMENT Node is up, proceed with next [...]]]></description>
		<link>http://expertdba.com/blog/?p=78</link>
			</item>
	<item>
		<title>Individual object restore from the last backup.</title>
		<description><![CDATA[Pre-req: The backup dir (taken using the backup script earlier) should be accessible from the target server and untar the bzip2 backup file before starting with restore.
This script will restore all the objects of all the schema(including mysql schema) use filters for selective restore.
#!/bin/sh
#============================================================================
# File:         DV_MySQL_restore.sh
# Description:  restore individual table backup to each database.
# Usage:   [...]]]></description>
		<link>http://expertdba.com/blog/?p=74</link>
			</item>
	<item>
		<title>Individual table/object backup of mysql database</title>
		<description><![CDATA[This script will backup tables separately and triggers/routines separately for each schema.]]></description>
		<link>http://expertdba.com/blog/?p=70</link>
			</item>
	<item>
		<title>To find data discrepancy in table partitions using maatkit checksum</title>
		<description><![CDATA[Script to find the datadiscrepancy across table partitions  b/w mysql servers(Master/slave) . The can also be used(with slight modifications) to find the data discrepancy across 2 standalone servers..
Pre-req: Need to have maatkit checksum tool installed on the server.
create tables checksum and checksum_results
CREATE TABLE checksum (
     db      [...]]]></description>
		<link>http://expertdba.com/blog/?p=66</link>
			</item>
	<item>
		<title>Schema Comparision Script</title>
		<description><![CDATA[PROMPT Posted by Anuj Kumar Pandey
PROMPT Schema Comparison
PROMPT =================
PROMPT
PROMPT Run this script while connected to one Oracle schema. Enter the Oracle
PROMPT username, password, and SQL*Net / Net8 service name of a second schema.
PROMPT This script will compare the two schemas and generate a report of
PROMPT differences.
PROMPT
PROMPT A temporary database link and table will be created [...]]]></description>
		<link>http://expertdba.com/blog/?p=53</link>
			</item>
	<item>
		<title>Tablespace free space check</title>
		<description><![CDATA[Select substr(b.tablespace_name,1,20) TableSpace, Total_Max_MB, NVL(Total_Used_MB,0) Total_Used_MB,
       ROUND((Total_Max_MB &#8211; NVL(Total_Used_MB,0)),0) &#8220;Free_MB&#8221;,
       ROUND((Total_Max_MB &#8211; NVL(Total_Used_MB,0))/1024,2) &#8220;Free_GB&#8221;,
       ROUND((Total_Max_MB &#8211; NVL(Total_Used_MB,0))/Total_Max_MB * 100,2) &#8220;Free%&#8221;
from (select tablespace_name, round(sum(bytes/1024/1024),2) Total_Used_MB
      from dba_segments
      group [...]]]></description>
		<link>http://expertdba.com/blog/?p=51</link>
			</item>
	<item>
		<title>Buffers used by objects</title>
		<description><![CDATA[TTITLE &#8220;Total buffers used by individual objects.&#8221;
COL OWNER FOR A8
COL OBJECT_NAME FOR A30
COL OBJECT_TYPE FOR A10
select obj.owner &#8220;OWNER&#8221;, obj.object_name &#8220;OBJECT_NAME&#8221;,
       obj.object_type &#8220;OBJECT_TYPE&#8221;, COUNT(distinct bh.block#) &#8220;# Buffers&#8221;
from dba_objects obj, v$bh bh
where obj.object_id = bh.objd and
      obj.owner != &#8216;SYS&#8217;
group by obj.owner, obj.object_name, obj.object_type
having COUNT(distinct bh.block#) >= [...]]]></description>
		<link>http://expertdba.com/blog/?p=48</link>
			</item>
	<item>
		<title>How to check datafile space utilization</title>
		<description><![CDATA[1)
set linesize 200
SELECT SUBSTR (df.NAME, 1, 65) file_name, df.bytes / 1024 / 1024 allocated_mb,
((df.bytes / 1024 / 1024) &#8211; NVL (SUM (dfs.bytes) / 1024 / 1024, 0))
used_mb,
NVL (SUM (dfs.bytes) / 1024 / 1024, 0) free_space_mb
FROM v$datafile df, dba_free_space dfs
WHERE df.file# = dfs.file_id(+)
GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes
ORDER BY file_name;
2)
select d.tablespace_name, d.file_id, d.file_name, d.bytes allocated, nvl(f.bytes,0) [...]]]></description>
		<link>http://expertdba.com/blog/?p=40</link>
			</item>
</channel>
</rss>
