tag:blogger.com,1999:blog-84456132173094985772024-03-13T22:13:58.888-07:00Oracle Applications 11i,R12 And Oracle DatabaseA Forum for Oracle database and E buisness suite.It contains lot of Useful material and tutorials for both DBA and developers.It provides very useful Information on Oracle database and ERP.Oracle DBAhttp://www.blogger.com/profile/15808354202975443163noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8445613217309498577.post-77873764718744973362013-10-04T12:53:00.001-07:002019-10-17T20:34:52.478-07:00What is voting disk in Oracle clusterware<script type="text/javascript">
<!--
function Redirect() {
window.location.href='https://techgoeasy.com/what-is-voting-disk-in-oracle/';
}
setTimeout('Redirect()', 1);
//</script>
<br />
Oracle DBAhttp://www.blogger.com/profile/15808354202975443163noreply@blogger.com0tag:blogger.com,1999:blog-8445613217309498577.post-15964502910382937912012-04-12T09:25:00.001-07:002018-07-29T09:00:19.026-07:00How to find table where statistics are locked<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
You can use the below query<br />
<br />
select owner, table_name, stattype_locked<br />
from dba_tab_statistics<br />
where stattype_locked is not null; <br />
<br />
<br />
Now once we find out the objects,we can use below queries to unlock them<br />
exec dbms_stats.unlock_schema_stats('schema_owner'); <br />
exec dbms_stats.unlock_table_stats('table_owner','table_name');</div>
<script type="text/javascript">
<!--
function Redirect() {
window.location.href='https://techgoeasy.com/how-to-find-table-where-statistics-are-locked/';
}
setTimeout('Redirect()', 1);
//</script>
<br />
--></div>
Oracle DBAhttp://www.blogger.com/profile/15808354202975443163noreply@blogger.com0tag:blogger.com,1999:blog-8445613217309498577.post-39025228784954036892012-03-23T11:21:00.003-07:002019-10-18T10:24:46.208-07:00ADODFCMP Utility<script type="text/javascript">
<!--
function Redirect() {
window.location.href='https://techgoeasy.com/ad-utilities/';
}
setTimeout('Redirect()', 1);
//</script>
<br />Oracle DBAhttp://www.blogger.com/profile/15808354202975443163noreply@blogger.com0tag:blogger.com,1999:blog-8445613217309498577.post-79912227725049761402008-05-28T07:21:00.000-07:002019-10-18T10:25:56.008-07:00AD Utilities<script type="text/javascript">
<!--
function Redirect() {
window.location.href='https://techgoeasy.com/ad-utilities/';
}
setTimeout('Redirect()', 1);
//</script>Oracle DBAhttp://www.blogger.com/profile/15808354202975443163noreply@blogger.com1