| Irfan |
Posted: Apr 29, 2008 04:34:15 AM |
Total Post: 29
Joined: Nov, 2005
|
Hi everyone,
I have a database. Which dba table or view will
let me know whether NOLOGGING is enabled or disabled
for INSERT , UPDATE , DELETE etc statements.
|
|
|
 http://shaharear.blogspot.com |
| Posted: Apr 29, 2008 04:44:03 AM |  |
|
Total Post: 127
Joined: Apr, 2008
|
A database is either in force logging or no force logging mode. Use v$database.force_logging to determine in which it is.
|
|
|
|
|
| Irfan |
| Posted: Apr 29, 2008 05:01:38 AM | |
|
Total Post: 29
Joined: Nov, 2005
|
Object v$database.force_logging does not exist
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Apr 29, 2008 05:47:58 AM | |
|
Total Post: 127
Joined: Apr, 2008
|
To know all about NOLOGGING please go through the article .. i hope it will help you
http://sharear.blogspot.com/2008/04/force-loggingnologging-mode.html
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Apr 29, 2008 05:52:50 AM | |
|
Total Post: 127
Joined: Apr, 2008
|
which version of oracle you used ? I used 10g
-bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Apr 29 17:51:19 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select FORCE_LOGGING from v$database;
FOR
---
NO
SQL>
|
|
|
|
|
| Gitesh |
| Posted: Apr 29, 2008 06:52:08 AM | |
|
Total Post: 322
Joined: May, 2005
|
Force logging is new feature which is introduced in Oracle 9i. It is not available in Oracle8i.
|
|
|
|
|
| Gitesh |
| Posted: Apr 29, 2008 07:03:48 AM | |
|
Total Post: 322
Joined: May, 2005
|
Force logging can enable 2 ways 1) database level (you can get v$database) and 2) tablespace level (you can get dba_tablespaces).
|
|
|
|
|
| GOPU |
| Posted: Apr 30, 2008 05:59:37 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
you can use dba_tables
select LOGGING from dba_tables where table_name='ABC';
but nologging wont be used for normal inserts / updates / deleted
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
