Re: Interesting new V$ table in 11.2
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 16 Sep 2011 23:28:10 +0200
Message-ID: <4e73bf6a$0$6568$9b4e6d93_at_newsspool3.arcor-online.net>
On 16.09.2011 21:50, Mladen Gogala wrote:
> On Fri, 16 Sep 2011 06:56:50 -0700, Mark D Powell wrote:
>
>> On Sep 14, 12:56 pm, Mladen Gogala<gogala.mla..._at_gmail.com> wrote:
>>> On Wed, 14 Sep 2011 09:13:47 -0700, dombrooks wrote:
>>>> See also the blocking_*, final_blocking_*, etc columns in the ever-
>>>> extending v$session.
>>>
>>> Yes, V$SESSION_WAIT and V$SESSION views have effectively been merged.
>>>
>>> --http://mgogala.byethost5.com
>>
>>
>> Just for general information the v$session_wait veiw was always build on
>> the same internal (x$) table as v$session. It is just that the
>> information was not exposed by Oracle in the v$session view definition.
>>
>> HTH -- Mark D Powell --
>
> How can I check that? V$FIXED_VIEW_DEFINITION contains only the first
> 4000 characters of the SQL, there is nothing in any of the bsq files and
> cdfixed.sql contains this for each and every table:
>
Date: Fri, 16 Sep 2011 23:28:10 +0200
Message-ID: <4e73bf6a$0$6568$9b4e6d93_at_newsspool3.arcor-online.net>
On 16.09.2011 21:50, Mladen Gogala wrote:
> On Fri, 16 Sep 2011 06:56:50 -0700, Mark D Powell wrote:
>
>> On Sep 14, 12:56 pm, Mladen Gogala<gogala.mla..._at_gmail.com> wrote:
>>> On Wed, 14 Sep 2011 09:13:47 -0700, dombrooks wrote:
>>>> See also the blocking_*, final_blocking_*, etc columns in the ever-
>>>> extending v$session.
>>>
>>> Yes, V$SESSION_WAIT and V$SESSION views have effectively been merged.
>>>
>>> --http://mgogala.byethost5.com
>>
>>
>> Just for general information the v$session_wait veiw was always build on
>> the same internal (x$) table as v$session. It is just that the
>> information was not exposed by Oracle in the v$session view definition.
>>
>> HTH -- Mark D Powell --
>
> How can I check that? V$FIXED_VIEW_DEFINITION contains only the first
> 4000 characters of the SQL, there is nothing in any of the bsq files and
> cdfixed.sql contains this for each and every table:
>
I've seen recorded in the 10046 trace the full text of queries for the views which are shortened due to 4000 byte restriction. However, if i remember correctly, only
V$FLASH_RECOVERY_AREA_USAGE V$BACKUP_CONTROLFILE_SUMMARY V$BACKUP_DATAFILE_SUMMARY
were shortened, the rest doesn't reach the limit.
Best regards
Maxim Received on Fri Sep 16 2011 - 16:28:10 CDT