如何關(guān)閉Oracle11g數(shù)據(jù)庫的審計(jì)功能？

在oracle11g中，數(shù)據(jù)庫的審計(jì)功能是默認(rèn)開啟的（這和oracle10g的不一樣，10g默認(rèn)是關(guān)閉的），\x0d\x0aoracle11gR2的官方文檔上寫的是錯(cuò)的，當(dāng)上說default是none，而且是審計(jì)到DB級(jí)別的，這樣就會(huì)\x0d\x0a往aud$表里記錄統(tǒng)計(jì)信息。\x0d\x0a \x0d\x0a1.如果審計(jì)不是必須的，可以關(guān)掉審計(jì)功能；\x0d\x0a\x0d\x0aSQL show parameter audit_trail;\x0d\x0a\x0d\x0aNAME TYPE VALUE\x0d\x0a------------------------------------ ----------- ------------------------------\x0d\x0aaudit_trail string DB\x0d\x0a\x0d\x0aSQL alter system set audit_trail=none scope=spfile;\x0d\x0aSQL shut immediate;\x0d\x0aSQLstartup\x0d\x0a2.刪除已有的審計(jì)信息\x0d\x0a可以直接truncate表aud$,\x0d\x0atruncate table SYS.AUD$;\x0d\x0a\x0d\x0a3.或者將aud$表移到另外一個(gè)表空間下，以減少system表空間的壓力和被撐爆的風(fēng)險(xiǎn)。\x0d\x0a \x0d\x0a附：11g中有關(guān)audit_trail參數(shù)的設(shè)置說明：\x0d\x0aAUDIT_TRAIL\x0d\x0aProperty Description\x0d\x0aParameter type String\x0d\x0aSyntaxAUDIT_TRAIL = { none | os | db [, extended] | xml [, extended] }\x0d\x0aDefault valuenone\x0d\x0aModifiable No\x0d\x0aBasic No\x0d\x0aAUDIT_TRAIL enables or disables database auditing.\x0d\x0aValues:\x0d\x0anone\x0d\x0aDisables standard auditing. This value is the default if the AUDIT_TRAIL parameter was not set \x0d\x0ain the initialization parameter file or if you created the database using a method other than \x0d\x0aDatabase Configuration Assistant. If you created the database using Database Configuration \x0d\x0aAssistant, then the default is db.\x0d\x0aos\x0d\x0aDirects all audit records to an operating system file. Oracle recommends that you use the os \x0d\x0asetting, particularly if you are using an ultra-secure database configuration.\x0d\x0adb\x0d\x0aDirects audit records to the database audit trail (the SYS.AUD$ table), except for records \x0d\x0athat are always written to the operating system audit trail. Use this setting for a general \x0d\x0adatabase for manageability.\x0d\x0aIf the database was started in read-only mode with AUDIT_TRAIL set to db, then Oracle Database \x0d\x0ainternally sets AUDIT_TRAIL to os. Check the alert log for details.\x0d\x0adb, extended\x0d\x0aPerforms all actions of AUDIT_TRAIL=db, and also populates the SQL bind and SQL text CLOB-type \x0d\x0acolumns of the SYS.AUD$ table, when available. These two columns are populated only when this \x0d\x0aparameter is specified.\x0d\x0aIf the database was started in read-only mode with AUDIT_TRAIL set to db, extended, then Oracle \x0d\x0aDatabase internally sets AUDIT_TRAIL to os. Check the alert log for details.\x0d\x0axml\x0d\x0aWrites to the operating system audit record file in XML format. Records all elements of the \x0d\x0aAuditRecord node except Sql_Text and Sql_Bind to the operating system XML audit file.\x0d\x0axml, extended\x0d\x0aPerforms all actions of AUDIT_TRAIL=xml, and populates the SQL bind and SQL text CLOB-type columns\x0d\x0a of the SYS.AUD$ table, wherever possible. These columns are populated only when this parameter \x0d\x0ais specified.\x0d\x0aYou can use the SQL AUDIT statement to set auditing options regardless of the setting of this \x0d\x0aparameter.

讓客戶滿意是我們工作的目標(biāo)，不斷超越客戶的期望值來自于我們對(duì)這個(gè)行業(yè)的熱愛。我們立志把好的技術(shù)通過有效、簡單的方式提供給客戶，將通過不懈努力成為客戶在信息化領(lǐng)域值得信任、有價(jià)值的長期合作伙伴，公司提供的服務(wù)項(xiàng)目有：國際域名空間、雅安服務(wù)器托管、營銷軟件、網(wǎng)站建設(shè)、梁河網(wǎng)站維護(hù)、網(wǎng)站推廣。

Oracle ERP R12稅設(shè)置好了以后，如果使用0稅率的話，會(huì)有一條金額為0的稅行，怎么去掉這個(gè)稅行？

應(yīng)該通過SLA解決。你看下日記行名稱是什么，到SAL里刪除對(duì)應(yīng)的日記賬行，就不會(huì)產(chǎn)生這個(gè)的分錄了。——我沒試過，如果是我的話，會(huì)這樣試試。

oracle軟件 結(jié)匯憑證怎么做

oracle軟件結(jié)匯憑證做的步驟為：

1、點(diǎn)擊“系統(tǒng)設(shè)置”按鈕,。

2、在出現(xiàn)的右側(cè)框中點(diǎn)擊“憑證類型設(shè)置”按鈕。

3、選中其中的“記賬憑證”。

4、填寫相關(guān)信息打印即可。

oracle只讀事務(wù)如何取消

一定要在commit之前，原窗口執(zhí)行rollback就可以回退到set transaction read only之前的狀態(tài)。但要慎用，任何操作之前記得用savepoint并且不要輕易commit

本文標(biāo)題：oracle怎么取消記賬,怎么取消記帳
標(biāo)題來源：http://chinadenli.net/article10/dsgccdo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供建站公司、ChatGPT、響應(yīng)式網(wǎng)站、移動(dòng)網(wǎng)站建設(shè)、營銷型網(wǎng)站建設(shè)、

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)