Re: Why is recursive calls so high

Shan R Shanmuganathan wrote:
> Of course, I should have queried v$sqlarea by first_load_time.
>
> Here is the first few seconds of v$sqlarea on startup:
> SQL> l
> 1 select first_load_time, substr(sql_text,1,240) from v$sqlarea
> 2 where first_load_time < '2004-02-20/01:22:00'
> 3* order by 1
> SQL> /
>
> FIRST_LOAD_TIME
> -------------------
> SUBSTR(SQL_TEXT,1,240)
> --------------------------------------------------------------------------------
> 2004-02-20/01:21:26
> ALTER DATABASE MOUNT
OK - so it's mounting/opening.

>
> 2004-02-20/01:21:26
> ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY
> = '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GR
> EGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= '
>

A session get's it's parameters set.
Your's, probably, logged on as sysdba.  

> 2004-02-20/01:21:30
> ALTER DATABASE OPEN

Opening.

>
> 2004-02-20/01:21:31
> select migrated from MIGRATE$
>

Was I migrated - am I still in migration state?  

> 2004-02-20/01:21:31
> select TOTAL from SYS.ID_GENS$
>
> 2004-02-20/01:21:31
> select OPEN_MODE from v$database
>
> 2004-02-20/01:21:31
> select ts# from ts$ where name=:1

Where's me tablespaces?

>
> 2004-02-20/01:21:31
> select user#,type# from user$ where name=:1
>
> 2004-02-20/01:21:31
> select value$ from sys.props$ where name = :1
>
> 2004-02-20/01:21:31
> select metadata from kopm$ where name='DB_FDO'
>
> 2004-02-20/01:21:31
> select value from gv$parameter where name = 'undo_retention' and INST_ID <> :1
>
> 2004-02-20/01:21:31
> select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc
>
> 2004-02-20/01:21:31
> select charsetid, charsetform from col$ where obj# = :1 and col# = :2
>
> 2004-02-20/01:21:31
> select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
>
> 2004-02-20/01:21:31
> select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1
>
> 2004-02-20/01:21:31
> select value$ from props$ where name='DEFAULT_TEMP_TABLESPACE'
>
> 2004-02-20/01:21:31
> SELECT NULL FROM OBJ$ WHERE NAME='MAP_FILE$' AND OWNER# = 0
>
> 2004-02-20/01:21:31
> select order#,columns,types from access$ where d_obj#=:1
>

bladibla
It's just opening, and doing some householding

-- 

Regards,
Frank van Bortel