Records 19 - 30 This documentation contains proprietary information of Oracle Corporation. It is Physical Structure Database Administrator Users .. Oracle9i Database Administration Fundamentals I is an instructor-led course. Oracle Database 10g Release 1 () New Features in the Administrator's Guide .. xli. Part I Basic Database Administration. 1 Overview of. Package Consists of 3 Courses: 1. Oracle Database 10g: Introduction to SQL. ( Code: DGC20) hours a day. PDF created with pdfFactory Pro trial version ziechowhasodi.ml . foundation in basic database administration. In this class.
|Language:||English, Spanish, French|
|Distribution:||Free* [*Registration needed]|
Managing the Redo Log Files______________________________________________ Page 1. Oracle 10g DBA Fundamentals Example and Code. Oracle Database 10g is the database for grid computing. Execute a basic SELECT statement. • Differentiate Capabilities of SQL SELECT Statements. Selection. Projection. Table 1. Table 2 Database administrator's view (what is in. Oracle DBA Concise Handbook. Oracle Saikat Basak. Published by Ensel Software ziechowhasodi.ml - 1 - 2nd Edition – updated for 10g & 11g .. Word format (PDF format is also available). Only the most basic aspects .
Know how to make a tablespace temporary. Know how to add a data file to a tablespace. Know how to use the autoextend feature. Know how to change the size of a data file manually. Know how to change t he storage settings of a tablespace.
Know how to take a tablespace offline. Know how to make a tablespace read-only. Use the including contents clause if the tablespace contains objects when you go to drop it. Storage Structure and Relationships:. Types of segments: Table Segment - Unclustered or nonpartitioned tables. Table Partition - Data within a table can be stored in multiple partitions and each partition can exist in a different tablespace if desired.
Each partition can have it's own storage parameters. Requires the use of the Oracle8 Partition option. Cluster - Rows are "clustered" together based upon key column value s.
A cluster can contain multiple tables. Is a type of data segment. Objects in a cluster belong to the same segment and share the same storage values. Index Organized Table - Data is actually stored in the index. All data retrieved from index tree, no table lookup needed. Index Partition - Contain index partitions.
An single index partition can NOT span multiple tablespaces. Rollback Segment - Holds rollback data for undo changes, read- consistency and recovery. Temporary Segment - Contain intermediate results data such as that used for sort operations. If the actual value placed in this column is large oracle actually stores the data in separate LOB segments and the table segment will only contain a locator or pointer to the LOB segment.
Used to lookup LOB segment values. Nested Table - A table that is actually stored in a column of a table. Also referred to as an inner table. Stored in it's own segment separate from the "parent" table. Managing Rollback Segments Rollback Segments: Is always equal to zero 0 for rb segs.
Types of rollback segments: Used for changes to objects in system tablespace only. Must be included in the parm. Useful with the Parallel Server option. Public and private rollback segments are the only ones that can be created by a DBA. Otherwise Oracle selects rb seg based upon the one that is available with the fewest number of txns in it.
Managing Temporary Segments: Created and used by Oracle when complete sort operation can not be performed in memory. Some statements that generate sort activity are: Permanent tablespace may contain multiple temporary segments.
Not recommended to use a permanent tablespace for temporary segments because of the amount of fragmentation created by temp segs. SMON reclaims temp segs for reuse from permanent tabelspaces.
In a temporary tablespace oracle creates a single sort segment for use by all requiring sort space. Extents can not be shared by multiple sort txns. Sort segment created by first statement requiring it and is deallocated at instance shut down. No limit to the number of extents a sort segment can have in a temporary tablespace.
The sort extent pool lives in the SGA and contains information about available extents for sorting. Set them to: Use different default storage clauses for different temporary tablespaces based upon sorting needs of users assigned to the temp tablespace. Use the following views to get info about temporary segment usage: Flag for inappropriate content.
Related titles. Jump to Page. Search inside document. Oracle Background Processes There are four mandatory processes. Storage Structure and Relationships: Page Biswajit Das.
Srinivas Kola. Mesha Malli. Arjun Jack. Ram Lakhan Verma. Yasir Zahoor. Birendra Padhi. Shahid Mahmud. Kaalidastan Balakerisnan. Munib Mohsin. Rajinish Kumar. Popular in Oracle Database. Troubleshooting Understanding and Tuning the Shared Pool. Mohit Saini.
Bhasker Naga. Srinivas Girnala.
Khawar Baig. Sheenam Bhalla. Jacyr Jefferson Popenda. Sreenivaas Reddy. J Agostinho O Junior. Installing Oracle Endeca Information Descovery 3. Ravi Kumar Lanke.
Anubha Verma. Nguyen Ho Long. Nested tables have only one column with no restriction of rows. Q 27 Can we save images in a database and if yes, how? This datatype has the capacity of holding data up to 4 GB. Q 28 What do you understand by database schema and what does it hold?
Ans: Schema is a collection of database objects owned by a database user who can create or manipulate new objects within this schema. The schema can contain any DB objects like table, view, indexes, clusters, stored procs, functions etc.
Q 29 What is a Data Dictionary and how can it be created? Ans: Whenever a new database is created, a database specific data dictionary gets created by the system. This dictionary maintains all the metadata related to the database and owned by the SYS user.
Q 30 What is a View and how is it different from a table? Ans: A view is a user-defined database object that is used to store the results of a SQL query, which can be referenced later. Views do not store this data physically but as a virtual table, hence it can be referred as a logical table. The table can be updated or deleted while Views cannot be done so. Q 31 What is meant by a deadlock situation? Ans: Deadlock is a situation when two or more users are simultaneously waiting for the data, which is locked by each other and hence, results in all blocked user sessions.
Q 32 What is meant by an index? Ans: An index is a schema object, which is created to search the data efficiently within the table. Indexes are usually created on certain columns of the table, which are accessed the most. Indexes can be clustered or non-clustered. Doing a variety of things will help you understand virtualization generally and the product itself. You might also benefit from reading a basic introduction to virtualization, like my article here.
Step 4 : Broaden Your Operating System Knowledge Following on from the previous step, once you are feeling comfortable with the basics of being an Oracle DBA and virtualization, you should probably start to broaden your knowledge of operating systems. This is especially true if your primary learning platform was Windows.
The easiest way into that is to use Oracle Linux , which is free and supported. I've already linked to creation of a VM and installation articles for various Linux distributions, including Oracle Linux, but you really need to know a bit more about Linux itself if you are serious about being a DBA on it.
You can read a whole bunch of stuff about it here. The better your grounding in Linux, the easier you will find more complex tasks, like RAC installations, in the future. Something like those described here. Personally, I would stick with Oracle on the basic file system at first, avoiding more complex features like ASM until you are more confident.
Play about with this stuff. Break it and try to fix it. Do backup and recovery. Do multiple installations.