Library cache:-
stores SQL and PL/SQL statements along with their execution plans.
Data Dictionary Cache:-
stores info about database schema such as tables, columns, definitions, indexes, privileges.
Shared Pool:-
shared memory structures for SQL and PL/SQL execution.
it contains frequently executed SQL statements, execution plans, data dictionary information.
--
buffer memory :- i/o operations happen.
cache memory :- read/write operations happen.
1. verify ACFS installation.
2. Create an ACFS File System:-
srvctl add filesystem -d <device> -m <mount_point>
eg. srvctl add filesystem -d /dev/asm/acfs-vol1-123 -m /acfs_file
3. Start the ACFS File System:-
srvctl start filesystem -d <device>
eg. srvctl start filesystem -d /dev/asm/acfs-vol1-123
4. Mount the ACFS File System:
mount -t acfs <device> <mount_point>
eg. mount -t acfs /dev/asm/acfs-vol1-123 /acfs_file
5. Verify ACFS Status:
srvctl status filesystem -d <device>
eg. srvctl status filesystem -d /dev/asm/acfs-vol1-123
6. Resize ACFS File System :-
acfsutil size +<size> <mount_point>
eg. acfsutil size +100G /acfs_file
7. List all ACFS file systems:
acfsutil info fs
8. Display information about a specific ACFS file system:
acfsutil info fs -o volume <mount_point>
eg. acfsutil info fs -o volume /acfs_file
9. Stop an ACFS FILE SYSTEM:
srvctl stop filesystem -d <device>
eg. srvctl stop filesystem -d /dev/asm/acfs-vol1-123
10. Remove an ACFS file system:
srvctl remove filesystem -d <device>
eg. srvctl remove filesystem -d /dev/asm/acfs-vol1-123
11. Display ACFS resource dependency:
srvctl config fs -d <device>
eg. srvctl config fs -d /dev/asm/acfs-vol1-123
12.
> /dev/null : Redirects standard output to /dev/null, discarding it.
echo -e "india\nmaharashtra" > india.txt
cat india.txt
india
maharashtra
#!/usr/bin/expect
spawn some_command # Replace some_command with the command you want to automate
expect "ExpectedPrompt" # Replace ExpectedPrompt with the prompt you expect
send "your_input\r" # Replace your_input with the input you want to provide
interact # Allows you to interact with the spawned process manually if needed
grep -v "^#|^$" filename
^# :- line start with comment #
^$ :- empty lines
[a-zA-Z0-9_] :- alpha numeric with _
grep -o "^.\{1,10\}" filename :- find first 10 character word at the beginning of line.
grep -o ".\{1,10\}$" filename :- find last 10 character word at the end of line.
grep -o "^." filename :- find one character for beginning of each line.
grep -o ".$" filename :- find one character for end of the each line.
grep -e "^$" filename :- find the empty lines in the file.
grep -e "$" filename :- end of the line.
grep -e "^[a-zA-Z\]\{0,255\}\+\@\+[a-zA-Z\]\{0,255\}\+\:\+\~\+\\$" fun.txt : kayyum@AbdulKayyum:~$
grep -v "^[a-zA-Z\]\{0,255\}\+\@\+[a-zA-Z\]\{0,255\}\+\:\+\~\+\\$" fun.txt : kayyum@AbdulKayyum:~$
kayyum@AbdulKayyum:~$ cat new.txt | grep -e "grep\|#" | grep -o "grep.*\|#.*"
# grep :- remove empty lines
grep -v "^$" sample.txt
# grep :- remove commented lines.
grep -v "^#" sample.txt
# grep :- to find oracle datafiles
grep -o "[a-zA-Z0-9_\]\{0,255\}\.dbf" sample.txt
# grep :- find first 10 characters each line
grep -o "^.\{1,10\}" sample.txt
# grep :- find last 10 characters each line
grep -o ".\{1,10\}$" sample.txt
# grep :- remove commented and empty lines
grep -v "^#\|^$" sample.txt
# grep :- to find ' " ' double quotes in the file
grep -e "\"" file.txt
# grep :- to find '{ ' and '}' curly braces
grep -e "\{" file.txt
grep -e "\}" file.txt
# combine
grep -e "\{\|\}" file.txt
grep -e "\"\.\"" file.txt
grep -e "[a-zA-Z\]\{0,255\}" file.txt
select (select host_name from v$instance) "host", (select instance_name from v$instance) "instance", owner, count(*) schema_obj_count from dba_objects where owner=upper('&owner') group by owner'
select * from dba_tab_privs where grantee=upper('grantee') and table_name in ('DBMS_LOCK','DBMS_JOB');
-- List all tables in all schemas SELECT OWNER ,table_name FROM dba_tables; -- List all views in all schemas SELECT OWNER ,view_name FROM dba_views; -- List all indexes in all schemas SELECT OWNER ,index_name ,table_name FROM dba_indexes; -- List all columns of a specific table in all schemas SELECT OWNER ,table_name ,column_name ,data_type FROM dba_tab_columns WHERE table_name = 'your_table_name'; -- List all procedures in all schemas SELECT OWNER ,object_name FROM dba_objects WHERE object_type = 'PROCEDURE'; -- List all triggers in all schemas SELECT OWNER ,trigger_name ,table_name FROM dba_triggers; -- List all sequences in all schemas SELECT sequence_owner ,sequence_name FROM dba_sequences; -- List all synonyms in all schemas SELECT OWNER ,synonym_name ,table_name FROM dba_synonyms; -- List all constraints in all schemas SELECT OWNER ,constraint_name ,constraint_type ,table_name FROM dba_constraints; -- List all sequences in all schemas SELECT sequence_owner ,sequence_name FROM dba_sequences; -- List all materialized views in all schemas SELECT OWNER ,mview_name FROM dba_mviews; -- List all materialized view logs in all schemas SELECT OWNER ,log_table ,master FROM dba_mview_logs; -- List all user-defined types (UDTs) in all schemas SELECT OWNER ,type_name FROM dba_types; -- List all packages in all schemas SELECT OWNER ,object_name FROM dba_objects WHERE object_type = 'PACKAGE'; -- List all package procedures and functions in all schemas SELECT OWNER ,object_name ,PROCEDURE_NAME ,function_name FROM dba_procedures WHERE object_type = 'PACKAGE'; -- List all indexes on a specific table in all schemas SELECT table_owner ,index_name ,column_name FROM dba_ind_columns WHERE table_name = 'your_table_name'; -- List all database links in all schemas SELECT OWNER ,db_link FROM dba_db_links;
-----------------------------------------------------Creating simple procedure:--- Create a simple procedure that prints a message
CREATE OR REPLACE PROCEDURE print_message
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello, this is a simple procedure!');
END;
/
#!/bin/bash
start=3
end=8
for i in $(seq $start $end); do
if test ${i} -lt ${end}
then
echo "${i} less than ${n} "
fi
if test ${i} -eq ${end}
then
echo "${i} equal to ${n} "
fi
done