Group Discounts available for 3+ students and Corporate Clients

LMTS Notes in Oracle DBA

LMTS notes (additional)

In case of lmts either auto or uniform ORACLE takes care of extent sizes, but ORACLE still supports already defined storage parameters just because of backward compatibilityness.

ORACLE calculates the initial demand which may or nay not be equal to initial extent depending on minextents.

But, the post growth be controlled by ORACLE after meeting “initial demand”.

User1>  create bable test 2 (two number, tname varchar 2 (10))

storage e(initial 100k

next 100k

minextents 5

maxextents 6
pot increase 50);

Screenshot_77

Initial demands

100
100
150
225
350
950         [opprox]

 


LMTS auto

 

Screenshot_78

Screenshot_79

 

Dblink within one server and only one database  but different users

 

Screenshot_80

 

In july

SQL>                     create database link pro_dev [100+50-20 = 130]
SQL>                      select table_name from user_tables; [production’s]
100 table
SQL>                      select table_name from user_tables@ pro_dev;
130 table
For dropped tables
SQL>                      select tabale_name from user_tables minus select table_name from user_tables@pro_dev;
100-130 = 20 tables
For added tables
SQL>                      select table_name from user_table@pro_dev minus select table_name from user_tables;
130-100 = 50 tables
For altered tables                            user_mod_columns

 

Screenshot_81

 

 

Screenshot_82

 

Wilshire: dba15’s user                                    dba15 :- server

Rajpal: dba12’s user                                        dba12:- client

 

Dba15 ~ ] $ cd $ ORACLE_HOME/notwork admin

Dba15 admin]$ cp listener.ora $ HOME

Dba15 admin]$ cd

Dba15  ~] $ vi .bash_profile

Export TNS_ADMIN = $ HOME

:wq

Dba15 ~ ] $ .. bash_profile

Dba15  ~]$ vi listener.ora

Listener_dba15  [Alias]

:wq

Dba15  ~] $ lsnrctl start listener_dba15

Dba15  ~ ]$ sqlplus   ‘/as sysdba’

Dba 15  SYS > startup

Dba12  ~] $ vi .bash_profile

Export TNS_ADMIN = $ HOME

:wq

Dba12 ~ ] $ . .bash_profile

Dba12 ~ ] $ vi tnsnames.ora

Tnsnames_dba12  [Alias]

:wq

Dba12 ~ ] $ tnsping tnsnames_dba12

Dba12~]$ sqlplus ‘/as SYSbad’

Dba12 SYS > startup

Dba12  SYS> grant create database link to rajpal;

Dba12 SYS> !

Dba12 ~]$ cd $ ORACLE_HOME/dbs

Dba12 dbs] $ vi initrajpar.ora

Global_names=false

{by default true}

:wq

Dba12 dbs]$ exit

Dba12 SYS > startup force

Dba12 SYS> conn rajpal/rajpal

Dba12 rajpal> select * from session_privs;

 

 

 

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on LMTS Notes in Oracle DBA"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6