Hey I want a full paraphrase for each point with making sure keeping the sam
Hey I want a full paraphrase for each point with making sure keeping the same names of values , numbers ,and terms I need that in 7 hours from now
1- Colum Name: BYTES – View Name: DBA_DATA_FILES
This column shows to me the size of a specific file in BYTES measure. In the view the first row was having the value 880803840 and that was the size of the SYSTEM01.DBA file
2- Colum Name: USER_BLOCK – View Name: DBA_DATA_FILES
User block here represent the number of blocks available to used by the data. It showed to me that the System file has 107520. And that basically means there are 107520 byte in System file that ready to be used by the data.
3- Colum Name: TABLESPACE_NAME – View Name: DATA_EXTENTS
I got the value ‘ System ‘ for the first row when I execute the command. And that value or the whole Colum in general represents the name of the TABLESPACE that a particular extent belongs too. Because. I find out that Most of the extents on DATA_EXTENT belong to ‘System’ and “SYSAUX” TABLESPACE.
4- Column Name: STATUS – View Name: DATA_ TABLESPACES
This column shows to me the status of a particular TABLESPACE . A TABLESPACE can have different status Online, offline and read only. All TABLSPACES on the view was online when I executed the command; and that mean those TABLESPACES are available for users to use. When the status is Offline that means the TABLESPACE is not available to use. When the status read only the users can only look to the data and have no option to modify or alter etc.
5- Column Name: MAX_EXTENTS – View Name: DBA_TABLESPACES
This column represents the maximum number of extent that can be allocated for a particular TABLESPACE. In the view I got this value “2147483645” for the system TABLESPACE Which means if we allocate a number to system TABLESPACE that is higher than the given number it will be rejected.
6- Column Name: SEGMENT_TYPE – View Name: DBA_SEGMENTS
This column represents the segment type of a particular segment. a segment can have many different type such as Index , Table, Cluster ..etc. In my view I got Cluster value in the first row .
7- Column Name: USERNAME – View Name: DBA_USERS
This column is telling me how many users I have stored in the database. In the view the first user I got was “SYS”I find out there are many users that I didn’t created; and that can help me to detect an unauthorized user.
8 – Column Name: ROLE – View Name: DBA_ROLES
This column represents the name of the role that I have created them on the database. And those roles have privileges that can be granted to users.
9 – Column Name: CREATED – View Name: DBA_USERS
This column shows to me the exact created time for a particular user. In my view I got the value in the first row “08.03.2017 15:57:49” which indicates the created time for SYS user.
10- Column Name: Name – View Name: V$DATAFILE
This column is showing to me the full path for a particular data file on the hard drive. In the first row on the view I find the full path for the datafile that I have created “C:APPORACLEOWNERORADATAAA6790SYSTEM01.DBF”
11- Column Name: INVALIDATION – View Name: V$LIBRARYCACHE
This column represents the total numbers for a specific object in the namespace that were marked as invalid and that happened because the object modified. In the view I got the value “484” in the first row and that was for the SQL area namespace.
12- Column Name: ACCOUNT_STATUS – View Name: DBA_USERS
This column can contain certain values that can tell us about the status of a particular user. In my view I got the value “ Open “ for “SYS” user. Which means that the SYS is ready to be used. It also can contain other values like LOCKED (TIMED), EXPIRED (GRACE) & LOCKED (TIMED), EXPIRED & LOCKED, and EXPIRED (GRACE) & LOCKED. EXPIRED, EXPIRED (GRACE), LOCKED, EXPIRED
13- Column Name: COMMON – View Name: DBA_ROLES
This column represents whether a specific type is a common role or not common role. In the view I got the value “YES ” in the first row for the CONNECT role; which means CONNECT role is a predefined.
14- Column Name: DEF_TAB_COMPRESSION – View Name: DBA_TABLESPACES
This column represents whether a TABLSPACE is enabling default table compression or not. In the view I got the value “DISABLED” in the first row.
15- Column Name: LMODE – View Name: V$LOCK
In my view the value was from the first row is “4”. This view contains the locks that are located in the database. Oracle can hold a lock in different modes.
0 – none 1 – null (NULL) 2 – row-S (SS) 3 – row-X (SX) 4 – share (S) 5 – S/Row-X (SSX) 6 – exclusive (X) and in general the higher the number, the more restrictive the lock.