KOTC Posted February 12, 2013 Report Posted February 12, 2013 inspired by SQL,SAP Oracle DBA valu andaru vachi oka OOOO vesukondi vayya
CheGuevara Posted February 12, 2013 Report Posted February 12, 2013 ooooooooooooooooooooooooooooooooooo
Joey_Tribbiani Posted February 12, 2013 Report Posted February 12, 2013 naa job adi kakapoina DBA is part of my job role .. OOOOOOOOOOOOOOOOOOOOOOOOO
KOTC Posted February 12, 2013 Author Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360696368' post='1303267297'] naa job adi kakapoina DBA is part of my job role .. OOOOOOOOOOOOOOOOOOOOOOOOO [/quote] SAP lo oracle DB use chestara bhayya me enviromental lo ma dagara kuda use chestara ippudu upgrade chestunaru sap basis team edo 7.0 to upgraded to 7.02 SPS 12
Gachibowli_Diwakar Posted February 12, 2013 Report Posted February 12, 2013 [img]https://lh6.googleusercontent.com/-BuaTEBQRDv8/UQy_GshT58I/AAAAAAAABtQ/hR7EW4jJCMk/s203/brahmi%2520%25281%2529.gif[/img]
Joey_Tribbiani Posted February 12, 2013 Report Posted February 12, 2013 [quote name='KOTC' timestamp='1360696781' post='1303267369'] SAP lo oracle DB use chestara bhayya me enviromental lo ma dagara kuda use chestara ippudu upgrade chestunaru sap basis team edo 7.0 to upgraded to 7.02 SPS 12 [/quote] yeah bhayya mem 11.2.0.3 use chestam oracle .. no special DBA team .. So antha maname ikkada ...
deals2buy Posted February 12, 2013 Report Posted February 12, 2013 Discussion thread anaali vayya...This thread is already in Disucssion Board btw nenu kuda nerchukundaam anukuntunna..So I will follow this thread
faf Posted February 12, 2013 Report Posted February 12, 2013 DBA kaadu EBS ikkada,, ayina interest anduko oka ooooooooooo eskuntunna..
Joey_Tribbiani Posted February 12, 2013 Report Posted February 12, 2013 DBA experience unna peddalandariki oka prashna ... okka tablespace lo enni datafiles undochu ... we reached hardlimit 1023 growth sarigga predict cheyaleka poyinaam .. datafile 4GB , 3GB ala add chesaam .. Now we reached limit .. for now , we are resizing the datafiles .. adi kakunda aa hardlimit ni change cheyocha ?? any suggestions
bmwx3 Posted February 12, 2013 Report Posted February 12, 2013 oooooooooooooooooooooooooooooooooooooooo
KOTC Posted February 12, 2013 Author Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360696965' post='1303267405'] yeah bhayya mem 11.2.0.3 use chestam oracle .. no special DBA team .. So antha maname ikkada ... [/quote] avuna ma dagara inka 10.2.0 lo unnaru
KOTC Posted February 12, 2013 Author Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360697147' post='1303267442'] DBA experience unna peddalandariki oka prashna ... okka tablespace lo enni datafiles undochu ... we reached hardlimit 1023 growth sarigga predict cheyaleka poyinaam .. datafile 4GB , 3GB ala add chesaam .. Now we reached limit .. for now , we are resizing the datafiles .. adi kakunda aa hardlimit ni change cheyocha ?? any suggestions [/quote] [b] How many Maximum Datafiles can there be in an Oracle Database[/b] [color=#204063][font=Helvetica, Arial, Verdana,] [/font][/color][color=#204063][font=Helvetica, Arial, Verdana,] How many Maximum Datafiles can there be in an Oracle Database? When starting an Oracle Database instance, the DB_FILES initialization parameter indicates the amount of SGA space to reserve for datafile information and thus, the maximum number of datafiles that can be created for the instance. This limit applies for the life of the instance. You can change the value of DB_FILES (by changing the initialization parameter setting), but the new value does not take effect until you shut down and restart the instance. You can add datafiles to traditional smallfile tablespaces, subject to the following limitations: • Operating systems often impose a limit on the number of files a process can open simultaneously. More datafiles cannot be created when the operating system limit of open files is reached. • Operating systems impose limits on the number and size of datafiles. • The database imposes a maximum limit on the number of datafiles for any Oracle Database opened by any instance. This limit is operating system specific. • You cannot exceed the number of datafiles specified by the DB_FILES initialization parameter. • When you issue CREATE DATABASE or CREATE CONTROLFILE statements, the MAXDATAFILES parameter specifies an initial size of the datafile portion of the control file. However, if you attempt to add a new file whose number is greater than MAXDATAFILES, but less than or equal to DB_FILES, the control file will expand automatically so that the datafiles section can accommodate more files.[/font][/color] [color=#204063][font=Helvetica, Arial, Verdana,] source :http://oracledbainterviewquestions.blogspot.com/2008/09/how-many-maximum-datafiles-can-there-be.html[/font][/color]
Gachibowli_Diwakar Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360697147' post='1303267442'] DBA experience unna peddalandariki oka prashna ... okka tablespace lo enni datafiles undochu ... we reached hardlimit 1023 growth sarigga predict cheyaleka poyinaam .. datafile 4GB , 3GB ala add chesaam .. Now we reached limit .. for now , we are resizing the datafiles .. adi kakunda aa hardlimit ni change cheyocha ?? any suggestions [/quote] database level lo hard limit untundi .. ([color=#333333][font=Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif][size=3][background=rgb(250, 250, 250)]MAXDATAFILES default value entho undhi ) u can change that value to whatever you want .. kani that requires db bounce .. tablespace level lo hard limit aah ... this is something very new to me .. also oka tablespace to 1023 data-files aah [/background][/size][/font][/color][color=#333333][font=Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif][size=3][background=rgb(250, 250, 250)] [/background][/size][/font][/color]
bmwx3 Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Silence..Please' timestamp='1360697722' post='1303267529'] database level lo hard limit untundi .. ([color=#333333][font=Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif][size=3][background=rgb(250, 250, 250)]MAXDATAFILES default value entho undhi ) u can change that value to whatever you want .. kani that requires db bounce .. [b]tablespace level lo hard limit aah ... this is something very new to me .. also oka tablespace to 1023 data-files aah [/b][/background][/size][/font][/color][b][color=#333333][font=Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif][size=3][background=rgb(250, 250, 250)] [/background][/size][/font][/color][/b] [/quote]
Recommended Posts