LMTS Notes in Oracle DBA

LMTS notes (additional)

In the 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 compatibilities.

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

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);

Initial demands

100

100

150

225

350

950         [opprox]  

Inclined to build a profession as Oracle DBA Training? Then here is the blog post on, explore Oracle DBA Training

LMTS auto

Dblink within one server and only one database but different users    

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        

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;        

For an in-depth knowledge, click on below

• Create database link Oracle DBA
• Log files in Oracle DBA