[askdba] Re: [dba_gurus] Re: Rebulding Index ---- Create date
- From: Nisar Tareen <ntareen@xxxxxxxxx>
- To: Braj Kishore Mahto <braj.mahto@xxxxxxxxx>
- Date: Thu, 12 May 2005 08:15:52 -0700 (PDT)
from dba_objectes select the object_type as index and field crated and the
owner the one you wish to check.
Nisar Tareen
Braj Kishore Mahto <braj.mahto@xxxxxxxxx> wrote:
Hi!
Narendra just want the date and time for last time index rebuild , not the stat.
On 5/12/05, gitesh <giteshtrivedi@xxxxxxxxx> wrote:
> Dear friend,
>
> Column last_ddl is only shows the date and time when last ddl occured
> but any one column will not showing the which ddl statement
> executed.Means you want rebuild statment exectly you cann't guess that
> last_ddl is showing that time user had executed rebuild stmt.But you
> can imagine that time 'alter' stmt executed eaither rebuild or
> anything else.
> If your requirement is constant checking about last rebuild stmt of
> indexes then you have to create ddl triggers on your database.Which
> one exectly propre result of your requirement.
>
> All the best and have a nice day..
>
> Regards
> Gitesh Trivedi
> OCP DBA (Oracle 10g/9i/8i/8)
>
>
> --- In dba_gurus@xxxxxxxxxxxxxxx, Braj Kishore Mahto <braj.mahto@xxxx>
> wrote:
> > Hi!
> > you can check it by
> >
> > select object_name,last_ddl_time from dba_objects where
> > object_name=<index name> and owner=<index owner>
> >
> > --
> > On 5/12/05, Narendra <nd7291@xxxx> wrote:
> > > Hi Guys,
> > >
> > > I want to get when last time indexes ( any types) has been rebuild???
> > > Last_analyzed is giving when indexes last time analysed.
> > >
> > > Waiting suggestions from great DBA's...
> > >
> > > Regards,
> > >
> > > --
> > > Narendra...
> > > Oracle DW DBA.
> > >
> > > ________________________________
> > > Yahoo! Groups Links
> > >
> > >
> > > To visit your group on the web, go to:
> > > http://groups.yahoo.com/group/dba_gurus/
> > >
> > > To unsubscribe from this group, send an email to:
> > > dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
> > >
> > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> >
> >
> > --
> >
> > Thanks & Regards,
> > Braj Kishore Mahto
> > ----------------------------------
>
>
>
> ________________________________
> Yahoo! Groups Links
>
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/dba_gurus/
>
> To unsubscribe from this group, send an email to:
> dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
--
Thanks & Regards,
Braj Kishore Mahto
----------------------------------
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
Other related posts:
- » [askdba] Re: [dba_gurus] Re: Rebulding Index ---- Create date
