Title: RE: Unix terminal question
You can also do a last |more
Kevin Naik
-Original Message-
From: Aldi Barco [mailto:[EMAIL PROTECTED]]
Sent: 03 August, 2001 00:52
To: Multiple recipients of list ORACLE-L
Subject: Unix terminal question
Hi List,
I have turned on the
Title: RE: x$table
v$ objects are not tables, they are views based on the x$ tables.
The x$ tables are your data dictionary tables, they store meta data (data about data in the db)
-Original Message-
From: kommareddy sreenivasa [mailto:[EMAIL PROTECTED]]
Sent: 12 July, 2001 15:51
Title: RE: Script to find space bound objects
This is my two pence
select a.tablespace_name,a.segment_name,a.segment_type,a.su ,b.sf from
(select tablespace_name,segment_name,segment_type,next_extent/(1024*1024) su from dba_segments) a,
(select tablespace_name,max(bytes/(1024*1024)) sf
Title: Crash Recovery
Hi All,
I have an interesting problem, on one of my databases, a data warehouse, a killed session was taking too long
to rollback. It was time for the backup, and I had to do a shutdown abort.
No its time to open the database, instance parallel recovery is taking place
To: Multiple recipients of list ORACLE-L
Subject: Re: Crash Recovery
Naik, Kevin K wrote:
Hi All,
I have an interesting problem, on one of my databases, a data
warehouse, a killed session was taking too long
to rollback. It was time for the backup, and I had to do a shutdown
abort