DBA_HIST_DATABASE_INSTANCE

In 10g there is a view called DBA_HIST_DATABASE_INSTANCE which has database instance information. It has history on information such as instance startup time, last ASH sample id. Example: SQL> column startup_time format a35 SQL> alter session set nls_timestamp_format=’DD-MON-YYYY HH24:MI:SS’; Session altered. SQL> SELECT startup_time, last_ash_sample_id FROM dba_hist_database_instance WHERE dbid = 1992878807 order by startup_time; STARTUP_TIME LAST_ASH_SAMPLE_ID —————————— —————— 12-AUG-2009 21:12:19 447735 21-AUG-2009 17:48:29 494755 .. … Continue reading DBA_HIST_DATABASE_INSTANCE

What are the different options to shutdown?

shutdown (or shutdown normal) – In this method the database shuts down cleanly and oracle will wait for all users process to terminate before shutting down the database, so if there is user with SQL*Plus session that is idle oracle will not terminate till the user session exits it. If user sessions haven’t been terminated then you will see a following message in the alert.log … Continue reading What are the different options to shutdown?

Information on Database in restricted mode.

When a database is started in restricted mode only users with restricted access can login to the database. The reason to start database in restrict is to restrict normal users to connect to the database. To switch the database back to normal mode, you would need to restart the database. One can start the database in restricted mode by using the following option when starting … Continue reading Information on Database in restricted mode.

How to tell if the database was started with spfile or pfile?

There are couple of ways of finding if the database was started with spfile or pfile. One way would be tell show the check the value of parameter spfile, if it returns blank then database was started by pfile. — belows show database was started by spfile SQL> show parameter spfile; NAME TYPE VALUE —— —— ———————————————— spfile string /u01/apps/oracle/10g/dbs/spfileorcltest.ora Another way to find would … Continue reading How to tell if the database was started with spfile or pfile?