Posted by Mir Sayeed Hassan on December 25th, 2017
[oracle@testdb ~]$ echo "select table_name from user_tables;" | sqlplus -s mir/mir123 TABLE_NAME ------------------------------ TEST1 TEST2
[oracle@testdb ~]$ echo "select * from test1;" | sqlplus -s mir/mir123 ENO ---------- 1 2
Posted in MISCELLANEOUS | Comments Off on Run SQL Query from Linux command as shown below:
Posted by Mir Sayeed Hassan on December 25th, 2017
Create the sample 2 directories for test & create 1 file in one of the directory therefore create a user for new test or use existing user. Grant the appropriate privilege to the user and copy the files from one folder to another using the Oracle...
Posted in MISCELLANEOUS | Comments Off on Copy OS files from one location to another by sql*plus using Oracle function UTL_FILE.FCOPY
Posted by Mir Sayeed Hassan on December 24th, 2017
SQL> conn sys/sys as sysdba Connected.
SQL> set autotrace traceonly; SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611:...Read more..
Posted in DBA Administration | Comments Off on To set up Autotrace by using the PLUSTRACE ROLE in Oracle Database
Posted by Mir Sayeed Hassan on December 23rd, 2017
Posted in Performance Tuning(PT) | Comments Off on Real time Auditing in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on December 23rd, 2017
DDL Auditing at Schema Level
Try to perform the below tested & verified auditing at schema level in Oracle Database 11gr2
A DDL event occurs when a DDL statement is run in specific schema level such as...
Posted in Performance Tuning(PT) | Comments Off on Auditing at Schema Level in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on December 3rd, 2017
Simulate step by step procedure for Wait Event enq: TX – row lock contention, by updated (locking) row in 1st session & while trying to update the 2nd...
Posted in Performance Tuning(PT) | Comments Off on Performance tuning test for Wait Event enq: TX – row lock contention.