Arun, you are awesome man, I am totally new to Oracle, like MS SQL DBA and AWS Cloud Engineer I am too good. Your videos are really helping me to become an Oracle DBA. Thank you for these videos
Dear Arun, I am a your big fan..This is a great initiative and I'm sure your will reach your goal very shortly ,already started sharing your videos / articles to my DBA networks...cheers and good luck ..
Hi Arun, thanks for helping out. Could you please provide the sequence of steps in right order to move table online to different tablespace with all attached objects if that table having indexes, partitions, LOBs all.
Oracle 12.2 onward you can move the table as an online operation using ONLINE keyword. but it can't be used on a partitioned index-organized table or index-organized tables that have a column defined as a LOB, VARRAY, Oracle-supplied type, or user-defined object type. ALTER TABLE t1 MOVE ONLINE TABLESPACE users;
Hi Arun, Can we have one listener and two databases with two different services. If one database is down we need not to down the listener we just down the service whch was offering
Great work Arun.. I have upgraded (manually) my 11.2.0.4 database to 12.1.0.2 and also I have upgraded the dst_timezone to 18 .. But after running the post_upgrade_fixups.sql ... It's still showing old_time_zone.So, my question is whether this is some sort of bug in oracle 12.1 or do I need to upgrade to timezone to some other values?? Please do respond... :)
If still, changes are not reflecting Check the preupgrade_fixups.sql script and do the changes manually. UPGRADE DST TIME ZONE: 1. Download the dst upgrade script from oracle unzip the file $ unzip DBMS_DST_scriptsV1.9.zip $ cd DBMS_DST_scriptsV1.9 run countstatsTSTZ.sql script. SQL> spool countstatsTSTZ.log SQL> @countstatsTSTZ.sql SQL> spool off Purge the scheduler jobs SQL> exec dbms_scheduler.purge_log; Run upg_tzv_check.sql ( it will detect the highest installed DST patch automatically) SQL> spool upg_tzv_check.log SQL> @upg_tzv_check.sql SQL> spool off SQL> spool upg_tzv_apply.log Run upg_tzv_apply.sql ( It will do the actual dst upgrade) SQL> spool upg_tzv_apply.log SQL> @upg_tzv_apply.sql Once dst upgrade is successful , validate the time_zone(It should be 18) SQL> SELECT version FROM v$timezone_file;
Hi Arun .Could you please share some details on capacity planning for database ,starting from the very basic like what should be my ideal SGA,PGA for a single node database that I want to implement for a application in production environment which would cater 2000+ transactions per day for online airline ticket purchase
Hi Arun, for question on moving table,can't we use expdp of schema,then allocate new tablespace to that user as default tablespace and import ,as this will take care of all the objects within schema.Only issue is all tables will be not available during this process,but we can use parallel option.?Can you please comment on my thought please.
Hi Arun Sir, just last week i came across this osm channel. Thank yo so much for the work . I have query , i am a oracle database developer and you recommend to up skill for Golden Gate for DAB profile . I have not much knowledge of administration and i am completely involved in development database activities . Is it ok to learn GG (i mean , am i going to face any challenge while learning due to my background) plz plz plz answer !!!!
@@dbagenesis Thanks for your response. One more doubt Bro.. We are creating index on only few Columns of the table even though Index size is very much near to size of the table why?
Sir If possible please post oracle rac video's in our channel and some videos of golden gate is already available but those videos are covering all the topics in golden gate ?
Yes, you can! If you want to change only instance name but not database name, just run SQL> alter system set instance_name=orcl scope=spfile; startup force;
Hey Uday, I am actually not an Apps DBA! Maybe I can call up my friend who is a well known Apps DBA on our #dailyDBA show to answer most of your queries.
Good one! added question to upcoming episode. Meanwhile, find below your answer: - First you need to add disks to shared storage - use oracleasm utility to create ASM disks - Fire ASMCA to create ASM disk group - Allocate disks to disk group, define redundancy and mount diskgroup - The newly created disk group will be visible to database by default
Arun, you are awesome man, I am totally new to Oracle, like MS SQL DBA and AWS Cloud Engineer I am too good. Your videos are really helping me to become an Oracle DBA. Thank you for these videos
Glad! Pleasure is all mine ;)
Very informative! This channel deserves more subscribers and views!!!
Really loved this Q & A style format of explaining... explanation is clean n crisp...
Thanks a lot 😊
You are a god for all DBA
I allways support your youtube channel, greetings from programer data base :)
Love it ;)
Thank you so much for clarifying our doubts on partition index.
Dear Arun,
I am a your big fan..This is a great initiative and I'm sure your will reach your goal very shortly ,already started sharing your videos / articles to my DBA networks...cheers and good luck ..
Thanks Mayur !! Let's build a strong DBA community ;)
i like u r channel , thank for creating such video, this will help our DBA team.
It's my pleasure
Hi Arun, thanks for helping out. Could you please provide the sequence of steps in right order to move table online to different tablespace with all attached objects if that table having indexes, partitions, LOBs all.
Oracle 12.2 onward you can move the table as an online operation using ONLINE keyword. but it can't be used on a partitioned index-organized table or index-organized tables that have a column defined as a LOB, VARRAY, Oracle-supplied type, or user-defined object type.
ALTER TABLE t1 MOVE ONLINE TABLESPACE users;
Joined DBA Genesis channel today...meet you @udemy DG course and finally in YT today!
Thank for Joining!
You are the best sir
Hi Arun, Can we have one listener and two databases with two different services. If one database is down we need not to down the listener we just down the service whch was offering
Yes, you can have it.
@@dbagenesis Thanks Arun for your prompt reply
Great work Arun..
I have upgraded (manually) my 11.2.0.4 database to 12.1.0.2 and also I have upgraded the dst_timezone to 18 .. But after running the post_upgrade_fixups.sql ... It's still showing old_time_zone.So, my question is whether this is some sort of bug in oracle 12.1 or do I need to upgrade to timezone to some other values??
Please do respond... :)
If still, changes are not reflecting Check the preupgrade_fixups.sql script and do the changes manually.
UPGRADE DST TIME ZONE:
1. Download the dst upgrade script from oracle
unzip the file
$ unzip DBMS_DST_scriptsV1.9.zip
$ cd DBMS_DST_scriptsV1.9
run countstatsTSTZ.sql script.
SQL> spool countstatsTSTZ.log
SQL> @countstatsTSTZ.sql
SQL> spool off
Purge the scheduler jobs
SQL> exec dbms_scheduler.purge_log;
Run upg_tzv_check.sql ( it will detect the highest installed DST patch automatically)
SQL> spool upg_tzv_check.log
SQL> @upg_tzv_check.sql
SQL> spool off
SQL> spool upg_tzv_apply.log
Run upg_tzv_apply.sql ( It will do the actual dst upgrade)
SQL> spool upg_tzv_apply.log
SQL> @upg_tzv_apply.sql
Once dst upgrade is successful , validate the time_zone(It should be 18)
SQL> SELECT version FROM v$timezone_file;
Hi Arun .Could you please share some details on capacity planning for database ,starting from the very basic like what should be my ideal SGA,PGA for a single node database that I want to implement for a application in production environment which would cater 2000+ transactions per day for online airline ticket purchase
Great question, will be answering it in upcoming episode !
You are doing good job I learned new things from you. Want to know more about the upcoming technology what will be the correct path for dba’s to learn
Sure, keep watching the videos, I will be adding more content related to upcoming technology
Hi Arun, for question on moving table,can't we use expdp of schema,then allocate new tablespace to that user as default tablespace and import ,as this will take care of all the objects within schema.Only issue is all tables will be not available during this process,but we can use parallel option.?Can you please comment on my thought please.
Hello Arun, thanks for sharing your expertise. Would it be possible to create a session on Oracle Apex
Sure, added it to my list. Won't be possible immediately but I will get it into priority list in this quarter !!
Hi Arun
1)What is use of the password file in database and password file mandatory create database?
Good question, picked it up for upcoming episode ;)
Hi Arun Sir,
just last week i came across this osm channel. Thank yo so much for the work .
I have query ,
i am a oracle database developer and you recommend to up skill for Golden Gate for DAB profile .
I have not much knowledge of administration and i am completely involved in development database activities .
Is it ok to learn GG (i mean , am i going to face any challenge while learning due to my background)
plz plz plz answer !!!!
You must first learn database administration else it will be challenge to move on to Golden Gate.
@@dbagenesis thank you sir..!!!
#morepowertoyou 🙏
thank you
You're welcome
What are all the monitoring tools used by DBA now and before?
Pickedup your question for upcoming episode!
Thanks for your response regarding listener bro.
Why won't we try drop and re-create index instead of rebuilding the index.
Added your question for upcoming episode. Will be answering it shortly!
@@dbagenesis
Thanks for your response.
One more doubt Bro..
We are creating index on only few Columns of the table even though Index size is very much near to size of the table why?
Happens sometimes! For small tables, the index size will be bigger than table size itself. ;)
Hi Arun. Please explain me what happens when we enable row movement?
It allows you to move rows from table to recycle bin or from recycle bin to table.
Could you please tell more ideas about normalization and what part it uses in db
A quick search on our channel will get your normalization videos.
Sir If possible please post oracle rac video's in our channel and some videos of golden gate is already available but those videos are covering all the topics in golden gate ?
Sure
can we have instance and database name are different? how can we do it.?
Yes, you can! If you want to change only instance name but not database name, just run
SQL> alter system set instance_name=orcl scope=spfile; startup force;
@@dbagenesis Thank you
How to fix the plan for a sql in database?
Can you tell me which modules are better to learn for Devops with AWS cloud
I have heard that so many modules are there in Devops. Currently i am working into Oracle DBA platform
Please do more videos on performance tuning it would be great help
Sure, keep watching #dailyDBA for more PT related questions.
What are all the info we can get from awr report.. pls do one video on this topic
Checkout this earlier video that I did on AWR: ruclips.net/video/QPJL1fswbO4/видео.html
@@dbagenesis thanks a lot
How can I reduce the gap between primary and standby Database?
Good question, will be answering in the upcoming episode ;)
@@dbagenesis Thanks boss ☺️
HI Arun, Please do cover Oracle Apps DBA concepts also. Advance Thanks.
Hey Uday, I am actually not an Apps DBA! Maybe I can call up my friend who is a well known Apps DBA on our #dailyDBA show to answer most of your queries.
@@dbagenesis Thanks again Arun.
Hi Arun in sga size is 10gb one user select one table 1tb size what happen
it will be in buffer chunk by chunk goes the new extent /blocks keep replacing the older one ..my 2 cents
How many datafiles can a tablespace have?
Check below article from support.dbagenesis.com
support.dbagenesis.com/knowledge-base/physical-oracle-database-limits/
6566 it depends on operating system.
Thanks Arun...
Will nologging while rebuilding indexes will affect the standby database ?
how to tune PGA memory as a developer
How to add the disk group in ASM and how to tell the steps in interview ??
Good one! added question to upcoming episode. Meanwhile, find below your answer:
- First you need to add disks to shared storage
- use oracleasm utility to create ASM disks
- Fire ASMCA to create ASM disk group
- Allocate disks to disk group, define redundancy and mount diskgroup
- The newly created disk group will be visible to database by default
Thank you so much and all the best for your work 👍👍👍
Hi
Create telegram channel