oca ocp

,T.extent_management Extman, T.segment_space_management SegmanFrom Dba_tablespaces T,(select Tablespace_name, sum (bytes) allocated, COUNT (file_id) datafiles from Dba_data_files Group by Tablespace_name) d,(select Tablespace_name, sum (bytes) free from Dba_free_space Group by Tablespace_name) F,(select Tablespace_name, sum (bytes) used from Dba_segments Group by Tablespace_name) uwhere T.tablespace_name = D.tablespace_name (+)and T.tablespace_name = F.tablespace_name (+)and T.tablespace_name =

decisions. setting thestatistics_level parameter tobasic disables The collection of many of the important statistics required by Oracle Database features and Fu Nctionality, including: Automatic Workload Repository (AWR) snapshots Automatic Database Diagnostic Monitor (ADDM) All server-generated Alerts Automatic SGA Memory Management Automatic Optimizer Statistics Collection Object Level Statistics end to End Application tracing (v$client_stats ) Database Time Distributi

metHandler_module-the PL/SQL process that runs when the audit condition is metEnable--true/false, enabling and disablingStatement_types--types of statements audited: SELECT, INSERT, UPDATE, DELETEAudit_trailaudit_column_opts--Dbms_fga_any_columns/dbms_fga_all_columnsExample of creating an audit policy:Dbms_fga.add_policy (Object_schema = ' HR ',object_name = ' EMPLOYEES ',Policy_name = ' POL1 ',audit_condition = ' department_id=80 ',Audit_column = ' SALARY ');Audit View:Dba_audit_trailDba_fga_a

the online redo log file is full, ARCN archives the online redo log file to the archive log file. 6, the storage structure of the database.1) Physical database structure• Control File• Online redo log files (Redo log file)• Data File• Instance parameter files (Instance Parameter file)• Password files (Password file)• Archive redo log files (Archive Redo log file)• Alert log and trace file (alert log and Trance files)2) Logical database structure• Table Space (tablespace)• Segment (Segment)•

independently of any backup of the current control file explicitly request Ed as part of your backup command. If you enable control file Autobackups, then RMAN automatically backs up the control file and the current server parameter FileSql*loaderhttp://bbs.cqsztech.com/forum.php?mod=viewthreadtid=521In the following case, even if the parameter undo_retention specifies a value, it may be ignored?For Fixed-size undo tablespaces, the system automatically tunes for the best possible undo retention

Tags: Oracle 11g installation Diagram Oracle database tutorial Oracle installation Oracle Video tutorial Oracle Tutorial1. After completing this chapter, the Oracle Video tutorial will be able to master the following:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6C/F9/wKiom1VYlzGBc2q8AAGwuGI81FQ479.jpg "title=" 05- High.jpg "alt=" wkiom1vylzgbc2q8aagwugi81fq479.jpg "/> use Oracle Enterprise Manager to access the database using the Sql*plus tool command How to set the environmen

Note: Questions and Answers are from the Internet. This article only provides answers for users to learn! Question: Answer: This topic describes the usage of merge. The concepts are as follows: The MERGE statement is a new syntax of Oracle9i, used

Recently busy, cool coin silver! Question: The core function of start with and connect by is to generate a tree result, and the meaning is to generate a tree result. Here, we don't need the example in the question. We use the example database

Question: Answer: give two examples to understand Example 1: SQL> select phone_number, 2 REGEXP_REPLACE(t.phone_number,'([[:digit:]]{3})\.([[:digit:]]{3})\.([[:digit:]]{4})', 3 '(\1)\2-\3') "PHONE_NUMBER" 4 from employees t; PHONE_NUMBER

Question: Answer: SQL> select * from session_privs; PRIVILEGE----------------------------------------ALTER SYSTEMAUDIT SYSTEMCREATE SESSIONALTER SESSIONRESTRICTED SESSIONCREATE TABLESPACEALTER TABLESPACEMANAGE TABLESPACEDROP TABLESPACEUNLIMITED

It's cool to listen to music, write a blog, and get it on a blog! This explains the functions of cube and rollup in SQL statements (used with group ); Question: Explanation of the answer:... let's look at the example. It's hard to describe

Note: Questions and Answers are from the Internet. This article only provides answers for users to learn! Question: Answer: This topic describes the usage of merge. The concepts are as follows: The merge statement is a new syntax of Oracle9i,

We recommend a piece of music, just blue Haha, which reminds you of your memories! Question: Answer analysis: How can I insert a table with a default value? A: An error occurred. If no column is specified, four columns are inserted. The SQL

61. YoufrequentlyhavemultipleRMANsessionsrunning, starting $ SESSION. WhatRMANcommandcanyouruntosetthevalueforthiscolumn? 61. you frequently have multiple RMAN sessions running, and you want to be able to easily identify each job via the CLIENTJNFO

Segment segment, partition extent, block logical conceptTable. A-> heap, heap table, relatively slow (records in the heap table are not ordered) Each block has an SCN header and some data is written at the end. (If the block breaks down, the entire

TCL: transaction control language, such as commit and rollback PLSQL: Provides object-oriented support. You can call C to manipulate the hardware. When called, PLSQL is put into the library cache in the share pool.PLSQL StructurePackagePackage body

Reclaim tables and IndexesResumable: if there is not enough space, it will be suspended for dBA for 2 hours, rather than directly reporting an error and exiting normally.If you can proceed, it will be suspended. Space management and local zone

1. optimizer statistics For performance, the selection of execution plans is very important. The standard practice is to use the optimizer to select an execution plan. The optimizer relies closely on Statistics to evaluate the efficiency of a number

Make sure that the directory where the installation file is located does not contain Chinese characters, otherwise there will be various problems! Since it is a learning and testing environment, these two items are free. Next, ignore. Of course, we

Preface This is a very tangled section, which is simple or detailed. If it is simple, nothing is said. The details are detailed. To be honest, there are many places that I don't understand. Just a few physical files, several memory blocks, and