Tema: Re: Oracle dievu ir pusdieviu:)
Autorius: Toxis@ze_yvil_place
Data: 2009-06-12 09:47:52
imechiau:)
"zZz" <zZz@zirzilia.lt> wrote in message news:h0srmo$ion$1@trimpas.omnitel.net...
> Išsprendei?
> 
> "Toxis@ze_yvil_place" <tox@work.ble> wrote in message 
> news:h0qtoh$p09$1@trimpas.omnitel.net...
>> dankeshon!
>> "Ness" <aggb_nutrinti@inbox.lt> wrote in message 
>> news:h0qr3n$k26$1@trimpas.omnitel.net...
>>> ALTER SYSTEM SET log_archive_dest_2='LOCATION=USE_DB_RECOVERY_FILE_DEST2
>>> QUOTA_SIZE=0';
>>>
>>> 0 = vietos neriboja
>>>
>>>
>>>
>>> "Toxis@ze_yvil_place" <tox@work.ble> wrote in message
>>> news:h0qi8a$5c7$1@trimpas.omnitel.net...
>>>> dlia osobina typych (tobish man:) gal gali trumpai apshviest:
>>>> alter user dba? (ar instanco useris) quota unlimited on
>>>> kuris_table_space'as?;
>>>> sorry uzh durna klausima:)"Ness" <aggb_nutrinti@inbox.lt> wrote in 
>>>> message
>>>> news:h0qha9$3v8$1@trimpas.omnitel.net...
>>>>>> QUOTA_SIZE=2048
>>>>>
>>>>> pasididink quota arba ja visai nuimk. Paskui 30 kartu paleisk
>>>>> ---------
>>>>> alter system switch logfile;
>>>>> --------
>>>>>
>>>>> cia kad kiekvienas redo logas susiaktyvintu, nes ju pas tave 30 ir
>>>>> dauguma
>>>>> invalidai.
>>>>> jei po visko dar bus like invalidu - restartuok instanca ir vel
>>>>> suaktykvink
>>>>> kiekviena redo loga.
>>>>>
>>>>> mano manymu redo logu pas tave per daug. geriau maziau ir didesni.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>> 
>